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
Previous12 3 Next

Previous:Shallow talk how to build attributive management system effectively
Next：Understand compatibility of DB2 database partition and apposition concept correc