Brian Donaldson wrote:

>Do you know if Howmessy will tell me when master dataset_a has nn% synonyms
>(nn > zero) and if it will give me the actual key values (Image record
>numbers too) of the offending primary entry and its synonym records?
>
>
>
Synonym/Secondary percentages are NOT good statistics for input into
performance tuning decisions/tasks.
These values do not take into consideration the clustering effects of
multiple synonym chains.

>I would like to see the actual data that is making up these stats.
>
One of the tools to see the data is DBDRIVER.PUB.SYS. The status returned
from a DBGET Mode=2 on a Master dataset reveals the Primary/Synonym Info.

If you were writing a program you could 'mode 2' down a master dataset using
the status area to clock the primary, synonym, chain lengths and the maximum
cluster sizes.

TGIF,
Mike Hornsby
Beechglen Development Inc.
Support Since 1988
513-922-0509


Status translation for DBGET on Master dataset:

1    Return status. 0=Good, <0 Bad Parameter, >0 Bad Execution
2    Length of the logical entry
3-4  Record number of the data entry read.
5-6  Zero for synonym, for a primary it is the number 'logical' primary
entries.
7-8  Record number of the preceding entry in the synonym chain.
9-10 Record number of the next entry in the synonym chain.

STAT LREC <RECORD#> <SYN CNT> <PREC ENT><NEXT ENT>
 01   02   03   04   05   06   07   08   09   10
0000 0002 0000 0001 0000 0001 0000 0000 0000 0000 <<Primary with no
synonyms>>
0000 0002 0000 0003 0000 0002 0000 0004 0000 0004 <<Primary with 1
synonyms>>
0000 0002 0000 0004 0000 0000 0000 0000 0000 0000 <<Synonym at end of
chain>>
0000 0002 0000 0005 0000 0003 0000 0009 0000 0008 <<Primary with 2
synonyms>>
...
0000 0002 0000 0008 0000 0000 0000 0000 0000 0009 <<Synonym at head of
chain>>
0000 0002 0000 0009 0000 0000 0000 0008 0000 0000 <<Synonym at end of
chain>>




:dbdriver
DBDRIVER C.05.00   FRI, APR 15, 2005,  9:09 AM  (C) HEWLETT-PACKARD 1978


Command: !b=MYDB
Command: !q=;
Command: !m=5
Command: o
Elapsed time (MS) = 198                 CPU = 22
Baseid=%000001  Class=64   Current DBG size=32767   DBU size=10240

Command: !M=2
Command: G
Elapsed time (MS) = 15                  CPU = 1
046524  031040
 M  T    2
Command: ?S
0000 0002 0000 0001 0000 0001 0000 0000 0000 0000
Command: G
Elapsed time (MS) = 0                   CPU = 0
047516  030040
 O  N    0
Command: ?S
0000 0002 0000 0002 0000 0001 0000 0000 0000 0000
Command: G
Elapsed time (MS) = 0                   CPU = 0
042103  030040
 D  C    0
Command: ?S
0000 0002 0000 0003 0000 0002 0000 0004 0000 0004
Command: G
Elapsed time (MS) = 0                   CPU = 0
051501  034440
 S  A    9
Command: ?S
0000 0002 0000 0004 0000 0000 0000 0000 0000 0000
Command: G
Elapsed time (MS) = 0                   CPU = 1
042105  030040
 D  E    0
Command: ?S
0000 0002 0000 0005 0000 0003 0000 0009 0000 0008
Command:

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *