TSM API DB2 Database Backup Error '610' occuring AFTER backup

thestorageagent

Active Newcomer
Joined
Oct 16, 2012
Messages
12
Reaction score
0
Points
0
Hey all!
I have an issue with a DB2 server on TSM on Windows Server 2008 64bit.

I have set up the DSM environment variables as such:
DSMI_CONFIG="C:\Program Files\Tivoli\TSM\baclient\dsm-db2.opt"
DSMI_DIR="C:\Program Files\Common Files\Tivoli\TSM\api64"
DSMI_LOG="C:\Program Files\Tivoli\TSM\baclient\LOGS"

When I start the backup using below command, the session connects to TSM (I can see it through Q sess on TSM Server), and the database is being transferred completely, (appox 7GB, again through q sess), the storage space is growing, and a Q OCC will show this node uses more storage, which leads me to think the backup is completing successfully After the backup, I gut the below error:

D:\IBM\SQLLIB\BIN>db2 backup db test online use tsm
SQL2033N An error occurred while accessing TSM during the processing of a database utility. TSM reason code: "610".


I understand this error shows up when the variables are not properly setup, but since the backup is running fine and the error is showing up at the end, I am assuming config should be ok.

Any help would be much appreciated.

Thanks.
 
Hi,
Check file C:\Program Files\Common Files\Tivoli\TSM\api64\dscenu.txt
Efim
 
Hi,
Check file C:\Program Files\Common Files\Tivoli\TSM\api64\dscenu.txt
Efim

Thanks for you answer.

I checked, the file is right there..
Also, note that when the environment variables were not set correctly, the backup would fail from the start.
At the moment, it is transfering the complete database, then failing.

Also, running the below command retunrs that there are no backups, while the node clearly is using around 25GB on TSM, which is the size of the 3 full backups I have ran so far.
db2adutl.exe query full for db test

Thanks again.
 
Hi,
- correct syntax: db2adutl query full db test
- check TSM actlog during the SQL2033N
Which version of TSM client and server you are use?
Efim
 
Hi,
- correct syntax: db2adutl query full db test
- check TSM actlog during the SQL2033N
Which version of TSM client and server you are use?
Efim

Yes i'm sorry, this is the syntax I had used for db2adutl.

Actlog of TSM Server only shows sessions open and session closed.
TSM client is 6.3.0, win2k8r2
TSM server is 6.2.3, win2k8
 
You can try to trace but the good idea is open PMR.
For trace add lines to dsm-db2.opt and run smallest backup:
TRACEFILE <path to file>
TRACEFLAGS api api_detail verbdetail
Efim
 
Back
Top