IC88602: ADMIN_MOVE_TABLE can fail with SQL0010N or a SQL0104N syntax error due to the length of comments.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If there are multiple comments attached to a table and its
    columns, and these comments exceed 1kB in size,
    OTM cannot be used to move the table.  ADMIN_MOVE_TABLE fails
    with a sytax error, since the COMMENT ON
    statement that copies the remarks gets truncated.
    
    The error will be seen if the length of the command to set the
    comments exceeds 1kb:
    
    COMMENT ON "SCHEMA"."TABLE" ("COL1" IS 'This is the comment for
    col1', "COL2" IS 'This is the comment on col2', ... etc.
    

Local fix

  • Shorten the length of comments on the table/columns.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of ADMIN_MOVE_TABLE on tables with many comments.      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If there are multiple comments attached to a table and its   *
    * columns, and these comments exceed 1kB in size,              *
    * OTM cannot be used to move the table.  ADMIN_MOVE_TABLE      *
    * fails                                                        *
    * with a sytax error, since the COMMENT ON                     *
    * statement that copies the remarks gets truncated.            *
    *                                                              *
    * The error will be seen if the length of the command to set   *
    * the                                                          *
    * comments exceeds 1kb:                                        *
    *                                                              *
    * COMMENT ON "SCHEMA"."TABLE" ("COL1" IS 'This is the comment  *
    * for                                                          *
    * col1', "COL2" IS 'This is the comment on col2', ... etc.     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v10.1 FP2 to avoid this issue                     *
    ****************************************************************
    

Problem conclusion

  • Upgrade to v10.1 FP2 to avoid this issue
    

Temporary fix

  • Remove the comments on the table (or at least enough to get
    under 1kb in size)
    

Comments

APAR Information

  • APAR number

    IC88602

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-27

  • Closed date

    2013-01-28

  • Last modified date

    2013-01-28

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

    IC85385

  • 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

  • RA10 PSN

       UP

  • RA10 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC88602

Modified date:

2013-01-28

Translate my page

Machine Translation

Content navigation