Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
IMS calls to database.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
dilip_bangalore

New User


Joined: 29 Sep 2011
Posts: 27
Location: India

PostPosted: Mon Sep 23, 2013 1:17 pm    Post subject: IMS calls to database.
Reply with quote

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
Back to top
View user's profile Send private message

Peter cobolskolan

Active User


Joined: 06 Feb 2012
Posts: 104
Location: Sweden

PostPosted: Mon Sep 23, 2013 3:30 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 23, 2013 7:01 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Mon Sep 23, 2013 7:52 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JAVA equivalent for IMS DL/I calls srinianusuya IMS DB/DC 2 Wed Jul 25, 2018 12:04 pm
No new posts Moving UDB database to Db2 on z/OS Keith Hooley DB2 4 Wed Sep 27, 2017 12:38 am
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Sending system service calls by AIBTDLI. lind sh IMS DB/DC 1 Wed Mar 16, 2016 6:51 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us