db2start: Starts DB2 (on UNIX, the instance owner must run this command).
db2stop: Stops DB2.
db2sysc process: Use this command to check if DB2 processes are running. For an average database usage, make sure that you have 2 GB RAM available for DB2 processes.
reorg indexes/table: The index option reorganizes all indexes defined on a table by rebuilding the index data into unfragmented, physically contiguous pages. The table option reorganizes a table by reconstructing the rows to eliminate fragmented data, and by compacting information.
runstats: Updates statistics about the physical characteristics of a table and the associated indexes. These characteristics include number of records, number of pages, and average record length. The optimizer uses these statistics when determining access paths to the data. This utility should be called when a table has had many updates, or after reorganizing a table.
db2 backup: Use this command to backup your database. If the command completes successfully, you will have acquired a new backup image that is located in the path or the directory from which the command was issued.
Did this help? You can provide feedback at Jazz.net (registration required): Comment in the forums or submit a bug