Restore database ..Rename – parallel creating of dbfiles
I am currently migrating a relatively small IQ 16 database to a new location. However, the pre-allocated size of 4 Main and 4 Temp dbfiles is 1 TB each. Creating those files sequentially one-by-one in an NFS based environment is taking forever.
RESTORE database ‘/sybase/PBW_NLS/data/PBW_NLS.db’
FROM ‘/sybase/PBW_NLS/saparch_1/SAPPBWDB.IQfullbkp ‘
RENAME IQ_SYSTEM_MAIN TO ‘/sybase/PBW_NLS/data/SYSTEM_MAIN_00.IQ’
RENAME SAPIQDBSPACE001_001 TO ‘/sybase/PBW_NLS/nlsdata_1/PBW_NLS/PBW_NLS_01.IQ’
RENAME SAPIQDBSPACE001_002 TO ‘/sybase/PBW_NLS/nlsdata_2/ PBW_NLS/PBW_NLS_02.IQ’
Is there any way to create those files in parallel?