On Windows, when specifying storage paths in DB2, if a storage
path contains a junction (mount) point, DB2 will end up
obtaining incorrect information about the mounted storage path
(e.g. incorrect filesystem ID, incorrect storage free space).
This can result in incorrect storage path information being
reported in database snapshots taken against databases
containing such storage paths. The problem stems from how DB2
gathers this information internally.
This issue can also be seen when attempting to restore the
database using the ON clause to define the automatic storage
paths.
The restore can fail with SQLO_DISK in routine/functions
sqlbASDefineContainersForDMS & sqlbRestoreASContainers.
db2diag.log:
2011-04-14-15.24.34.565000+060 I6664H709 LEVEL: Error
PID : 2088 TID : 6096 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 6096 EDUNAME: db2bm.4248.0 (NEWDB) 0
FUNCTION: DB2 UDB, buffer pool services,
sqlbASDefineContainersForDMS, probe:10
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
DATA #1 : String, 8 bytes
TBSPACE01
DATA #2 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
5
DATA #3 : unsigned integer, 4 bytes
0
DATA #4 : unsigned integer, 4 bytes
0
DATA #5 : unsigned integer, 4 bytes
524256
DATA #6 : unsigned integer, 1 bytes
1
DATA #7 : Boolean, 1 bytes
false
2011-04-14-15.24.34.581000+060 I7375H572 LEVEL: Severe
PID : 2088 TID : 6096 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 6096 EDUNAME: db2bm.4248.0 (NEWDB) 0
FUNCTION: DB2 UDB, buffer pool services,
sqlbRestoreASContainers, probe:40
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
DIA8312C Disk was full.
DATA #1 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
5
DATA #2 : Pool flags, PD_TYPE_SQLB_POOL_FLAGS, 4 bytes
4386
DATA #3 : unsigned integer, 4 bytes
160
2011-04-14-15.24.34.643000+060 E7949H443 LEVEL: Error
PID : 2088 TID : 6096 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 6096 EDUNAME: db2bm.4248.0 (NEWDB) 0
FUNCTION: DB2 UDB, database utilities, sqludProcessSPCS,
probe:3583
DATA #1 : <preformatted>
Problem restoring table space TBSPACE01 (5).
Function return code: 0, container return code = -2062614516.
2011-04-14-15.24.34.643000+060 E8394H370 LEVEL: Warning
PID : 2088 TID : 6096 PROC :
db2syscs.exe
INSTANCE: DB2 NODE : 000
EDUID : 6096 EDUNAME: db2bm.4248.0 (NEWDB) 0
FUNCTION: DB2 UDB, database utilities, sqludProcessSPCS,
probe:3613
DATA #1 : <preformatted>
Skipping table space TBSPACE01. |
