WAVV Requirement Form

 

Date: 4/7/2005                                               Requirement #:  WAVV200410

Product Name:           DB2/VSE     Product Release# (or state “current”): current

Vendor Name:           IBM

 

Title: (Paraphrase problem in a single statement)Provide way to verify log and data archives

Detailed Problem Description: (Description of what you want changed - 400 character entry limit)

 

There is no way to know that a log or data archive is readable after it is created. The only way currently is to actually perform a restore. This is not practical. There needs to be a way to verify the contents of an archive.

                                                                                             

Priority: (Select one: Urgent - High - Medium - Low) High

Requested Completion Date: (When? Examples: 3 months, 1 year, Next Release) ASAP

Requirement Type: (Select one: Acceptability - Compatibility/Migration - Ease of Use - Feature/Function - Performance - Reliability/Availability/Serviceability - Packaging - Interoperability)

Reliability/Availability/Peace of Mind!

Business Justification: (Why? Non-technical business case description. Do not reword Detailed Problem Description from above. What are the benefits to be gained by your company, and the vendor and others?  Quantify: run time, dollars, manpower, etc.   Why should the vendor do this for the customer?)

 

For any type of backup, it always provides peace of mind to be able to know that the backup that was just taken is correct and readable when it is stored off-site or to the tape library (in the case of tape). Most backup software provide a means to verify their backups without actually performing a restore (like LIBR's RESTORE SCAN=YES).

Solution: (Optional)(Desired/undesired elements Note: Making a suggestion may limit a vendors ability to deliver a solution)

 

Provide a batch utility that can read any DB2/VSE/VM archive (from tape or disk) from beginning to end and list for you some detail of the contents. It would work for either log or data archive. This would prove that it is intact and readable should a restore become necessary.

Impact: (Optional) (How will your company’s business be affected if a solution is not delivered?)

 

Being able to know that an archive is good and readable before storing it will provide great peace of mind to any DBA. Having to wait until a crisis where a restore is necessary, only to discover that the archive is faulty, would be a nightmare. Please help us keep our sanity.

 

Company Name:            Computer Credit, Inc.                                                                 

Author Name:            Michael Rosinger                                Author Title: Systems Programmer/DBA

Author Address:             640 West Fourth Street, Winston-Salem, NC 27101

Author E-mail:            mrosinger@cciws.com

Telephone:                 (336) 761-1524