TSM Schedule backup DB2

forbidth

ADSM.ORG Member
Joined
Jun 22, 2011
Messages
25
Reaction score
0
Points
0
PREDATAR Control23

hi,

i have problem when backup DB2 (with schedule)

TSM server : V 6.3 on AIX
TSM Client : V 6.3.0.10 on Windows 2008

when i setup everything is OK, i have test backup DB2 to TSM with script (manual execute) is completed,
(db2cmd.exe db2 backup db [my DB] online use TSM include logs)

but when i create schedule backup on TSM server

(define sched [domain] [schedule name] action=command object=my script)

its don't backup anything to TSM server, but its not failed (status on TSM server completed)

please help me.
 
PREDATAR Control23

Which return code is returned?
Was the backup even attempted?
Were there any entries in db2diag.log from that time?
Are DSMI_* variables correctly set up?
Does user runing scheduler have sufficient permission to launch a DB backup?
 
PREDATAR Control23

tdp for SAP with db2 having same problem.

We have TDP for SAP with DB2. We are able to run script for online and offline backup and it is working fine. but when we schedule it with tsm server , schedule starts but does not takes backup.




Which return code is returned?
Was the backup even attempted?
Were there any entries in db2diag.log from that time?
Are DSMI_* variables correctly set up?
Does user runing scheduler have sufficient permission to launch a DB backup?
 
PREDATAR Control23

reply

Hi, sorry for the late answer, I found it now accidentally.

When you define a schedule you should create an association between the domain - schedulation - server name.

I am working on Unix TSM, but probably the same syntactic:

To query existing association:
query assoc <domain name> <schedulation name>

To define new association:
define assoc <domain name> <schedulation name> <registered name of the client server within TSM>

like: define assoc UNIX_DOMAIN IDSPISPOPD_OFFLINE UNIX06Hopefully it helps.






hi,

i have problem when backup DB2 (with schedule)

TSM server : V 6.3 on AIX
TSM Client : V 6.3.0.10 on Windows 2008

when i setup everything is OK, i have test backup DB2 to TSM with script (manual execute) is completed,
(db2cmd.exe db2 backup db [my DB] online use TSM include logs)

but when i create schedule backup on TSM server

(define sched [domain] [schedule name] action=command object=my script)

its don't backup anything to TSM server, but its not failed (status on TSM server completed)

please help me.
 
PREDATAR Control23

forbidth,

I've just finished working through the same problem at our site. Our backup script would run fine manually but it we ran it through the TSM scheduler, it would fail. It would work if we ran the scheduler in the foreground.

We were running the scheduler with this.

Code:
nohup dsmc schedule >/dev/null 2>&1 &

Changed to this and it all worked

Code:
[COLOR=black][FONT=Times New Roman][/FONT][/COLOR]nohup dsmc schedule >/dev/null 2>&1 </dev/null &


I suspect this is also your issue.

Cheers
 
Top