Hi,
I was assigned to study and look for a way to improve the database
recovery time during end of day batch processing. This is to ensure we
meet the Service level agreement of system online hour. Let me explain
on the approach we are using now.
Whenever there is an abnormal-end during the EOD batch run, we will
identify the error and then restore the whole data library (consist of
*FILE, *DTAARA, *MSGQ...) from save file and then rerun the batch.
However, it is getting painful because it is now take us at least 2
hours for the restoration to complete. The timing will certainly be
prolonged because the database is growing.
Would like to ask for advice on how to improve from there.
p/s: I was wondering if journaling could help in this issue? However, I
am not familiar with IBM's journaling feature for this purpose.
Cheers.
Lian Yew Seng
Payments, MCS
Tel: +603 2084 5418 (Ext: 25466)
Fax: +603 2084 5484
DID: +603 2084 5466
yewseng.lian@xxxxxxxx <mailto:jessica.sukumaran@xxxxxxxx>
Suite 19.02, Level 19
Centrepoint South Mid Valley City
Lingkaran Syed Putra
59200 Kuala Lumpur, Malaysia
atos.net <
http://www.atos.net/>
Disclaimer: This e-mail and the documents attached are confidential and
intended solely for the addressee; it may also be privileged. If you
receive this e-mail in error, please notify the sender immediately and
destroy it. As its integrity cannot be secured on the Internet, the Atos
group liability cannot be triggered for the message content. Although
the sender endeavors to maintain a computer virus-free network, the
sender does not warrant that this transmission is virus-free and will
not be liable for any damages resulting from any virus transmitted.
midrange.com
