| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC77353 | Status: Closed |
RESTORE WITH MULTIPLE DB2BM THREADS MAY HIT SQL1042C IF SOME DB2BM TAKES MORE THAN 1000 SECONDS FOR DB2AGENT's POLL | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
Restore database with multiple db2bm threads may hit SQL1042C if
some db2bm takes more than 1000 seconds to answer db2agent's
poll.
Likely db2pd -edu shows only one db2bm existing for very long
time.
In db2diag.log, db2agent hit -1042 at sqludPollMsg, probe:155
2010-09-29-15.04.01.114077-240 E461752A546 LEVEL: Severe
PID : 37696862 TID : 1801 PROC : db2sysc
INSTANCE: weiren NODE : 000 DB : DB85357
APPHDL : 0-7 APPID: *LOCAL.weiren.100929183819
AUTHID : WEIREN
EDUID : 1801 EDUNAME: db2agent (DB85357)
FUNCTION: DB2 UDB, database utilities, sqludPollMsg, probe:155
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-1042
DATA #2 : Hexdump, 4 bytes
0x0700000032E14978 : FFFF FBEE
....
2010-09-29-15.04.01.114608-240 E462299A876 LEVEL: Severe
PID : 37696862 TID : 1801 PROC : db2sysc
INSTANCE: weiren NODE : 000 DB : DB85357
APPHDL : 0-7 APPID: *LOCAL.weiren.100929183819
AUTHID : WEIREN
EDUID : 1801 EDUNAME: db2agent (DB85357)
FUNCTION: DB2 UDB, database utilities, sqludPollMsg, probe:155
MESSAGE : SQL1042C An unexpected system error occurred.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1042 sqlerrml: 0
sqlerrmc:
sqlerrp : sqludPol
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * RESTORE WITH MULTIPLE DB2BM THREADS MAY HIT SQL1042C IF SOME * * DB2BM TAKES MORE THAN 1000 SECONDS FOR DB2AGENT's POLL * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW Version 9.7 Fix Pack 4 * **************************************************************** | |
| Local Fix: | |
Explicitly specify parallelism to 1 in restore database command. | |
| Solution | |
Problem was first fixed in Version 9.7 Fix Pack 4 | |
| Workaround | |
See Local Fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.07.2011 11.07.2011 11.07.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP4 | |
| Problem solved according to the fixlist(s) of the following version(s) | |