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
 

 

Count of records in IMS DB

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

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Fri May 02, 2008 8:16 pm    Post subject: Count of records in IMS DB
Reply with quote

Hi,


Is there any tool or utility is availble to count number of records in an IMS
DB.


Thanks,
Nagendran.R
Back to top
View user's profile Send private message

Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Sat May 03, 2008 10:07 pm    Post subject:
Reply with quote

Have your DBA run a statistic or analyzer.
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Sun May 04, 2008 9:42 pm    Post subject: Reply to: Count of records in IMS DB
Reply with quote

could you please let me know what is STATISTIC or ANALYZER? Is this is separate utility, do the normal user will have access to run that tool?
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Mon May 05, 2008 7:40 pm    Post subject:
Reply with quote

Don't know your shop but usually the DBA takes care of it. The DBA analyses and reorganises. As a user you could write a program using GN and keep track of the segment types or use DLITEST.
Back to top
View user's profile Send private message
mohitsaini
Warnings : 1

New User


Joined: 15 May 2006
Posts: 92

PostPosted: Tue May 06, 2008 10:26 am    Post subject:
Reply with quote

Hi George,

Please correct me if I am wrong.

Can't we have an unqualified call for the whole IMS-DB and also have a counter which gets incremented after every successful call. In this way we can come up with the total number of recs in a particular IMS-DB.

Plz let me know if this is unclear or if I am wrong somewhere?

Thanks.
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 CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Display FTP Session Count within TSO Yolanda Harvey TSO/ISPF 3 Fri Mar 10, 2017 10:31 pm


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