Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 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
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am
No new posts Scan for Calls to DB2 kctechpro2 IBM Tools 10 Fri Sep 04, 2015 11:31 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us