IC82096: RUNNING TWO DATABASE BACKUPS SEQUENTIALLY THE SECOND ONE MAY FAIL.

APAR status

• Closed as program error.

Error description

• Running two database backup sequentially with Tivoli Storage
  Manager the second one may fail with the following error
  messages:
  
  ANR2993E The database backup terminated with a log
  problem. DB2 sqlcode: -2428. DB2 sqlerrmc:
  (SESSION: XXXXX, PROCESS: XX)
  ANR0985I Process XX for Database Backup running
  in the FOREGROUND completed with completion state
  FAILURE at (SESSION: XXXXX, PROCESS: XX)
  ANR1893E Process XX for Database Backup
  completed with a completion state of FAILURE. (SESSION: XXXXX,
  PROCESS: XX)
  ANR2753I (SCHEDULE):ANR2993E The database
  backup terminated with (SESSION: XXXXX)
  ANR2753I (SCHEDULE):a log problem. DB2
  sqlcode: -2428. DB2 (SESSION: XXXXX)
  
  
  In the db2diag.log the following messages can be found:
  
  
  2011-09-29-04.40.59.229038-240 I7491744A365       LEVEL: Warning
  PID     : 39977310             TID  : 6170        PROC : db2sysc
  0
  INSTANCE: db2inst1              NODE : 000
  EDUID   : 6170                 EDUNAME: db2logmgr (SAMPLE) 0
  FUNCTION: DB2 UDB, data protection services,
  sqlpgRetrieveLogFile, probe:4130
  MESSAGE : Started retrieve for log file S0007548.LOG.
  
  2011-09-29-04.41.00.228963-240 I7492110A388       LEVEL: Error
  PID     : 39977310             TID  : 6941        PROC : db2sysc
  0
  INSTANCE: db2inst1              NODE : 000
  EDUID   : 6941                 EDUNAME: db2lfr (SAMPLE) 0
  FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:25
  DATA #2 : Hexdump, 4 bytes
  0x07000000097FDA50 : 860F 000A
  ....
  
  2011-09-29-04.41.00.229463-240 E7492499A572       LEVEL: Severe
  PID     : 39977310             TID  : 679646      PROC : db2sysc
  0
  INSTANCE: db2inst1              NODE : 000         DB   : SAMPLE
  APPHDL  : 0-48649              APPID:
  *LOCAL.db2inst1.111003125943
  AUTHID  : db2inst1
  EDUID   : 679646               EDUNAME: db2bm.2068183.18
  (SAMPLE) 0
  FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent,
  probe:1790
  MESSAGE : ADM8010E  Backup was unable to copy requested log file
  "S0007547.LOG"
            for inclusion in the backup image. The backup has been
  aborted.
  
  
  2011-09-29-04.41.00.230717-240 E7493623A563       LEVEL: Severe
  PID     : 39977310             TID  : 679646      PROC : db2sysc
  0
  INSTANCE: db2inst1              NODE : 000         DB   : SAMPLE
  APPHDL  : 0-48649              APPID:
  *LOCAL.db2inst1.111003125943
  AUTHID  : db2inst1
  EDUID   : 679646               EDUNAME: db2bm.2068183.18
  (SAMPLE) 0
  FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent,
  probe:1861
  DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
  -2428
  DATA #2 : Hexdump, 4 bytes
  0x00000002527F0998 : FFFF F684
  ....
  
  2011-09-29-04.41.00.231109-240 E7494187A966       LEVEL: Severe
  PID     : 39977310             TID  : 679646      PROC : db2sysc
  0
  INSTANCE: db2inst1              NODE : 000         DB   : SAMPLE
  APPHDL  : 0-48649              APPID:
  *LOCAL.db2inst1.111003125943
  AUTHID  : db2inst1
  EDUID   : 679646               EDUNAME: db2bm.2068183.18
  (SAMPLE) 0
  FUNCTION: DB2 UDB, database utilities, sqlubProcessLogExtent,
  probe:1861
  MESSAGE : SQL2428N  The BACKUP did not complete because one or
  more of the
            requested log files could not be retrieved.
  DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
   sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2428   sqlerrml: 0
   sqlerrmc:
   sqlerrp : sqlubPro
   sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)
  0x00000000
             (4) 0x00000000      (5) 0x00000000      (6)
  0x00000000
   sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
  
             (7)      (8)      (9)      (10)        (11)
   sqlstate:
  
  
  The problem is caused from the DB2 defect described from the DB2
  APAR IC79193.
  
  Customer/L2 Diagnostics: NONE.
  
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager version 6.2.x, 6.3.0.X
  
  Initial Impact: Low
  
  Additional Keywords:
  TSM DB2 SQLN2428
  

Local fix

• Next database backup run will finish successfully.
  

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 levels 6.2.4 and 6.3.1. 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

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP

• R63A PSY

     UP

• R63H PSY

     UP

• R63L PSY

     UP

• R63S PSY

     UP

• R63W PSY

     UP