Console Commands (SVCONPR)

Mainframe Server Component Implementation › Console Commands (SVCONPR)

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 to be performed, you must issue multiple console MODIFY commands.

The following options are commands you can enter using the Console Commands command. Each entry must be preceded by the server job or started task name followed by a comma (,). For example in CA SYSVIEW PM, the command syntax is the following:

/f xxxxxxxx,command

Where xxxxxxxx is the job or started task name and command is the command. The following commands are available:

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

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. 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

OPTIONS

(Optional) Requests that a list of options be listed on the console.

SYSVIEW ISPF1 CA31 ------------------------------------- OUTPUT, Job Output -----------------------------11/12/10 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 what the status for each is.

The STATUS command can be issued to see if any workstation requests are waiting for a free CA Datacom/DB thread. If requests are waiting, DBUSERS can be increased. 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

TRACEON

(Optional) Turns on the Trace facility.

TRACEOFF

(Optional) Turns off the Trace facility.

TRUSERx=uuuuuuuu

(Optional) Enables a SQL syntax trace and defines the userids to trace. When enabled, the SQL syntax generated by the user's application is written to SYSPRINT. The output of the SQL Syntax trace is typically brief but depends on the length of the SQL statements. For an example of the output, see SQL Syntax Trace Example Output.

TRUSERx=useridx enables the SQL Syntax trace for a specific userid.
TRUSERx= disables the SQL Syntax trace for the userid previously enabled.
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 TRUSERx= command.

The global TRACEON option overrides TRUSERx=. If TRACEON=YES is coded in Server Mainframe Region startup options, or TRACEON issued a previous console or SVCOMPR command, the SQL syntax trace entries are not written to SYSPRINT.