| 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 IC63982 | Status: Closed |
IF RESTORE GENERATION SCRIPT RUNS AFTER LOAD HAS BEEN STARTED, USERS MAY GET ERROR ON LOAD. | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
If restore with generate script command is issued while load
is going on , Load may fail with SQL3508.
db2diag log may show errors similar to:
2009-01-07-15.36.54.799378-300 I86444300A513 LEVEL: Error
PID : 1236540 TID : 1 PROC :
db2agent (SAMPLE) 0
INSTANCE: db2qa4 NODE : 000 DB : SAMPLE
APPHDL : 0-623 APPID:
172.30.248.135.49899.0904071626
AUTHID : LOADER
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 138 bytes
LOADID: 1650730.2009-04-07-11.26.16.620873.0 (146;4)
open locfile for read failed! , -2045837302, 0, Detected in
file:sqlulocf.C, Line:272
2009-01-07-15.36.54.799739-300 I86444814A1023 LEVEL: Error
PID : 1236540 TID : 1 PROC :
db2agent (SAMPLE) 0
INSTANCE: db2SAMPLE NODE : 000 DB :
SAMPLE
APPHDL : 0-623 APPID:
172.30.248.135.49899.0904071626
AUTHID : LOADER
FUNCTION: DB2 UDB, database utilities, sqluReadLocFile,
probe:279
MESSAGE : ZRC=0x8015006D=-2146107283=SQLU_CA_BUILT
"SQLCA has already been built"
DATA #1 : LOADID, PD_TYPE_LOADID, 44 bytes
1650730.2009-01-07-10.26.16.620873.0 (146;4)
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -3508 sqlerrml:
70
sqlerrmc: LOCATION FILE 1
/db2/SAMPLE/db2SAMPLE/NODE0000/SQL00001/load/DB200012.PID/DB
sqlerrp : SQLULOCF
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:
2009-01-07-15.36.54.838984-300 I86445838A415 LEVEL: Severe
PID : 1236540 TID : 1 PROC :
db2agent (SAMPLE) 0
INSTANCE: db2SAMPLE NODE : 000 DB :
SAMPLE
APPHDL : 0-623 APPID:
172.30.248.135.49899.0904071626
AUTHID : LOADER
FUNCTION: DB2 UDB, database utilities, sqluRegisterLoadEnd,
probe:476
MESSAGE : Load Error: Failed to set temporary file path. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * db2 users on all platforms * **************************************************************** * PROBLEM DESCRIPTION: * * Unable to run a restore generate script command whilst * * running a load operation.The load operation fails. * **************************************************************** * RECOMMENDATION: * * move up to version with fix in it. * **************************************************************** | |
| Local Fix: | |
Do not run restore with generate script command while load is running. | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
| Solution | |
First Fixed in Version 9.7 Fixpack 1 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.10.2009 16.03.2010 16.03.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7.FP1 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.1 |
|