dbmaint
Description
The dbmaint tool manages named databases.
Note This tool can be run only by user accounts belonging to group pvsw. See for information on PSQL Linux, macOS, or Raspbian utilities and user accounts.
Synopsis
dbmaint a | d | l | m [-nDbname][-a][-b][-c][-i][-e][-v][-ldictpath][-ddatapath][-ssecuritymode]
add new database name | a -nDbname [-b] [-i] [-e] [-ldictpath] [-ddatapath] |
delete database name | d -nDbname |
list database names | ldictpath [-a] |
modify database security policy | m -nDbname -ssecuritymode |
modify database code page | m -nDbname -c=codepage |
Options
Commands
add, a | Add database name |
del, d | Delete database name |
list, l | List all database names |
modify, m | Modify database name, security mode, or code page |
Options
-a | Show full details about dbnames in database list when you use the -l option |
-b | Create bound database |
-c=codepage | Set the database code page. Zero specifies the server default (-c=0). |
-i | Enforce relational integrity on the database |
-e | Do not create dictionary files for database |
-v | Create a database using long metadata (V2 metadata) |
-nDBName | Set database name |
-ldictpath | Set dictionary path |
-h | Show help |
-ddatapath | Set data path |
-ssecuritymode | Set Btrieve security policy for database. Valid choices are Classic, Mixed, Database. |
Examples
To create a database named TEST with relational integrity:
% dbmaint a -i -nTEST
Note Unless a data path is specified, the new database will be in the default location, $PVSW_ROOT/data. Likewise, if a dictionary path is not specified, the dictionary will be created in the default location.
To delete the same database:
% dbmaint d -nTEST
To create a database named mydbase with a database code page of CP932:
% dbmaint a -nmydbase -c=CP932
For the same database, to set the code page to the default operating system code page:
% dbmaint m -nmydbase -c=0
To see a list of valid code pages (specify an invalid code page and dbmaint returns a list of valid ones):
% dbmaint m -nmydbase -c=xzy
Dbmaint returns something similar to the following:
Bad code page "xyz" should be: ASCII, ISO8859_1, CP437, CP1252, UTF-8, CP1250, CP1251, CP1253, CP1254, CP1255, CP1256, CP1257, CP1258, CP737, CP775, CP850, CP852, CP855, CP857, CP858, CP862, CP866, CP932, or EUCJP
To list all database names with full information:
% dbmaint l -a
To modify the security policy of the DefaultDB database to Mixed:
% dbmaint m -nDefaultDB -sMixed
See Also
dsnadd,
butil(1),
btadmin(1), syslogd(1), smb.conf(5)