Issuing Db2® commands from the command line

You can issuing a Db2® command from the command line on these FM/Db2 panels:
  • Table Browse panel
  • Table Edit panel
  • Table View panel
  • Object list panels displayed with the Object List utility
  • Privilege details panels
  • Enter, Execute and Explain SQL Statements panel

To issue a Db2® command from the command line of a File Manager/Db2 panel:

  1. Type DB2, followed a space, and then the Db2® command you want to issue.
    For example, to issue the Db2® command DISPLAY ARCHIVE, type: 
    DB2 DISPLAY ARCHIVE
  2. Press Enter.

    FM/Db2 displays the output from the Db2® command in an ISPF View session as shown in Example of output displayed by Db2 after Db2 command issued.

Figure 1. Example of output displayed by Db2® after Db2® command issued
   File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help
 ───────────────────────────────────────────────────────────────────────────────
 VIEW       SYS07228.T121015.RA000.FMNUSER.R0227849         Columns 00001 00072
 ****** ***************************** Top of Data ******************************
 ==MSG> -Warning- The UNDO command is not available until you change
 ==MSG>           your edit profile using the command RECOVERY ON.
 000001 DSNV401I  -DFE2 DISPLAY THREAD REPORT FOLLOWS -
 000002 DSNV402I  -DFE2 ACTIVE THREADS -
 000003 NAME     ST A   REQ ID           AUTHID   PLAN     ASID TOKEN
 000004 DB2CALL  T      144 FMNUSER      FMNUSER  FMN2PLN1 00C0   302
 000005 DB2CALL  T  *     2 FMNUSER      FMNUSER           00C0   303
 000006 DISPLAY ACTIVE REPORT COMPLETE
 000007 DSN9022I  -DFE2 DSNVDT '-DISPLAY THREAD' NORMAL COMPLETION
 ****** **************************** Bottom of Data ****************************







 Command ===>                                                  Scroll ===> PAGE
  F1=Help      F2=Split     F3=Exit      F5=Rfind     F6=Rchange   F7=Up
  F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel

Related references