DB2 Version 9.7 for Linux, UNIX, and Windows

Command-line variables

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_CLP_EDITOR
  • Operating system: All
  • Default: Notepad( Windows), vi (UNIX), Values: Any valid editor that is located in the operating system path
    Note: This registry variable is not set to the default value during installation. Instead, the code that makes use of this variable uses a default value if the registry variable is not set.
  • This variable determines the editor to be used when executing the EDIT command. From a CLP interactive session, the EDIT command launches an editor preloaded with a user-specified command which can then be edited and run.
DB2_CLP_HISTSIZE
  • Operating system: All
  • Default: 20, Values: 1-500 inclusive
    Note: This registry variable is not set to the default value during installation. Instead, the code that makes use of this variable uses a default value of 20 if the registry variable is not set or if it is set to a value outside of the valid range.
  • This variable determines the number of commands stored in the command history during CLP interactive sessions. Because the command history is held in memory, a very high value for this variable might result in a performance impact depending on the number and length of commands run in a session.
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:
    1. 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.
    2. 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 the DB2INSTANCE variable 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.
    3. 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.
    4. 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.
Parent topic: DB2 registry and environment variables