Library > Products > Pervasive PSQL > Pervasive PSQL v10 > User's Guide > Command Line Interface Utilities > dbmaint

PreviousUser's Guide (v10) Next

dbmaint

Chapter contents

Availability

Windows
Linux
Clients
Engines
No
Yes
No
Yes

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 Pervasive PSQL for information on Pervasive PSQL Linux utilities and user accounts.

Synopsis 

dbmaint a | d | l | m [-nDbname] [-a] [-b] [-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

Options

Commands

add, a
add dbname
del, d
delete dbname
list, l
list dbnames

Options

-b
create bound database
-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

Examples

To create DBName TEST with relational integrity type: 

% 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, type: 

% dbmaint d -nTEST

To list all DBNames with full information, type: 

% dbmaint l -a

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

% dbmaint m -nDefaultDB -sMixed

See Also

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

Advanced Operations Guide - for more information about database names, bound databases, referential integrity, and Btrieve security policies.

Chapter contents
Book contents

Prev topic: clilcadm
Next topic: dsnadd