Restore CA-7 Database



Unicenter CA-7 Job Management: CA's workload automation tool for managing, visualizing, automating, optimizing applications

Restore CA-7 Database

Postby sentosa » Mon Jul 16, 2012 10:52 am

Hello,

Since i have more than 100 new jobs with dependency & triggering which require
to update CA7, my procedure is as follows,

1.) Perform CA7 backup using SASSBK00.
2.) Update new jobs into CA7 database.

In case of any reason, i need to perform database restoration using last backup of point 1.

I have some questions for restoration. May i know anyone who can help?

a.) Do i need to stop all Queues before restore in the CA7?
(the new 100 jobs is another schedule ID, which is not affected the current day schedule.)
b.) Is need to ensure no job is running in CA7?
c.) After restore, is all the jobs in request queue are same as before shutdown?

Thanks & Regards
sentosa
 
Posts: 14
Joined: Wed Jun 27, 2012 8:50 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Restore CA-7 Database

Postby kchidambara2 » Fri Aug 10, 2012 4:14 am

explain clearely ...
kchidambara2
 
Posts: 9
Joined: Sat Dec 19, 2009 6:33 am
Has thanked: 0 time
Been thanked: 0 time

Re: Restore CA-7 Database

Postby Robert Sample » Fri Aug 10, 2012 4:35 am

You need to read the CA-7 Systems Programmer Guide in detail, particularly chapter 7 talking about backup and recovery, where this point is made:
The safest procedure to adopt is frequent backups of most CA-7 data sets and all systems under the control of CA-7. This includes all JCL, load module and control statement data sets, and so forth. All should be backed up on the same time period. During the backup of the CA-7 database, CA-7 should be shut down for totally predictable results.


Based on what I know about CA-7 (and I am knowledgeable but not an expert on CA-7), the answers to your questions are:
a) stop the queues during the backup, not the restore
b) it appears to depend upon why, exactly, you're doing the restore
c) are you starting CA-7 COLD or WARM? A CA-7 COLD start (there's at least 3 different parameters that force a COLD start to CA-7) means no data is retained about the jobs and queues previously. And that, in turn, goes back to your question (b) -- WHY are you doing the restore?
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Restore CA-7 Database

Postby adurthisridhar » Wed Jun 12, 2013 11:57 pm

Thanks to this forum. I got answer for my long lasting question of how to backup and restore CA7. Thanks to all.
adurthisridhar
 
Posts: 28
Joined: Thu Mar 04, 2010 6:51 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Restore CA-7 Database

Postby BillyBoyo » Thu Jun 13, 2013 12:37 am

Thank's for letting us know. Why don't you click on the Thumb's Up in the corner of Robert's post?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to CA-7