|
Problem IC62910
|
Status: Closed |
LOAD COMMAND WITH IXF FILE AND CPU_PARALLELISM > 1 MAY WRITE ERROR MESSAGE IN DB2DIAG LOG. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
Load command with IXF file and CPU_PARALLELISM > 1 may write
error message in db2diag.log.
When users issue load command with IXF input file format, and
using CPU_PARALLELISM > 1 (implicitly or explicitly),
db2diag.log may show the following messages while load finishes
successfully. The error message is harmless.
2009-07-02-06.45.37.013193-240 I143075A951 LEVEL: Error
PID : 4313 TID : 2199112486608PROC : db2lfrm1 0
INSTANCE: dblpa NODE : 000 DB : DWEBPPA
APPHDL : 0-87 APPID: *LOCAL.dblpa.090702104528
AUTHID : DBLPA
FUNCTION: DB2 UDB, database utilities, sqluGetShadowedWorkArea,
probe:5001
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 41 bytes
27759.2009-07-02-06.45.31.383921.0 (25;2)
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLULDAT
sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
The APAR fix will remove the confusing message. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* Load command with IXF file and CPU_PARALLELISM > 1 may write *
* *
* error message in db2diag.log. *
* *
* *
* *
* When users issue load command with IXF input file format, *
* and *
* using CPU_PARALLELISM > 1 (implicitly or explicitly), *
* *
* db2diag.log may show the following messages while load *
* finishes *
* successfully. The error message is harmless. *
* *
* *
* *
* 2009-12-02-06.45.37.013193-240 I143075A951 LEVEL: Error *
* *
* PID : 4313 TID : 2199112486608PROC : db2lfrm1 0 *
* *
* INSTANCE: db2inst1 NODE : 000 DB : DBTEST *
* *
* APPHDL : 0-87 APPID: *LOCAL.db2inst1.090702104528 *
* *
* AUTHID : DB2test *
* *
* FUNCTION: DB2 UDB, database utilities, *
* sqluGetShadowedWorkArea, *
* probe:5001 *
* *
* MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT *
* *
* "SQLCA has already been built" *
* *
* DATA #1 : LOADID, PD_TYPE_LOADID, 41 bytes *
* *
* 27759.2009-07-02-06.45.31.383921.0 (25;2) *
* *
* DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes *
* *
* sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3025 sqlerrml: 0 *
* *
* sqlerrmc: *
* *
* sqlerrp : SQLULDAT *
* *
* sqlerrd : (1) 0x8015006D (2) 0x00000000 (3) 0x00000000 *
* *
* (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 *
* *
* sqlwarn : (1) (2) (3) (4) (5) (6) *
* *
* (7) (8) (9) (10) (11) *
* *
* sqlstate: *
****************************************************************
* RECOMMENDATION: *
* none *
**************************************************************** |
| Local Fix: |
Ignore the harmless message, OR use CPU_PARALLELISM 1 in load
command. |
| available fix packs: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
The APAR fix will remove the confusing message.
Problem was first fixed in Version 9.1 FP9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.09.2009
16.04.2010
16.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.9
|
 |
