IBM Support

Recovery from IBM Spectrum Protect DB packed descriptor corruption

Troubleshooting


Problem

If there is a packed descriptor corruption, the IBM Spectrum Protect server may report a message similar to the following: ANR0162W Supplemental database diagnostic information: -1:58004:-901 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Length in PD=9704, LFD length=10968, DMS length=10968".) SQLSTATE=58004 Key here is the packed descriptor problem, "Length in PD"

Symptom

For the symptom, as reported in the actlog message above, the matching message in the db2diag.log file reads:

2014-04-14-07.44.48.241985+120 I38090704E490 LEVEL: Severe
PID : 5753 TID : 140737014392576PROC : db2sysc 0
INSTANCE: tsm100 NODE : 000 DB : TSMDB1
APPHDL : 0-60 APPID: *LOCAL.tsm100.140414054508
AUTHID : TSM100
EDUID : 45 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, catcache support, sqlrlc_systables_fetch_from_disk,
probe:200
MESSAGE : Corrupt PD->length in table:TSMDB1 .GLOBAL_ATTRIBUTES

2014-04-14-07.44.48.242297+120 I38091195E7553 LEVEL: Severe
PID : 5753 TID : 140737014392576PROC : db2sysc 0
INSTANCE: tsm100 NODE : 000 DB : TSMDB1
APPHDL : 0-60 APPID: *LOCAL.tsm100.140414054508
AUTHID : TSM100
EDUID : 45 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, catcache support, sqlrlc_systables_fetch_from_disk,
probe:201
MESSAGE : Length in PD=9704, LFD length=10968, DMS length=10968
DATA #1 : LOB Descriptor, PD_TYPE_LOB_DESCRIPTOR, 60 bytes
SQLDX_LD: Size:60
x0000 lfd_check 0x49
x0001 lfd_version 10
x0002 lfd_numsegs 1
x0003 lfd_flags 0x00
x0004 lfd_size 10968
x000C lfd_life_lsn 0000010D44A3E951
x0014 lfd_mini_numsegs 0
x0015 lfd_first 4
x0016 lfd_descsize 60
x0018 lfd_last_pages 16
x001C lfd_last_bytes 10968
x0038 lfd_dir Regular Directory Offsets
lfd_dir[0]: 4560 (16K)
Hexdump of LOB descriptor follows:
490A 0100 0000 0000 D82A 0000 51E9 A344
0D01 0000 0004 3C00 1000 0000 D82A 0000
0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 D011 0000
DATA #2 : String, 11 bytes
Corrupt PD:
DATA #3 : Hexdump, 1192 bytes

[{"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"","Line of Business":{"code":"LOB69","label":"Storage TPS"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 June 2018

UID

swg21673071

Page Feedback