IBM Support

IC68897: DB2LOOK OR DROP MQT CAN RETURN AN SQL0901N ERROR OR TRAP IF THE DDL TEXT IN SYSCAT.VIEWS DOES NOT BEGIN WITH 'CREATE' OR 'ALTER'

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An MQT that was created via a Windows utility may prepend extra
    characters (^M or <NL> characters) in the MQT DDL text. This can
    lead to an SQL0901N error or possible trap when trying to
    collect the DDL via db2look or when the DROP TABLE RECOVERY
    feature attempts to collect the DDL when the MQT is being
    dropped. This also applies to any MQT DDL statement that does
    not begin with 'CREATE' or 'ALTER' (case insensitive).
    
    You can verify the DDL text used to create the MQT with the
    below query:
    
    select text from syscat.views
    

Local fix

  • For the drop table case, you can temporarily turn off DROP TABLE
    RECOVERY for that tablespace (e.g. ALTER TABLESPACE <tbspname>
    DROPPED TABLE RECOVERY OFF) to allow the drop to complete and
    then re-enable it.
    

Problem summary

  • Users affected: Any using a 3rd party client tool to create
    tables
    Problem Description: Extra characters in the table name can
    cause db2 to trap during DROP table or db2look.
    Problem Summary: See above.
    

Problem conclusion

  • Problem was first fixed in Version 9.7 FixPak 3
    

Temporary fix

  • For the drop table case, you can temporarily turn off DROP TABLE
    
    RECOVERY for that tablespace (e.g. ALTER TABLESPACE <tbspname>
    DROPPED TABLE RECOVERY OFF) to allow the drop to complete and
    then re-enable it.
    

Comments

APAR Information

  • APAR number

    IC68897

  • 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-05-27

  • Closed date

    2010-10-07

  • Last modified date

    2010-10-07

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

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

    IC69731

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

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

Document Information

Modified date:
07 October 2010