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 |