I tried to restore DB2 UDB two databases into two different instances on AIX
server. the raw devices size of rShortSpace0 and rShortSpace1 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 if the container size are setup correctly or not
in this case?
Thanks!
Lan
--
Message posted via http://www.dbmonster.com