IBM Support

IC82410: Allow creation of tables with null characters within its name, however after it cannot be dropped or insert anything on it.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The original problem was the a user could create a table with a
    NULL character in the name, but then could not drop the table or
    insert anything into it. This was happening because there was a
    check to ensure no NULL characters in the table name, but this
    check only happened on insert and drop commands, not on the
    create table command. We decided that the customer should be
    able to create a table with a NULL terminator in the name if
    they want to, so we removed the check I mentioned above. Now,
    when a user attempts to insert into or drop a table with a NULL
    terminator in its name, the operation succeeds
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users on DB2 v9.7 before fix pack 7.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 FP7                               *
    ****************************************************************
    

Problem conclusion

  • N/A
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC82410

  • 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

    2012-04-01

  • Closed date

    2013-08-23

  • Last modified date

    2013-08-23

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

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

    IC88631

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC82410

Modified date: 23 August 2013