jzhardy
Active User
Joined: 31 Oct 2006
Posts: 131
Location: brisbane
|
|
|
|
I have a requirement to backup a number of databases and provide a facility to restore them. The tablespaces are are small and can be unloaded into single datasets, but there are a lot of them (approx 300).
db2 admin (Unload) puts the following in the control file
| Code: |
LOAD DATA INDDN SYSREC LOG NO RESUME YES
EBCDIC CCSID(00037,00000,00000)
INTO TABLE
... |
ideally i would want the following defaults :
| Code: |
LOAD DATA INDDN SYSREC LOG NO NOCOPYPEND REPLACE
STATISTICS TABLE INDEX UPDATE ALL
INTO TABLE
... |
Can this be done within the db2 admin facility?
Any help appreciated. |
|
