Return to sysmod.nr CVS log

Up to [CSRG BSD Unix] / 42BSD / ingres / doc / unix

Annotation of 42BSD/ingres/doc/unix/sysmod.nr, revision 1.1.1.1

1.1       root        1: .th SYSMOD UNIX 3/14/79
                      2: .sh NAME
                      3: sysmod \- modify system relations to predetermined storage structures.
                      4: .sh SYNOPSIS
                      5: .bd sysmod
                      6: [
                      7: .bd \-s
                      8: ] [
                      9: .bd \-w
                     10: ] dbname
                     11: [
                     12: .bd relation
                     13: ] [
                     14: .bd attribute
                     15: ] [
                     16: .bd indexes
                     17: ] [
                     18: .bd tree
                     19: ] [
                     20: .bd protect
                     21: ] [
                     22: .bd integrities
                     23: ]
                     24: .sh DESCRIPTION
                     25: .it Sysmod
                     26: will modify the relation,
                     27: attribute,
                     28: indexes,
                     29: tree,
                     30: protect,
                     31: and integrities
                     32: relations
                     33: to hash unless at least one of the
                     34: .bd relation,
                     35: .bd attribute,
                     36: .bd indexes,
                     37: .bd tree,
                     38: .bd protect,
                     39: or
                     40: .bd integrities
                     41: parameters are given,
                     42: in which case only those relations given as parameters
                     43: are modified.
                     44: The system relations are modified to gain maximum access performance
                     45: when running \*(II.
                     46: The user must be the data base administrator for
                     47: the specified database,
                     48: or be the \*(II superuser and have the
                     49: .bd \-s
                     50: flag stated.
                     51: .s3
                     52: .it Sysmod
                     53: should be run on a data base when it is first created
                     54: and periodically thereafter to maintain peak performance.
                     55: If many relations and secondary indices are created and/or destroyed,
                     56: .it sysmod
                     57: should be run more often.
                     58: .sp
                     59: If the data base is being used while
                     60: .it sysmod
                     61: is running, errors will occur.
                     62: Therefore,
                     63: .it sysmod
                     64: will lock the data base while it is being processed.
                     65: If the data base is busy,
                     66: .it sysmod
                     67: will report this.
                     68: If standard input is not a terminal
                     69: .it sysmod
                     70: will wait for the data base to be free.
                     71: If
                     72: .bd \-w
                     73: flag is stated
                     74: .it sysmod
                     75: will not wait, regardless of standard input.
                     76: The
                     77: .bd +w
                     78: flag causes
                     79: .it sysmod
                     80: to always wait.
                     81: .s3
                     82: The system relations are modified to hash;
                     83: the relation relation is keyed on the first domain,
                     84: the indexes,
                     85: attribute,
                     86: protect,
                     87: and integrities
                     88: relations are keyed on the first two domains,
                     89: and the tree
                     90: relation is keyed on domains one, two, and five.
                     91: The relation and attribute relations have the minpages option
                     92: set at 10, the indexes,
                     93: protect,
                     94: and integrities
                     95: relations have the minpages value set at 5.
                     96: .sh "SEE ALSO"
                     97: modify(quel)

This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.