DB2 Backup delete

[scottgassTSM]

I have a process that runs every Monday that marks backup files older than 50 days as deactivated. They are then deleted by another process. My Unix admin did not make any changes, but he renamed the dsm.opt and dsm.sys files, then changed the name back for some testing he was doing. Now, every Monday, my process fails and I get the following error:

Error: Initialize environment failed with ADSM return code 406

I'm running this command:

db2adutl delete full older than 50 days db PENODFT0 without prompting

I know that this points to the dsm.opt file missing, but it is where is has always been, the permissions are setup correctly, and I am running the process as the instance owner.

Backups are working properly.

Has anyone run into this before? Any help would be greatly appreciated as this has been ongoing for 3 weeks now.

 

[moon-buddy]

Have you restarted the TSM service?

 

[scottgassTSM]

We're going to bounce the instance tonight. Would using DSM_DIR instead of DSMI_DIR work? I'm not sure if this is an option since it runs through an API and DSMI is the API syntax.

 

[max]

hmmmm,

try and reset password with dsmapipw as root, then check that your environment variables are correct (DSMI_***), and then try a db2adutl query as the instance owner.

If it works, you will succesfully run your failed command, if it doesn't, please post on which of the 3 steps above it is failing.

max

 

[percy78]

We've just performed an upgrade to TSM 5.5 and apparently one DB2 DB does no longer respond with the server. We're getting this message on the DB2 server.

Error: Initialize environment failed with ADSM return code 426

The peculiar thing is that is working for another DB sitting on the same server.

If i su to db2inst3 and issue this command it works
b2inst3 @ l5f101 /db2/home/db2inst3
=> db2adutl query full db arcgis

Query for database ARCGIS


Retrieving FULL DATABASE BACKUP information.
1 Time: 20080420191615 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
2 Time: 20080413191614 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
3 Time: 20080406191612 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
4 Time: 20080323191614 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
5 Time: 20080316191605 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
6 Time: 20080310184817 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
7 Time: 20080309191632 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
8 Time: 20080302191614 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
9 Time: 20080227195011 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
10 Time: 20080224191614 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
11 Time: 20080217191609 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
12 Time: 20080210191606 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
13 Time: 20080203191611 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
14 Time: 20080127191608 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
15 Time: 20080124112053 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
16 Time: 20080124105505 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
17 Time: 20080124100846 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
18 Time: 20080121203650 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
19 Time: 20080121194535 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
20 Time: 20080121185052 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
21 Time: 20080117171530 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
22 Time: 20080117163509 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
23 Time: 20080116170525 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
24 Time: 20080115174200 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
25 Time: 20071129152907 Oldest log: S0000033.LOG DB Partition Number: 0 Sessions: 1
26 Time: 20071129140335 Oldest log: S0000014.LOG DB Partition Number: 0 Sessions: 1
27 Time: 20071122113105 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
28 Time: 20071122110703 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1
29 Time: 20070813121337 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1


Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for ARCGIS


Retrieving DELTA DATABASE BACKUP information.
1 Time: 20071130153702 Oldest log: S0000106.LOG DB Partition Number: 0 Sessions: 1
2 Time: 20071129153701 Oldest log: S0000033.LOG DB Partition Number: 0 Sessions: 1
3 Time: 20071122113702 Oldest log: S0000000.LOG DB Partition Number: 0 Sessions: 1

db2inst3 @ l5f101 /db2/home/db2inst3


The environment varibles are the same for both users.
db2inst3 @ l5f101 /db2/home/db2inst3
=> more .profile
PS1="`whoami` @ `hostname` "'$PWD
=> '
set -o vi

# export DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64
# export DSMI_DIR=/usr/tivoli/tsm/client/ba/bin
# export DSMI_LOG=/db2/home/db2inst3/tsm.log

DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
export DSMI_DIR
DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt
export DSMI_CONFIG
DSMI_LOG=$HOME
export DSMI_LOG


# The following three lines have been added by UDB DB2.
if [ -f /db2/home/db2inst3/sqllib/db2profile ]; then
. /db2/home/db2inst3/sqllib/db2profile
fi

[l5f101][/]> su - isail_t
[YOU HAVE NEW MAIL]
isail_t @ l5f101 /db2/home/isail_t
=> more .profile
PS1="`whoami` @ `hostname` "'$PWD
=> '
set -o vi


PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

export PATH

if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.

# The following three lines have been added by UDB DB2.
if [ -f /db2/home/isail_t/sqllib/db2profile ]; then
. /db2/home/isail_t/sqllib/db2profile
fi

DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
export DSMI_DIR
DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt
export DSMI_CONFIG
DSMI_LOG=$HOME
export DSMI_LOG

=> db2adutl query full db sailtest


Error: Initialize environment failed with ADSM return code 426

isail_t @ l5f101 /db2/home/isail_t


Has anyone seen this issue before?