Db2 Restore

[Janice Rank]

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 weekly 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
[phone] Ext.517
[phone] Fax
***@gomedico.com

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
intercepted, 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.

[Robert Payne]

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:VMESA-***@LISTSERV.UARK.EDU]On
Behalf Of Janice Rank
Sent: Monday, February 13, 2006 7:59 AM
To: VMESA-***@LISTSERV.UARK.EDU
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 weekly 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
[phone] Ext.517
[phone] Fax
***@gomedico.com

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
intercepted, 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.

[Roland P. Chung]

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
and the most important:
ARISPIDC MACRO - contains cms id owner of 193 & 195

My 2 cents.

Good luck

... Roland


Robert Payne <***@TAD.org> 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:VMESA-***@LISTSERV.UARK.EDU]On
Behalf Of Janice Rank
Sent: Monday, February 13, 2006 7:59 AM
To: VMESA-***@LISTSERV.UARK.EDU
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 weekly 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
[phone] Ext.517
[phone] Fax
***@gomedico.com

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
intercepted, 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: [phone] (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. **

[Dave Tibbetts]

Janice,

If you're running VMBackup, I've also got a fairly simple command line
solution I could send to you.

Dave

Post by Janice Rank
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 weekly 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
[phone] Ext.517
[phone] Fax
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
intercepted, 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.

---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 0606-4, 02/10/2006
Tested on: 2/13/2006 9:43:13 AM
avast! - copyright (c) 2000-2004 ALWIL Software.
http://www.avast.com

[Tom Duerbusch]

I use the DB2 Restore feature to reload production to test. No rexx
envolved.

Tom Duerbusch
THD Consulting

St. Louis Missouri
Host City
1904 Summer Olympics
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 weekly 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
[phone] Ext.517
[phone] Fax
***@gomedico.com

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
intercepted, 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.

[Janice Rank]

Tom,
How do I contact you off list? I have several questions I need to ask. If
you could just e-mail me directly so that we can correspond off list,
perhaps we can have a dialog about this.
Thanks,
Jan

-----Original Message-----
From: VM/ESA and z/VM Discussions [mailto:VMESA-***@LISTSERV.UARK.EDU] On
Behalf Of Tom Duerbusch
Sent: Monday, February 13, 2006 10:19 AM
To: VMESA-***@LISTSERV.UARK.EDU
Subject: Re: Db2 Restore

I use the DB2 Restore feature to reload production to test. No rexx
envolved.

Tom Duerbusch
THD Consulting

St. Louis Missouri
Host City
1904 Summer Olympics
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 weekly 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
[phone] Ext.517
[phone] Fax
***@gomedico.com

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 intercepted, 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.

[Berry van Sleeuwen]

Hello Jan,

We do this on a daily basis. We have three production DB2's that are
replicated to a 'read-only' database every day. Also we use the same process
to replicate our production database to the test databases every three
months. The first uses the same names and configs on a different VM system,
the second uses a different DB name on a different VM system.

Basically we use DDR to copy the minidisks to the target database. The
process requires several CMS-machines to process the DDR. The database
requirement is to have an identical directory structure for both source and
target. Perhaps you need to update grants to the database afterwards if CICS
or other userid's are different on the target.

Contact me offlist if you want to know more.

Regards, Berry.