IBM Support

IC93931: IN SOME CASES CALLING 'USER-SPECIFIED PROFILE' FROM DB2SUPPORT M AY CAUSE SCRIPT TIME-OUT REGARDLESS OF THE SETTING OF 'TIMEOUT'.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Here you have an example of such behave.
    
    When one directly executes SQL statement in CLP:
    
    ?db2 -v "select routineschema, routinename, specificname,
    fenced, owner, implementation, create_time, alter_time from
    syscat.routines order by routinename asc?
    
    time-out issue doesn't occur and statement returns some results,
    which is expected, but calling above command via user-specified
    profile(example below) won't return any results, and time-out
    appear.
    
    <COLLECTION>
    <NAME>USER SCRIPT: SQL TO RUN</NAME>
    <CMD>db2 -v "select routineschema, routinename, specificname,
    fenced, owner, implementation, create_time, alter_time from
    syscat.routines order by routinename asc" </CMD>
    <OUTFILE>outputFile</OUTFILE>
    <TIMEOUT>200</TIMEOUT>
    </COLLECTION>
    
    The issue is related to size of the output produces by CMD
    command.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All platforms.                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Please See Error Description                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please See Error Description                                 *
    ****************************************************************
    

Problem conclusion

Temporary fix

  • N/A
    

Comments

APAR Information

  • APAR number

    IC93931

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-05

  • Closed date

    2013-10-02

  • Last modified date

    2013-10-02

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

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

    IC94545 IC94546

Fix information

Applicable component levels

  • R970 PSN

       UP

  • R980 PSN

       UP

  • RA10 PSN

       UP

  • RA50 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC93931

Modified date: 02 October 2013