Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Display FTP Session Count within TSO Yolanda Harvey TSO/ISPF 3 Fri Mar 10, 2017 10:31 pm
No new posts Count Trailing Spaces in variable str... Virendra Shambharkar SYNCSORT 10 Thu Feb 02, 2017 12:23 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us