Issuing commands from TSO terminals

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

Begin general-use programming interface information.

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).
    Examples:
    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.End general-use programming interface information.