Commands in Db2 Admin Tool
You can use primary commands and line commands in Db2 Admin Tool.
Primary commands
Primary commands are issued from the command line on Db2 Admin Tool panels. Some primary commands can be entered on all panels and some primary commands are restricted to certain panels. For more information about a particular primary command, see Db2 Admin Tool primary commands or the Help panels.
- When you enter a primary command that has the same name as a TSO command, the TSO command is executed first. To bypass the TSO command processor, enter the primary command with a prefix of the greater than symbol (>), which is a TSO escape character.
- On table display panels, primary commands operate on each row that is displayed in the table. If you want to omit some of the rows before you issue the primary command, use the minus (-) line command to remove rows from the display. The primary commands operate only on rows that are listed.
Line commands
Line commands specify an operation that is to be performed on the selected line or object. You can issue line commands from ISPF table display panels. Specify line commands in the line command area in front of each row. This area is called the SELECT (or SEL) field.
If you enter a line command or update a row on a table display panel and also issue a scroll request (PF7 to scroll up or PF8 to scroll down), the line command or row update is processed and the scroll request is ignored.
Two types of line commands are supported: special line commands and general line commands. You also can define your own line commands during the installation process; see Defining your own line commands and primary commands for specific panels
- Special line commands
- The special line commands that are available for a panel are listed in the line
command description area.
A question mark (?) line command indicates that not all line commands are listed because of limited space. Enter ? in the Select column to display a list of all of the line commands available for that panel.
Because the objects that are listed on a panel have varying attributes, not all of the line commands that are shown on the panel or its extension panel are applicable to each object. When you try to issue a line command against an object where it is not applicable, an error message is returned.
Utility line commands, which open Db2 utility panels, are prefixed with "U."
For information about a particular line command on a panel, see the online help (PF1).
- General line commands
- The following general line commands are valid on any table display panel:
- Minus (-)
- Excludes a line from the list. You can specify multiple minus (-) line commands at a time.
- Equals (=)
- Repeats the last entered line command.
For example, in the following figure, the DIS line command is entered to request a display of the DBEDB1 database:
Figure 1. DIS line command on the Databases (ADB21D) panel DB2 Admin ------------------- DB2X Databases --------------------- Row 1 of 5 Command ===> Scroll ===> PAGE Commands: GRANT MIG DIS STA STO UTIL MOVETB Line commands: T - Tables S - Table spaces X - Indexes G - Storage group ICS - IC status DIS - Display database STA - Start database STO - Stop database A - Auth ? - Show all line commands Storage Buffer Created Index Select Name Owner Group Pool DBID By T E BPool I * * * * * * * * * * ------ -------- -------- -------- -------- ------ -------- - - -------- - ADBDCH ADB ADBGCH BP1 271 ISTFL2 E BP2 Y DIS DBEDB1 DPGROTH SYSDEFLT BP1 272 DPGROTH E BP2 Y DBEDB2 DPGROTH SYSDEFLT BP1 273 DPGROTH E BP2 N DSNDB04 SYSIBM SYSDEFLT BP1 4 SYSIBM BP2 N DSNDB06 SYSIBM 6 SYSIBM E BP0 N ******************************* END OF DB2 DATA *******************************After Db2 Admin Tool executes this line command, the first character of the command is replaced with an asterisk (*). If you then specify = for the next line and press Enter, the DIS line command is executed for DBEDB2 database:
Figure 2. Equals (=) line command on the Databases (ADB21D) panel DB2 Admin ------------------- DB2X Databases --------------------- Row 1 of 5 Command ===> Scroll ===> PAGE Commands: GRANT MIG DIS STA STO UTIL MOVETB Line commands: T - Tables S - Table spaces X - Indexes G - Storage group ICS - IC status DIS - Display database STA - Start database STO - Stop database A - Auth ? - Show all line commands Storage Buffer Created Index Select Name Owner Group Pool DBID By T E BPool I * * * * * * * * * * ------ -------- -------- -------- -------- ------ -------- - - -------- - ADBDCH ADB ADBGCH BP1 271 ISTFL2 E BP2 Y *IS DBEDB1 DPGROTH SYSDEFLT BP1 272 DPGROTH E BP2 Y = DBEDB2 DPGROTH SYSDEFLT BP1 273 DPGROTH E BP2 N DSNDB04 SYSIBM SYSDEFLT BP1 4 SYSIBM BP2 N DSNDB06 SYSIBM 6 SYSIBM E BP0 N ******************************* END OF DB2 DATA *******************************If you enter the = line command multiple times, Db2 Admin Tool issues each line command successively. The panel where you entered the = line commands is not shown between executions of the line commands. In the following example, Db2 Admin Tool displays the DSNDB06 database first. When you exit that display, Db2 Admin Tool immediately displays the DSNDB07 database.
Figure 3. Multiple equals (=) line commands Databases (ADB21D) panel DB2 Admin ------------------- DB2X Databases --------------------- Row 1 of 7 Command ===> Scroll ===> PAGE Commands: GRANT MIG DIS STA STO UTIL MOVETB Line commands: T - Tables S - Table spaces X - Indexes G - Storage group ICS - IC status DIS - Display database STA - Start database STO - Stop database A - Auth ? - Show all line commands Storage Buffer Created Index Select Name Owner Group Pool DBID By T E BPool I * * * * * * * * * * ------ -------- -------- -------- -------- ------ -------- - - -------- - ADBDCH ADB ADBGCH BP1 271 ISTFL2 E BP2 Y *IS DBEDB1 DPGROTH SYSDEFLT BP1 272 DPGROTH E BP2 Y *IS DBEDB2 DPGROTH SYSDEFLT BP1 273 DPGROTH E BP2 N DSNDB04 SYSIBM SYSDEFLT BP1 4 SYSIBM BP2 N = DSNDB06 SYSIBM 6 SYSIBM E BP0 N = DSNDB07 DSCGDB2 SYSDEFLT BP1 7 ISTJE W BP2 N DSNRGFDB DSCGDB2 SYSDEFLT BP1 257 ISTJE E BP2 N ******************************* END OF DB2 DATA ******************************* - Slash (/)
- Shows all column names and their values for the selected row. You can enter more
than one slash (/) line command at a time, with the exception of the Launchpad
(ADBDMT) panel. On that panel, you
can specify only one / line command at a time.
For example, on the following Databases (ADB21D) panel, suppose that you issue the / line command for database
DSNDB06:Figure 4. Slash (/) line command on the Databases (ADB21D) panel DB2 Admin ------------------- DB2X Databases --------------------- Row 1 of 7 Command ===> Scroll ===> PAGE Commands: GRANT MIG DIS STA STO UTIL MOVETB Line commands: T - Tables S - Table spaces X - Indexes G - Storage group ICS - IC status DIS - Display database STA - Start database STO - Stop database A - Auth ? - Show all line commands Storage Buffer Created Index Select Name Owner Group Pool DBID By T E BPool I * * * * * * * * * * ------ -------- -------- -------- -------- ------ -------- - - -------- - ADBDCH ADB ADBGCH BP1 271 ISTFL2 E BP2 Y *IS DBEDB1 DPGROTH SYSDEFLT BP1 272 DPGROTH E BP2 Y *IS DBEDB2 DPGROTH SYSDEFLT BP1 273 DPGROTH E BP2 N DSNDB04 SYSIBM SYSDEFLT BP1 4 SYSIBM BP2 N / DSNDB06 SYSIBM 6 SYSIBM E BP0 N DSNDB07 DSCGDB2 SYSDEFLT BP1 7 ISTJE W BP2 N DSNRGFDB DSCGDB2 SYSDEFLT BP1 257 ISTJE E BP2 N ******************************* END OF DB2 DATA *******************************Db2 Admin Tool displays all column names and their values from the SYSIBM.SYSDATABASE catalog table:
Figure 5. Result of the slash (/) line command DB2 Admin ------------------- DB2X Display Row ------------------- Row 1 of 18 Command ===> Scroll ===> PAGE S Column Name Column Value * * - ------------------ ---------------------------------------------------------- NAME DSNDB06 CREATOR SYSIBM STGROUP BPOOL DBID 6 IBMREQD Y CREATEDBY SYSIBM ROSHARE TIMESTAMP 0001-01-01-00.00.00.000000 TYPE GROUP_MEMBER CREATEDTS 1985-04-01-00.00.00.000000 ALTEREDTS 1985-04-01-00.00.00.000000 ENCODING_SCHEME E SBCS_CCSID 0 DBCS_CCSID 0 MIXED_CCSID 0 INDEXBP BP0 IMPLICIT Y CREATORTYPE RELCREATED P ******************************* END OF DB2 DATA *******************************