Solved

Need BRMS Recovery Analysis Report examples

Posted on 2013-12-10
7
190 Views
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?

STRRCYBRM OPTION(*SYSTEM) ACTION(*REPORT)

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.

Thanks!
0
Comment
Question by:Gary Patterson
  • 3
  • 2
7 Comments
 
LVL 27

Expert Comment

by:tliotta
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.

Tom
0
 
LVL 34

Author Comment

by:Gary Patterson
ID: 39715754
Tom,

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
0
 
LVL 27

Expert Comment

by:tliotta
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.

Tom
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 34

Accepted Solution

by:
Gary Patterson earned 0 total points
ID: 39730030
Tom,

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.  

Appreciated.

- Gary
0
 
LVL 27

Expert Comment

by:tliotta
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.

Tom
0
 
LVL 14

Expert Comment

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Windows 7 does not have the best desktop search built in. This is something Windows 7 users have struggled with. You type something in, and your search results don’t always match what you are looking for, or it doesn’t actually work at all. There ar…
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 show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
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…

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now