|
DB2ATLD_PWFILE | DB2 UDB ESE on AIX, Solaris, and Windows NT | Default = null
Value:
a file path expression |
Specifies a path to a file that contains a password used during AutoLoader authentication. If not set, AutoLoader either extracts the password from its configuration file or prompts you interactively. Using this variable addresses password security concerns and allows the separation of AutoLeader configuration information from authentication information.
This registry variable is no longer needed, but is retained for backward compatibility. |
DB2CHGPWD_ESE | DB2 UDB ESE on AIX and Windows NT | Default = null
Values:
YES or NO |
Specifies whether you allow other users to change passwords on AIX or Windows NT ESE systems. You must ensure that the passwords for all partitions or nodes are maintained centrally using either a Windows NT domain controller on Windows NT, or NIS on AIX. If not maintained centrally, passwords may not be consistent across all partitions or nodes. This could result in a password being changed only at the database partition to which the user connects to make the change. In order to modify this global registry variable, you must be at the root directory and on the DAS instance.
This variable is required only if you use the old db2atld utility instead of the new LOAD utility. |
DB2_FORCE_FCM_BP | AIX | Default = NO
Values:
YES or NO |
This registry variable is applicable to DB2 UDB ESE for AIX with multiple logical partitions. When DB2START is issued, DB2 allocates the FCM buffers either from the database global memory or from a separate shared memory segment, if there is not enough global memory available. These buffers are used by all FCM daemons for that instance on the same physical machine. The kind of memory allocated is largely dependent on the number of FCM buffers to be created, as specified by the fcm_num_buffers database manger configuration parameter.
If the DB2_FORCE_FCM_BP variable is set to Yes, the FCM buffers are always created in a separate memory segment so that communication between FCM daemons of different logical partitions on the same physical node occur through shared memory. Otherwise, FCM daemons on the same node communicate through UNIX sockets. Communicating through shared memory is faster, but there is one fewer shared memory segment available for other uses, particularly for database bufferpools. Enabling the DB2_FORCE_FCM_BP registry variable thus reduces the maximum size of database bufferpools. |
DB2_NUM_FAILOVER_NODES | All | Default:
2
Values:
0 to the number of logical nodes |
Specifies the number of nodes that can be used as failover nodes in a high availability environment. With high availability, if a node fails, then the node can be restarted as a second logical node on a different host. The number used with this variable determines how much memory is reserved for FCM resources for failover nodes.
For example, host A has two logical nodes: 1 and 2; and host B has two logical nodes: 3 and 4. Assume DB2_NUM_FAILOVER_NODES is set to 2. During DB2START, both host A and B will reserve enough memory for FCM so that up to four logical nodes could be managed. Then if one host fails, the logical nodes for the failing host could be restarted on the other host. |
DB2_PARTITIONEDLOAD_DEFAULT | All supported ESE platforms | Default:
YES
Range of values:
YES/NO |
The DB2_PARTITIONEDLOAD_DEFAULT registry variable lets users change the default behavior of the Load utility in an ESE environment when no ESE-specific Load options are specified. The default value is YES, which specifies that in an ESE environment if you do not specify ESE-specific Load options, loading is attempted on all partitions on which the target table is defined.
When the value is NO, loading is attempted only on the partition to which the Load utility is currently connected. |
DB2PORTRANGE | Windows NT | Values:
nnnn:nnnn |
This value is set to the TCP/IP port range used by FCM so that any additional partitions created on another machine will also have the same port range. |
No comments:
Post a Comment