DB2编目

来源：互联网发布：ubuntu ntp设置编辑：程序博客网时间：2024/06/06 14:25

编目，简单的说就是给远程的计算机的实例和数据库再起一个名字，方便后面连接时用到
网上搜了一下，大多数文章并没有很好的分清编目的TCP/IP节点是主机还是实例，其实它就是个实例

1.编目TCP/IP节点
db2 catalog tcpip node [节点名称] remote [主机名或IPv4/v6地址] server [服务名或端口号]
#拿到远程计算机中默认的实例
db2 catalog tcpip node [节点名称] remote [主机名或IPv4/v6地址] server [服务名或端口号] remote_instane [实例名]
#拿到远程计算机中指定实例名的实例

2.编目本地节点
db2 catalog local node [节点名称] instance [实例名]
#将本地的实例名进行编目

3.编目数据库
db2 catalog db [数据库名] at node [节点名称]
#拿到远程计算机中对应实例下的数据库名编目，得到的名称与原数据库名一致

db2 catalog db [数据库名] as [别名] at node [节点名称]
#拿到远程计算机中对应实例下的数据库名编目，并对数据库重新命名

db2 catalog database [数据库名] as [别名] at node [节点名称]

#同上

4.删除节点
db2 uncatalog node [节点名称]

5.删除数据库编目
db2 uncatalog database [数据库名]

6.列出所有节点目录
db2 list node directory

7.列出所有数据库目录

db2 list db directory

8.连接到节点(相当于设置当前实例为远程实例)
db2 attach to [节点名称]

9.断开数据库连接,同时退出CLP（刷新数据库高速缓存）
db2 terminate

例1.本地编目
(1)在默认实例DB2中创建数据库,数据库名称为mydb1
(2)新建实例DB2_02,通过本地编目命名为mynode2
(3)在mynode2中创建数据库
命令
db2 create database mydb1
db2icrt DB2_02
set db2instance=DB2_02
db2start
db2 catalog local node mynode2 instance DB2_02
db2 terminate
db2 list node directory
db2 attach to mynode2
db2 create database mydb2

结果

C:\Program Files\IBM\SQLLIB\BIN>db2 create database mydb1DB20000I  CREATE DATABASE命令成功完成。C:\Program Files\IBM\SQLLIB\BIN>db2icrt DB2_02DB20000I  DB2ICRT命令成功完成。C:\Program Files\IBM\SQLLIB\BIN>set db2instance=DB2_02C:\Program Files\IBM\SQLLIB\BIN>db2startSQL1063N  DB2START 处理成功。C:\Program Files\IBM\SQLLIB\BIN>db2 catalog local node mynode2 instance DB2_02DB20000I  CATALOG LOCAL NODE命令成功完成。DB21056W  只有在刷新目录高速缓存以后，目录更改才会生效。C:\Program Files\IBM\SQLLIB\BIN>db2 terminateDB20000I  TERMINATE命令成功完成。C:\Program Files\IBM\SQLLIB\BIN>db2 list node directory 节点目录 目录中的条目数 = 1节点 1 条目： 节点名                            = MYNODE2 注释                            = 目录条目类型                    = LOCAL 协议                            = LOCAL 实例名                            = DB2_02C:\Program Files\IBM\SQLLIB\BIN>db2 attach to mynode2   实例连接信息 实例服务器             = DB2/NT 9.1.2 授权标识                            = ADMINIST... 本地实例别名           = MYNODE2C:\Program Files\IBM\SQLLIB\BIN>db2 create database mydb2DB20000I  CREATE DATABASE命令成功完成。C:\Program Files\IBM\SQLLIB\BIN>

例2.TCP/IP编目(默认实例)
(1)将远程计算机默认实例DB2，通过TCP/IP编目命名为renode2
(2)在远程实例renode2中创建数据库mydb1

(2)将远程实例renode2中SAMPLE数据库编目，别名为RESAMPLE

命令

db2 catalog tcpip node renode2 remote 192.168.116.129 server 50000
db2 terminate
db2 list node directory
db2 attach to renode2 user db2admin using db2admin
db2 create database mydb1
db2 catalog db SAMPLE as RESAMPLE at node renode2
db2 terminate
db2 list db directory
db2 connect to RESAMPLE user db2admin using db2admin
db2 select * from administrator.employee

结果

C:\Program Files\IBM\SQLLIB\BIN>db2 catalog tcpip node renode2 remote 192.168.116.129 server 50000DB20000I  CATALOG TCPIP NODE命令成功完成。DB21056W  只有在刷新目录高速缓存以后，目录更改才会生效。C:\Program Files\IBM\SQLLIB\BIN>db2 terminateDB20000I  TERMINATE命令成功完成。C:\Program Files\IBM\SQLLIB\BIN>db2 list node directory 节点目录 目录中的条目数 = 1节点 1 条目： 节点名                            = RENODE2 注释                            = 目录条目类型                    = LOCAL 协议                            = TCPIP 主机名                          = 192.168.116.129 服务名称             = 50000C:\Program Files\IBM\SQLLIB\BIN>db2 attach to renode2 user db2admin using db2admin   实例连接信息 实例服务器             = DB2/NT 9.1.2 授权标识                            = DB2ADMIN 本地实例别名           = RENODE2C:\Program Files\IBM\SQLLIB\BIN>db2 create database mydb1DB20000I  CREATE DATABASE命令成功完成。C:\Program Files\IBM\SQLLIB\BIN>db2 catalog db SAMPLE as RESAMPLE at node renode2DB20000I  CATALOG DATABASE命令成功完成。DB21056W  只有在刷新目录高速缓存以后，目录更改才会生效。C:\Program Files\IBM\SQLLIB\BIN>db2 terminateDB20000I  TERMINATE命令成功完成。C:\Program Files\IBM\SQLLIB\BIN>db2 list db directory 系统数据库目录 目录中的条目数 = 3数据库 1 条目： 数据库别名                      = MYDB1 数据库名称                               = MYDB1 节点名                            = RENODE2 数据库发行版级别                = b.00 注释                            = 目录条目类型                    = 远程 目录数据库分区号                  = -1 备用服务器主机名                = 备用服务器端口号                =数据库 2 条目： 数据库别名                      = SAMPLE 数据库名称                               = SAMPLE 本地数据库目录                  = C: 数据库发行版级别                = b.00 注释                            = A sample database 目录条目类型                    = 间接 目录数据库分区号                  = 0 备用服务器主机名                = 备用服务器端口号                =数据库 3 条目： 数据库别名                      = RESAMPLE 数据库名称                               = SAMPLE 节点名                            = RENODE2 数据库发行版级别                = b.00 注释                            = 目录条目类型                    = 远程 目录数据库分区号                  = -1 备用服务器主机名                = 备用服务器端口号                =C:\Program Files\IBM\SQLLIB\BIN>db2 connect to RESAMPLE user db2admin using db2admin   数据库连接信息 数据库服务器         = DB2/NT 9.1.2 SQL 授权标识         = DB2ADMIN 本地数据库别名       = RESAMPLEC:\Program Files\IBM\SQLLIB\BIN>db2 select * from administrator.employeeEMPNO  FIRSTNME     MIDINIT LASTNAME        WORKDEPT PHONENO HIREDATE   JOB EDLEVEL SEX BIRTHDATE  SALARY      BONUS       COMM------ ------------ ------- --------------- -------- ------- ---------- -------- ------- --- ---------- ----------- ----------- -----------000010 CHRISTINE    I       HAAS            A00      3978    1995-01-01 PRES      18 F   1963-08-24   152750.00     1000.00     4220.00000020 MICHAEL      L       THOMPSON        B01      3476    2003-10-10 MANAGER      18 M   1978-02-02    94250.00      800.00     3300.00000030 SALLY        A       KWAN            C01      4738    2005-04-05 MANAGER      20 F   1971-05-11    98250.00      800.00     3060.00000050 JOHN         B       GEYER           E01      6789    1979-08-17 MANAGER      16 M   1955-09-15    80175.00      800.00     3214.00000060 IRVING       F       STERN           D11      6423    2003-09-14 MANAGER      16 M   1975-07-07    72250.00      500.00     2580.00000070 EVA          D       PULASKI         D21      7831    2005-09-30 MANAGER      16 F   2003-05-26    96170.00      700.00     2893.00000090 EILEEN       W       HENDERSON       E11      5498    2000-08-15 MANAGER      16 F   1971-05-15    89750.00      600.00     2380.00000100 THEODORE     Q       SPENSER         E21      0972    2000-06-19 MANAGER      14 M   1980-12-18    86150.00      500.00     2092.00000110 VINCENZO     G       LUCCHESSI       A00      3490    1988-05-16 SALESREP      19 M   1959-11-05    66500.00      900.00     3720.00000120 SEAN                 O'CONNELL       A00      2167    1993-12-05 CLERK      14 M   1972-10-18    49250.00      600.00     2340.00000130 DELORES      M       QUINTANA        C01      4578    2001-07-28 ANALYST      16 F   1955-09-15    73800.00      500.00     1904.00000140 HEATHER      A       NICHOLLS        C01      1793    2006-12-15 ANALYST      18 F   1976-01-19    68420.00      600.00     2274.00000150 BRUCE                ADAMSON         D11      4510    2002-02-12 DESIGNER      16 M   1977-05-17    55280.00      500.00     2022.00000160 ELIZABETH    R       PIANKA          D11      3782    2006-10-11 DESIGNER      17 F   1980-04-12    62250.00      400.00     1780.00000170 MASATOSHI    J       YOSHIMURA       D11      2890    1999-09-15 DESIGNER      16 M   1981-01-05    44680.00      500.00     1974.00000180 MARILYN      S       SCOUTTEN        D11      1682    2003-07-07 DESIGNER      17 F   1979-02-21    51340.00      500.00     1707.00000190 JAMES        H       WALKER          D11      2986    2004-07-26 DESIGNER      16 M   1982-06-25    50450.00      400.00     1636.00000200 DAVID                BROWN           D11      4501    2002-03-03 DESIGNER      16 M   1971-05-29    57740.00      600.00     2217.00000210 WILLIAM      T       JONES           D11      0942    1998-04-11 DESIGNER      17 M   2003-02-23    68270.00      400.00     1462.00000220 JENNIFER     K       LUTZ            D11      0672    1998-08-29 DESIGNER      18 F   1978-03-19    49840.00      600.00     2387.00000230 JAMES        J       JEFFERSON       D21      2094    1996-11-21 CLERK      14 M   1980-05-30    42180.00      400.00     1774.00000240 SALVATORE    M       MARINO          D21      3780    2004-12-05 CLERK      17 M   2002-03-31    48760.00      600.00     2301.00000250 DANIEL       S       SMITH           D21      0961    1999-10-30 CLERK      15 M   1969-11-12    49180.00      400.00     1534.00000260 SYBIL        P       JOHNSON         D21      8953    2005-09-11 CLERK      16 F   1976-10-05    47250.00      300.00     1380.00000270 MARIA        L       PEREZ           D21      9001    2006-09-30 CLERK      15 F   2003-05-26    37380.00      500.00     2190.00000280 ETHEL        R       SCHNEIDER       E11      8997    1997-03-24 OPERATOR      17 F   1976-03-28    36250.00      500.00     2100.00000290 JOHN         R       PARKER          E11      4502    2006-05-30 OPERATOR      12 M   1985-07-09    35340.00      300.00     1227.00000300 PHILIP       X       SMITH           E11      2095    2002-06-19 OPERATOR      14 M   1976-10-27    37750.00      400.00     1420.00000310 MAUDE        F       SETRIGHT        E11      3332    1994-09-12 OPERATOR      12 F   1961-04-21    35900.00      300.00     1272.00000320 RAMLAL       V       MEHTA           E21      9990    1995-07-07 FIELDREP      16 M   1962-08-11    39950.00      400.00     1596.00000330 WING                 LEE             E21      2103    2006-02-23 FIELDREP      14 M   1971-07-18    45370.00      500.00     2030.00000340 JASON        R       GOUNOT          E21      5698    1977-05-05 FIELDREP      16 M   1956-05-17    43840.00      500.00     1907.00200010 DIAN         J       HEMMINGER       A00      3978    1995-01-01 SALESREP      18 F   1973-08-14    46500.00     1000.00     4220.00200120 GREG                 ORLANDO         A00      2167    2002-05-05 CLERK      14 M   1972-10-18    39250.00      600.00     2340.00200140 KIM          N       NATZ            C01      1793    2006-12-15 ANALYST      18 F   1976-01-19    68420.00      600.00     2274.00200170 KIYOSHI              YAMAMOTO        D11      2890    2005-09-15 DESIGNER      16 M   1981-01-05    64680.00      500.00     1974.00200220 REBA         K       JOHN            D11      0672    2005-08-29 DESIGNER      18 F   1978-03-19    69840.00      600.00     2387.00200240 ROBERT       M       MONTEVERDE      D21      3780    2004-12-05 CLERK      17 M   1984-03-31    37760.00      600.00     2301.00200280 EILEEN       R       SCHWARTZ        E11      8997    1997-03-24 OPERATOR      17 F   1966-03-28    46250.00      500.00     2100.00200310 MICHELLE     F       SPRINGER        E11      3332    1994-09-12 OPERATOR      12 F   1961-04-21    35900.00      300.00     1272.00200330 HELENA               WONG            E21      2103    2006-02-23 FIELDREP      14 F   1971-07-18    35370.00      500.00     2030.00200340 ROY          R       ALONZO          E21      5698    1997-07-05 FIELDREP      16 M   1956-05-17    31840.00      500.00     1907.00  42 条记录已选择。C:\Program Files\IBM\SQLLIB\BIN>

0 0