During a redirected restore of a database with automatic
storage. If you specify a number of paths less than the
original number of paths in the backup it can fail with
SQL1051N.
Example:
The original 8 automatic storage paths are path1 - path8
Given the restore command:
db2 restore db sample from /backup ON
'newpath1', 'newpath2', 'newpath3', 'newpath4'
DBPATH ON 'dbpath'
It can fail with an SQL1015N and you will see messages similar
to the following in the db2diag.log:
2009-11-21-17.49.03.759130-300 I124239656E584 LEVEL: Severe
PID : 5359 TID : 47033587067200PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 10224 EDUNAME: db2bm.9159.0 (LRT)
FUNCTION: DB2 UDB, buffer pool services,
sqlbReadStorageGroupEntry, probe:30
MESSAGE :
ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
"Storage path does not exist or is inaccessible."
DATA #1 : String, 38 bytes
Error reading from storage group files
DATA #2 : signed integer, 8 bytes
0
DATA #3 : Pointer, 8 bytes
0x00002ac6dc3fcce8
2009-11-21-17.49.03.759353-300 I124240241E1341 LEVEL: Error
(OS)
PID : 5359 TID : 47033587067200PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 10224 EDUNAME: db2bm.9159.0 (LRT)
FUNCTION: DB2 Common, OSSe, ossGetDiskInfo, probe:150
MESSAGE : ECF=0x9000001A=-1879048166=ECF_FILE_DOESNT_EXIST
File doesn't exist
CALLED : OS, -, stat OSERR: ENOENT
(2)
DATA #1 : String, 12 bytes
/path8
DATA #2 : unsigned integer, 8 bytes
384
CALLSTCK:
[0] 0x00002AC547159F5B pdOSSeLoggingCallback + 0x91
[1] 0x00002AC54C1E69EB /opt/ibm/db2/V9.5/lib64/libdb2osse.so.1
+ 0x1AD9EB
[2] 0x00002AC54C1E7E1F ossLogSysRC + 0x113
[3] 0x00002AC54C1FD29E ossGetDiskInfo + 0xB74
[4] 0x00002AC5471CBC31
_Z21sqlbGetFileSystemInfoPcP11OSSDiskInfoj + 0xE3
[5] 0x00002AC5471C9200
_Z30sqlbCopyStoragePathsFromDiskCBPcmP13SQLO_MEM_POOLS_
P20SQLB_STORAGEGROUP_CBj + 0x206
[6] 0x00002AC5471C8B09
_Z25sqlbReadStorageGroupEntryPcl12SQLO_FHANDLElP13SQLO_
MEM_POOLPP20SQLB_STORAGEGROUP_CBj + 0x1A3
[7] 0x00002AC5471C847E
_Z20sqlbReadStorageGrouplP23SQLB_STORAGEGROUP_TABLEP13S
QLO_MEM_POOLPcj + 0x13E
[8] 0x00002AC5471CA055
_Z25sqlbReadStorageGroupTablePcP23SQLB_STORAGEGROUP_TAB
LEP13SQLO_MEM_POOLj + 0x8B |
