dbmaint

The dbmaint utility manages named databases.

Note: This utility can only be run by user accounts belonging to group pvsw. See Getting Started With Pervasive PSQL for information on Pervasive PSQL Linux utilities and user accounts.

dbmaint a | d | l | m [-nDbname] [-a] [-b] [-c] [-i] [-e]
[-ldictpath] [-ddatapath] [-ssecuritymode]


add new database name	a -nDbname [-b] [-i] [-e] [-ldictpath] [-ddatapath]
delete database name	d -nDbname
list database names	l [-a]. The -a option displays the full information about the dbnames.
modify database name security policy	m -nDbname -ssecuritymode


add, a	Add database name
del, d	Delete database name
list, l	List database names


-b	Create bound database
-c=codepage	Set the database code page. Zero specifies the server default (-c=0).
-i	Create database with relational integrity
-e	Do not create dictionary files for database
-nDBName	Specify database name
-ldictpath	Specify dictionary path
-ddatapath	Specify datapath
-a	Show detail information about dbnames in database list
-ssecuritymode	Specify Btrieve security policy for database. Valid choices are: Classic, Mixed, Database

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:

To modify the security policy of the DefaultDB database to Mixed:

% dbmaint m -nDefaultDB -sMixed

dsnadd, butil(1), btadmin(1), syslogd(1), smb.conf(5)

Data Encoding in Getting Started With Pervasive PSQL.