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?
Regards
Axel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
10 | |
10 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |