Hi,
We have successfully restored production database to Sandbox ECC system.
I have executed the following command like that :-
db2 -tvf prodtest.clp
UPDATE COMMAND OPTIONS USING S ON Z ON PR1_NODE0000.out V ON
DB20000I The UPDATE COMMAND OPTIONS command completed successfully.
SET CLIENT ATTACH_DBPARTITIONNUM 0
DB20000I The SET CLIENT command completed successfully.
SET CLIENT CONNECT_DBPARTITIONNUM 0
DB20000I The SET CLIENT command completed successfully.
RESTORE DATABASE PE1 FROM '/sapbackup/sapbackup/PE1' TAKEN AT 20130610221844 ON
'/db2/SN1/sapdata1' , '/db2/SN1/sapdata2' , '/db2/SN1/sapdata3' , '/db2/SN1/s
apdata4' DBPATH ON '/db2/SN1' INTO SN1 NEWLOGPATH '/db2/SN1/log_dir/NODE0000/' R
EPLACE HISTORY FILE REPLACE EXISTING REDIRECT WITHOUT ROLLING FORWARD
SQL2528W Warning! Restoring to an existing database that is the same as the
backup image database, but the alias name "SN1" of the existing database does
not match the alias "PR1" of backup image, and the database name "SN1" of the
existing database does not match the database name "PR1" of the backup image.
The target database will be overwritten by the backup version.
SQL1277W A redirected restore operation is being performed. Table space
configuration can now be viewed and table spaces that do not use automatic
storage can have their containers reconfigured.
DB20000I The RESTORE DATABASE command completed successfully.
But in last line we got an error message like
The restore process has completed successfully, but one or more table spaces from the backup were not restored.
Kindly Help.
Regards,
Soumya Biswas