Hi,
I tried to restore DB2 UDB two databases into two different instances on AIX server. the raw devices size on the two instances are the same.
# lsvg -l datavg
datavg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
db2templv jfs 52 52 1 open/syncd /db2temp
loglv00 jfslog 1 1 1 open/syncd N/A
RegSpace0 jfs 12 12 1 closed/syncd N/A
RegSpace1 jfs 12 12 1 closed/syncd N/A
RegSpace2 jfs 12 12 1 closed/syncd N/A
RegSpace3 jfs 12 12 1 closed/syncd N/A
ShortSpace1 jfs 12 12 1 closed/syncd N/A
ShortSpace2 jfs 12 12 1 closed/syncd N/A
ShortSpace3 jfs 12 12 1 closed/syncd N/A
IndexSpace1 jfs 3 3 1 closed/syncd N/A
IndexSpace2 jfs 3 3 1 closed/syncd N/A
IndexSpace3 jfs 3 3 1 closed/syncd N/A
ShortSpace0 jfs 12 12 1 closed/syncd N/A
IndexSpace0 jfs 3 3 1 closed/syncd N/A
db2backup jfs 80 80 1 open/syncd /db2/backup
LongSpace0 jfs 128 128 1 open/syncd /db2/longspace
when I issue the command "set tablespace containers for 5 replay rollforward container operations using (DEVICE "/dev/rShortSpace1" 196608)
I got the error: "SQL1422N The size of the container is invalid. SQLSTATE=54039:
However, it works fine for the other instance as:
set tablespace containers for 5 replay rollforward container operations using (DEVICE "/dev/rShortSpace0" 196608)
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
Does anyone can tell me reason?