DB2 file Registry

The file Registry (DB2ProfileRegistries), which can affect the running environment configuration of DB2, is the basic DB2. View existing parameters: -- View All configured db2 registry variables db2set-all -- view a list Of all supported registry variables db2set-lr example: [db2inst1 @ O11g64] $ db2set-all [I] DB2AUT

The file Registry (DB2 Profile Registries), which can affect the running environment configuration of DB2, is the basic DB2. View existing parameters: -- View all configured db2 registry variables db2set-all -- View list of all supported registry variables db2set-lr example: [db2inst1 @ O11g64/] $ db2set-all [I] DB2AUT

The file Registry (DB2 Profile Registries), which can affect the running environment configuration of DB2, is the basic DB2.

View existing parameters:

-- View All configured db2 registry Variables

Db2set-all

-- View the list of all supported registry Variables

Db2set-lr

Example:

[Db2inst1 @ O11g64/] $ db2set-all

[I] DB2AUTOSTART = YES

[G] DB2SYSTEM = O11g64. localdomain

[G] DB2INSTDEF = db2inst1

Parameter Change:

The parameters in the file registry must be restarted on the DB2 server and the DB2 application before they take effect.

-- Set

Db2set DB2COMM = TCPIP

-- Set specific variables at the local level

Db2set DB2INSTPROF = "C: \ INSTDIR"-g

-- Set specific variables at the instance level

Db2set DB2INSTPROF = "C: \ INSTDIR"-I DB2

Clear parameters:

-- The parameter value is null.

Db2set parameter name =

Example:

Db2setDB2COMM=

Note:

-- Do not leave spaces before and after db2set (=)

-- We recommend that you restart the instance after the change to prevent it from taking effect immediately.

Usage 1:

Windows:

1. Execute the following command:

Db2set db2_clpprompt = "(Instance: % I, Database: % d ):"

2. Open the command line processor of DB2 and the prompt changes.

(Instance: INST1, Database:): connect to xcldb2

Database connection information

Database Server = DB2/NT 9.1.3

SQL authorization id = ADMINIST...

Local Database alias = XCLDB2

(Instance: INST1, Database: XCLDB2 ):

MAIL: xcl_168@aliyun.com

Blog: http://blog.csdn.net/xcl168