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 Segment occurence in a Database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
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    Post subject: Count of Segment occurence in a Database
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    Post subject: Re: Count of Segment occurence in a Database
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: 1105
Location: The Netherlands at Hole 19

PostPosted: Mon Feb 12, 2007 1:02 am    Post subject: Re: Count of Segment occurence in a Database
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    Post subject:
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: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Feb 14, 2007 3:48 pm    Post subject:
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    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 write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Moving UDB database to Db2 on z/OS Keith Hooley DB2 4 Wed Sep 27, 2017 12:38 am
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

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