IBM Support

IC74032: BIND FILE FOR AUTOMATICALLY BINDING NULLID.AOTMH00 IS INCORRECT

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If the NULLID.AOTMH00 package is dropped, there is auto-bind
    functionality to bind the package when you call the
    SYSPROC.ADMIN_MOVE_TABLE procedure.  The problem is that the
    bind file name used was incorrect.  Here are the symptoms:
    
        1.) The package for SYSPROC.ADMIN_MOVE_TABLE is dropped, ie.
     NULLID.AOTMH00
    
        2.) You call SYSPROC.ADMIN_MOVE_TABLE and get the following:
    
    
    call
    sysproc.admin_move_table('MYSCHEMA','TDF','TS2','TS2','TS2','','
    ','','','','MOVE')
    SQL0805N  Package "NULLID.AOTMH00 0X4141414141634858" was not
    found.
    SQLSTATE=51002
    

Local fix

  • The workaround is to bind db2_adminotm.bnd package manually. To
    do this please do the following:
    
        1.) Navigate to .../sqllib/bnd
        2.) Connect to the database in question
        3.) Run: db2 bind db2_adminotm.bnd
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users who have dropped NULLID.AOTMH00                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If the NULLID.AOTMH00 package is dropped, there is auto-bind *
    *                                                              *
    * functionality to bind the package when you call the          *
    *                                                              *
    * SYSPROC.ADMIN_MOVE_TABLE procedure.  The problem is that the *
    *                                                              *
    * bind file name used was incorrect.  Here are the symptoms:   *
    *                                                              *
    *     1.) The package for SYSPROC.ADMIN_MOVE_TABLE is dropped, *
    * ie.                                                          *
    * NULLID.AOTMH00                                               *
    *     2.) You call SYSPROC.ADMIN_MOVE_TABLE and get the        *
    * following:                                                   *
    *                                                              *
    * call                                                         *
    * sysproc.admin_move_table('MYSCHEMA','TDF','TS2','TS2','TS2', *
    * '','                                                         *
    * ','','','','MOVE')                                           *
    *                                                              *
    * SQL0805N  Package "NULLID.AOTMH00 0X4141414141634858" was    *
    * not                                                          *
    * found.                                                       *
    *                                                              *
    * SQLSTATE=51002                                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.7 FP5 or newer                             *
    ****************************************************************
    

Problem conclusion

  • Upgrade to DB2 v9.7 FP5 or newer
    

Temporary fix

  • The workaround is to bind db2_adminotm.bnd package manually. To
    do this please do the following:
    
        1.) Navigate to .../sqllib/bnd
        2.) Connect to the database in question
        3.) Run: db2 bind db2_adminotm.bnd
    

Comments

APAR Information

  • APAR number

    IC74032

  • 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-01-21

  • Closed date

    2011-12-20

  • Last modified date

    2011-12-20

  • 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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC74032

Modified date: 20 December 2011