IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Count of Segment occurence in a Database


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Suren1

New User


Joined: 11 Dec 2006
Posts: 3
Location: Chennai

PostPosted: Thu Feb 08, 2007 4:52 pm
Reply with quote

Is there any tool to get the number of segment occurence in each segment in a database. This can be done programatically but if there is a tool available then I thought it would run faster. Please suggest.
Back to top
View user's profile Send private message
IQofaGerbil

Active User


Joined: 05 May 2006
Posts: 183
Location: Scotland

PostPosted: Thu Feb 08, 2007 6:11 pm
Reply with quote

There are utilities, depends on what your shop has.
eg unload utilities would have a report output normally with segment counts.
your DBAs should have details of them.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


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

PostPosted: Mon Feb 12, 2007 1:02 am
Reply with quote

Suren1 wrote:
get the number of segment occurence in each segment in a database.


Could you explain what you exactly want to know? If you want to know how many occurrences of a segmenttype are present use some tool like re-organise.
Back to top
View user's profile Send private message
palas_2007
Currently Banned

New User


Joined: 30 Jan 2007
Posts: 6
Location: kolkatta

PostPosted: Wed Feb 14, 2007 3:31 pm
Reply with quote

Could you explain what you exactly want to know? If you want to know how many occurrences of a segmenttype are present use some tool like re-organise.
_________________
Regards,
George
Answers to your IMS questions may be found here and here

Back to top


Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


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

PostPosted: Wed Feb 14, 2007 3:48 pm
Reply with quote

palas_2007 wrote:
Could you explain what you exactly want to know? If you want to know how many occurrences of a segmenttype are present use some tool like re-organise.
_________________
Regards,
George
Answers to your IMS questions may be found here and here

Back to top


Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First


icon_rolleyes.gif icon_eek.gif icon_rolleyes.gif icon_question.gif icon_question.gif We have a parrot in the forum icon_eek.gif icon_razz.gif icon_rolleyes.gif icon_wink.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts To get the count of rows for every 1 ... DB2 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Validating record count of a file is ... DFSORT/ICETOOL 13
No new posts What database does Jobtrac use CA Products 4
No new posts Insert header record with record coun... DFSORT/ICETOOL 14
Search our Forums:

Back to Top