db2 环境 设置技巧篇（DB2 environment settings tips）.doc

db2 环境 设置技巧篇（DB2 environment settings tips） DB2 environment settings tips Setting up the DB2 environment Setting up the DB2 environment properly is important because it controls the way DB2 actions and activities operate. The DB2 environment consists of the following sections: * DB2 configuration file registry * operating system environment variables * DB2 database manager configuration parameters * DB2 database configuration parameters Setting profile registry The DB2 configuration file registry library is a DB2 - specific variable that affects the management, configuration, and performance of DB2 systems. To make changes to the DB2 configuration file registry library effective, you usually need to stop and restart the instance. To list all the DB2 configuration files supported, register libraries: Db2set -lr To set up the DB2 configuration file registry: Db2set registry_variable = value Note that there is no space between variable names, equal sign, and variable values. Here is an example of setting a DB2COMM registry library variable to a single value: Db2set DB2COMM=TCPIP An example of setting the DB2COMM registry library variables to multiple values is as follows: Db2set, DB2COMM=TCPIP, NPIPE, LOCAL To reset the DB2 configuration file registry to the default, simply use the same command as above, but do not specify any value: Db2set registry_variable = To display all the DB2 profile registry libraries currently set on the server, execute the following command: Db2set -all Youll see the output as follows: [e] DB2PATH=C:\Program Files\IBM\SQLLIB_01 DB2ACCOUNTNAME=IBM-TP101\dwsnow DB2INSTOWNER=IBM-SB2QTSR5RSN DB2PORTRANGE=60001:60004 DB2INSTPROF=C:\PROGRA~1\IBM\SQLLIB~1 DB2COMM=TCPIP, NPIPE, LOCAL [g] DB2_EXTSECURITY=YES [g] DB2SYSTEM=IBM-TP101 [g] DB2PATH=C:\Program Files\IBM\SQLLIB_01 [g] DB2INSTDEF=DB2V The square brackets ([]) markers included in the scope of said registry configuration file, as follows: * [e] stands for the registry set for the current sessio