dbmaint
Description
The dbmaint utility manages named databases.
*Note: This utility can only be run by user accounts belonging to group pvsw. See Getting Started with PSQL for information on PSQL Linux or OS X 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 datapath 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)
Database Code Page and Client Encoding in Advanced Operations Guide.