Problem with backup DB in DB2 to TSM

epiphany-pin · Apr 18, 2009

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 · Apr 18, 2009

It (rc = 106) usually means that db2inst1 cannot write to /opt/tivoli/tsm/client/api/log/, where it should write its log.

epiphany-pin · Apr 18, 2009

Mita201 said:
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 · Apr 18, 2009

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

epiphany-pin · Apr 18, 2009

Mita201 said:
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 · Apr 18, 2009

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

epiphany-pin · Apr 19, 2009

Mita201 said:
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? =)

Mita201 · Apr 19, 2009

maybe to try with newer TSM client/api. 5.3.4 sounds like pretty old for db2 9.1/RH4 combintaiton...

epiphany-pin · Apr 19, 2009

Mita201 said:
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:

quinstear · Apr 20, 2009

just a quick thought.

Have you taken an offline backup to TSM?

Mita201 · Apr 20, 2009

Can you check if your db2 instance is 32bit since you are using 32bit api?
Have you seen this one?

http://www-01.ibm.com/support/docview.wss?uid=swg21252398

epiphany-pin · Apr 20, 2009

Thanks all who has responded. The problem has been solved by means of http://www-01.ibm.com/support/docview.wss?uid=swg21308680

Thanks all once again

stetsonnboots · Oct 20, 2009

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

mdemir · Sep 20, 2010

this link is corrupt now.
if you have instructions paste here please.

epiphany-pin said:
Thanks all who has responded. The problem has been solved by means of http://www-01.ibm.com/support/docview.wss?uid=swg21308680

Thanks all once again

lazyreefer · Sep 20, 2010

maybe this?

http://www-01.ibm.com/support/docview.wss?uid=swg21368481

Rhuobhe · Oct 23, 2013

I wish that link would work

Problem with backup DB in DB2 to TSM

epiphany-pin

Active Newcomer

Mita201

epiphany-pin

Active Newcomer

Mita201

epiphany-pin

Active Newcomer

Mita201

epiphany-pin

Active Newcomer

Mita201

epiphany-pin

Active Newcomer

quinstear

Mita201

epiphany-pin

Active Newcomer

stetsonnboots

Newcomer

mdemir

Newcomer

lazyreefer

Newcomer

Rhuobhe

Data Privacy Impact Assessment

Sponsor ADSM.ORG

Navigation Menu

NordVPN 3 Months FREE

Forum statistics