DB2 Database Catalog Instructions_PHP Tutorial

DB2 database catalog description

[db2inst2@localhost ~]$ db2 catalog tcpip node node_247 remote 108.88.3.247 server 50000
DB20000I CATALOG TCPIP NODE command completed successfully.
DB21056W Directory changes do not take effect until the directory cache is flushed.


[db2inst2@localhost ~]$ db2 catalog db ptsdb as ptsdb247 at node node_247
DB20000I CATALOG DATABASE command completed successfully.
DB21056W Directory changes do not take effect until the directory cache is flushed.

db2inst2@localhost ~]$ db2 list db directory


Database 4 entry:


Database alias=PTSDB247
Database name=PTSDB
Node Name = NODE_247
Database Release Level = d.00
Comments =
Directory Entry Type = Remote
Directory Database Partition Number = -1
Alternate Server Hostname =
Alternate server port number=

[db2inst2@localhost ~]$ db2 connect to ptsdb user administrator
Enter the administrator’s current password:


Database connection information


Database Server = DB2/NT 9.5.7
SQL Authorization ID = ADMINIST...
Local Database Alias ​​= PTSDB


Table/View Schema Type Creation Time
---------------------------------- --------------- -- --------------------------------
TANK ADMINISTRATOR T 2015-09-08-17.44.59.243001


1 record selected.

http://www.bkjia.com/PHPjc/1067484.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1067484.htmlTechArticleDB2 database catalog description [db2inst2@localhost ~]$ db2 catalog tcpip node node_247 remote 108.88.3.247 server 50000 DB20000I CATALOG TCPIP NODE command completed successfully. DB21056W Until brushing...