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 IC85259 Status: Closed

IN A DB2 MULTI-PARTITION (DPF) ENVIRONMENT, SQL0960C AND TDA FIL E
ACCUMULATION CAN RESULT WHEN CREATING GLOBAL TEMPORARY TABLES.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
In a DB2 MULTI-PARTITION (DPF) configuration (where the 
applications are connected at non-catalog partitions), an 
interrupt detected during connection termination can result in 
the following probes to the db2diag.log: 
 
2012-06-25-07.35.23.965277+540 I7405212A1209      LEVEL: Warning 
PID     : 127116               TID  : 26243       PROC : db2sysc 
3 
INSTANCE: db2inst1             NODE : 003         DB   : SAMPLE 
APPHDL  : 3-613                APPID: 
12.30.47.77.56095.120624223508 
AUTHID  : DB2INST1 
EDUID   : 26243                EDUNAME: db2agent (SAMPLE) 3 
FUNCTION: DB2 UDB, base sys utilities, 
sqeAgent::AgentBreathingPoint, probe:16 
CALLSTCK: 
  [0] 0x0900000006E5B7F8 pdLog + 0xF0 
  [1] 0x0900000004B0476C pdLog@glue40E + 0x94 
  [2] 0x0900000003B47F90 AgentBreathingPoint__8sqeAgentFi + 0x2C 
  [3] 0x09000000070775E8 
AgentBreathingPoint__8sqeAgentFi@glue198 + 0x78 
  [4] 0x0900000003EA37EC 
sqlrkrpc_nl__FP8sqlrr_cbiN22PsP15SQLR_RPCMESSAGEP13SQLO_MEM_POOL 
P18SQLR_RPC_REPLY_HDRPbPl + 0x178 
  [5] 0x0900000003F9C8AC 
sqlrl_userTempReleaseFIDTID__FP8sqlrr_cbiT2P21sqlrl_userTempDrop 
pedT2P16sqlr_usertemp_cb + 0x774 
  [6] 0x09000000049E2DE8 
sqlrl_userTempCleanup__FP8sqlrr_cbiP16sqlr_usertemp_cb + 0x64C 
  [7] 0x09000000035E755C sqlrr_appl_term__FP8sqeAgentiP5sqlca + 
0x79C 
  [8] 0x0900000006DE4350 
AppStopUsing__14sqeApplicationFP8sqeAgentUcP5sqlca + 0x650 
  [9] 0x0900000006DFCF5C sqlesrspWrp__FP14db2UCinterface + 0xEC 
 
 
2012-06-25-07.35.23.969501+540 I7406422A569       LEVEL: Error 
PID     : 127116               TID  : 26243       PROC : db2sysc 
3 
INSTANCE: db2inst1             NODE : 003         DB   : SAMPLE 
APPHDL  : 3-613                APPID: 
12.30.47.77.56095.120624223508 
AUTHID  : DB2INST1 
EDUID   : 26243                EDUNAME: db2agent (SAMPLE) 3 
FUNCTION: DB2 UDB, catalog services, 
sqlrl_userTempReleaseFIDTID, probe:20 
RETCODE : ZRC=0x80120003=-2146303997=SQLR_INTRP 
          "Statement interrupt, detected at RDS" 
          DIA8003C The interrupt  has been received. 
 
2012-06-25-07.35.23.978135+540 I7406992A563       LEVEL: Error 
PID     : 127116               TID  : 26243       PROC : db2sysc 
3 
INSTANCE: db2inst1             NODE : 003         DB   : SAMPLE 
APPHDL  : 3-613                APPID: 
12.30.47.77.56095.120624223508 
AUTHID  : DB2INST1 
EDUID   : 26243                EDUNAME: db2agent (SAMPLE) 3 
FUNCTION: DB2 UDB, catalog services, sqlrl_userTempCleanup, 
probe:90 
RETCODE : ZRC=0x80120003=-2146303997=SQLR_INTRP 
          "Statement interrupt, detected at RDS" 
          DIA8003C The interrupt  has been received. 
 
2012-06-25-07.35.23.978289+540 I7407556A560       LEVEL: Error 
PID     : 127116               TID  : 26243       PROC : db2sysc 
3 
INSTANCE: db2inst1             NODE : 003         DB   : SAMPLE 
APPHDL  : 3-613                APPID: 
12.30.47.77.56095.120624223508 
AUTHID  : DB2INST1 
EDUID   : 26243                EDUNAME: db2agent (SAMPLE) 3 
FUNCTION: DB2 UDB, relation data serv, sqlrr_appl_term, 
probe:850 
RETCODE : ZRC=0x80120003=-2146303997=SQLR_INTRP 
          "Statement interrupt, detected at RDS" 
          DIA8003C The interrupt  has been received. 
 
This would indicate that loss of the file token(s) that were in 
the process of being released during application termination 
processing.   This loss of file tokens (if the problem recurs 
enough) can lead to a subsequent exhaustion of file tokens for a 
user temporary tablespace resulting in SQL0960N errors 
 
2012-06-24-23.59.05.787521+540 I1838A537          LEVEL: Error 
 
PID     : 439676               TID  : 17308       PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE 
APPHDL  : 3-55406              APPID: 
12.30.47.77.44519.120826022356 
AUTHID  : DB2INST1 
 
EDUID   : 17308                EDUNAME: db2agntp (SAMPLE) 0 
 
FUNCTION: DB2 UDB, catalog services, sqlrl_userTempGetInfo, 
probe:320 
RETCODE : ZRC=0x85020007=-2063466489=SQLB_NTOK "no file token 
available" 
                  DIA8307C Maximum file tokens were used. 
 
In addition the user temporary tablespace may see an 
accumulation of TDA files due to the loss of the FID (resulting 
in a lack of re-use of the files).
Problem Summary:
In a DB2 MULTI-PARTITION (DPF) configuration (where the 
applications are connected at non-catalog partitions), an 
interrupt detected during connection termination can result in 
the following probes to the db2diag.log: 
 
2012-06-25-07.35.23.965277+540 I7405212A1209      LEVEL: Warning 
PID     : 127116               TID  : 26243       PROC : db2sysc 
3 
INSTANCE: db2inst1             NODE : 003         DB   : SAMPLE 
APPHDL  : 3-613                APPID: 
12.30.47.77.56095.120624223508 
AUTHID  : DB2INST1 
EDUID   : 26243                EDUNAME: db2agent (SAMPLE) 3 
FUNCTION: DB2 UDB, base sys utilities, 
sqeAgent::AgentBreathingPoint, probe:16 
CALLSTCK: 
  [0] 0x0900000006E5B7F8 pdLog + 0xF0 
  [1] 0x0900000004B0476C pdLog@glue40E + 0x94 
  [2] 0x0900000003B47F90 AgentBreathingPoint__8sqeAgentFi + 0x2C 
  [3] 0x09000000070775E8 
AgentBreathingPoint__8sqeAgentFi@glue198 + 0x78 
  [4] 0x0900000003EA37EC 
sqlrkrpc_nl__FP8sqlrr_cbiN22PsP15SQLR_RPCMESSAGEP13SQLO_MEM_POOL 
P18SQLR_RPC_REPLY_HDRPbPl + 0x178 
  [5] 0x0900000003F9C8AC 
sqlrl_userTempReleaseFIDTID__FP8sqlrr_cbiT2P21sqlrl_userTempDrop 
pedT2P16sqlr_usertemp_cb + 0x774 
  [6] 0x09000000049E2DE8 
sqlrl_userTempCleanup__FP8sqlrr_cbiP16sqlr_usertemp_cb + 0x64C 
  [7] 0x09000000035E755C sqlrr_appl_term__FP8sqeAgentiP5sqlca + 
0x79C 
  [8] 0x0900000006DE4350 
AppStopUsing__14sqeApplicationFP8sqeAgentUcP5sqlca + 0x650 
  [9] 0x0900000006DFCF5C sqlesrspWrp__FP14db2UCinterface + 0xEC 
 
 
2012-06-25-07.35.23.969501+540 I7406422A569       LEVEL: Error 
PID     : 127116               TID  : 26243       PROC : db2sysc 
3 
INSTANCE: db2inst1             NODE : 003         DB   : SAMPLE 
APPHDL  : 3-613                APPID: 
12.30.47.77.56095.120624223508 
AUTHID  : DB2INST1 
EDUID   : 26243                EDUNAME: db2agent (SAMPLE) 3 
FUNCTION: DB2 UDB, catalog services, 
sqlrl_userTempReleaseFIDTID, probe:20 
RETCODE : ZRC=0x80120003=-2146303997=SQLR_INTRP 
          "Statement interrupt, detected at RDS" 
          DIA8003C The interrupt  has been received. 
 
2012-06-25-07.35.23.978135+540 I7406992A563       LEVEL: Error 
PID     : 127116               TID  : 26243       PROC : db2sysc 
3 
INSTANCE: db2inst1             NODE : 003         DB   : SAMPLE 
APPHDL  : 3-613                APPID: 
12.30.47.77.56095.120624223508 
AUTHID  : DB2INST1 
EDUID   : 26243                EDUNAME: db2agent (SAMPLE) 3 
FUNCTION: DB2 UDB, catalog services, sqlrl_userTempCleanup, 
probe:90 
RETCODE : ZRC=0x80120003=-2146303997=SQLR_INTRP 
          "Statement interrupt, detected at RDS" 
          DIA8003C The interrupt  has been received. 
 
2012-06-25-07.35.23.978289+540 I7407556A560       LEVEL: Error 
PID     : 127116               TID  : 26243       PROC : db2sysc 
3 
INSTANCE: db2inst1             NODE : 003         DB   : SAMPLE 
APPHDL  : 3-613                APPID: 
12.30.47.77.56095.120624223508 
AUTHID  : DB2INST1 
EDUID   : 26243                EDUNAME: db2agent (SAMPLE) 3 
FUNCTION: DB2 UDB, relation data serv, sqlrr_appl_term, 
probe:850 
RETCODE : ZRC=0x80120003=-2146303997=SQLR_INTRP 
          "Statement interrupt, detected at RDS" 
          DIA8003C The interrupt  has been received. 
 
This would indicate that loss of the file token(s) that were in 
the process of being released during application termination 
processing.   This loss of file tokens (if the problem recurs 
enough) can lead to a subsequent exhaustion of file tokens for a 
user temporary tablespace resulting in SQL0960N errors 
 
2012-06-24-23.59.05.787521+540 I1838A537          LEVEL: Error 
 
PID     : 439676               TID  : 17308       PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE 
APPHDL  : 3-55406              APPID: 
12.30.47.77.44519.120826022356 
AUTHID  : DB2INST1 
 
EDUID   : 17308                EDUNAME: db2agntp (SAMPLE) 0 
 
FUNCTION: DB2 UDB, catalog services, sqlrl_userTempGetInfo, 
probe:320 
RETCODE : ZRC=0x85020007=-2063466489=SQLB_NTOK "no file token 
available" 
                  DIA8307C Maximum file tokens were used. 
 
In addition the user temporary tablespace may see an 
accumulation of TDA files due to the loss of the FID (resulting 
in a lack of re-use of the files).
Local Fix:
Ensure connections are terminated with proper disconnect/connect 
resets or are forced off to avoid this interrupt detection. 
Restarting the database reclaims the lost file tokens as well - 
so a periodic db restart can keep this from causing application 
errors.
available fix packs:
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in DB2 Version 9.7 Fix Pack7.
Workaround
Ensure connections are terminated with proper disconnect/connect 
resets or are forced off to avoid this interrupt detection. 
Restarting the database reclaims the lost file tokens as well - 
so a periodic db restart can keep this from causing application 
errors.
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC88612 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
12.07.2012
23.10.2012
23.10.2012
Problem solved at the following versions (IBM BugInfos)
9.7.
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.7 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.