IMS calls to database.

dilip_bangalore · New User Joined: 29 Sep 2011 Posts: 27 Location: India

Hi,

Can anyone let me know how is the number of IMS calls to database is kept track of automatically without using any WS variable. What is the maximum number of IMS calls that can be made to database in a COBOL program.

Thanks,
Dilip

Peter cobolskolan · Posted: Mon Sep 23, 2013 3:30 pm

Interview question ?
No one but you - the programmer, can keep track.
Why do you think there would be a limit? The problem to be solved by the program may cause one(1) or thousands Calls.

dick scherrer · Posted: Mon Sep 23, 2013 7:01 pm

Hello,

If IMS is like many other database products, it internally keeps track of activity.

Suggest you talk with your dba and see what might be available (unless this is just an interview question).

If you want custom statistics, do as Peter mentioned - implement code to do what you want.

Ed Goodman · Active Member Joined: 08 Jun 2011 Posts: 556 Location: USA

There is a built in reporting utility that you can run as part of the job. I don't have a lot of interest in it because there are more performance-minded tools that do it too.

The IBM built in will give a list of each PCB in the PSB and shows the calls and type of calls for them.

I've noticed that only very experienced DBAs can use that information wisely. I've seen a lot of people use that same information to do some stupid things and try to fix the wrong problems. That's why I use STROBE and Application Performance Analyzer.