Console Commands (SVCONPR)

Console support is available when the Mainframe Server region is started. It allows the same functions that are available when using the SVCOMPR. There are some differences in the presentation of the data returned and how the input is processed. Console communication is only available to the Mainframe Server region with which it is associated, so there is no option to specify an APPLID. Commands are issued to the Mainframe Server region using the z/OS console MODIFY command. The interface allows one function per z/OS MODIFY command. If multiple functions are performed, you must issue multiple console MODIFY commands.
cadts
Console support is available when the Mainframe Server region is started. It allows the same functions that are available when using the SVCOMPR. There are some differences in the presentation of the data returned and how the input is processed. Console communication is only available to the Mainframe Server region with which it is associated, so there is no option to specify an APPLID. Commands are issued to the Mainframe Server region using the z/OS console MODIFY command. The interface allows one function per z/OS MODIFY command. If multiple functions are performed, you must issue multiple console MODIFY commands.
The following topics are discussed on this page:
Console Command Syntax
The following options are commands that you can enter using the Console Commands command. Precede each entry with the server job or started task name followed by a comma (,). For example, in CA SYSVIEW Performance Management (PM) the command syntax is:
/f 
xxxxxxxx
,
command
Where
xxxxxxxx
is the job or started task name and
command
is the command.
Console Commands
The following options are commands that you can issue to the Mainframe Server Region using the Console Command (SVCONPR).
  • CANCEL=
    nnnnnnnnnnnnnnn
    (
    Optional
    ) Cancels a connection. Issue a STATUS command to display a list of connections. Then issue a CANCEL for the connection number you want to terminate. You can enter a 1- to 15-digit number specifying the connection number obtained from a STATUS command.
  • DB_THREADS
    (
    Optional
    ) The DB_THREADS command prints or displays a DB Queue Depth Report. This report shows a measure of the
    CA Datacom®
    MUF (DB) thread utilization for the threads/tasks allocated to a Server region by the DBUSERS startup option.
    DSV00122I-Console command entered -DB_THREADS DSV00136I-DB Threads Requests DSV00136I ---------- -------- DSV00136I-    1         140912 DSV00136I-    2           6898 DSV00136I-    3           5743 DSV00136I-    4           4612 DSV00136I-    5           3789 DSV00136I-    6           3264 DSV00136I-    7           2900 DSV00136I-    8           2563 DSV00136I-    9           2261 DSV00136I-    10          1946 DSV00136I-    11          1600 DSV00136I-    12          1267 DSV00136I-    13           975 DSV00136I-    14           648 DSV00136I-    15           323 DSV00136I-DB Requests delayed due to no thread available: 0  
    Note:
    For this command, the number of lines of output is related to the number of DBUSERS specified in the Server Mainframe startup options. If the number of DBUSERS is high, use the SVCOMPR utility instead of the console command to minimize the amount of console space used for the display.
   For more information about the report written, see DB_THREADS Report
  • EOJ
    (
    Optional
    ) terminates the server immediately.
  • MODIFY
    (
    Optional
    ) Specifies server options that can be modified while the server is active. Any option modified by this command is in effect for all connections to the server and is in effect until another MODIFY is issued or until the server is recycled. Only one option can be modified in a single instance of the MODIFY command. The following server options can be modified:
         AUTHID           LOGON            SQLMODE          CBSIO      URTPRTY          PRTY             WORKSPACE        TIMEMIN      TIMESEC          PLANCLOSE        DECPOINT         STRDELIM      ISOLEVEL         MSG              OPT              SQLMEM      SUPMSG           DATE             TIME             PLANNAME      TIMEOUT          TIMEOUTWAIT      DECPOINT
    For example, to modify LOGON to YES, the form of the command would be:
    /f xxxxxxxx,MODIFY OPTION,LOGON=YES
    MODIFY is keyword OPTION followed by a comma. The keyword of the option to modify is followed by an equal sign (=) followed by the value. If the command is not issued correctly, the following error message is issued:DSV00071E-Invalid option received on MODIFY card. Not processed.
  • OPTIONS
(
Optional
) Requests that a list of options be listed on the console. For more information, see OPTIONS Report.
SYSVIEW ISPF1 CA31 ------------------------------------- OUTPUT, Job Output -----------------------------11/12/13 08:43:19 Command ====>                                                                                            Scroll *---> CSR -----------------------------------------------------------------------------------------------------------Lvl 4 Row 45-62 JobName  Jobid    Queue    DDName   StepName ProcStep DBSRS14  STC29494 EXECUTE  JESMSGLG JES2 --------------------------------------------------------------------------------------------------------------------------  ...+....10...+....20...+....30...+....40...+....50...+....60...+....70...+....80...+....90...+....100..+....120..+....13  08.43.14 STC29494  BPXM023I (ABCDE01) DSV00122 -OPTIONS 08.43.14 STC29494  BPXM023I (ABCDE01)      DBUSERS:              52 08.43.14 STC29494  BPXM023I (ABCDE01)      SUPMSG:               N 08.43.14 STC29494  BPXM023I (ABCDE01)      SERVERNAME:           DEV_R140_CA31 08.43.14 STC29494  BPXM023I (ABCDE01)      APPLID:               DEV_R140_CA31 08.43.14 STC29494  BPXM023I (ABCDE01)      PROTOCOL:             BOTH 08.43.14 STC29494  BPXM023I (ABCDE01)      MAXURTS:              10 08.43.14 STC29494  BPXM023I (ABCDE01)      PLANNAME:             $MBH 08.43.14 STC29494  BPXM023I (ABCDE01)      AUTHID:               SYSUSR 08.43.14 STC29494  BPXM023I (ABCDE01)      DDDID:                0015 08.43.14 STC29494  BPXM023I (ABCDE01)      LOGON:                N 08.43.14 STC29494  BPXM023I (ABCDE01)      TRACEON:              Y 08.43.14 STC29494  BPXM023I (ABCDE01)      CONEXIT:              NONE 08.43.14 STC29494  BPXM023I (ABCDE01)      SECEXIT:              NONE 08.43.14 STC29494  BPXM023I (ABCDE01)      DDBID:                0002 08.43.14 STC29494  BPXM023I (ABCDE01)      SQL:                  Y 08.43.14 STC29494  BPXM023I (ABCDE01)      TIMEOUT:              1 08.43.14 STC29494  BPXM023I (ABCDE01)      TIMEOUTWAIT           12 --------------------------------------------------------------------------------------------------------------  1=HELP 2=SPLIT 3=RETURN 5=FIND 7=UP 8=DOWN 9=SWAP 10=LEFT 11=RIGHT 12=RECALL
  • STATUS
(
Optional
) Produces a list of all tasks that are currently attached and the status for each.
The STATUS command can be issued to see if any workstation requests are waiting for a free
CA Datacom®/DB
thread. DBUSERS can be increased if requests are waiting. Additionally, the value of TASKS can be increased in the MUF startup options.
The following example depicts the display STATUS value:
  11.41.12 STC48943  BPXM023I (ABCDE01) DSV00122I-Console command entered -STATUS                                        11.41.12 STC48943  BPXM023I (ABCDE01) TASK NO USERID   SYSTEMID APPLID               STATUS                             11.41.12 STC48943  BPXM023I (ABCDE01) ------- -------- -------- -------------------- ------------------------------    11.41.12 STC48943  BPXM023I (ABCDE01) 0000002          ABCDE01  SV110000176C00000001 WAITING REQUEST-NO THREAD HELD    11.41.12 STC48943  BPXM023I (ABCDE01) 0000002          ABCDE01  SV110000176C00000001 WAITING REQUEST-NO THREAD HELD
For more information about the reports written, see STATUS Report.
  • TRACEON
    (
    Optional
    ) Turns on the Trace facility.
  • TRACEOFF
    (
    Optional
    ) Turns off the Trace facility.
  • TRACETIME
    (
    Optional
    ) Turns on the abbraviated date/time stamp trace.
  • TRUSER
    x
    =
    uuuuuuuu
    (
    Optional
    ) Enables an SQL Syntax trace and defines the userids to trace. When enabled, the SQL syntax generated by the application of the user is written to SYSPRINT. The output of the SQL Syntax trace is typically brief but depends on the length of the SQL statements. An example of the output is shown in the Input Parameters topic of Mainframe Server Component Implementation.
    • TRUSER
      x
      =
      useridx
      enables the SQL Syntax trace for a specific userid.
    • TRUSER
      x
      = disables the SQL Syntax trace for the previously enabled userid.
    • TRUSER1=TRUSRALL enables the SQL Syntax trace for ALL userids.
    • TRUSER1=TRUSROFF disables the SQL Syntax trace for ALL userids including those enumerated by a previous TRUSER
      2
      = through TRUSER5= commands.
    The global TRACEON option overrides TRUSER
    x
    =. If TRACEON=YES is coded in the Server Mainframe Region startup options, or TRACEON is issued in a previous console or SVCOMPR command, the SQL syntax trace entries are not written to SYSPRINT.
    Valid entries are:
    A valid user ID, TRUSRALL, or TRUSROFF
    Following is a sample trace entry from the TRUSER
    x
    SQL syntax trace.
    DBR: Statement for UserID: USERID01        .                              | | DECLARE SQL_CUR_CA_1 CURSOR FOR select * from sysadm.muf_identity         | |                                                                           | | DBR: Statement for UserID: USERID02        .                              | | DECLARE SQL_CUR_CA_1 CURSOR FOR select tab1.D_MUF_ENABLE, tab1.D_MUF_START| | _DATETIME, tab1.D_MUF_END_DATETIME, tab1.D_MUF_TYPE, tab1.D_MUF_TOTALROW, | | tab1.D_MUF_DURATION, tab1.MUF_NAME, tab1.ELAPSED_SECONDS, ,          tab1.| | CPU_SECONDS, tab1.DB_REQUESTS, tab1.DATA_MGR_REQUESTS, tab1.REL_MGR_REQUES| | TS tab1.REL_MGR_REQUESTS,          tab1.SQL_REQUESTS, tab1.REL_SQL_REQUEST| | S, tab1.PHYSICAL_IO, tab1.PHYSICAL_READS,         tab1.REL_PHYS_READS, tab| | .PHYSICAL_WRITES, tab1.REL_PHYS_WRITES, tab1.SEQ_READ_AHEAD, ...          |