• 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.

Problem with backup DB in DB2 to TSM

#1
Hi.
I have problem with backup DB in DB2 to TSM. Please, help me, if u can.
I have configured TSM client, which very well backup my filesystem, but i can't configured him with DB2.
Server and client - RHEL 4.0, DB2 - v9.1, TSM client - v5.3.4.

From db2inst1 in client machine i do
export DSMI_DIR='/opt/tivoli/tsm/client/api/bin/'
export DSMI_CONFIG='/opt/tivoli/tsm/client/api/bin/dsm.opt'
export DSMI_LOG='/opt/tivoli/tsm/client/api/log/'

This is TSM client configs.
# cat dsm.sys
SErvername 10.42.222.42
COMMmethod TCPip
TCPPort 1500
TCPServeraddress 10.42.222.42
Passwordaccess generate
Schedmode polling
Schedlogname /tmp/dsmsched.log
Errorlogname /tmp/dsmerror.log
Schedlogret 7
Errorlogret 7
NODENAME 70

(node registered in server; password generate with dsmapipw)

# cat dsm.opt
SErvername 10.42.222.42

# db2 get db cfg for sample | grep -y tsm
First log archive method (LOGARCHMETH1) = TSM
TSM management class (TSM_MGMTCLASS) = standard
TSM node name (TSM_NODENAME) = 70
TSM owner (TSM_OWNER) =
TSM password (TSM_PASSWORD) = *****

This error i get on start backup
# db2 BACKUP DATABASE SAMPLE ONLINE USE TSM
SQL2033N An error occurred while accessing TSM during the processing of a database utility. Reason code: "106".

If I right understand this error - db is busy, but lsof and db2 list application that not confirm.
What's problem?

p.s. i'm sorry for my english =)
 

Mita201

ADSM.ORG Senior Member
#2
It (rc = 106) usually means that db2inst1 cannot write to /opt/tivoli/tsm/client/api/log/, where it should write its log.
 
#3
It (rc = 106) usually means that db2inst1 cannot write to /opt/tivoli/tsm/client/api/log/, where it should write its log.
From root i change privileges for this directory
chown -R db2inst1:dasadm1 /opt/tivoli/tsm/client/api/log/
And i can create file in this directory from db2inst1, but error reason code don't change.
 

Mita201

ADSM.ORG Senior Member
#4
check your /tmp/dsmerror.log file, and rights on it.
Export environment, I mean DSMI_xxx values
Check that your db2 related dsm.sys resides in '/opt/tivoli/tsm/client/api/bin/'
play a bit with all logs permissions...
 
#5
check your /tmp/dsmerror.log file, and rights on it.
Export environment, I mean DSMI_xxx values
Check that your db2 related dsm.sys resides in '/opt/tivoli/tsm/client/api/bin/'
play a bit with all logs permissions...
After change privileges on this file i have this error.
SQL2033N An error occurred while accessing TSM during the processing of a
database utility. Reason code: "2033".
In log files are nothing.
In db2 ? SQL2033N, site ibm.com and google i can't find this reason code.

About environment:
env | grep DSMI
DSMI_DIR=/opt/tivoli/tsm/client/api/bin/
DSMI_LOG=/opt/tivoli/tsm/client/api/log/
DSMI_CONFIG=/opt/tivoli/tsm/client/api/bin/dsm.opt

About dsm.sys permissions:
# ls -la /opt/tivoli/tsm/client/api/bin/ | grep dsm.sys
-rwxr-xr-x 1 db2inst1 dasadm1 329 Apr 18 07:15 dsm.sys
 

Mita201

ADSM.ORG Senior Member
#6
Hmm...
I have compared to one of my (working) setups of unix db2 TSM api installs, and have found following differences:
My DSMI variables that points to directories does not have trailing slash at the end - eg. you maybe should try:
DSMI_DIR=/opt/tivoli/tsm/client/api/bin
instead of
DSMI_DIR=/opt/tivoli/tsm/client/api/bin/

Also, I keep my logs in /home/db2inst1/tsm and not in /tmp, maybe you should also give it try, to change it in your dsm.sys as well as in your DSMI_LOG variable

I have DSMI variables exported to root env and to db2inst1 env
I have root as member of db2grp1 group
I have newer versions of TSM api and client (5.4.2)

Try some of these...
 
#7
Hmm...
I have compared to one of my (working) setups of unix db2 TSM api installs, and have found following differences:
My DSMI variables that points to directories does not have trailing slash at the end - eg. you maybe should try:
DSMI_DIR=/opt/tivoli/tsm/client/api/bin
instead of
DSMI_DIR=/opt/tivoli/tsm/client/api/bin/
I try this. Now env from root and db2inst1 like this
# env | grep DSMI
DSMI_DIR=/opt/tivoli/tsm/client/api/bin
DSMI_LOG=/opt/tivoli/tsm/client/api/log
DSMI_CONFIG=/opt/tivoli/tsm/client/api/bin/dsm.opt
Also, I keep my logs in /home/db2inst1/tsm and not in /tmp, maybe you should also give it try, to change it in your dsm.sys as well as in your DSMI_LOG variable

I have DSMI variables exported to root env and to db2inst1 env
I have root as member of db2grp1 group
I have newer versions of TSM api and client (5.4.2)

Try some of these...
I change place to file dsmerror.log in dsm.sys
Errorlogname /opt/tivoli/tsm/client/api/log/dsmerror.log
From db2inst1 i can can write in this directory and this file, but after start backup db this file are empty.

And i add root in groups dasadm1, db2grp1.

Error code don't change after this turns.

Another idea? =)
 
#9
maybe to try with newer TSM client/api. 5.3.4 sounds like pretty old for db2 9.1/RH4 combintaiton...
I try to install TSM client/api version 5.5.1.4, error cod doesn't change.

In db2diag.log there are next lines. There can be it somehow will help
Code:
2009-04-20-04.18.22.996292+240 I9596932079G631    LEVEL: Error
PID     : 21710                TID  : 3086920192  PROC : db2med.28851.0 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:939
DATA #1 : String, 108 bytes
Vendor error: rc = 11 returned from function sqluvint.
Return_code structure from vendor library libtsm.a:
 
#13
resolution link provide error

I have tried the link and all I get is an error.

If you still have access to the resolution, could you please post it here?

Regards,
Stetson
 

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: 17 19.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 53 60.9%
  • Let's be formal and just say Spectrum Protect

    Votes: 10 11.5%
  • Other (please comement)

    Votes: 7 8.0%

Forum statistics

Threads
31,468
Messages
134,124
Members
21,569
Latest member
srinathkodela
Top