IBM Support

IC72083: AUTOMATIC REORG FOR INDEX FAILED WITH -2205 DUE TO MISSING OF SCHEMA NAME.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Users may see the following information in db2diag.log:
    2010-09-24-03.09.40.350836-240 I2023046A716       LEVEL: Error
    PID     : 1245372              TID  : 1211        PROC : db2acd
    0
    INSTANCE: db2nbp               NODE : 000
    EDUID   : 1211                 EDUNAME: db2acd 0
    FUNCTION: DB2 UDB, Automatic Table Maintenance,
    db2AutoReorgExec, probe:190
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2205   sqlerrml: 1
     sqlerrmc: 1
     sqlerrp : db2Reorg
     sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0xFFFFFF38      (6)
    0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    
    In SYSTOOLS.HMON_ATM_INFO table, REORG_DETAIL column will
    contain the string of REORG query and the error code for
    SQL2205N. The schema name is missing in the REORG statement,
    which caused it failed for reorganizing indexes.
    

Local fix

  • n/a
    

Problem summary

  • Problem Description:
    AUTOMATIC REORG FOR INDEX FAILED WITH -2205 DUE TO MISSING OF
    SCHEMA NAME.
    
    Problem Summary:
    Users may see the following information in db2diag.log:
    
    2010-09-24-03.09.40.350836-240 I2023046A716       LEVEL: Error
    PID     : 1245372              TID  : 1211        PROC : db2acd
    0
    INSTANCE: db2nbp               NODE : 000
    EDUID   : 1211                 EDUNAME: db2acd 0
    FUNCTION: DB2 UDB, Automatic Table Maintenance,
    db2AutoReorgExec, probe:190
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2205   sqlerrml: 1
     sqlerrmc: 1
     sqlerrp : db2Reorg
     sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3)
    0x00000000
               (4) 0x00000000      (5) 0xFFFFFF38      (6)
    0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    
    In SYSTOOLS.HMON_ATM_INFO table, REORG_DETAIL column will
    contain the string of REORG query and the error code for
    SQL2205N. The schema name is missing in the REORG statement,
    which caused it failed for reorganizing indexes.
    

Problem conclusion

  • Problem is first fixed in Version 9.7 Fixpack 4
    

Temporary fix

  • n/a
    

Comments

APAR Information

  • APAR number

    IC72083

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-10-21

  • Closed date

    2011-04-29

  • Last modified date

    2011-04-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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       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":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 April 2011