LI73809: REORG ON TABLE FAILED WITH SQL2216 AFTER ALTER TABLE ON COLUMN ENDED WITH SQL0668N ERROR RC=7

DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• ALTER TABLE on COLUMN FAILED WITH SQL0668N error RC=7.
  
  Subsequent REORG command on that table failed with SQL2216.
  
  db2diag.log showed the error messages
  
  
  2008-09-24-12.49.25.738380-300 I13747E584          LEVEL:
  Warning
  PID     : 11240                TID  : 47679421802816PROC :
  db2sysc 0
  INSTANCE: flexadm              NODE : 000          DB   :
  FLEXPROD
  APPHDL  : 0-17                 APPID:
  *LOCAL.flexadm.080924174914
  AUTHID  : FLEXADM
  EDUID   : 20                   EDUNAME: db2agent (FLEXPROD) 0
  FUNCTION: DB2 UDB, data management, sqldTableReorgObject,
  probe:4296
  RETCODE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
            "non-severe dms programming error"
            DIA8532C An internal processing error has occurred.
  
  2008-09-24-14.44.36.825041-300 I16108E1516         LEVEL: Severe
  PID     : 11240                TID  : 47679417608512PROC :
  db2sysc 0
  INSTANCE: flexadm              NODE : 000          DB   :
  FLEXPROD
  APPHDL  : 0-185                APPID:
  *LOCAL.flexadm.080924194417
  AUTHID  : FLEXADM
  EDUID   : 21                   EDUNAME: db2agent (FLEXPROD) 0
  FUNCTION: DB2 UDB, data management, sqldReorgFormat, probe:2648
  MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
            "non-severe dms programming error"
            DIA8532C An internal processing error has occurred.
  DATA #1 : String, 32 bytes
  Attempting to reformat ADT field
  DATA #2 : String, 8 bytes
  sqldreor
  CALLSTCK:
    [0] 0x00002B5D24DC6570 sqlzSetAndLog901 + 0x1E8
    [1] 0x00002B5D23798818
  _Z15sqldReorgFormatP8sqeAgentP13SQLD_REORG_CBP13SQLD_DFM_WORKP13
  SQLD_TDATARECS6_PiPS6_ + 0x1090
    [2] 0x00002B5D24F347AB _Z12sqldReadNormP13SQLD_DFM_WORKl +
  0x176D
    [3] 0x00002B5D22E94C11 _Z18sqldFetchFromBlockP13SQLD_DFM_WORK
  + 0x287
    [4] 0x00002B5D2379ACDF /opt/ibm/db2/V9.5/lib64/libdb2e.so.1 +
  0x1908CDF
    [5] 0x00002B5D24D1901E /opt/ibm/db2/V9.5/lib64/libdb2e.so.1 +
  0x2E8701E
    [6] 0x00002B5D24D18590
  _Z15sqliScanLeafLvlP8sqeAgentP8SQLD_TCBjiPFiPvP14SQLI_PAGE_DESCi
  iiP8SQLD_KEYP12SQLI_KEYDATAES3_P16SQLD_SEQDET_INFOPhm + 0x672
    [7] 0x00002B5D2379C14E /opt/ibm/db2/V9.5/lib64/libdb2e.so.1 +
  0x190A14E
    [8] 0x00002B5D2379C207 /opt/ibm/db2/V9.5/lib64/libdb2e.so.1 +
  0x190A207
    [9] 0x00002B5D237A05EC /opt/ibm/db2/V9.5/lib64/libdb2e.so.1 +
  0x190E5EC
  
  2008-09-24-14.44.36.871352-300 I17625E560          LEVEL:
  Warning
  PID     : 11240                TID  : 47679417608512PROC :
  db2sysc 0
  INSTANCE: flexadm              NODE : 000          DB   :
  FLEXPROD
  APPHDL  : 0-185                APPID:
  *LOCAL.flexadm.080924194417
  AUTHID  : FLEXADM
  EDUID   : 21                   EDUNAME: db2agent (FLEXPROD) 0
  FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary
  logging fu, probe:0
  MESSAGE : Reorg table failed.
  DATA #1 : String, 68 bytes
  Table(5:5)=FLEXADM .LIST, Flags=x0000409A, IID=1, Temp=0,
  LongTemp=0
  
  The issue was when converting the change in row version
  during ALTER Table, from old to new.
  

Local fix

Problem summary

• User affected: Any doing reorg after an alter table failed
  Problem Description: After an alter table column fails a
  subsequent reorg can also fail.
  Problem summary: see above.
  

Problem conclusion

• Problem was first fixed in Version 9.5 FixPak 4
  

Temporary fix

• n/a
  

Comments

APAR Information

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

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

  LI73810

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R950 PSN

     UP