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
 
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 How to Count a particular record in a... Mounika Nemani DFSORT/ICETOOL 5 Tue May 29, 2018 1:07 pm
No new posts MXG - Processing Compressed DB2 SMF r... vasanthz All Other Mainframe Topics 2 Thu May 10, 2018 12:47 am
No new posts Extract the records with a PD field's... sudhakar84 DFSORT/ICETOOL 11 Mon Apr 02, 2018 7:26 pm
No new posts Merge 2 records sancraig16 SYNCSORT 19 Tue Mar 27, 2018 8:17 pm
No new posts Creation of Datasets dynamically on t... Raghu M N DFSORT/ICETOOL 8 Fri Mar 16, 2018 12:56 am

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