
110 Administering and Implementing WebSphere Business Integration Server V4.3
db2 attach to wbidb user db2admin using sas313r
db2 create database CMDB
db2 connect to CMDB user db2admin using sas313r
db2 GRANT DBADM, CREATETAB, BINDADD, CONNECT, CREATE_NOT_FENCED_ROUTINE,
IMPLICIT_SCHEMA, LOAD, CREATE_EXTERNAL_ROUTINE, QUIESCE_CONNECT ON DATABASE
TO USER WBIADMIN
db2 catalog system odbc data source CMDB
a. First, the remote system is cataloged.
b. Next, we attach to the remote database instance using the user ID
db2admin, which is the database instance owner.
c. The next step creates the actual database on the remote server. When the
database is cre ...