Can't backup DB

[BDMcGrew]

So I've got dozens of 6.3.3.0 servers running in Win2K8 that are all fine save for 2 servers that's won't do a DB backup. I'm getting the below errors. I'm at a loss. I've googled the errors and sql codes and tried all the fixes I can find (which worked on another server having the problem) but these two servers I'm unable to resolve.

Anyone have any ideas? I'll take all the help I can get

Appreciate it!

-brian

tsm: LPDTSM001>backup db type=full dev=lpd0013_P_Y wait=yes
ANR0984I Process 2 for Database Backup started in the FOREGROUND at 15:50:51.
ANR4559I Backup DB is in progress.
ANR2280I Full database backup started as process 2.
ANR4626I Database backup will use 1 streams for processing with the number
originally requested 1.
ANR2983E Database backup terminated due to environment or setup issue related
to DSMI_DIR - DB2 sqlcode -2033 sqlerrmc 168 .
ANR0985I Process 2 for Database Backup running in the FOREGROUND completed with
completion state FAILURE at 15:51:01.
ANR1893E Process 2 for Database Backup completed with a completion state of
FAILURE.
ANS8001I Return code 4.

tsm: LPDTSM001>

tsm: LPDTSM001>q devc

Device Device Storage Device Format Est/Max Mount
Class Access Pool Type Capacity Limit
Name Strategy Count (MB)
--------- ---------- ------- --------- ------ -------- ------
DISK Random 0
LPD0013_- Sequential 1 FILE DRIVE 61,440.0 50
DT_N
LPD0013_- Sequential 1 FILE DRIVE 30,720.0 50
DT_Y
LPD0013_- Sequential 1 FILE DRIVE 61,440.0 50
P_N
LPD0013_- Sequential 1 FILE DRIVE 30,720.0 50
P_Y
WHSTSM021 Sequential 0 SERVER 500.0 1

tsm: LPDTSM001>q db f=d

Database Name: TSMDB1
Total Size of File System (MB): 1,716,902
Space Used by Database(MB): 53,856
Free Space Available (MB): 1,136,469
Total Pages: 3,903,493
Usable Pages: 3,903,293
Used Pages: 3,890,113
Free Pages: 13,180
Buffer Pool Hit Ratio: 94.8
Total Buffer Requests: 1,462,098
Sort Overflows: 0
Package Cache Hit Ratio: 95.4
Last Database Reorganization: 08/24/2017 05:15:04
Full Device Class Name: LPD0013_P_Y
Number of Database Backup Streams: 1
Incrementals Since Last Full: 0
Last Complete Backup Date/Time: 06/27/2017 07:30:31


tsm: LPDTSM001>


D:\tsm\lpdtsm01>more tsmdbmgr.env
DSMI_CONFIG=d:\tsm\lpdtsm01\tsmdbmgr.opt
DSMI_LOG=d:\tsm\lpdtsm01

D:\tsm\lpdtsm01>more tsmdbmgr.opt
*************************************************
nodename $$_TSMDBMGR_$$
commmethod tcpip
tcpserveraddr localhost
tcpport 1500
passwordaccess generate
errorlogname d:\tsm\lpdtsm01\TSMDBMGR_TSMSERVER1.log

D:\tsm\lpdtsm01>

D:\tsm\lpdtsm01>db2set
DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:500
DB2_KEEPTABLELOCK=OFF
DB2_VENDOR_INI=d:\tsm\lpdtsm01\tsmdbmgr.env
DB2INSTPROF=C:\ProgramData\IBM\DB2\DB2TSM1
DB2COMM=TCPIP

D:\tsm\lpdtsm01>

 

[marclant]

Hi,

ANR2983E Database backup terminated due to environment or setup issue related
to DSMI_DIR - DB2 sqlcode -2033 sqlerrmc 168 .

sqlerrmc 168 is actually a TSM API return code: https://www.ibm.com/support/knowled.../com.ibm.itsm.msgs.client.doc/msg-0168_E.html

Try:

"c:\program files\tivoli\tsm\server\dsmsutil.exe" UPDATEPW /NODE:$$_TSMDBMGR_$$ /PASSWORD:TSMDBMGR /VALIDATE:NO /OPTFILE:"d:\tsm\lpdtsm01\tsmdbmgr.opt"

source: bottom of this page: https://www.ibm.com/support/knowled...bm.itsm.srv.install.doc/t_srv_prep_dbmgr.html

 

[BDMcGrew]

Thank you Sir! That worked.

Much appreciated!

-b