Create Catalog to connect DB2 server

The following command is how to Create Catalog in DB2

C:\Program Files\IBM\SQLLIB\BIN>db2 catalog tcpip node DEV_NODE remote 10.22.199.22 server 50000

C:\Program Files\IBM\SQLLIB\BIN>db2 catalog database DEV_DB as DEV_DB at node DEV_NODE authentication server


C:\Program Files\IBM\SQLLIB\BIN>db2 list db directory

System Database Directory

Number of entries in the directory = 3

Database 1 entry:

Database alias = DEV_DB
Database name = DEV_DB
Node name = DEV_NODE
Database release level = b.00
Comment =
Directory entry type = Remote
Authentication = SERVER
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

Database 2 entry:

Database alias = BCUDB
Database name = BCUDB
Node name = BCUPROD
Database release level = b.00
Comment =
Directory entry type = Remote
Authentication = SERVER
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

Database 3 entry:

Database alias = DB2LOCAL
Database name = DB2LOCAL
Local database directory = C:
Database release level = b.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

C:\Program Files\IBM\SQLLIB\BIN>db2 list node directory

Node Directory

Number of entries in the directory = 2

Node 1 entry:

Node name = BCUPROD
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = 10.22.197.34
Service name = 50000

Node 2 entry:

Node name = DEV_NODE
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = 10.22.199.22
Service name = 50000

C:\Program Files\IBM\SQLLIB\BIN>db2 connect to dev_db user david using P4ssw0rd

Database Connection Information

Database server = DB2/AIX64 9.5.1
SQL authorization ID = BCUAIX
Local database alias = DEV_DB

C:\Program Files\IBM\SQLLIB\BIN>db2 list tables for schema systools

Table/View Schema Type Creation time
------------------------------- --------------- ----- --------------------------

ALTOBJ_INFO SYSTOOLS T 2009-01-19-13.02.00.203748

ALTOBJ_INFO_V SYSTOOLS V 2009-01-19-13.02.00.463528

AM_BASE_TASKS SYSTOOLS T 2009-05-14-16.34.17.117446

AM_BASE_TASK_RPTS SYSTOOLS T 2009-05-14-16.34.17.903781

AM_TASKS SYSTOOLS V 2009-05-14-16.34.18.092012

AM_TASK_RPTS SYSTOOLS V 2009-05-14-16.34.18.119430

DB2LOOK_INFO SYSTOOLS T 2009-01-19-13.02.02.065869

DB2LOOK_INFO_V SYSTOOLS V 2009-01-19-13.02.02.182347

FED_CACHE_MQTS SYSTOOLS T 2009-01-19-16.14.35.518413

FED_CACHE_OPTIONS SYSTOOLS T 2009-01-19-16.14.35.611751

HMON_ATM_INFO SYSTOOLS T 2008-12-19-08.57.58.227416

HMON_COLLECTION SYSTOOLS T 2008-12-19-08.57.58.257666

POLICY SYSTOOLS T 2008-12-19-08.57.57.904110

STMG_CONTAINER SYSTOOLS T 2009-01-20-10.55.36.147630

STMG_CURR_THRESHOLD SYSTOOLS T 2009-01-20-10.55.35.638062

STMG_DATABASE SYSTOOLS T 2009-01-20-10.55.35.997506

STMG_DBPARTITION SYSTOOLS T 2009-01-20-10.55.35.893326

STMG_DBPGROUP SYSTOOLS T 2009-01-20-10.55.36.043392

STMG_DBSIZE_INFO SYSTOOLS T 2008-12-18-14.00.40.428888

STMG_HIST_THRESHOLD SYSTOOLS T 2009-01-20-10.55.35.836928

STMG_INDEX SYSTOOLS T 2009-01-20-10.55.36.243653

STMG_OBJECT SYSTOOLS T 2009-01-20-10.55.35.773379

STMG_OBJECT_TYPE SYSTOOLS T 2009-01-20-10.55.35.395527

STMG_OBJ_HISTORICAL_THRESHOLDS SYSTOOLS V 2009-01-20-10.55.36.351677

STMG_ROOT_OBJECT SYSTOOLS T 2009-01-20-10.55.35.720545

STMG_TABLE SYSTOOLS T 2009-01-20-10.55.36.193561

STMG_TABLESPACE SYSTOOLS T 2009-01-20-10.55.36.095785

STMG_TBPARTITION SYSTOOLS T 2009-01-20-10.55.35.943119

STMG_THRESHOLD_REGISTRY SYSTOOLS T 2009-01-20-10.55.35.590367

29 record(s) selected.

Advertisements

About davidand

Hi, welcome to my blogs. My name is David Andriansyah. I am currently working as an independent Cognos Business Intelligence consultant, and I also as Freelance Web Developer. View all posts by davidand

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: