Re: DB2 Problem Urgent
Hi david thanks for response ... do u mean RESTORE DB2 database data Volumes (which were backed up previous end of day) and then logapply and these logs are nothing but archive logs generated after previous end of day.(and not all archive logs generated after last imagecopy ??) Is it easy to restore DB2 VSAM datasets ?how ? or all database volumes restoration required to be done. On 5/10/06, david [EMAIL PROTECTED] wrote: You just have to do a restore of the datasets and then a logapply, you don't have to use imagecopy. RECOVER TABLESPACE xxx TO LOGPOINT REBUILD INDEX (ALL) TABLESPACE xxx -Oorspronkelijk bericht- Van: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Namens Jacky Bright Verzonden: woensdag 10 mei 2006 5:38 Aan: IBM-MAIN@BAMA.UA.EDU Onderwerp: Re: DB2 Problem Urgent can anyone respond to this ?? On 5/10/06, Jacky Bright [EMAIL PROTECTED] wrote: Hi I have query with regard to DB2 restoration ... In case you have the DB2 Volume day end backup and next day's DB2 Archive datasets backup .. then is it possible to restore DB2 using those db2 volume level backup and archive datasets. In order to apply DB2 Archives is it necessary to have latest db2 database imagecopy and all archive datasets generated thereafter ? Jacky -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 Problem Urgent
The parm you want is RECOVER LOGONLY - This is discussed in DB2 administration guide and the utilities manual. The short answer is both DF/DSS, FDR and all the products that do volume backups can easily do volume restores or dataset restores with the one exception of multi-volume datasets - then you need to get the manual out - it is recoverable just not as easy. Next step is DB2 RECOVER tablespace LOGONLY - DB2 keeps track of starting and ending rba's or LRSN's for updates so it will only read the archive logs required. for the recovery. If the archive logs are in HSM or something, it will recall them and apply the log records. If you have a big DB2 subsystem, this can take a long time to read archive logs. Once this completes, you can REBUILD the indexes and use the table. You should take an image copy at this point since you no longer have a normal recovery point. Mike -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 Problem Urgent
In a message dated 5/10/2006 7:51:01 A.M. Central Standard Time, [EMAIL PROTECTED] writes: backups can easily do volume restores or dataset restores with the one exception of multi-volume datasets - then you need to get the manual out - it is recoverable just not as easy. The DB/2 list is a much better place to ask these questions. The DB/2 course on Admin and Recovery is excellent! We had one group that was bad about dropping tables without an Image copy. Have to take our incremental and restore then run the DB/2 utils to fix the IDs. Finally bought them a W2K machine and said you're on your own. List name: DB2-L Host name: _WWW.IDUGDB2-L.ORG_ (http://www.lsoft.com/scripts/wl.exe?SS1=WWW.IDUGDB2-L.ORG) (IDUGDB2-L) Subscribers: 2,997 Features: * Spam filter * Hands free bounce processing * Archives * _Web archive interface_ (http://www.idugdb2-l.org/adminscripts/wa.exe?LIST=DB2-L) * Digests (with MIME support) * Indexes * Database functions -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 Problem Urgent
Jacky This group is for MVS. I believe there is a DB2 group that would be more helpful. If you want to bring all the databases and DB2 catalog up to the point when it went bad, you do need all the archived logs. The best way to recover DB2 is with image copies and archived logs. Volume copies do not bring DB2 to a consistent point. You may have to do a Conditional Restart. Get your DBAs and DB2 support together. DB2 Administration Guide and DB2 Utility Reference Guide are good references. Good Luck, Heloisa -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
DB2 Problem Urgent
Hi I have query with regard to DB2 restoration ... In case you have the DB2 Volume day end backup and next day's DB2 Archive datasets backup .. then is it possible to restore DB2 using those db2 volume level backup and archive datasets. In order to apply DB2 Archives is it necessary to have latest db2 database imagecopy and all archive datasets generated thereafter ? Jacky -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 Problem Urgent
can anyone respond to this ?? On 5/10/06, Jacky Bright [EMAIL PROTECTED] wrote: Hi I have query with regard to DB2 restoration ... In case you have the DB2 Volume day end backup and next day's DB2 Archive datasets backup .. then is it possible to restore DB2 using those db2 volume level backup and archive datasets. In order to apply DB2 Archives is it necessary to have latest db2 database imagecopy and all archive datasets generated thereafter ? Jacky -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: DB2 Problem Urgent
You just have to do a restore of the datasets and then a logapply, you don't have to use imagecopy. RECOVER TABLESPACE xxx TO LOGPOINT REBUILD INDEX (ALL) TABLESPACE xxx -Oorspronkelijk bericht- Van: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Namens Jacky Bright Verzonden: woensdag 10 mei 2006 5:38 Aan: IBM-MAIN@BAMA.UA.EDU Onderwerp: Re: DB2 Problem Urgent can anyone respond to this ?? On 5/10/06, Jacky Bright [EMAIL PROTECTED] wrote: Hi I have query with regard to DB2 restoration ... In case you have the DB2 Volume day end backup and next day's DB2 Archive datasets backup .. then is it possible to restore DB2 using those db2 volume level backup and archive datasets. In order to apply DB2 Archives is it necessary to have latest db2 database imagecopy and all archive datasets generated thereafter ? Jacky -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html