You can set command line variables to control the default
behavior of the command line in a DB2® product
environment.
- DB2BQTIME
-
- Operating system: All
- Default=1 second, Minimum value: 1 second
- This variable specifies the amount of time the command-line processor
front end sleeps before it checks whether the back-end process is
active and establishes a connection to it.
- DB2BQTRY
-
- Operating system: All
- Default=60 retries, Minimum value: 0 retries
- This variable specifies the number of times the command-line processor
front-end process tries to determine whether the back-end process
is already active. It works in conjunction with DB2BQTIME.
- DB2_CLPPROMPT
-
- Operating system: All
- Default=None (if it is not defined, "db2 => " will be
used as the default CLP interactive prompt), Values: Any text string
of length less than 100 that contains zero or more of the following
tokens %i, %d, %ia, %da, or %n. Users need not set this variable
unless they explicitly wish to change the default CLP interactive
prompt (db2 =>).
- This registry variable allows a user to define the prompt to be
used in the Command Line Processor (CLP) interactive mode. The variable
can be set to any text string of length less than 100 characters containing
zero or more of the optional tokens %i, %d, %ia, %da, or %n. When
running in CLP interactive mode, the prompt to be used is constructed
by taking the text-string specified in the DB2_CLPPROMPT registry
variable and replacing all occurrences of the tokens %i, %d, %ia,
%da, or %n by the local alias of the current attached instance, the
local alias of the current database connection, the authorization
ID of the current attached instance, the authorization ID of the current
database connection, and newline (that is, a carriage-return) respectively.
Note: - If the DB2_CLPPROMPT registry variable is
changed within CLP interactive mode, the new value for DB2_CLPPROMPT will
not take effect until the CLP interactive mode has been closed and
reopened.
- If no instance attachment exists, %ia is replaced by the empty
string and %i is replaced by the value of the DB2INSTANCE registry
variable. On Windows platforms
only, if DB2INSTANCE is not set, %i is replaced
by the value of the DB2INSTDEF registry
variable. If neither of these variables are set, %i is replaced by
the empty string.
- If no database connection exists, %da is replaced by the empty
string and %d is replaced by the value of the DB2DBDFT registry
variable. If the DB2DBDFT variable is not set,
%d is replaced by the empty string.
- The interactive input prompt will always present the values for
the authorization IDs, database names, and instance names in upper
case.
- DB2IQTIME
-
- Operating system: All
- Default=5 seconds, Minimum value: 1 second
- This variable specifies the amount of time the command line processor
back end process waits on the input queue for the front end process
to pass commands.
- DB2RQTIME
-
- Operating system: All
- Default=5 seconds, Minimum value: 1 second
- This variable specifies the amount of time the command line processor
back end process waits for a request from the front end process.