DB2 Server for VSE & VM: Operation

DB2 Server for VM Parameters

Refer to Starting the Application Server in a VM Environment for the format of the SQLSTART EXEC syntax diagram and an explanation of the SQLSTART EXEC options.

Parameter	Default	Description
ACCOUNT=D|N	N	Accounting This 1-character field indicates whether the database manager is to generate accounting records. N indicates no accounting records are to be generated. D indicates that you want the database manager to generate records. The database manager writes (spools) the accounting records to the VM system accounting file.
DBMODE=L|G|N	Defined in VM directory	Database Mode This 1-character field specifies the mode in which the database manager is used. This parameter is only used for VM/SP and VM/ESA systems. If DBMODE=L is specified, the database manager attempts to start the database as a local resource. There must be a directory entry that allows that resource to be identified as a local resource. If DBMODE=G is specified, the database manager attempts to start the database as a global resource. There must be a directory entry that allows that resource to be identified as a global resource. DBMODE=N is used during migration; see the DB2 Server for VM System Administration manual for information on DBMODE=N. If the DBMODE parameter is not specified, the database manager system defaults to the resource authorization specified in its VM directory.
PROTOCOL=type	SQLDS	Protocol Type Specifies the type of protocol that the application server is capable of handling. Use SQLDS if your database is only to be accessed through SQLDS protocol from DB2 Server for VM application requesters only. Specify the AUTO option if both DRDA and SQLDS protocols are to be supported. Note: The DRDA protocol is not available if you have not installed the optional DRDA code. For a description of how to do this, refer to the DB2 Server for VM System Administration manual.