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.

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
BOSD APC_INDEX_MISMATCH - who's the culprit ? 4 60
Unable to print after system state restore 32 48
Best audio extractor from Youtube? 16 59
sync 2 servers 2008 9 63
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

738 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