IBM Support

IT07454: LOAD HANGS DUE TO LOAD RIDDER QUEUE FULL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A Load will hang and not able to be forced off (even after
    having been terminated).
    
    The symptons are:
    
    1. db2lrid showing in db2pd -utilities output for the Load but
    not showing in db2pd -edus.
    2. Ipcs ouput shows that there is a message queue full, which is
    likely the db2lrid queue.
    3. Stacks for the threads show:
    
    db2lfrm0 waiting on db2lrid
    
    32 (0)   ossDumpStackTraceEx
    33 (1)   OSSTrapFile::dumpEx
    34 (2)   sqlo_trce
    35 (3)   sqloDumpDiagInfoHandler
    36 (4)   __PRETTY_FUNCTION__.5889
    37 (5)   msgsnd
    38 (6)   sqlowqueInternal
    39 (7)   sqlowque
    40 (8)   sqluWriteQueue
    41 (9)   sqluTellRidderNoMoreData
    42 (10)          squFrmTerm
    43 (11)          sqluCFormatter::iCleanUp
    44 (12)          sqluLoadEDUDriver
    45 (13)          sqloEDUEntry
    46 (14)          pthread_tryjoin_np
    47 (15)          clone
    
    
    Load agent is on msgsnd the same as the db2lfrmx
    
    db2lfrmx:
    34 (0)   ossDumpStackTraceEx
    35 (1)   OSSTrapFile::dumpEx
    36 (2)   sqlo_trce
    37 (3)   sqloDumpDiagInfoHandler
    38 (4)   __PRETTY_FUNCTION__.5889
    39 (5)   msgsnd
    40 (6)   sqlowqueInternal
    41 (7)   sqlowque
    42 (8)   sqluWriteQueue
    43 (9)   sqlulPutBuff
    44 (10)          sqluRiddifyRecords
    45 (11)          sqluGetAndFormatRecords
    46 (12)          sqluCFormatter::iRun
    47 (13)          sqluLoadEDUDriver
    48 (14)          sqloEDUEntry
    49 (15)          pthread_tryjoin_np
    50 (16)          clone
    
    Load agent:
    
    72 (0)   ossDumpStackTraceEx
    73 (1)   OSSTrapFile::dumpEx
    74 (2)   sqlo_trce
    75 (3)   sqloDumpDiagInfoHandler
    76 (4)   __PRETTY_FUNCTION__.5889
    77 (5)   msgsnd
    78 (6)   sqlowqueInternal
    79 (7)   sqlowque
    80 (8)   sqluWriteQueue
    81 (9)   sqlulSndTermMsg
    82 (10)          sqlulTerminate
    83 (11)          sqlulPrcErr
    84 (12)          sqlulFRMResponse
    85 (13)          sqlulPollMsg
    86 (14)          sqluvload
    87 (15)          call_sqluvload
    88 (16)          sqluLoadPartition
    89 (17)          sqlu_register_table_load
    90 (18)          sqluvtld_route_in
    91 (19)          sqlesrvr
    92 (20)          sqleMappingFnServer
    93 (21)          sqlerKnownProcedure
    94 (22)          sqlerCallDL
    95 (23)          sqljs_ddm_excsqlstt
    96 (24)          sqljsParseRdbAccessed
    97 (25)          sqljsParse
    98 (26)          sqljsSqlam
    99 (27)          sqljsDriveRequests
    100 (28)         sqljsDrdaAsInnerDriver
    101 (29)         sqljsDrdaAsDriver
    102 (30)         sqeAgent::RunEDU
    103 (31)         sqzEDUObj::EDUDriver
    104 (32)         sqlzRunEDU
    105 (33)         sqloEDUEntry
    106 (34)         pthread_tryjoin_np
    107 (35)         clone
    

Local fix

Problem summary

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

Problem conclusion

  • Problem was first fixed in DB2 Version 9.7 and Fix Pack 11
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT07454

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-03-03

  • Closed date

    2015-10-08

  • Last modified date

    2015-10-08

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

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

    IT13349 IT13373

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:
08 October 2015