Db2 Admin Tool primary commands

This command is equivalent to issuing the SET CURRENT APPLICATION COMPATIBILITY statement.

Syntax:

compatvalue

The application compatibility level. You can specify one of the following formats

• V12R1Mmmm
• FLmmm
• mmm

where mmm is the function level number, such as 502. If you do not explicitly specify Vxx, the current version is assumed.

Alternatively, you can specify an asterisk (*) to set the application compatibility level to the current function level.

The specified function level must be equal to or less than the current version and function level and the APPLCOMPAT value that was specified for ADBMAIN at bind time. The new value applies to only the current Db2 connection and does not apply to new Db2 connections that might be established during the Db2 Admin Tool session.

Examples:

APPLCOMPAT V12R1M502
APPLCOMPAT FL502
APPLCOMPAT 502
APPLCOMPAT *
APPLC V12R1M502
APPLC FL502
APPLC 502
APPLC *

For more information about this setting, see Changing defaults.

Syntax:

ON

Specifies that all characters are to be translated to uppercase characters.

OFF

Specifies that lowercase characters are not to be translated to uppercase characters.

Specifying CAPS (without ON or OFF) toggles between CAPS ON and CAPS OFF.

A question mark (?) is the default shortcut character for the catalog navigation command, CAT. You can specify a different character on the DB2 Admin Defaults (ADB2P2) panel in the CAT command character field.

Syntax:

xx

The object type from the System Catalog (ADB21) panel. For example, s is for table spaces, v is for views, and x is for indexes.

qualifier

The object qualifier. You can specify any value that is valid in the Owner field on the System Catalog (ADB21) panel.

name

The object name. You can specify any value that is valid in the Name field on the System Catalog (ADB21) panel.

All parameters are optional. However, you must specify xx if you specify qualifier or name.

?d MYDB
?s MYDB.TS1
?s TS1
?s MYDB.
CAT s MYDB.TS1

For a demonstration of how to use this command, see Video: Catalog Navigation Command.

This command displays the DB2 Space Manager (ADB2MSPC) panel, where you can specify the qualifier.

This command displays the Restore Packages (ADBPBMRE) panel, where you can specify options for restoring the packages. See Restoring packages.

See Defining your own primary commands.

This command displays the Change Management (CM) (ADB2C) panel, where you can choose which CM function you want to invoke.

Syntax:

location-name

The location name for the remote system.

Syntax:

DB2 can be omitted from the command.

db2-command

Any valid Db2 command except for START DB2. Start the command with the command recognition character, which is usually a hyphen (-).

Example:

DB2 -DIS THREAD (*)

This list is displayed on the Display or Terminate Utilities (ADB2Z2U2) panel. See Displaying or terminating utilities.

Depending on your prompt options, you might be asked to confirm the change before the SET statement is executed. See Changing Db2 Admin Tool prompt options.

Syntax:

YES

Turns EXPLAIN mode on.

NO

Turns EXPLAIN mode off.

ONLY

Turns EXPLAIN mode on and prevents statements from being executed. Do not use this mode with regular Db2 Admin Tool functions.

For more information about these values, see CURRENT EXPLAIN MODE special register (Db2 12 for z/OS documentation) .

Example:

EXPLAIN YES

Syntax:

ispf-statement

A valid ISPF statement. Use a semicolon (;) to separate ISPF statements.

Example:

ISPF SELECT CMD(MYCMD)

This command displays the DB2 Admin Options (ADB2P) panel, where you can select the settings that you want to change.

This command displays the Batch Job Utility Parameters (ADB2UPA) panel, where you can specify parameters for your utility jobs.

This command displays the Panel Display Options (ADBPPDO) panel, where you can select the items that you want displayed on panels.

This command allows you to extend your Db2 Admin Tool installation with your own panels and then use these panels directly with Db2 Admin Tool. You must design your panels to be invoked with this PANEL command. Your panels should not be designed to be part of a multi-panel dialog and rely on variables being set in the preceding panels. Otherwise, unpredictable results can occur. For more information about creating your own panels, see Db2 Admin Tool application development.

Syntax:

panel-ID

The panel ID, such as ADB21D.

Example:

PANEL ADBP7P

This command displays the Admin Defaults (ADB2P2) panel, where you optionally make any changes to these default settings.

Syntax:

ddname

The DD name for the file. The specified file should be allocated exclusively, which means that it has a disposition of OLD, NEW or MOD. For example, tso alloc f(temp1) dsn(temp1.list) old. If you do not specify a file name, the default file with the DD name PRINT is used.

Example:

PRT TABLE ON FILE temp1

Syntax:

statement-type

The statement type for which you want to change the prompt options. Valid values are:

DDL

Data definition language, or definition SQL statements.

DCL

Data control language, or authorization SQL statements.

DML

Data manipulation language, or update SQL statements.

DB2

Db2 commands.

DSN

DSN commands.

ON

Turns the prompt on for the specified statement type. If a statement type is not specified, the prompt is turned on for all statement types.

OFF

Turns the prompt off for the specified statement type. If a statement type is not specified, the prompt is turned off for all statement types.

If no options are specified after PROMPT or PRMT, the Prompt Options (ADB2PRMT) panel is displayed, and you can enter your preferences on that panel.

Example:

PROMPT DB2 OFF

When SAVE is issued on the Details for object(s) (ADBPD) panel, the detail report (which is generated by the DET command) is saved in the specified data set.

Depending on your prompt options, you might be asked to confirm the change before the SET statement is executed. See Changing Db2 Admin Tool prompt options.

Syntax:

schema-name

The schema name. If no value is specified, CURRENT SCHEMA is set to the SQL ID.

Example:

SCHEMA ISTJE

Syntax:

ddname

The library DD name. The data set that is associated with the DD name must be a PDS or PDSE. If you do not specify a library name, the default library ISPTABL is used.

panel-ID

The panel ID. If you do not specify a panel name, the default panel DB2ADL is used.

Syntax:

name

The table name. The table must be in open status.

panel-ID

The panel ID. If you do not specify a panel name, the default panel ADB2DF is used.

Syntax:

panel-ID

The panel ID, such as ADB21T. The default is the current panel.

If an SQL statement returns rows, the default table display panel shows the rows.

Syntax:

SQL-statement

An SQL statement. Use a semicolon (;) to separate SQL statements.

If you do not specify an SQL statement, the Edit/Run SQL Statement (ADBPMESQ) panel is displayed. You can enter SQL statements on this panel and run them.

Example:

SQL SELECT * FROM MYTABLE

Syntax:

ID

The authorization ID. If you do not specify an authorization ID, the DB2 Change Current SQL ID (ADB24) panel is displayed. You can select a value from this panel.

Example:

SQLID ISTJE

Syntax:

ssid

The subsystem ID.

Example:

SSID DSN9

This command displays the Manage Work Statement Lists (ADB2W) panel, where you can select the WSL list or list library that you want to view.

For more information about BROWSE, see BROWSE and VIEW panels.

This command allows you to go directly to a particular string without having to scroll. The command starts at the row on which the cursor is positioned and searches all the columns, or the specified columns, for the specified string. If the string is found, the cursor is placed at the row.

Syntax:

string

The search string. If the string contains special characters, enclose it in quotation marks (").

*

Search for the last string used.

NEXT

Searches forward from the current location.

PREV

Searches backward from the current location.

fromcolno

The number of the column from which the search is to start. Specifying fromcolno limits the search to the specified column and the columns after it.

tocolno

The number of the column at which the search is to end. Specifying tocolno limits the search to the specified column and the columns before it.

To find the column numbers for fromcolno and tocolno, issue the SORT command without any parameters.

You can specify RFIND to repeat the last FIND command.

Examples:

FIND MYUSERID
FIND MYUSERID PREV
FIND MYUSERID 2 4
FIND MYUSERID PREV 2 4

This command displays the Order By Columns (ADB2SORT) panel, where you can specify the ORDER BY criteria.

Syntax:

name

The name under which the table is to be saved.

ddname

The library DD name. The data set that is associated with the DD name must be preallocated before you use this command. If you do not specify a library name, the default library ISPTABL is used.

This command displays the Search fields (ADB2SARG) panel, which lists all of the columns in the current ISPF table. On this panel you can specify searches on individual columns by entering a search operator and a search value for the columns. See Filtering data on panels.

Syntax:

RESET

Clears your search specifications.

Syntax:

column-name

The column name. Instead of specifying a column name, you can place the cursor in the column that you want sorted. If you do not specify a column name, and the cursor is not in a column, Db2 Admin Tool displays a panel on which you can specify your sort criteria. See Sorting display data.

For more information about VIEW, see BROWSE and VIEW panels.