Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search 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
Author Message
Nagendran

Active User


Joined: 24 Jan 2007
Posts: 77
Location: Trivandrum

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
References
PostPosted: Fri May 02, 2008 8:16 pm    Post subject: Re: Count of records in IMS DB Reply with quote

Bitneuker

IMS Moderator


Joined: 07 Nov 2005
Posts: 1130
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

Active User


Joined: 24 Jan 2007
Posts: 77
Location: Trivandrum

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

IMS Moderator


Joined: 07 Nov 2005
Posts: 1130
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

New User


Joined: 15 May 2006
Posts: 40

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
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1