db2 system Commands.pdfVIP

DB2 System Command Examples Michael Dang Certified Database Administrator for DB2 UDB Sylvia Qi Certified Database Administrator for DB2 UDB The purpose of this document is to provide examples for each DB2 system command, because these examples may be lacking in the DB2 Command Reference. However, the document is not intended to replace the Command Reference. The Command Reference still contains the most complete information about syntax and available options for each command. The DB2 system commands must be invoked from the Operating System command prompt on Linux/UNIX, or from the DB2 Command prompt on Windows. The DB2 Command prompt on Windows can be launched by the ‘db2cmd’ command, or simply by opening the DB2 Command Window from the Start menu. The DB2 system commands are not valid in the DB2 interactive CLP session. The commands in this document are applicable to DB2 version 8. dasauto (UNIX only) Description: Enables or disables autostarting of the DB2 Administration Server (DAS) Linux/UNIX Examples Command Location: /usr/opt/db2_08_01/das/adm (AIX) Command Location: /opt/IBM/db2/V8.1/das/adm (Linux/UNIX) Authorization: dasadm Example 1: To enable autostart on the DAS, issue: dasauto -on Example 2: To disable autostart on the DAS, issue: dasauto -off dascrt (UNIX only) Description: Creates a DB2 Administration Server. Linux/UNIX Examples Command Location: /usr/opt/db2_08_01/instance (AIX) Command Location: /opt/IBM/db2/V8.1/instance (Linux/UNIX) Authorization: Root Example: To create a DAS user “db2as”. dascrt –u db2as Notes ? In previous DB2 versions, this command was known as “dasicrt”. ? This command can create only 1 DAS per server. ? The command must be issued from the command location by a root user. dasdrop (UNIX only) Description: Removes a DB2 Administration Server Linux/UNIX Examples Command Location: /usr/opt/db2_08_0