Client end examines database server to carry the method that locks up informatio

1. examines this locality example

C:≫DB2ilist

DB2

　　---This locality example is Db2

2. Examine the example that using currently

C:≫db2 Get Instance

Current database manages implement example is: DB2

3. Examine case of node make a catalogue, get is not the example of this locality

C:≫db2 List Node Directory

Node catalog

The entry in catalog counts = 1

Node 1 entry:

Node name = DB164

Annotate =

= LOCAL of list entry type

Consultative = TCPIP

Leader name = 169.254.11.164

Serve name = 50000

　　

C:≫db2 List Node Directory Show Detail

Node catalog

The entry in catalog counts = 1

Node 1 entry:

Node name = DB164

Annotate =

= LOCAL of list entry type

Consultative = TCPIP

Leader name = 169.254.11.164

Serve name = 50000

Long-range example name = Db2

Systematic =

= of operating system type is not had

The node of the DB164 example that can see this locality has 169.254.11.164 to go up catalogues.

4. Examine the corresponding information of all databases and example.

C:≫db2 List Db Directory

Systematic database catalog

The entry in catalog counts = 3

Database 1 entry:

Database alias = DW

Database name = DW

Node name = DB164

The database issues edition level = A.00

Annotate =

= of list entry type is long-range

Attestation = SERVER

= -1 of date of catalog database partition

Reserve server leader name =

Reserve = of server port date

Database 2 entry:

Database alias = CCP_BUSI

Database name = CCP_BUSI

Node name = DB164

The database issues edition level = A.00

Annotate =

= of list entry type is long-range

Attestation = SERVER

= -1 of date of catalog database partition

Reserve server leader name =

Reserve = of server port date

Database 3 entry:

Database alias = MYDB

Database name = MYDB

Database driver = D:DB2

The database issues edition level = A.00

Annotate =

= of list entry type is indirect

= 0 of date of catalog database partition

Reserve server leader name =

Reserve = of server port date

　　---Can see there are 2 database DW and CCP_BUSI on Db164, connect look on DW next

5.attach arrives on Db164

C:≫db2 Attach To Db164 User Db2admin

Input the present code of Db2admin:

Example join information

Example server = DB2/NT 8.2.0

Award mace to know = DB2ADMIN

= DB164 of alias of this locality example
1、分页标题#e#< 2、分页标题#e#<