Help with BRMS and iSeries Tape Analysis

Posted on 2010-11-25
Last Modified: 2013-12-06
Experts, I come to you as a fool with little knowledge of iSeries or BRMS. In other fields of IT I consider myself very knowledgeable but on this forum I'm an amateur.

I have been asked to look at tuning some BRMS environments and want a couple of pointers around accessing reports. Having logged onto the iSeries and started BRMS, I can produce various canned reports and downloaded them to my PC, so far so good.

Question 1. Does BRMS use a DB2 database for storing information and if so is there any documentation around the tables and fields with, as I can't find them.

Question  2. If I want to look at tape drive usage, i.e. mount time/dismount time and volser mounted is there an iSeries log that I can look at and analyse.

Coming from a m/frame background I was very happy that Rexx is available and have already written some code to issue SQL commands and save the output to a file.

Please help!!!!
Question by:RibTime
  • 4
  • 4
  • 2
LVL 34

Assisted Solution

by:Gary Patterson
Gary Patterson earned 50 total points
ID: 34213134

Accepted Solution

Tomunique earned 200 total points
ID: 34218194
Some what of the blind leading the blind here, but, at least, I've felt my way down this path before

Yes, there's a DB2 table for BRMS (should be "tables", nothing is easy).
My program looks at volser status (that is in table  QUSRBRM/QA1AMM )

Do you know how to get a list of all the fields and their descriptions from a table?

browse Qusrbrm, (wrklib qusrbrm), there's a lot of tables in there.
I've not seen a decent break-down of what the tables are..
You may review the last update date on the files, just following a backup..
this will reduce your search to just tables keeping updated information.


Expert Comment

ID: 34218212
Additional note:
See Appendix F from Gary's link above..
it's old, but a lot of that stuff hasn't changed.

Thanks Gary!

Author Comment

ID: 34218255
Thanks guys this is helping a lot.

While I have the ear of you guys, how can I find mount/dismout times

I'll look at the information passed so far.

Expert Comment

ID: 34219380
I've not seen that level of detail (nor have I looked).
Years past I pulled similar information from syslog, don't know if intermediate mounts are displayed there.
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.


Author Comment

ID: 34229815
Tom / Gary

I found a manual "Backup Recovery and Media Services for OS/400 A Practical Approach" that provides a list of tables in appendix F, however without your help I wouldn't have found it.

I will close this question in a couple of days and award points to both of you but as you both seem on top of this issue I'll ask a cheeky related question....

Within the QA1AMM table there is a field TMCEXP which is a ZONED data type. When I do a "select" on this fields I get as an example "1,000,902" whereas if I display the tape from BRMS the expiry date is "09/02/01" ( US format date ).

Have either of you programmatically or prehaps another method converted this date and if so how as I have failed to "google" the answer.

Regards and thanks so far


Expert Comment

ID: 34229902
Dates are stored in YYMMDD so sorts work properly.

When you say "convert", do you mean from mm-dd-yy to yy-mm-dd and so forth?
I've not done it on the 400, but I believe you can set that in the bind options.

Author Closing Comment

ID: 34229943
I was after some pointers to allow me to work this out myself but have really been helped here, especially by Gary.

For anyone else looking for help on this check out my post about the IBM manual as that had the information I was after.


LVL 34

Expert Comment

by:Gary Patterson
ID: 34231228
That particular date format looks like it could be cyymmdd, where:

c=0 means 19xx
c=1 means 20xx

To convert cyymmdd to yyyymmdd, just add 19,000,000.

cyymmdd + 19,000,000 = yyyymmdd

- Gary Patterson

Author Comment

ID: 34231275

Thanks for taking the time.

As it happens I sat looking at my data and worked it out. All the data I've seen is from +2000 so had ignored the first digit, but it's nice to know what it means.

Thanks again


Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Introduction How to create multiboot configuration with XP\Vista and Windows 7 on it? And most important question - how to do this correctly so not to have any kind of nightmares we get when system gets screwed? First of all one should realize t…
Hello I read in a discussion about a person who configured a very simple mirror RAID with two hard drives; the system and data were on the same partition. He asked how to repair the system as it was not booting up anymore. In his case running …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

706 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

13 Experts available now in Live!

Get 1:1 Help Now