Set instance properties

Typically, a DB2 ESE system has one partition assigned to each computer. If a computer has more than one partition running on the same computer and participating in the same instance, it is running multiple logical partitions. Multiple logical partitions can be beneficial on a computer that has symmetric multiprocessor (SMP) architecture. For more information on running multiple logical partitions, see the DB2 Administration Guide: Implementation.

If you are installing a partitioned database environment, you must specify the maximum number of logical partitions that will run on any one computer in your system. This reserves TCP/IP port numbers for the partitions to use for communications. The additional logical partitions can be added later. Type this number in the Maximum logical partitions field. If you are not running multiple logical partitions on any computer, enter 1.

Access to an instance or a database first requires that the user be authenticated. The authentication type for each instance determines how and where a user will be verified. The authentication type is set initially when the instance is created, and can be changed at a later time. The authentication type covers access to the database server for all the databases under its control.

If you intend to access data sources from a federated database, you must consider data source authentication processing and definitions for federated authentication types. See the DB2 Administration Guide for more information.

Authentication type determines how and where authentication of a user takes place.

If authentication is Server, then the user ID and password are sent from the client to the server so authentication can take place on the server. This is the default security mechanism. The value Server Encrypt provides the same behavior as Server, except that any passwords sent over the network are encrypted.

The value Server Encrypt specifies that the server accepts encrypted Server authentication schemes. If the client authentication is not specified, the client is authenticated using the method selected at the server. If the client authentication is Server, the client is authenticated by passing the user ID and password to the server. If the client authentication is Server Encrypt, the client is authenticated by passing a user ID and encrypted password. If Server Encrypt is specified at the client and Server is specified at the server, an error is returned because of the discrepancy in the authentication levels.

A value of Client indicates that all authentication takes place at the client, so no authentication needs to be performed at the server. Client authentication is for trusted clients only.

For more information on Authentication Types, see the DB2 Administration Guide: Implementation.

Select the Autostart instance at system startup check box to automatically start the instance whenever the system is started.