The following options are commands you can send to the Mainframe Server region. Entries must begin in column 1.
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
(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:
(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
(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.
(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
(Optional) Requests SVCOMPR to report a list of all the Mainframe Server options and their current settings.
(1-7) OPTIONS
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.
(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
(Optional) Turns on the Trace facility.
(1-7) TRACEON
(Optional) Turns off the trace facility.
(1-8) TRACEOFF
(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.
TRUSER1=
TRUSER2=
TRUSER3=
TRUSER4=
TRUSER5=
Enables the SQL Syntax trace for a specific userid.
Disables the SQL Syntax trace for the userid previously enabled.
Enables the SQL Syntax trace for ALL userids.
Disables the SQL Syntax trace for ALL userids including those enumerated by a previous TRUSERx= command.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|