|
|
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.