Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC95794 Status: Closed

DB2 MAY HANG WHEN -901 ERROR IS ENCOUNTERED, YOU WILL SEE MESSAGE
"APPLICATION IS ALREADY QUEUED BY A THRESHOLD"

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
From the logs you will see these messages: 
 
2013-03-11-12.42.55.693635-240 I606036967A870     LEVEL: Severe 
PID     : 13107250             TID  : 17821       PROC : db2sysc 
2 
INSTANCE: db2inst1             NODE : 002         DB   : SAMPLE 
APPHDL  : 9-33138              APPID: xxxx 
AUTHID  : USER 
EDUID   : 17821                EDUNAME: db2agntp (PRD1) 2 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 45 
 sqlerrmc: Application is already queued by a threshold. 
 sqlerrp : SQLRW080 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFFFB      (6) 
0x00000002 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
You can also find SQLO_LT_sqeApplication__masterAppLatch latch 
being held from the stack.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users are affected.                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to the latest  fixpack.                       * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
Problem is first fixed in DB2 V10.1 fixpack 3.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC96351 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
06.09.2013
01.10.2013
01.10.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.3 FixList
10.1.0.3 FixList