1 08/06/84  display_mrds_db_population, dmdbp
 2 
 3 Syntax as a command:  dmdbp path {-control_args}
 4 
 5 
 6 Function:  This command displays the current tuple count for each
 7 relation in the given data base model or submodel view.  It can also
 8 display population statistics about the vfile for each relation's data.
 9 
10 
11 Arguments:
12 path
13    is the relative or absolute pathname of the data base model or
14    submodel, with or without suffix, that is to have the relation's
15    population statistics displayed.  If both a data model and submodel
16    of the same name are in the same directory, then the model will be
17    found if no suffix is given.
18 
19 
20 Control arguments:
21 -brief, -bf
22    limits the output display to only relation names and their current
23    tuple count.  (Default)
24 -long, -lb
25    displays the average number of tuples selected by index during
26    retrieval.
27 -relation rel_name1 ...  rel_nameN
28    specifies that only the population for those relations whose names
29    are given in the rel_nameI list are to be displayed according to the
30    other control arguments.  This control_arg must appear after path.
31 
32 
33 Notes:  Version 3 data bases must have been opened at least once for
34 exclusive update.  They cannot have secondary index information
35 displayed.
36 
37 For version 4 data bases, only a DBA may use this command on a secured
38 data base, with the model view.  The user must have at least "r" access
39 to the relation model segment and the relation data vfile for those
40 relations in the view presented by "path".
41 
42 
43 Examples:
44 
45    display_mrds_db_population test -bf
46 
47    Opening version 4 data model:  >udd>m>jg>dr>test.db
48 
49        RELATION                            TUPLES
50 
51          r001                                100
52          r002                                100
53 
54    display_mrds_db_population x001 -long
55 
56 
57    Displaying version 4 data model: >udd>d>dbmt>ndb>K>x>doc>x001.db
58 
59    RELATION  TUPLES    INDEX     AVE TUPLES SELECTED
60 
61    r001      100
62                        x001      16
63 
64 A description of the -long form output follows:
65 
66    Relation:  the name of the relation in the user's view.
67 
68    Tuples:  the number of tuples currently stored as records in the
69    vfile.
70 
71    Index:  the indexed attributes in the relation.
72 
73    Ave Tuples Selected:  the number of tuples that MRDS expects to
74    retrieve when doing a comparison on an indexed attribute.  This
75    estimate is based on the number of duplicate keys for that index.