IBM Support

IC65753: THE REORGCHK COMMAND MIGHT STOP RESPONDING (HANG), IF THE COMMAND RECEIVES SQL ERROR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The reorgchk command might stop respond (hang) if the command
    receives SQL error.
    
    While executing reorgchk, if the table display or index display
    function of reorgchk will return any error, the reorgchk and
    back-end process of CLP will finish execution but, control of
    the execution may not be transferred to the front-end process
    and CLP could hang.
    
    The following db2diag.log entry illustrates one of the cause,
    reorgchk receives SQL0911N during retrieving pagesize of given
    table or index object.
    
    2009-12-12-19.11.39.996120+540 I23144472A1258     LEVEL: Severe
    PID     : 2392224              TID  : 1           PROC : db2bp
    INSTANCE: udbebb01             NODE : 000
    APPID   : *N0.udbebb01.091212095629
    EDUID   : 1
    FUNCTION: DB2 UDB, command line process,
    clp_reorgchk_get_tpagesize, probe:2622
    <snip>
    DATA #7 : unsigned integer, 4 bytes
    4294966385 = -911
    

Local fix

  • No local fix. This problem will be fixed in db2_v95fp6,
    db2_v97fp2, db2_v98fp1 or heigher releases.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users who use reorgchk command.                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The reorgchk command might stop respond (hang) if the        *
    * command receives SQL error.                                  *
    *                                                              *
    * While executing reorgchk, if the table display or index      *
    * display function of reorgchk will return any error, the      *
    * reorgchk and back-end process of CLP will finish execution   *
    * but, control of the execution may not be transferred to the  *
    * front-end process and CLP could hang.                        *
    *                                                              *
    * The following db2diag.log entry illustrates one of the       *
    * cause, reorgchk receives SQL0911N during retrieving pagesize *
    * of given table or index object.                              *
    *                                                              *
    * 2009-12-12-19.11.39.996120+540 I23144472A1258  LEVEL: Severe *
    *                                                              *
    * PID    : 2392224              TID  : 1         PROC : db2bp  *
    *                                                              *
    * INSTANCE: udbebb01            NODE : 000                     *
    * APPID  : *N0.udbebb01.091212095629                           *
    * EDUID  : 1                                                   *
    * FUNCTION: DB2 UDB, command line process,                     *
    * clp_reorgchk_get_tpagesize, probe:2622                       *
    * <snip>                                                       *
    * DATA #7 : unsigned integer, 4 bytes                          *
    * 4294966385 = -911                                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to DB2 V9.7 fixpack 2 or later.               *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.7 Fix Pack 2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC65753

  • 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

    2010-01-21

  • Closed date

    2010-07-06

  • Last modified date

    2010-07-06

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

    IC65204

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

    IC71217

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 July 2010