IBM Support

JR21911: SQL1227N WHILE ALTERING A TABLE IN THE CONTROL CENTER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL1227N while altering a table in the Control Center.
    
    The alter action consist of several SQL statements and the
    SQL1227N can be reported while executing "UPDATE SYSSTAT.TABLES"
    statement.
    
    The problem was reported while executing this statement:
    UPDATE SYSSTAT.TABLES
    SET CARD=0,
        NPAGES=0,
        FPAGES=2,
        OVERFLOW=0,
        ACTIVE_BLOCKS=0
    WHERE TABNAME = 'TABNME' AND TABSCHEMA = 'TABSCH'
    
    Error reported:
    SQL_CODE:  -1227
    SQL_STATE: 23521
    SQL_ERRMC: 0|CARD|6
    

Local fix

Problem summary

  • USERS AFFECTED:
    Control Center users.
    
    PROBLEM DESCRIPTION:
    SQL1227N while altering a table in the Control Center.
    
    The alter action consist of several SQL statements and the
    SQL1227N can be reported while executing "UPDATE SYSSTAT.TABLES"
    statement.
    
    PROBLEM SUMMARY:
    The problem was reported while executing this statement:
    UPDATE SYSSTAT.TABLES
    SET CARD=0,
        NPAGES=0,
        FPAGES=2,
        OVERFLOW=0,
        ACTIVE_BLOCKS=0
    WHERE TABNAME = 'TABNME' AND TABSCHEMA = 'TABSCH'
    
    Error reported:
    SQL_CODE:  -1227
    SQL_STATE: 23521
    SQL_ERRMC: 0|CARD|6
    

Problem conclusion

  • First fixed in DB2 UDB Version 8, FixPak 11 (s060120).
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR21911

  • Reported component name

    DB2 UDB EXE WIN

  • Reported component ID

    5724E4901

  • Reported release

    820

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2005-06-15

  • Closed date

    2006-02-03

  • Last modified date

    2006-02-03

  • 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 UDB EXE WIN

  • Fixed component ID

    5724E4901

Applicable component levels

  • R820 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"820"}]

Document Information

Modified date:
05 October 2021