Need BRMS Recovery Analysis Report examples

Posted on 2013-12-10
Last Modified: 2015-05-12
I'm testing some software that parses BRMS reports, and I need several real-world examples of the recovery analysis report from multiple versions of the OS.  

Can anyone help?


Result is spooled file QP1ARCY - easiest thing I know to do is just pull it down by exporting to a text file in Navigator.

Any help would be greatly appreciated.

Question by:Gary Patterson
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 27

Expert Comment

ID: 39715716
Any chance of auditing a job running STRRCYBRM to see object locks, open files, etc., to see if data can be extracted in other ways?

I don't have the product, so no real help here.

LVL 35

Author Comment

by:Gary Patterson
ID: 39715754

Good suggestion.

Doesn't look difficult to get info from the BRMS database files, but this is an existing product being ported from AIX, and already has a report parser with a parsing template already built for BRMS.  Client also needs to archive the formatted audit report, so the report has to be produced one way or the other.

No significant benefit in redesign or rework at this stage of the project.

Just looking to stir up some additional analysis reports for testing purposes.  

- Gary
LVL 27

Expert Comment

ID: 39728519
...but this is an existing product being ported from AIX, and already has a report parser with a parsing template already built for BRMS.

Okay, a really bad idea popped into mind. (Even bad ideas can spark better thoughts.)

If the underlying data can be extracted, it's plausible that custom reports could be generated that match BRMS report formatting. Perhaps it could even be generated using BRMS printer files to ensure some compatibility. A parsing tool shouldn't care about origins as much as the validity of the data.

Following that thought in a potentially more useful direction, do you know if the reports are created with externally-described printer files? If the report formats stay stable, various BRMS releases could possibly be ignored.

Don't Cry: How Liquid Web is Ensuring Security

WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.

LVL 35

Accepted Solution

Gary Patterson earned 0 total points
ID: 39730030

Your input is always welcome and appreciated.  

These are great design phase considerations.  However the small amount of design, coding, and initial unit testing work required on this porting project are complete.  I just posted here in hopes of obtaining some real-world test data before the product goes to alpha test.  No luck here on EE, but I was able to obtain a samples of the required report elsewhere.

Your idea above isn't bad, in general.  It isn't a fit for this particular application, but you don't have a full set of requirements, so there is no way for you to know that.

I evaluated the available mechanisms for data retrieval, and determined that report parsing was very acceptable in this case.  In general, report parsing isn't my favorite interface, but it works very well for this particular application.

Since it sounds like you may not have seen one:

BRMS Recovery Analysis report provides step-by step recovery instructions, with a lot of verbiage, specific commands to execute, sequence of operations, all interspersed with lists of tape volumes to load for each step.  Definitely would not take time and expense to reverse engineer that report when the actual formatted report can be obtained on demand with a single BRMS command.

If the report format stays stable, then parsing will continue to work from release to release.  This is a commercial product, and agent release testing is needed anyway any time there is a new version of a supported backup product.  Modifying the parsing template doesn't appear to be a major process, though I wasn't involved in that work.

This is not an IBM i-specific product.  This is a centralized tape inventory system (SAAS model) that uses platform-specific agents to harvest tape-related data from a variety of systems: IBM mainframe, AIX, BRMS on IBM i, and others.

I'm helping port the existing AIX agent to run on IBM i and harvest the needed tape and recovery info from BRMS.  

Agent dumps the BRMS media inventory table to a CSV,  and the detailed recovery info (which also provides the subset of tape inventory required to perform a full recovery) is obtained by dumping the Recovery Analysis report to a stream file.  Both are parsed and uploaded to the central system where the data is used to update the centralized inventory.  A copy of the recovery report is also retained intact on the central system to provide an offsite copy of recovery instructions.

It is a very slick product, from what I've seen.  At any given time, in one place you can verify that you have everything needed to restore all your critical systems, regardless of platform, based on real-time tape tracking info provided by the offsite tape storage vendor.

Thanks for taking the time to share thoughts, though.  


- Gary
LVL 27

Expert Comment

ID: 39731182
No thanks needed. If it didn't hook my imagination, "bad ideas" wouldn't come up on their own. If nothing else, it's pretty sure it'll be an interesting problem when posted y you.

LVL 14

Expert Comment

ID: 40772093
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question