![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to ingres.nr CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [CSRG BSD Unix] / 42BSD / ingres / doc / unix|
Return to ingres.nr CVS log | Up to [CSRG BSD Unix] / 42BSD / ingres / doc / unix |
1.1 root 1: .th INGRES UNIX 3/14/79
2: .sh NAME
3: ingres \- \*(II relational data base management system
4: .sh SYNOPSIS
5: .bd ingres
6: [
7: .it flags
8: ] dbname [ process_table ]
9: .sh DESCRIPTION
10: This is the \*(UU command which is used to invoke \*(II.
11: Dbname is the name of an existing data base.
12: The optional flags have the following meanings
13: (a ``\*(+-'' means the flag may be stated
14: ``+\c
15: .it x\c
16: \&''
17: to set option
18: .it x
19: or ``\-\c
20: .it x\c
21: \&''
22: to clear option
23: .it x.
24: ``\-'' alone means that ``\-\c
25: .it x\c
26: \&''
27: must be stated
28: to get the
29: .it x
30: function):
31: .s3
32: .de xx
33: .lp +10 10
34: .if t \fB\\$1\fP\fI\\$2\fP\t\c
35: .if n \\$1\\$2\t\c
36: ..
37: .xx \*(+-U
38: Enable/disable direct update
39: of the system relations
40: and secondary indicies.
41: You must have the 000004 bit
42: in the status field
43: of the users file
44: set
45: for this flag to be accepted.
46: This option is provided
47: for system debugging
48: and is strongly discouraged for normal use.
49: .xx \-u name
50: Pretend you are the user
51: with login name
52: .it name
53: (found in the users file).
54: If
55: .it name
56: is of the form
57: .bd :\c
58: .it xx,
59: .it xx
60: is the two character user code
61: of a user.
62: This may only be used
63: by the DBA for the database
64: or by the \*(II superuser.
65: .xx \-c N
66: Set the minimum field width
67: for printing
68: character domains
69: to
70: .it N.
71: The default is 6.
72: .xx \-i lN
73: Set integer output field width to
74: .it N.
75: .it l
76: may be 1, 2, or 4 for
77: i1's, i2's, or i4's repectively.
78: .xx \-f lxM.N
79: Set floating point output field width
80: to
81: .it M
82: characters
83: with
84: .it N
85: decimal places.
86: .it l
87: may be 4 or 8 to apply to
88: f4's or f8's respectively.
89: .it x
90: may be
91: .bd e,
92: .bd E,
93: .bd f,
94: .bd F,
95: .bd g,
96: .bd G,
97: .bd n,
98: or
99: .bd N
100: to specify an output format.
101: .bd E
102: is exponential form,
103: .bd F
104: is floating point form,
105: and
106: .bd G
107: and
108: .bd N
109: are identical to
110: .bd F
111: unless the number
112: is too big to fit in that field,
113: when it is output in
114: .bd E
115: format.
116: .bd G
117: format guarantees decimal point alignment;
118: .bd N
119: does not.
120: The default format for both is
121: .bd n10.3.
122: .xx \-v X
123: Set the column seperator
124: for retrieves to the terminal
125: and print commands
126: to be
127: .it X.
128: The default is vertical bar.
129: .xx \-r M
130: Set modify mode
131: on the
132: .it retrieve into
133: command
134: to
135: .it M.
136: .it M
137: may be
138: .bd isam,
139: .bd cisam,
140: .bd hash,
141: .bd chash,
142: .bd heap,
143: .bd cheap,
144: .bd heapsort,
145: or
146: .bd cheapsort,
147: for ISAM,
148: compressed ISAM,
149: hash table,
150: compressed hash table,
151: heap,
152: compressed heap,
153: sorted heap,
154: or compressed sorted heap.
155: The default is ``cheapsort''.
156: .xx \-n M
157: Set modify mode on the
158: .it index
159: command to
160: .it M.
161: .it M
162: can take the same values as the
163: .bd \-r
164: flag above.
165: Default is ``isam''.
166: .xx \*(+-a
167: Set/clear
168: the autoclear option in the terminal monitor.
169: It defaults to set.
170: .xx \*(+-b
171: Set/reset batch update.
172: Users must the 000002 bit set
173: in the status field of the users file
174: to clear this flag.
175: This flag is normally set.
176: When clear,
177: queries will run slightly faster,
178: but no recovery can take place.
179: Queries which update a secondary index
180: automatically set this flag for that query only.
181: .xx \*(+-d
182: Print/don't print the dayfile.
183: Normally set.
184: .xx \*(+-s
185: Print/don't print any of the monitor messages,
186: including prompts.
187: This flags is normally set.
188: If cleared,
189: it also clears the
190: .bd \-d
191: flag.
192: .xx \*(+-w
193: Wait/don't wait for the database.
194: If the
195: .bd +w
196: flag is present,
197: \*(II will wait if
198: certain processes are running (purge,restore, and/or sysmod)
199: on the given data base.
200: Upon completion of those processes \*(II will proceed.
201: If the
202: .bd \-w
203: flag is present,
204: a message is returned and execution stopped
205: if the data base is not available.
206: If the
207: .bd \*(+-w
208: flag is omitted
209: and the data base is unavailable,
210: the error message is returned
211: if \*(II is running in foreground
212: (more precisly if the
213: standard input is from a terminal),
214: otherwise the wait option
215: is invoked.
216: .i0
217: .s3
218: .it Process_table
219: is the pathname of a \*(UU file
220: which may be used to specify the run-time configuration of \*(II.
221: This feature is intended for use in system maintenance only,
222: and its unenlightened use by the user community is strongly
223: discouraged.
224: .s3
225: Note: It is possible to run the monitor as a batch-processing
226: interface using the `<', `>' and `\*v' operators of the \*(UU shell,
227: provided the input file is in proper
228: monitor-format.
229: .sh EXAMPLE
230: .nf
231: ingres demo
232: ingres \-d demo
233: ingres \-s demo < batchfile
234: ingres \-f4g12.2 \-i13 +b \-rhash demo
235: .fi
236: .sh FILES
237: \&.../files/users \- valid \*(II users
238: .br
239: \&.../data/base/* \- data bases
240: .br
241: \&.../datadir/* \- for compatability with previous versions
242: .br
243: \&.../files/proctab7 \- runtime configuration file
244: .sh "SEE ALSO"
245: monitor(quel)
246: .sh DIAGNOSTICS
247: .lp +4 4
248: Too many options to \*(II \- you have stated too many flags
249: as \*(II options.
250: .lp +4 4
251: Bad flag format \- you have stated a flag
252: in a format which is not intelligible,
253: or a bad flag entirely.
254: .lp +4 4
255: Too many parameters \- you have given a database name,
256: a process table name,
257: and ``something else''
258: which \*(II doesn't know what to do with.
259: .lp +4 4
260: No database name specified
261: .lp +4 4
262: Improper database name \- the database name is not legal.
263: .lp +4 4
264: You may not access database
265: .it name
266: \- according to the users file,
267: you do not have permission to enter this database.
268: .lp +4 4
269: You are not authorized to use the
270: .it flag
271: flag \- the flag specified
272: requires some special authorization,
273: such as a bit in the users file,
274: which you do not have.
275: .lp +4 4
276: Database
277: .it name
278: does not exist
279: .lp +4 4
280: You are not a valid \*(II user \- you have not been
281: entered into the users file,
282: which means that you may not use \*(II at all.
283: .lp +4 4
284: You may not specify this process table \- special authorization
285: is needed to specify process tables.
286: .lp +4 4
287: Database temporarily unavailable \- someone else is currently
288: performing some operation on the database
289: which makes it impossible for you to even log in.
290: This condition should disappear shortly.
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.