|
Problem IC68214
|
Status: Closed |
REDIRECT RESTORE OF DATABASE FAILS WITH SQL5153N |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
Redirect restore of a database fails with the following error
SQL5153N The update cannot be completed because the following
relationship
would be violated: "".
Following errors can be seen in the db2diag.log
2010-03-19-03.21.14.686996-240 E18178A946 LEVEL: Severe
PID : 143450 TID : 2058 PROC : db2sysc
INSTANCE: rohiraut NODE : 000 DB : CRCTST3
APPHDL : 0-8 APPID:
*LOCAL.rohiraut.100319072115
AUTHID : ROHIRAUT
EDUID : 2058 EDUNAME: db2agent (CRCTST3)
FUNCTION: DB2 UDB, database utilities, sqludProcessDBCfg,
probe:474
MESSAGE : SQL5153N The update cannot be completed because the
following
relationship would be violated: "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -5153 sqlerrml: 0
sqlerrmc:
sqlerrp : sqludPro
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:
2010-03-19-03.21.15.189518-240 E19125A1051 LEVEL: Error
(OS)
PID : 143450 TID : 2058 PROC : db2sysc
INSTANCE: rohiraut NODE : 000 DB : CRCTST3
APPHDL : 0-8 APPID:
*LOCAL.rohiraut.100319072115
AUTHID : ROHIRAUT
EDUID : 2058 EDUNAME: db2agent (CRCTST3)
FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing
violation."
DIA8519C A file sharing violation has occurred,
filename was "".
CALLED : OS, -, open
OSERR : ETXTBSY (26) "Text file busy"
DATA #1 : Codepath, 8 bytes
4:14:15:16:23:36:37
DATA #2 : File name, 71 bytes
/home/rohiraut/databases/CRCTST3/rohiraut/NODE0000/SQL00001///SQ
LDBCONF
DATA #3 : Bitmask, 4 bytes
0x0000004C
fuser for the file SQLDBCONF shows db2sysc as the holder
Note that this error only occurs on V9.5 FP5. Will be fixed in
V9,5 FP6 onwards. On all FixPaks's below Fp5 it works fine.
This error only occurs during a redirect restore and when
LOGSECOND is set to 254 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 V9.5 FP5 *
****************************************************************
* PROBLEM DESCRIPTION: *
* Redirect restore of a database fails with the following *
* error *
* *
* *
* SQL5153N The update cannot be completed because the *
* following *
* relationship *
* *
* would be violated: "". *
* *
* *
* *
* Following errors can be seen in the db2diag.log *
* *
* *
* *
* 2010-03-19-03.21.14.686996-240 E18178A946 LEVEL: *
* Severe *
* PID : 143450 TID : 2058 PROC : *
* db2sysc *
* INSTANCE: rohiraut NODE : 000 DB : *
* CRCTST3 *
* APPHDL : 0-8 APPID: *
* *
* *LOCAL.rohiraut.100319072115 *
* *
* AUTHID : ROHIRAUT *
* *
* EDUID : 2058 EDUNAME: db2agent (CRCTST3) *
* *
* FUNCTION: DB2 UDB, database utilities, sqludProcessDBCfg, *
* *
* probe:474 *
* *
* MESSAGE : SQL5153N The update cannot be completed because *
* the *
* following *
* *
* relationship would be violated: "". *
* *
* DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes *
* *
* sqlcaid : SQLCA sqlcabc: 136 sqlcode: -5153 sqlerrml: 0 *
* sqlerrmc: *
* *
* sqlerrp : sqludPro *
* *
* 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: *
* *
* *
* *
* 2010-03-19-03.21.15.189518-240 E19125A1051 LEVEL: *
* Error *
* (OS) *
* *
* PID : 143450 TID : 2058 PROC : *
* db2sysc *
* INSTANCE: rohiraut NODE : 000 DB : *
* CRCTST3 *
* APPHDL : 0-8 APPID: *
* *
* *LOCAL.rohiraut.100319072115 *
* *
* AUTHID : ROHIRAUT *
* *
* EDUID : 2058 EDUNAME: db2agent (CRCTST3) *
* *
* FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80 *
* *
* MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing *
* *
* violation." *
* *
* DIA8519C A file sharing violation has occurred, *
* *
* filename was "". *
* *
* CALLED : OS, -, open *
* *
* OSERR : ETXTBSY (26) "Text file busy" *
* *
* DATA #1 : Codepath, 8 bytes *
* *
* 4:14:15:16:23:36:37 *
* *
* DATA #2 : File name, 71 bytes *
* *
* /home/rohiraut/databases/CRCTST3/rohiraut/NODE0000/SQL00001///
* LDBCONF *
* *
* DATA #3 : Bitmask, 4 bytes *
* *
* 0x0000004C *
* *
* *
* *
* fuser for the file SQLDBCONF shows db2sysc as the holder *
* *
* *
* *
* Note that this error only occurs on V9.5 FP5. Will be fixed *
* in *
* V9,5 FP6 onwards. On all FixPaks's below Fp5 it works fine. *
* *
* *
* *
* This error only occurs during a redirect restore and when *
* *
* LOGSECOND is set to 254 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V9.5 FP6 *
**************************************************************** |
| Local Fix: |
1. Move the instance to V9.5 FP4 and then do the redirect
restore.
2. Update db cfg parameter LOGSECOND to less that 254. Take a
new backup and then do the redirect restore |
| available fix packs: |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
1. Move the instance to V9.5 FP4 and then do the redirect
restore.
2. Update db cfg parameter LOGSECOND to less that 254. Take a
new backup and then do the redirect restore |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.04.2010
10.01.2011
10.01.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP4,
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.3
|
 |
