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
  • 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 34

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.

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

LVL 34

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

In this article we will discuss all things related to StageFright bug, the most vulnerable bug of android devices.
#Citrix #POC #XenDesktop #vCenter #VMware #ESX
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

770 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