Hi Jan, Please make sure the source (from) database has been shutdown by using 'sqlend dverfy' before start your DDR. Or you may get a ARIYI19 09 abend when you start your copied DB.
After that you have to modify a few database specified files in the target (new) DB's 195 disk to point to the target DB, unless you only DDR copy the BDISK and DDSKs. i.e.:
dbname SQLDBGEN - in case you perform another DBGEN
dbname SQLDBN - contains: db cms id, dcssid, dbname and amode
dbname SQLFDEF - contains owner cms id of bdisk & ddsks
dbname SQLDBN - contains: db cms id, dcssid, dbname and amode
dbname SQLFDEF - contains owner cms id of bdisk & ddsks
and the most important:
ARISPIDC MACRO - contains cms id owner of 193 & 195
My 2 cents.
Good luck
... Roland
Robert Payne <[EMAIL PROTECTED]> wrote:
We do this sort of thing 2 or 3 times a year. I use DDR to copy the mini-disks
(REXX procedure invokes DDR) and it makes the process easy. If you want, I'll
send off list. It's not a fancy solution, but works. After copying the DB/2 data
mdisks (not the one with the code) you have to do a "COLDLOG" procedure to make
it happy.
:)
Bubba
817 595-6146 office
-----Original Message-----
From: VM/ESA and z/VM Discussions [mailto:[EMAIL PROTECTED]
Behalf Of Janice Rank
Sent: Monday, February 13, 2006 7:59 AM
To: [email protected]
Subject: Db2 Restore
Listers,
Has anyone set up REXX execs they wouldn't mind sharing for using DB2
RESTORE to populate a test database from production that they wouldn't
mind sharing with me. Up until now we have had only one VM version 7.3
DB2 database that has a full backup on a w! eekly basis. We are on
zVM/ESA 3.1.0. We would now like to start using that backup to build a
test database in the same VM system, but on a different virtual machine.
I have very limited knowledge of using REXX and CP or CMS. You can
contact me off list at the e-mail address I listed below if you would
like.
Thanks for any help,
Jan Rank
DBA
Medico Insurance Company
Medico Life Insurance Company
1515 South 75th Street
Omaha, NE. 68124
(402)391-6900 Ext.517
(402)391-6489 Fax
[EMAIL PROTECTED]
This message contains confidential information and is intended only for
the individual named. If you are not the named addressee, you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and
delete this e-mail from your system. E-mail transmission cannot be
guaranteed to be secure or error-free as information could be
intercep! ted, corrupted, lost, destroyed, arrive late or incomplete, or
contain viruses. The sender therefore does not accept liability for any
errors or omissions in the contents of this message which arise as a
result of e-mail transmission. If verification is required, please
request a hard copy version.
Medico Insurance Company
Medico Life Insurance Company
1515 South 75th St., Omaha, NE 68124.
With best regards,
...Roland Chung
Senior Technical Specialist (S/390,VM/VSE,DB2/VSE&VM)
MAXC Consultants Inc.
Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268)
197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6
** Life is short. Stop once in a while and smell the roses. **
