db2start: Starts DB2 (on UNIX, the instance owner must run this command).
db2stop: Stops DB2.
db2sysc process: Checks whether DB2 processes are running. For average database use, you must have a minimum of 2 GB RAM available for DB2 processes. In a production environment, consider installing more RAM.
reorg indexes/table: Reorganizes all indexes that are 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 the number of records, the number of pages, and the average record length. The optimizer uses these statistics when determining access paths to the data. Call this utility when a table has had many updates or after reorganizing a table.
db2 backup: Backs up your database. When the command is complete, you have a new backup image that is located in the path or the directory from which the command was issued.
db2set DB2_OPTPROFILE=YES
db2stop
db2start
db2set DB2_OPTPROFILE
Run the following commands in the DB2 Command Window. You can open the Command window from the application Start menu under the DB2 Command Line Tools menu. To connect to a remote server, you can use Telnet or SSH. Ensure that you are connected as the db2inst1 user by running the su db2inst1 command.
Running the setup wizard is the recommended method to configure the database connections and create the database tables. To run the setup wizard, follow the instructions in: Running the Jazz Team Server setup wizard for Rational Engineering Lifecycle Manager applications
If you prefer to do this procedure manually, use this topic to edit the teamserver.properties file to setup an IBM DB2 database connection and run the -createTables command to create database tables.