1. Introducing Database Administration : Database Administration Summary
 
Share this page                  
Database Administration Summary
The following table is a quick reference to the statements, commands, and utilities used to perform database administration tasks.
For details, refer to the appropriate chapter in this guide, the SQL Reference Guide, Command Reference Guide, and Security Guide. Many of these tasks can be also performed using Actian Director or the Visual Tools on Windows.
Note:  UPPERCASE denotes SQL statement; lowercase denotes command or utility.
Task
Statement, Command, or Utility
Back up and recover a database
ckpdb
copydb
rollforwarddb
unloaddb
Change locations of a database
accessdb
extenddb
relocatedb
Configure installation parameters
cbf
Copy a BLOB to a table
blobstor
Copy data from a table into a file
xmlexport
COPY INTO
Copy data from a file into a table
xmlimport
COPY FROM
Duplicate a database
relocatedb
Extend a database to use a location
accessdb
extenddb
Maintain a database
verifydb
Manage constraints
ALTER TABLE...ADD CONSTRAINT
ALTER TABLE...DROP CONSTRAINT
HELP CONSTRAINT
Manage current installation
GRANT...ON CURRENT INSTALLATION
Manage groups
CREATE GROUP
ALTER GROUP
DROP GROUP
Manage indexes
CREATE INDEX
DROP INDEX
HELP INDEX
MODIFY
Manage integrities
CREATE INTEGRITY
DROP INTEGRITY
HELP INTEGRITY
Manage locations
accessdb
extenddb
unextenddb
CREATE LOCATION
ALTER LOCATION
DROP LOCATION
SET WORK LOCATIONS
Manage databases
accessdb
alterdb
copydb
createdb
destroydb
relocatedb
unloaddb
GRANT...ON DATABASE
REVOKE
Manage database events
CREATE DBEVENT
DROP DBEVENT
GET DBEVENT
GRANT ... ON DBEVENT
HELP PERMIT ON DBEVENT
RAISE DBEVENT
REGISTER DBEVENT
REMOVE DBEVENT
Manage database objects
copyapp
copyform
copyrep
delobj
unloaddb
Manage database procedures
CREATE PROCEDURE
DROP PROCEDURE
EXECUTE PROCEDURE
GRANT...ON PROCEDURE
HELP PERMIT ON PROCEDURE
HELP PROCEDURE
REVOKE
Manage database rules
CREATE RULE
DROP RULE
HELP RULE
Manage locking strategies
SET LOCKMODE
SET SESSION ISOLATION LEVEL
SET TRANSACTION
SET TRANSACTION ISOLATION LEVEL
Manage optimization statistics
optimizedb
statdump
Manage profiles
CREATE PROFILE
ALTER PROFILE
DROP PROFILE
Manage roles
CREATE ROLE
ALTER ROLE
DROP ROLE
GRANT
REVOKE
Manage replication
dereplic
reconcil
repcat
repcfg
repdbcfg
repinst
repmod
repstat
rsstatd
Manage schemas
CREATE SCHEMA
Manage security alarms
CREATE SECURITY_ALARM
DROP SECURITY_ALARM
HELP SECURITY_ALARM
Manage security auditing
ALTER SECURITY_AUDIT
DISABLE SECURITY_AUDIT
ENABLE SECURITY_AUDIT
REGISTER TABLE
REMOVE TABLE
Manage sequences
CREATE SEQUENCE
ALTER SEQUENCE
DROP SEQUENCE
GRANT...ON SEQUENCE
REVOKE
Manage synonyms
CREATE SYNONYM
DROP SYNONYM
HELP SYNONYM
Manage tables
CREATE TABLE
CREATE TABLE AS
ALTER TABLE
DROP [TABLE]
COMMENT ON
COPY
COPY FROM/INTO
DECLARE GLOBAL TEMPORARY TABLE
DECLARE TABLE
GRANT...ON TABLE
HELP COMMENT
HELP DEFAULT
HELP PERMIT ON TABLE
HELP TABLE
MODIFY
REVOKE
copydb
blobstor
fastload
unloaddb
Manage users
CREATE USER
ALTER USER
ALTER PROFILE
DROP USER
accessdb
Manage views
CREATE VIEW
DROP VIEW
GRANT ... ON TABLE
HELP PERMIT ON VIEW
HELP VIEW
REVOKE
Monitor and tune a database
Various statements, commands, and utilities
Remove a database from a location
unextenddb
Set or change storage structure for a table or index
SET RESULT_STRUCTURE
CREATE TABLE AS
CREATE INDEX
MODIFY
Tidy user tables or indexes
MODIFY
usermod
Tidy system catalogs
sysmod
Unload data from a database to a flat file
copydb
fastload
unloaddb
View database characteristics
accessdb
catalogdb
infodb