IBM Support

IC77886: AN ERROR MIGHT OCCUR FOR SYSPROC.ADMIN_CMD EXECUTION OF RUNSTATS/IMPORT/LOAD WHEN NON-ASCII CHARACTERS APPEAR IN COMMAND STRING

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • You might receive an error when calling the sysproc.admin_cmd
    for runstats when the command string includes table, index,
    and/or column identifiers with non-ASCII characters.  The
    problem can occur when the connection is made by an application
    whose codepage is different from the database codepage.
    
    You can examine an application's codepage from an application
    snapshot.  You can examine the database's codepage from the
    database configuration file.
    
    The following error codes can be observed:
    - SQL2301N  The tablename parameter is not valid.  Either it is
    too long, only an authorization ID was specified, or the address
    of the name is not valid.
    - SQL2309N  The index name "<name>" is not valid.  It is too
    long or only a qualifier was specified.
    - SQL0205N  Column or attribute "<name>" is not defined in
    "<table>".  SQLSTATE=42703
    -SQL3015N  An SQL error "-104" occurred during processing.
    -SQL3304N  The table does not exist.
    

Local fix

  • 1) In the same unequal codepage connection, use the
    runstats/import/load
    command or API, instead of the admin_cmd procedure, or 2) Use an
    equal codepage connection and make the admin_cmd call using the
    object name in the database codepage.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You might receive an error when calling the                  *
    * sysproc.admin_cmd for runstats when the command string       *
    * includes table, index, and/or column identifiers with        *
    * non-ASCII characters.                                        *
    * The problem can occur when the connection is made by an      *
    * application whose codepage is different from the database    *
    * codepage.                                                    *
    *                                                              *
    * You can examine an application's codepage from an            *
    * application snapshot.                                        *
    * You can examine the database's codepage from the database    *
    * configuration file.                                          *
    *                                                              *
    * The following error codes can be observed:                   *
    *                                                              *
    * - SQL2301N  The tablename parameter is not valid.            *
    *   Either it is too long, only an authorization ID was        *
    * specified, or the address of the name is not valid.          *
    *                                                              *
    * - SQL2309N  The index name "<name>" is not valid.  It is too *
    * long or only a qualifier was specified.                      *
    *                                                              *
    * - SQL0205N  Column or attribute "<name>" is not defined in   *
    * "<table>".  SQLSTATE=42703                                   *
    *                                                              *
    * -SQL3015N  An SQL error "-104" occurred during processing.   *
    *                                                              *
    * -SQL3304N  The table does not exist.                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB version 9.7 fixpack 6.                    *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 FixPack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77886

  • 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

    2011-08-03

  • Closed date

    2012-06-04

  • Last modified date

    2012-06-04

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

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

    IC84428 IC84429

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 #: IC77886

Modified date: 04 June 2012