TDP for ERP (DB2) Backup SQL2062N RC11 Error

[innocentsinner]

Hi all, i'm new to TDP for ERP v5.5. I have 2 client nodes in my environment, dev & production server running under AIX 64-bit v5.3.0.0 & the SAP Database is DB2 v9.1.0.7 64-bit. There's nothin wrong with the storage media, because all file system backups to TS3100 library are done successfully. I have managed to do a full online DB2 backups via backom -c b_db -a SID -O on the SAP dev server until suddenly all the backups fails with the following error dialog :

BKI8637I: Full online backup of 'SID' started ...
SQL2062N An error occurred while accessing media "VENDOR". Reason code: "11".
BKI8634E: Backup command failed due to an error.
BKI8512I: Return code is: 605

Things i have done so far in the installation process :
1. Configure & Define server stanzas in dsm.sys & opt :
SErvername <nodename>_TDP_DB2
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 192.168.1.228
passwordaccess prompt
nodename <nodename>_TDP
errorlogname /usr/tivoli/tsm/client/api/bin64/dsmerror_tdp.log

2. Edit usercshrc environment variables for the DB2 instance owner
setenv XINT_PROFILE /db2/SID/tdp_r3/init<SID>.utl
setenv TDP_DIR /db2/SID/tdp_r3/tdplog
setenv DSMI_DIR /usr/tivoli/tsm/client/api/bin64
setenv DSMI_CONFIG /usr/tivoli/tsm/client/api/bin64/dsm.opt
setenv DSMI_LOG /var/log/tsm
setenv DB2_VENDOR_LIB=/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a

3. Edit the access rights to the log directory
chmod ugo+rw /var/log/tsm

4. Register the node & create the .bki config file via backom -c password utility
reg node <nodename>_TDP password domain=SAP_TDP maxnummp=2
su - db2SID
db2SID 1>/usr/tivoli/tsm/tdp_r3/db264/backom -c password

5. Update the DB2 VENDOROPT config :
db2 update db cfg for SID using VENDOROPT "'/db2/SID/tdp_r3/vendor.env'"

here's the backom log :

KI8806I: Data Protection for SAP(R) - BackOM 5.5.0.0 (316B) Oct 23 2007
BKI2027I: Using TSM-API version 5.5.0.0 (compiled with 5.3.0.0).
BKI8652I: DB2 version 'SQL09017' with 64 bits detected.

BKI8511I: The command is: -c b_db -a <SID> -O
BKI8637I: Full online backup of 'SID' started ...
BKI8643I: Using vendor library at '/usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a' ...
BKI8653I: Using autonomic buffer size and number of buffers ...
BKI8641I: Using 1 session(s) ...
BKI8656I: Using an autonomic degree of parallelism ...
SQL2062N An error occurred while accessing media "VENDOR". Reason code:
"11".
BKI8548I: Elapsed time: 5 sec
BKI8634E: Backup command failed due to an error.
BKI8512I: Return code is: 605
-------------------------

Please kindly advice of what might hv caused the error, or if there's any other known workaround for this issue. I have played around with the environment variables & config, but it doesn't solve the issue.

Thx & Best Regards,
Sinz

 

[Efim]

Hi
Reason code: "11" usually mean that env DSMI_DIR set incorrectly or not applied.
Do you restart DB2 after set env ?
Ask AIX admins how to check environment for running process (DB2). - ps eww <pid>
Efim

 

[innocentsinner]

Hi Efim, thx for the response and suggestion.
Yes, i hv restarted the DB2, if i su -db2<SID> and do env | grep DSMI, TDP, XINT, DB2. It seems that all the environment variable has been set correctly. And also note that i have successfully done a full online backup
once, before i hv this SQL2062N RC 11 issue. From the sample/dsmrc.h in the API client directory, RC 11 equals to DSM_RS_ABORT_NO_STO_SPACE_SKIP.
i tried to verify the running DB2 instance variables by checking the :
(1) ps -elf | grep -i "db2sysc" | grep -i "<instance owner>"
(2) ps eww <pid of db2sysc from the output of step 1>
and i got this result (the TDP, XINT, BACKOM is there but none of the
DSMI variables are set) :
PID TTY STAT TIME COMMAND
884896 - A 0:18 db2sysc 0 INSTHOME=/db2/db2apd SAPSYSTEMNAME=SID dbs_db6_schema=sapsid DIR_LIBRARY=/usr/sap/SID/SYS/exe/run HOME=/home/sidadm PWD=/home/sidadm TZ=THAIST-7 DB2DBDFT=SID DB2INSTANCE=db2sid DB2INSTDEF=db2sid DB2LPORT=0 DB2NODE=0 LANG=en_US USER=sidadm CLASSPATH=:/db2/db2sid/sqllib/java/sqlj.zip:/db2/db2sid/sqllib/java/db2java.zip:/db2/db2sid/sqllib/java/runtime.zip:.:/db2/db2sid/sqllib/java/sqlj.zip:/db2/db2sid/sqllib/java/db2java.zip:/db2/db2sid/sqllib/java/runtime.zip:. LOCPATH=/usr/lib/nls/loc XINT_PROFILE=/db2/sid/tdp_r3/initAPD.utl TDP_DIR=/db2/sid/tdp_r3/tdplog BACKOM_LOCATION=/usr/tivoli/tsm/tdp_r3/db264/backom AIXTHREAD_SCOPE=S DB2SYSC_EXEC_OWNER=DB2 PATH=/db2/db2sid/sqllib/bin:/db2/db2sid/sqllib/adm:/bin: LIBPATH=/db2/db2sid/sqllib/lib64:/db2/db2sid/sqllib/function:

Please advice on how to set TSM environment variables user profile for the DB2(v9.1.0.7 on AIX) instance owner properly in case i missed out something.

Thx & Best Regards,
Sinz

 

[Efim]

Try to add those lines to user profile (instance owner):

export DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
export DSMI_CONFIG=/usr/tivoli/tsm/client/ba/bin/dsm.opt
export DSMI_LOG=/var/log/tsm

Efim

 

[innocentsinner]

Thx again efim for the response. Been there done that though, add those lines in instance owner's $HOME/sqllib/userprofile file right? i'm stuck, any other recommendation based on your experience?

Thx & Best Regards,
Sinz

 

[Efim]

I'm not AIX guru, bit usually you can find default profile in $HOME/.profile
In you case HOME=/home/sidadm so look profile in it.
Efim

 

[mohsinalighaffar]

I'm not AIX guru, bit usually you can find default profile in $HOME/.profile
In you case HOME=/home/sidadm so look profile in it.
Efim

Hi All,

I am facing same problem. TDP for ERP for SAP along with DB2. OS AIX 7.1.

exec(): 0509-036 Cannot load program /usr/tivoli/tsm/tdp_r3/db264/backom because of the following errors:
0509-150 Dependent module libdb2.a(shr_64.o) could not be loaded.
0509-022 Cannot load module libdb2.a(shr_64.o).
0509-026 System error: A file or directory in the path name does not exist.

Need help urgent.

 

[Kelvin]

What is the full path and command that you are running..it is probably env variables that are set wrong.

Hi All,

I am facing same problem. TDP for ERP for SAP along with DB2. OS AIX 7.1.

exec(): 0509-036 Cannot load program /usr/tivoli/tsm/tdp_r3/db264/backom because of the following errors:
0509-150 Dependent module libdb2.a(shr_64.o) could not be loaded.
0509-022 Cannot load module libdb2.a(shr_64.o).
0509-026 System error: A file or directory in the path name does not exist.

Need help urgent.