DB2 Version 9.7 for Linux, UNIX, and Windows

HISTORY command

Displays the history of commands run within a CLP interactive mode session.

Scope

This command can only be run within CLP interactive mode. Specifically, it cannot be run from the CLP command mode or the CLP batch mode.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-+-HISTORY-+--+---------+--+-----+---------------------------><
   '-H-------'  +-REVERSE-+  '-num-'   
                '-R-------'            

Command parameters

REVERSE | R
Displays the command history in reverse order, with the most-recently run command listed first. If this parameter is not specified, the commands are listed in chronological order, with the most recently run command listed last.
num
Displays only the most recent num commands. If this parameter is not specified, a maximum of 20 commands are displayed. However, the number of commands that are displayed is also restricted by the number of commands that are stored in the command history.

Usage notes

  1. The value of the DB2_CLP_HISTSIZE registry variable specifies the maximum number of commands to be stored in the command history. This registry variable can be set to any value between 1 and 500 inclusive. If this registry variable is not set or is set to a value outside the valid range, a maximum of 20 commands is stored in the command history.
  2. Since the HISTORY command will always be listed in the command history, the maximum number of commands displayed will always be one greater than the user-specified maximum.
  3. The command history is not persistent across CLP interactive mode sessions, which means that the command history is not saved at the end of an interactive mode session.
  4. The command histories of multiple concurrently running CLP interactive mode sessions are independent of one another.