MVSFORUMS.com

mfuser · Banned Joined: 01 Mar 2005 Posts: 105 Topics: 58

Hai,

I would like to read the IMS Activity log by any method which has variuos information containing the before & after image copies of the databases done by many users pertaining to many transactions.Actually many TSO userids enter into the IMS region & do many kinds of access could be updating/ deleting / browsing / deleting ,so all these information is recorded for many TSO userids who have a serial number associated to them.

I have a dataset saved which is the IMS Log dataset which contains the ONLINE Activity Log pertaining to a IMS region & i have a Standard ASSEMBLER Routine which describes the common elements of all IMS LOG RECORDS.That means the saved IMS LOG DATASET contains information which is of a standard format.

My objective is to write a a PL/I Program which will read that IMS ACTIVITY LOG dataset & the Program should generate a kind of detailed report based on the different logging done by various TSO userids.

Can anyone provide me any kind of documentaion about how should i proceed / is there any program which i can take the help.

Regards
mfuser

Bithead · Posted: Wed Mar 02, 2005 11:06 am Post subject:

The Diagnosis Guide and Reference lists all the log record types and sub-types along with descriptions and DSECTs.

mfuser · Banned Joined: 01 Mar 2005 Posts: 105 Topics: 58

Hi Bithead,

Can u please brief me more about how should i proceed to the problem discussed above

Bithead · Posted: Wed Mar 02, 2005 1:02 pm Post subject:

You can order the book from IBM - it is not available on their website. The DSECTS can be used for your declaratives. Your assembler program may also have this. I would read the log and create an extract file, probably just using the type x'50' records, keyed by RACF id, date and time along with PSB and database names, command type (ISRT, REPL etc) and key value. The log record does not show both the before and after data so this may be of limited use. You should probably bypass updates of indexes.

Sort the output file based on RACF id, date and time and then use it to create a report.

mfuser · Banned Joined: 01 Mar 2005 Posts: 105 Topics: 58

Hi Bithead,

Can u please tell me what are DSECTS actually ? I have to read a IMS Activity Log which contains ASCII characters too.How should i read the entire IMS log which is so huge & has many information done by many TSO user ids pertaining to various transactions.

I should proceed with a PL/I program to read the IMS activity lof first ,figure out & then proceed to generate a kind of report.

Thanks
mfuser

kolusu · Posted: Wed Mar 02, 2005 1:24 pm Post subject:

mfuser,

DSECT = Dummy Control Section - A control section that an assembler can use to format an area of storage without producing any object code. Synonymous with dummy section.

Check this link which explains in detail about the DSECT instruction

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ASMR1003/5.20?DT=20000721044852
Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Bithead · Posted: Wed Mar 02, 2005 1:34 pm Post subject:

If IMS is on the mainframe, the logs should only contain EBCDIC characters. If you are running on a server or on a PC, then they are probably ASCII. I doubt that the logs contain both.

The users are probably not in TSO but rather in IMS given that you are running transactions.

Having said that, yes the IMS logs are huge but you should be able to process them. Determine what kind of reports you need and that will tell you what type of logrec you should process.