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
 
Only count of Child segments under parent segment

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
kris_madras
Warnings : 1

New User


Joined: 04 Jul 2005
Posts: 26

PostPosted: Tue Dec 18, 2007 10:13 am    Post subject: Only count of Child segments under parent segment
Reply with quote

I did search.. but coulnd't find similar topic here..

This is our IMS DB structure (sample)

MASTER --> CHILD1 ---> GRCHILD1
----> GRCHILD2
CHILD2 ---> GRCHILD1
----> GRCHILD2



Basically I need count of GRCHILDx under MASTER. I don't want to scan all segments under..

Could anyone please suggest me the best way to get this count instead of going thru all segments by GNP. This is large database.
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue Dec 18, 2007 1:20 pm    Post subject:
Reply with quote

I dont think any short cuts available for your requirement.

Let's wait for any other replies
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Tue Dec 18, 2007 9:31 pm    Post subject:
Reply with quote

No.
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 Dec 19, 2007 1:56 am    Post subject:
Reply with quote

Just the total number of all GRCHILDx in the entire database? And not per master?
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Dec 19, 2007 2:10 am    Post subject:
Reply with quote

Well, George it would be nice if we knew what the requirements were? He can go after a specific child segment with an unqualified SSA for that segment type - he can go after all segments types under that parent. The chart he drew looks very much like a DB2 relational structure - which IMS is NOT. Without the requirements, we do not have a clue.............and I refer to your STICKY! http://ibmmainframes.com/viewtopic.php?t=26538
Back to top
View user's profile Send private message
kris_madras
Warnings : 1

New User


Joined: 04 Jul 2005
Posts: 26

PostPosted: Wed Dec 19, 2007 5:52 am    Post subject:
Reply with quote

Bitneuker wrote:
Just the total number of all GRCHILDx in the entire database? And not per master?


Correct the requirement is count of all GRCHILDx in the entire database..
Back to top
View user's profile Send private message
kris_madras
Warnings : 1

New User


Joined: 04 Jul 2005
Posts: 26

PostPosted: Wed Dec 19, 2007 5:55 am    Post subject:
Reply with quote

Sandy Zimmer wrote:
Well, George it would be nice if we knew what the requirements were? He can go after a specific child segment with an unqualified SSA for that segment type - he can go after all segments types under that parent. The chart he drew looks very much like a DB2 relational structure - which IMS is NOT. Without the requirements, we do not have a clue.............and I refer to your STICKY! http://ibmmainframes.com/viewtopic.php?t=26538



Apologies for not providing correct structure of IMS data base..I am unable to draw picture... Here is the structure..


MASTER Segment has 2 child segments CHILD1 and CHILD2 (Actually more than 2)

Each CHILD1 and CHILD2 has many childs GRCHILDx

Need count of GRCHILDx s
MASTER --> CHILD1 ---> GRCHILD1
----> GRCHILD2
CHILD2 ---> GRCHILD1
----> GRCHILD2
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Dec 19, 2007 7:15 am    Post subject:
Reply with quote

What are the segment names of CHILD1 and CHILD2? Are they twins? What about the the segment types at the 3rd level? Do you have access to the DBD? Are you looking for a count beneath each root - each child? WHY?
Back to top
View user's profile Send private message
babai043
Currently Banned

New User


Joined: 19 Dec 2007
Posts: 19
Location: chennai

PostPosted: Wed Dec 19, 2007 3:51 pm    Post subject: Reply to: Only count of Child segments under parent segment
Reply with quote

Hi,

To my knowledge only GNP call you have to issue.

If any one knows please give ans

Regards,
Srinivas Jala
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 Dec 19, 2007 7:07 pm    Post subject:
Reply with quote

If you just want to know the total number get a copy of the analyse report. The analyser should be run by systems programming on a regular basis.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Thu Dec 20, 2007 9:39 am    Post subject:
Reply with quote

With BMC utility you can get all segment counts.
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 ISMF Difference between volume count ... upendrasri IBM Tools 2 Tue Dec 05, 2017 12:40 pm
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 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