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 column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts SORT Trailer Count - LRECL Output co... amorante DFSORT/ICETOOL 5 Tue Aug 29, 2017 8:57 pm
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 21 Sun Aug 27, 2017 10:35 pm
No new posts CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm

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