Upgrading database (UPGRADE DATABASE) or restore from pre-10.1
version to 10.1 or higher might cause container path in
tablespace control file (SQLSPCS) to get corrupted if database
path is a symbolic link. This problem might be encountered for
tablespaces which are created within database path using fully
qualified directory name.
As the result, upgrade of that database might fail with:
SQL0980C A disk error occurred. Subsequent SQL statements
cannot be processed
or
SQL0902C A system error occurred. Subsequent SQL statements
cannot be processed
db2diag.log will indicate that one of database containers cannot
be accessed:
restore:
2015-07-03-06.49.59.354776+120 I131009E684 LEVEL:
Severe
PID : 10440 TID : 140153825781504 PROC :
db2sysc 0
INSTANCE: edwdev NODE : 000 DB :
EDWDB
APPHDL : 0-99 APPID: *N0.edwdev.150703044954
AUTHID : EDWDEV HOSTNAME: db2inst1.db2.pl.ibm.com
EDUID : 306 EDUNAME: db2agent (EDWDB) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbUpdateCntrTag,
probe:11528
MESSAGE : ZRC=0x870F0011=-2029060079=SQLO_PATH "an invalid path"
DIA8514C An invalid file path, "", was specified.
DATA #1 : String, 69 bytes
Error occurred while updating container tags during database
upgrade.
upgrade:
2015-07-23-10.43.28.285716+120 I415681E713 LEVEL:
Error
PID : 22974 TID : 140373254989568 PROC :
db2sysc 1
INSTANCE: edwdev NODE : 001 DB :
EDWDB
APPHDL : 0-59 APPID: *N0.edwdev.150723084312
AUTHID : EDWDEV HOSTNAME: db2inst1.db2.pl.ibm.com
EDUID : 67 EDUNAME: db2agntp (EDWDB) 1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp,
probe:810
MESSAGE :
ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
DATA #1 :
Error checking container 0
(/db2fs/edwdev/NODE0001/SQL00001/DE0001/edwdev/EDWDB/ts_small_re
al) for tbsp 6. Rc = 870F0011
Examination of tablespace control files (SQLSPCS) will indicate
that path to tablespace container is corrupted (truncated) |
