IBM Support

IC93887: ADMIN_CMD GIVES OUT ONE-DIGIT NUMBER OF OPERATION ID AND ADMIN_REMOVE_MSGS FAILED WITH SQL1156N

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • PROBLEM DESCRIPTION
    =========================
    ADMIN_CMD gives out one-digit number of operation ID
    
     (1) Ran ADMIN_CMD with the parameter below.
     IMPORT FROM
    /dir1/f1.csv
    OF DEL MODIFIED BY COLDEL, timestampformat="HH:MM:SS" MESSAGES
    ON SERVER REPLACE INTO Table1
    
     (2) Message returned from MSG_REMOVAL column after ADMIN_CMD
    procedure call
     CALL SYSPROC.ADMIN_REMOVE_MSGS('5')
    
     (3) Exception occured when ran "CALL
    SYSPROC.ADMIN_REMOVE_MSGS('5')"
          com.ibm.db2.jcc.am.SqlException: The utility operation ID
    is not
          valid.. SQLCODE=-1156, SQLSTATE=     , DRIVER=3.64.82
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 9.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC93887

  • 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

    2013-07-02

  • Closed date

    2015-11-10

  • Last modified date

    2015-11-10

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

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

    IT09946 IT10134 IT10135 IT10136 IT10137 IT10138 IT10139 IT10140
    IT10176 IT10177 IT10259 IT10268 IT10395 IT10396 IT10414 IT10415
    IT10476 IT10477 IT10502 IT10503

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

Modified date: 10 November 2015