Thread View: bit.listserv.idms-l
2 messages
2 total messages
Started by Joseph, Leon , CAP, CARD
Fri, 25 Apr 2003 15:29
Re: is there a way to get the number of members within a set?
Author: Joseph, Leon , CAP, CARD
Date: Fri, 25 Apr 2003 15:29
Date: Fri, 25 Apr 2003 15:29
15 lines
2020 bytes
2020 bytes
Sorry it took so long to respond to this.
There is a third party utility called DCIDMSXX that will, along with other things, count the number of members of a set. It will produce a report, by set name, with the number of sets that have 1 member, 2 members, 3 members, etc. (Similar to what I tried to type just below)
ZERO X-1 X-2 X-3 X-4 X-5 X-6 X-7 X-8 x-9 x-0 over 1000
SET A-B 10 252 356 - - - - - - - - 2
We just had to run it here because we had a set where the owner has a record counter field that said there were two members in the set. In DMLO, however, I found over 110 members for that owner record (and then I stopped counting). When I ran the report I found that 2 occurrences of the set have over 1,000 members. Unfortunately, it does not give you either the owner record db-key to track this down.
I am not trying to sell this product (it is not mine to sell), but I can put you in touch with the vendor.
Hope this helps
Leon Joseph
IDMS DBA (while it still lasts here)
Re: is there a way to get the number of members within a set?
Author: Sam William
Date: Wed, 30 Apr 2003 11:38
Date: Wed, 30 Apr 2003 11:38
58 lines
3421 bytes
3421 bytes
Hello Joseph,
it looks like report No.5 (SET ANALYSIS DATA) from Database-Analyser
(IDMSDBAN), it provides similar information, also without dbkey,
like your "DCIDMSXX"-utility.
But we need the number of members ad hoc, every time a user starts a
special function.
/sam
Sample-DBAN-Output:
===================
SET: V27SCLAS-LAGO ORDER: SORTED SUBSCHEMA: XTXU95
OWNER: XTXRCLAS
MEMBERS: XTXRLAGO
HISTOGRAM OF MEMBERS IN INDEX SET OCCURRENCES
MEMBERS NUMBER PERCENT OF GRAPH
OF SETS TOTAL SETS
...10...20...30...40...50...60...70...80...90..100
0 361 37 XXXXXXXXXXXXXXXXXX/
1 498 51 XXXXXXXXXXXXXXXXXXXXXXXXX/
2 40 4 XX
3 - 4 34 3 X/
5 - 8 20 2 X
9 - 16 16 2 X
17 - 32 3 0
33 - 64 4 0
65 - 128 0 0
129 - 256 0 0
257 - 512 0 0
OVER 512 0 0
AVERAGE NUMBER OF MEMBERS PER SET OCCURRENCE (ALL SETS): 1
AVERAGE NUMBER OF MEMBERS PER SET OCCURRENCE (NON-EMPTY SETS): 2
MAXIMUM NUMBER OF MEMBERS IN A SET OCCURRENCE: 56
Leon.Joseph@GECAPITAL.COM (Joseph, Leon , CAP, CARD) wrote in message news:<12104DED123C4847A7D1CB86540BE4AB692030@ALPMLVEM01.e2k.ad.ge.com>...
> Sorry it took so long to respond to this.
>
> There is a third party utility called DCIDMSXX that will, along with other things, count the number of members of a set. It will produce a report, by set name, with the number of sets that have 1 member, 2 members, 3 members, etc. (Similar to what I tried to type just below)
>
>
> ZERO X-1 X-2 X-3 X-4 X-5 X-6 X-7 X-8 x-9 x-0 over 1000
> SET A-B 10 252 356 - - - - - - - - 2
>
> We just had to run it here because we had a set where the owner has
a record counter field that said there were two members in the set.
In DMLO, however, I found over 110 members for that owner record (and
then I stopped counting). When I ran the report I found that 2
occurrences of the set have over 1,000 members. Unfortunately, it
does not give you either the owner record db-key to track this down.
>
> I am not trying to sell this product (it is not mine to sell), but I can put you in touch with the vendor.
>
> Hope this helps
> Leon Joseph
> IDMS DBA (while it still lasts here)
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads