On Windows operating systems, db2cmd opens the CLP-enabled DB2® window, and initializes the DB2 command line environment. Issuing this command is equivalent to clicking on the DB2 Command Window icon.
QUIT stops the command line processor. TERMINATE also stops the command line processor, but removes the associated back-end process and frees any memory that is being used. It is recommended that a TERMINATE be issued prior to every STOP DATABASE MANAGER (db2stop) command. It might also be necessary for a TERMINATE to be issued after database configuration parameters have been changed, in order for these changes to take effect. Existing connections should be reset before terminating the CLP.
The shell command (!), allows operating system commands to be executed from the interactive or the batch mode on UNIX based systems, and on Windows operating systems (!ls on UNIX, and !dir on Windows operating systems, for example).
>>-db2--+--------------------------------------------+--------->< | .-----------------. | | V | | +---+-------------+-+--+-------------------+-+ | '-option-flag-' +-db2-command-------+ | | +-sql-statement-----+ | | '-?--+------------+-' | | +-phrase-----+ | | +-message----+ | | +-sqlstate---+ | | '-class-code-' | '- ----comment-------------------------------'
? options requests a description and the current settings of the CLP options. ? help requests information about reading the online help syntax diagrams.
In each case, a blank space must separate the question mark (?) from the variable name.