db2数据联邦基础命令
类别:DB2数据库 作者:码皇 来源:lyc557的博客 点击:
db2数据联邦基础命令1 db2 编目节点: www 2cto com db2 CATALOG TCPIP NODE <NODENAME> REMOTE <IP> SERVER50000 REMOTE_INSTANCE DB2 OSTYPE AIX取消编目节点:db2 uncatalog node <node_name>
db2数据联邦基础命令 1.db2 编目节点: www.2cto.com db2 CATALOG TCPIP NODE <NODENAME> REMOTE <IP> SERVER 50000 REMOTE_INSTANCE DB2 OSTYPE AIX 取消编目节点: db2 uncatalog node <node_name> 2.db2 编目数据库: db2 CATALOG DATABASE <dbname> AS <dbaliasname> AT NODE <NODENAME> AUTHENTICATION SERVER 取消编目数据库: db2 uncatalog database <db_name> 3.创建wrappers create wrapper localda library 'libdb2drda.so' www.2cto.com 4.创建server CREATE SERVER <SERVERNAME> TYPE DB2 / UDB VERSION '9.1' WRAPPER LOCALDA AUTHORIZATION <SCHEMANAME> PASSWORD 154221348321515183610552 OPTIONS ( ADD NODE <nodename> , ADD DBNAME <dbname> ) @ 5.创建 nickname CREATE NICKNAME <nickname> FOR <SERVERNAME>.<SCHEMANAME>.<tablename> @
相关热词搜索:
数据 联邦 基础