Command Line Interface Utilities : dbmaint
 
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)
Database Code Page and Client Encoding in Advanced Operations Guide.