Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Need BRMS Recovery Analysis Report examples

Posted on 2013-12-10
Medium Priority
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.

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

By default, Carbonite Server Backup manages your encryption key for you using Advanced Encryption Standard (AES) 128-bit encryption. If you choose to manage your private encryption key, your backups will be encrypted using AES 256-bit encryption.
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

636 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