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 Pervasive.SQL (Server edition) for information on Pervasive.SQL 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.