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

Can't backup DB

BDMcGrew

ADSM.ORG Member
#1
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

ADSM.ORG Moderator
#2
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:
Code:
"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
 

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

    Votes: 19 51.4%
  • Let's be formal and just say Spectrum Protect

    Votes: 6 16.2%
  • Other (please comement)

    Votes: 4 10.8%

Forum statistics

Threads
30,967
Messages
131,778
Members
21,224
Latest member
alexp36
Top