![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to creatdb.nr CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [CSRG BSD Unix] / 43BSD / ingres / doc / unix|
Return to creatdb.nr CVS log | Up to [CSRG BSD Unix] / 43BSD / ingres / doc / unix |
1.1 root 1: .th CREATDB UNIX 11/6/79
2: .sh NAME
3: creatdb \- create a data base
4: .sh SYNOPSIS
5: .bd creatdb
6: [
7: .bd \-u\c
8: .it name
9: ] [
10: .bd \-e
11: ] [
12: .bd \-m
13: ] [
14: .bd \*(+-c
15: ] [
16: .bd \*(+-q
17: ] dbname
18: .sh DESCRIPTION
19: Creatdb creates a new \*(II database,
20: or modifies the status of an existing database.
21: The person who executes this command
22: becomes the Database Administrator
23: (DBA) for the database.
24: The DBA has special powers
25: not granted to ordinary users.
26: .s3
27: .it Dbname
28: is the name of the database
29: to be created.
30: The name must be unique
31: among all \*(II users.
32: .s1
33: The flags
34: .bd \*(+-c
35: and
36: .bd \*(+-q
37: specify options
38: on the database.
39: The form
40: .bd +\c
41: .it x
42: turns an option on,
43: while
44: .bd \-\c
45: .it x
46: turns an option off.
47: The
48: .bd \-c
49: flag
50: turns off the concurrency control scheme
51: (default on).
52: The
53: .bd +q
54: flag
55: turns on query modification
56: (default on).
57: .s3
58: Concurrency control should not be turned off
59: except on databases
60: which are never accessed
61: by more than one user.
62: This applies
63: even if users do not share
64: data relations,
65: since system relations
66: are still shared.
67: If the concurrency control scheme is not installed
68: in \*(UU,
69: or if the special file
70: /dev/lock
71: does not exist or is not accessible
72: for read-write by \*(II,
73: concurrency control acts as though it is off
74: (although it will suddenly come on
75: when the lock driver is installed in \*(UU).
76: .s3
77: Query modification must be turned on
78: for the protection,
79: integrity,
80: and view subsystems
81: to work,
82: however,
83: the system will run
84: slightly slower
85: in some cases
86: if it is turned on.
87: It is possible to turn query modification on
88: if it is already off
89: in an existing database,
90: but it is not possible
91: to turn it off
92: if it is already on.
93: .s3
94: Databases with query modification turned off
95: create new relations with all access permitted
96: for all users,
97: instead of no access except to the owner,
98: the default for databases with query modification enabled.
99: .s1
100: Database options
101: for an existing database
102: may be modified
103: by stating the
104: .bd \-e
105: flag.
106: The database is adjusted
107: to conform to the option flags.
108: For example:
109: .s3
110: creatdb \-e +q mydb
111: .s3
112: turns query modification on
113: for database
114: ``mydb''
115: (but leaves concurrency control alone).
116: Only the database administrator
117: (DBA)
118: may use the
119: .bd \-e
120: flag.
121: .s3
122: When query modification is turned on,
123: new relations will be created with no access,
124: but previously created relations will still have all access
125: to everyone.
126: The
127: .it destroy
128: command may be used to remove this global permission,
129: after which more selective permissions may be specified
130: with the
131: .it permit
132: command.
133: .s1
134: The \*(II user
135: may use the
136: .bd \-u
137: flag
138: to specify a different DBA:
139: the flag should be immediately followed
140: by the login name
141: of the user who should be the DBA.
142: .s3
143: The
144: .bd \-m
145: flag
146: specifies that the \*(UU directory
147: in which the database is to reside
148: already exists.
149: This should only be needed
150: if the directory
151: if a mounted file system,
152: as might occur for a very large database.
153: The directory must exist
154: (as
155: .bd \&.../data/base/\c
156: .it dbname\c
157: ),
158: must be mode 777,
159: and must be empty of all files.
160: .s1
161: The user who executes this command
162: must have the U_CREATDB bit set in
163: the status field
164: of her entry in
165: the users file.
166: .s3
167: The \*(II superuser can create a file in
168: .bd \&.../data/base
169: containing a single line which is the full pathname
170: of the location of the database.
171: The file must be owned by \*(II and
172: be mode 600.
173: When the database is created,
174: it will be created in the file named,
175: rather than in the directory
176: .bd \&.../data/base.
177: For example, if the file
178: .bd \&.../data/base/ericdb
179: contained the line
180: .s3
181: /mnt/eric/database
182: .s3
183: then the database called ``ericdb''
184: would be physically stored in the directory
185: /mnt/eric/database
186: rather than in the directory
187: \&.../data/base/ericdb.
188: .sh EXAMPLE
189: .nf
190: creatdb demo
191: creatdb \-ueric \-q erics_db
192: creatdb \-e +q \-c \-u:av erics_db
193: .fi
194: .sh FILES
195: \&.../files/dbtmplt7
196: .br
197: \&.../files/data/base/*
198: .br
199: \&.../files/datadir/* (for compatibility with previous versions)
200: .sh "SEE ALSO"
201: demodb(unix),
202: destroydb(unix),
203: users(files),
204: chmod(I),
205: destroydb(quel),
206: permit(quel)
207: .sh DIAGNOSTICS
208: .in +4
209: .ti -4
210: No database name specified.
211: .br
212: You have not specified the name of the database
213: to create
214: (or modify)
215: with the command.
216: .ti -4
217: You may not access this database
218: .br
219: Your entry in the users file says
220: you are not authorized to access this database.
221: .ti -4
222: You are not a valid \*(II user
223: .br
224: You do not have a users file entry, and can
225: not do anything with \*(II at all.
226: .ti -4
227: You are not allowed this command
228: .br
229: The U_CREATDB bit is not set in your users
230: file entry.
231: .ti -4
232: You may not use the \-u flag
233: .br
234: Only the \*(II superuser may become
235: someone else.
236: .ti -4
237: <name> does not exist
238: .br
239: With
240: .bd \-e
241: or
242: .bd \-m,
243: the directory does not exist.
244: .ti -4
245: <name> already exists
246: .br
247: Without either
248: .bd \-e
249: or
250: .bd \-m,
251: the database
252: (actually, the directory) already exists.
253: .ti -4
254: <name> is not empty
255: .br
256: With the
257: .bd \-m
258: flag, the directory you named
259: must be empty.
260: .ti -4
261: You are not the DBA for this database
262: .br
263: With the
264: .bd \-e
265: flag, you must be the database
266: administrator.
267: .in -4
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.