You can connect and issue commands from TSO terminals by issuing a DSN command to invoke
the DSN command processor explicitly, or through the DB2I (Db2 Interactive) ISPF panels.
About this task
Procedure
To issue commands from a TSO terminal take one of the following actions:
Issue a DSN command to start an explicit DSN session. The DSN command can be issued in the foreground or background, when running under the TSO terminal monitor program (TMP).
Invoking a DSN session with five retries at 30-second intervals
For example, the following TSO command invokes a DSN session, requesting five retries at 30-second intervals: DSN SYSTEM (DB2) RETRY (5)
Displaying information about threads from a TSO session
The TSO terminal displays: READY
You enter: DSN SYSTEM (subsystem-name )
The TSO terminal displays: DSN
You enter: -DISPLAY THREAD
Db2 returns the following messages: DSNV401I - DISPLAY THREAD REPORT FOLLOWS -
DSNV402I - ACTIVE THREADS -
⋮
Start a DB2I session to invoke and
implicit DSN session.
The following figure shows the options of the DB2I Primary Option Menu .
Figure 1. The ISPF panel for the DB2I Primary Option Menu
DSNEPRI DB2I PRIMARY OPTION MENU SSID: DSN
COMMAND ===>
Select one of the following DB2 functions and press ENTER.
1 SPUFI (Process SQL statements)
2 DCLGEN (Generate SQL and source language declarations)
3 PROGRAM PREPARATION (Prepare a DB2 application program to run)
4 PRECOMPILE (Invoke DB2 precompiler)
5 BIND/REBIND/FREE (BIND, REBIND, or FREE plans or packages)
6 RUN (RUN an SQL program)
7 DB2 COMMANDS (Issue DB2 commands)
8 UTILITIES (Invoke DB2 utilities)
D DB2I DEFAULTS (Set global parameters)
X EXIT (Leave DB2I)
When you complete operations by using the
DB2I panels,
DB2I invokes CLISTs, which start the DSN session and
invoke appropriate subcommands.