db2 backup with TSM

[henrychen]

I have a problem with a db2 machine backup to TSM, this is client version 5.1.1.



The db is using the API client to do a full online backup hence dsm.sys is pretty empty:



SErvername bs19

COMMMETHOD TCPip

TCPPORT 1500

TCPSERVERADDRESS 10.0.105.1

NODENAME dbs19

PASSWORDACCESS generate



the online backup to tsm works fine but we would also like to backup other files on this system so i added the following to dsm.sys:



Domain /db2/db201

Domain /db2/db205



exclude /*

exclude /.../*

include /db2/db201/DS50/db2udb/NODE0000/SQL00001/SQLOGDIR/*

include /db2/db201/DS50/db2udb/NODE0000/SQL00001/SQLOGDIR/.../*

include /db2/db205/export_directory/*

include /db2/db205/export_directory/.../*



to include the log files in SQLOGDIR and data in export_directory. when this is added and dsmclient started, i get the following in the db2diag.log:



2003-11-15-05.00.06.898598 Instance:db2udb Node:000

PID:1293(db2med.28158.0) Appid:none

database_utilities sqluMapVend2MediaRCWithLog Probe:1



Error in Vendor Support Code at line: 499. rc: 185



2003-11-15-05.00.07.003989 Instance:db2udb Node:000

PID:1293(db2med.28158.0) Appid:none

database_utilities sqluMCInitBackupMC Probe:85



Media controller -- vendor device initialization error



2003-11-15-05.00.07.054320 Instance:db2udb Node:000

PID:28158(db2agent (DS50)) Appid:*LOCAL.db2udb.031115050005

database_utilities sqlubMWResponse Probe:5 DatabaseS50



DiagData

ffff f7f2 2f6f 7074 2f64 6232 7564 622f ÿÿ÷ò/opt/db2udb/

7371 6c6c 6962 2f61 6473 6d2f 6c69 6261 sqllib/adsm/liba

6473 6d2e 61ff 3138 3500 dsm.aÿ185.





2003-11-15-05.00.07.147023 Instance:db2udb Node:000

PID:28158(db2agent (DS50)) Appid:*LOCAL.db2udb.031115050005

database_utilities sqlubMWResponse Probe:10 DatabaseS50



DiagData

ffff f7f2 ÿÿ÷ò





2003-11-15-05.00.31.482135 Instance:db2udb Node:000

PID:28158(db2agent (DS50)) Appid:*LOCAL.db2udb.031115050005

database_utilities sqlubcka Probe:0 DatabaseS50



Backup terminated.



is this a conflict with the dsm client config and the API client? how can i resolve this problem? thanks.



-henry

 

[mpfrench]

What you need to do is setup a seperate node and dsm.opt file to backup this other data. The DB2 backup should be handled by a scheduled event inside of DB2 and the other data should be picked up by the TSM scheduler. If you want to do transaction logs into the same nodename as the DB2, look at the DB2 TSM Redbook from IBM:



http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65f/ca11be93f3ae47b2852569f800819a82?OpenDocument&Highlight=0,db2





Michael French

 

[mpfrench]

What you need to do is setup a seperate node and dsm.opt file to backup this other data. The DB2 backup should be handled by a scheduled event inside of DB2 and the other data should be picked up by the TSM scheduler. If you want to do transaction logs into the same nodename as the DB2, look at the DB2 TSM Redbook from IBM:



http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65f/ca11be93f3ae47b2852569f800819a82?OpenDocument&Highlight=0,db2





Michael French

 

[mpfrench]

What you need to do is setup a seperate node and dsm.opt file to backup this other data. The DB2 backup should be handled by a scheduled event inside of DB2 and the other data should be picked up by the TSM scheduler. If you want to do transaction logs into the same nodename as the DB2, look at the DB2 TSM Redbook from IBM:



http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65f/ca11be93f3ae47b2852569f800819a82?OpenDocument&Highlight=0,db2





Michael French

 

[henrychen]

so i checked out the "Backing Up DB2 UDB Using Tivoli Storage Manager" doc and it showed i can just use include/exclude statement in the client config in conjunction with the db2 backup, am i reading this wrong?



instead of kicking off the db backup online using tsm from the cronjob of the db host, can i make a schedule on the tsm server side and have the db host read the include/exclude statements to back up certain files i need, then kick off the online db backup as well?

 

[henrychen]

<TABLE BORDER=0 ALIGN=CENTER WIDTH=85%><TR><TD><font class="pn-sub">Quote:</font><HR></TD></TR><TR><TD><FONT class="pn-sub"><BLOCKQUOTE>What you need to do is setup a seperate node and dsm.opt file to backup this other data. </BLOCKQUOTE></FONT></TD></TR><TR><TD><HR></TD></TR></TABLE>



does this mean another system? so i would need to transfer all the other files i want backed up to this other system for backup? in another word, once i use the API for the db online backup, i cannot use the dsm client on this system to do anything else?



-henry