What you are attemting is pzartially correct.
Putting your running db in write suspend is the first step.
Using file system copy to the target is the next. It depends on what how
you plan to use the db on the target: standby, snapshot or mirror.
You will have more or less to copy.
Once copied the write resume is the proper way.
On the target, you have to ensure that either ALL of the following are true
and the same:
Instance name, db bname, dbpath,logpath,archivelogpath,all container paths.
Then you can use the:
db2inidb command with the proper parm.
If one or some or all of the above change, you will have to read the docs
and learn to use the relocatedb command to generate the specific file that
will tell what to relocate.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Bernard Dhooghe" <dh******@yahoo.com> a écrit dans le message de news:
11*********************@j55g2000cwa.googlegroups.c om...
Suppose a running database (DB2 UDB) with all containers being SMS
based (file system as JFS or JFS2 on AIX).
How to make a backup (online) by doing a file system backup and not a
database backup?
Could this be done with:
db2 set write suspend for db
backup file system data used by db2 data and logs
db2 set write resume for db
with the purpose of doing:
restore of db2 file system data on another system
startup and usage of database.
The questions are:
- will the restored database be consistent after start/restart
- what additional resources are taken between suspend write and
resume write (a file system backup takes more time that just splitting
off a snapshot in a storage subsystem).
Bernard Dhooghe