Previous Topic: z/OS SVCOMPR JCL Control StatementsNext Topic: STATUS Command Output


SVCOMPR Input Parameters

The following options are commands you can send to the Mainframe Server region. Entries must begin in column 1.

APPLID=

Identifies the Mainframe Server region to which subsequent commands should be sent. If CAICCI communication protocol is used, APPLID= is the Application Identifier. If TCP/IP communication protocol is used, the APPLID is a token that uniquely identifies the Mainframe Server region. Valid columns and entries are as follows:

Valid Entries: 1 to 20 alphabetic characters, following the rules for SQL names

Default Value: No default

CANCEL=

(Optional) Cancels the connection. Issue the STATUS command to get a list of connections. Then, issue the CANCEL command for the connection number you want to terminate. Valid columns and entries are as follows:

EOJ

(Optional) Tells the server to terminate immediately. A Mainframe Server should terminate automatically if its MUF fails while there are active database requests. If the MUF fails and the server does not terminate automatically, or if you need to restart a server with different input parameters, you must terminate the server or LPAR manually with the EOJ parameter.

(1-3) EOJ

HOSTNAME=xxxxxxxx

(Optional) Specifies the hostname or IP address SVDBSPR to permit TXP/IP connections for request instead of CCI. HOSTNAME must be pared with PORT= for a connection to SVDBSPR to be made.

MODIFY

(Optional) Specifies startup Mainframe Server options that you can modify while the Server is active. Any option modified by this statement is in effect for all connections to the server after modification and is in effect until another MODIFY is issued or until the server is terminated. The following input options can be modified:

AUTHID, CBSIO, DATE, DECPOINT, DYNURT, ISOLEVEL, MSG, OPT, PLANNAME, PLNCLOSE, PRTY, STRDELIM, SUPMSG, SQLMODE, TIME, TIMEMIN, TIMEOUT, TIMESEC, URTPRTY, WORKSPACE

Valid columns and entries are:

Example: AUTHID=SYSADM,LOGON=YES

OPTIONS

(Optional) Requests SVCOMPR to report a list of all the Mainframe Server options and their current settings.

(1-7) OPTIONS

PORT=xxxxx

Specifies the PORT number. This number has to conform to the port number that is assigned in the SVDBSPR start-up parameters. If PORT= is specified, then HOSTNAME has to be present as well.

Note: If all TCP/IP ports are in use and the request is a STATUS or OPTIONS, it is possible that a timeout will occur. If this happens, resubmit the job or the request has to be issued using the CONSOLE interface.

STATUS

(Optional) Produces a status report of activity currently being processed by the Mainframe Server including a list of current tasks or connections.

(1-6) STATUS

TRACEON

(Optional) Turns on the Trace facility.

(1-7) TRACEON

TRACEOFF

(Optional) Turns off the trace facility.

(1-8) TRACEOFF

TRUSER1=
TRUSER2=
TRUSER3=
TRUSER4=
TRUSER5=

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

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.