IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    LI73809

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-10-08

  • Closed date

    2009-09-22

  • Last modified date

    2009-09-22

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 September 2009