IBM delivers Imagecopy(Backup) feature with utilities suite. But, there are some amazing innovations and obvious "should have done" features are covered in BMC Imagecopy. Some of the features (I might have really missed any, in my study) that is going to make the buyers happy for this BMC Copy Plus are:
1) Inline statistics - This is an important functionality IBM missed to cover. BMC collects/updates the information pertinent to tablespace. Sure this is going to be a rocking feature in partitioned tablespaces.
2) Copying index (Defined with COPY NO) - BMC overrides the IBM's protocol and manages to create imagecopy of index that are not copyable as per IBM/definition. Though index could be recovered by REBUILD against using naive RECOVERY, during disaster of huge objects,this is going to fasten the recovery, provided table, index copies are intact.
3) Dynamic syscopy choice - This feature is going to be loved by DBAs. By OUTSIZE and BIGDDN/BIGDSN, BMC lets the choice of syscopy file to be made dynamically at the execution time considering the size of the file to be copied. This could help DBAs to put bigger tables on Tapes and smaller ones on DASD. Think of the case when table grows in size where you do not realise a huge table being copied on DASD later. Isn't this sweet ?
4) Syscopy files according to IC Type - Are you running CHANGELIMIT (m,n) ICTYPE AUTO ? Not sure how to name incremental and full image copies differently ? With IBM, all the copies (whatever type !) gets created in similar files. FULLDDN/FULLDSN and COPYDDN/RECOVERYDDN could be used together wherein full IC (if chosen) goes to FULLDDN while incremental IC (if chosen) goes to COPYDDN.
5) Incremental copy, still changed pages intact - RESETMOD yes/no is going to tell BMC program whether DBA likes to reset the modified pages flag on taking incremental copies. In case incremental IC is corrupted/lost, he could just rerun to create another incremental one. Also, BMC lets an option (MAXINCRs) to escalate a incremental IC to Full IC if a certain number of incremental ones are done after a full IC. This would sum up the backup strategy for a week.
Tuesday, December 04, 2007
Subscribe to:
Posts (Atom)