IC74919: BACKUP DB TERMINATES WITH "DB2 SQLCODE: -2033" IF THE SELECTED DRIVE CANNOT BE OPENED

APAR status

• Closed as program error.

Error description

• The BACKUP DB terminates if the selected drive from this process
  cannot be opened. The following error will be seen in the
  Tivoli Storage Manager server actlog for the drive:
  .
  ANR8779E Unable to open drive
  .
  The Tivoli Storage Manager server did not get another available
  drive to mount the volume
  .
  Customer/L2 Diagnostics
  Very common API error codes are possible.
  .
  Here are two examples:
  .
  Example 1:
  .
  ANR2017I Administrator SERVER_CONSOLE issued command: BACKUP DB
    devc=ecartclass type=full
  ANR4559I Backup DB is in progress.
  ANR0984I Process 1 for Database Backup started in the BACKGROUND
    at 15:33:18.
  ANR0406I Session 2 started for node $$_TSMDBMGR_$$ (DB2/NT)
    (Tcp/Ip 345x1(1075-)).
  ANR0136I Table updating statistics performed successfully for 1
    of 1.
  ANR8945W Scratch volume mount failed 00130004.
  ANR8779E Unable to open drive mt7.1.0.2, error number= 5.
  ANR8381E ECARTRIDGE volume 00110004 could not be mounted in
    drive DRV1 (mt1.1.0.2).
  ANR1404W Scratch volume mount request denied - mount failed.
  ANR4578E Database backup/restore terminated - required volume
    was not mounted.
  ANR0403I Session 9 ended for node $$_TSMDBMGR_$$ (DB2/NT).
  ANR2992W The total DB used in DB space is 23,583 megabytes, and
    the total space available in the DB space is 34,702 megabytes.
    The ratio is 0.68.
  ANR0406I Session 3 started for node $$_TSMDBMGR_$$ (DB2/NT)
    (Tcp/Ip localhost(1079)).
  ANR0403I Session 3 ended for node $$_TSMDBMGR_$$ (DB2/NT).
  ANR2968E Database backup terminated. DB2 sqlcode: -2033. DB2
    sqlerrmc: 157
  ANR0985I Process 1 for Database Backup running in the BACKGROUND
    completed with completion state FAILURE at 15:56:28.
  .
  Example 2:
  .
  ANR2017I Administrator ADMIN issued command: BACKUP DB type=full
    devclass=lto4 wait=yes
  ANR4559I Backup DB is in progress.
  ANR0984I Process 4 for DATABASE BACKUP started in  the
    FOREGROUND at 05:13:40 AM.
  ANR0406I Session 5 started for node $$_TSMDBMGR_$$
    (DB2/LINUXX8664) (Tcp/Ip localhost(12345)).
  ANR8779E Unable to open drive /dev/IBMtape1, error  number=21.
  ANR8945W Scratch volume mount failed A00011L4.
  ANR8779E Unable to open drive /dev/IBMtape1, error  number=21.
  ANR2980E Database backup terminated TCPIP failure - DB2 sqlcode
    -2033 sqlerrmc -50.
  ANR0985I Process 4 for DATABASE BACKUP running in the FOREGROUND
    completed with completion state FAILURE at 05:20:41 AM.
  .
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager Server version 6.1 and 6.2 on all
  platforms
  .
  Initial Impact:
  medium
  .
  Additional Keywords:
  zz61 zz62 TSM DB2 sqlcode -2033
  

Local fix

• Resubmit the BACKUP DB command.
  The retry of the BACKUP DB will pick another drive.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See error description.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in level 6.2.3. Note that this   *
  *                 is                                           *
  *                 subject to change at the discretion of IBM.  *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP