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 number
IC82096
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
62W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-03-19
Closed date
2012-03-29
Last modified date
2012-03-29
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"62W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
29 March 2012