View previous topic :: View next topic
|
Author |
Message |
kris_madras Warnings : 1 New User
Joined: 04 Jul 2005 Posts: 31
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
I dont think any short cuts available for your requirement.
Let's wait for any other replies |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
No. |
|
Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
Just the total number of all GRCHILDx in the entire database? And not per master? |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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! ibmmainframes.com/viewtopic.php?t=26538 |
|
Back to top |
|
|
kris_madras Warnings : 1 New User
Joined: 04 Jul 2005 Posts: 31
|
|
|
|
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 |
|
|
kris_madras Warnings : 1 New User
Joined: 04 Jul 2005 Posts: 31
|
|
|
|
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! 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 |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
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 |
|
|
babai043 Currently Banned New User
Joined: 19 Dec 2007 Posts: 19 Location: chennai
|
|
|
|
Hi,
To my knowledge only GNP call you have to issue.
If any one knows please give ans
Regards,
Srinivas Jala |
|
Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
With BMC utility you can get all segment counts. |
|
Back to top |
|
|
|