• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TDP for ERP (DB2) Backup SQL2062N RC11 Error

#1
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
 
Last edited:

Efim

ADSM.ORG Senior Member
#2
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
 
Last edited:
#3
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
 
Last edited:

Efim

ADSM.ORG Senior Member
#4
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
 
#5
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

ADSM.ORG Senior Member
#6
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
 
#7
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

Active Newcomer
#8
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.
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 18 20.0%
  • Keep using TSM for Spectrum Protect.

    Votes: 55 61.1%
  • Let's be formal and just say Spectrum Protect

    Votes: 10 11.1%
  • Other (please comement)

    Votes: 7 7.8%

Forum statistics

Threads
31,505
Messages
134,278
Members
21,590
Latest member
madebi
Top