At first, apology, as we are planning to get to the latest version, before which we want to refresh a production copy in non-prod.
Current state:
CMDO 9.0.0.6, DB2 9.7 FP10, OS Windows 2008 R2, we have cache_only option.
The non-prod/prod cache is on D drive of their own local disks.
[CACHE]
SMFS1=D:\IBM\OnDemandServer\arscache1
SMFS_NUM=1
The plan is
1. Take a backup of current non-prod DB, backup of current arscache1(this may not require, however we wanted to be safe just in case), take prod backup of DB
2. New drive is created in non-prod to hold prod arscache1 files in F drive from prod.
3. Copied prod arscache1 to non-prod new drive.
4. Add the new arscache1 to point to new location on F drive
we can not remove the current arscache(from one of the technote), we rather have to add the second entry. We have not tested, but after we add the second entry, can we remove the first? (if that will not cause a problem, we are OK to do so and have only one arscache1).
==>Assuming we will have two entries<==
[CACHE]
SMFS1=D:\IBM\OnDemandServer\arscache1
SMFS2=F:\ars\arscache1
SMFS_NUM=2
5. restore the DB from prod to non-prod. Yes non-prod and prod are on same version of OS, DB, CMOD. We also made the db2 admin, and od admin id/pass the same just in case. Once this is complete, we will do the new OS, DB, CMOD upgrade a clean.
Do we need anything else to be done?
Thank you