Return to creatdb.nr CVS log

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

Annotation of 43BSD/ingres/doc/unix/creatdb.nr, revision 1.1

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.