All pastes #155994 Raw Edit

Unnamed

public text v1 · immutable
#155994 ·published 2006-08-31 14:13 UTC
rendered paste body
Hostnames: 

lngr3 --> database server. 
lngr9 --> programmers workstation
yo --> nfs-server
verona --> Pruction PC (hmm?..)


LNGR9 - Programmer's WS

-------------------------------------------------------

[es@lngr9 es]$  db2 list db directory

 System Database Directory

 Number of entries in the directory = 3

Database 1 entry:

 Database alias                  = CREDAPP
 Database name                   = CREDAPP
 Node name                       = LNGR3
 Database release level          = 9.00
 Comment                         =
 Directory entry type            = Remote
 Authentication                  = CLIENT
 Catalog node number             = -1

Database 2 entry:

 Database alias                  = DBVERONA
 Database name                   = CREDAPP
 Node name                       = VERONA
 Database release level          = 9.00
 Comment                         =
 Directory entry type            = Remote
 Authentication                  = CLIENT
 Catalog node number             = -1

Database 3 entry:

 Database alias                  = SAMPLE
 Database name                   = SAMPLE
 Node name                       = LNGR3
 Database release level          = 9.00
 Comment                         =
 Directory entry type            = Remote
 Catalog node number             = -1


----------------------------------------------------------------
[es@lngr9 es]$ mount
...
yo:/home/es on /home/es type nfs (rw,addr=10.0.20.2)
yo:/home/db2inst1 on /home/db2inst1 type nfs (rw,addr=10.0.20.2)
yo:/usr/IBMdb2 on /mount/IBMdb2 type nfs (rw,addr=10.0.20.2)
...


LNGR3 - DB2-Server


----------------------------------------------------------------
es@lngr3:~>ps auxww | grep db2
root      1281  0.0  1.6 46576 8432 ?        S    Aug10   0:00 db2wdog
db2as     1282  0.0  1.6 46584 8696 ?        S    Aug10   0:00 db2sysc
root      1283  0.0  1.6 46576 8464 ?        S    Aug10   0:00 db2gds
db2as     1284  0.0  1.6 46584 8608 ?        S    Aug10   0:00 db2ipccm
db2as     1285  0.0  1.6 46580 8632 ?        S    Aug10   0:00 Scheduler
db2as     1286  0.0  1.6 46584 8656 ?        S    Aug10   0:00 db2tcpcm
db2as     1287  0.0  1.6 46584 8680 ?        S    Aug10   0:00 db2tcpdm
root      1358  0.0  1.2 36860 6376 ?        S    Aug10   0:00 db2wdog
db2inst   1359  0.0  1.6 37316 8596 ?        S    Aug10   0:00 db2sysc
root      1360  0.0  1.2 36860 6412 ?        S    Aug10   0:00 db2gds
db2inst   1361  0.0  1.2 36864 6560 ?        S    Aug10   0:00 db2ipccm
db2inst   1362  0.0  1.6 37316 8628 ?        S    Aug10   0:00 db2tcpcm
db2inst   1363  0.0  1.2 36860 6468 ?        S    Aug10   0:00 db2resyn
db2inst   1364  0.0  1.2 36860 6432 ?        S    Aug10   0:00 db2srvlst
db2inst   1715  0.0  2.9 39636 15160 ?       S    Aug10   0:05 db2agent (idle)
db2inst   1888  0.0  2.9 39624 14944 ?       S    Aug10   0:07 db2agent (idle)
db2inst   3106  0.0  2.8 73524 14720 ?       S    Aug21   0:01 db2agent (CREDAPP)
db2inst   4445  0.0  3.9 73800 20272 ?       S    Aug22   0:00 db2agent (CREDAPP)
db2inst  24610  0.0  1.5 80104 8196 ?        S    12:22   0:00 db2loggr (CREDAPP)
db2inst  24611  0.0  1.2 71020 6536 ?        S    12:22   0:00 db2dlock (CREDAPP)
db2inst  24612  0.0  1.2 71020 6516 ?        S    12:22   0:00 db2pfchr
db2inst  24613  0.0  1.2 71020 6516 ?        S    12:22   0:00 db2pfchr
db2inst  24614  0.0  1.2 71020 6516 ?        S    12:22   0:00 db2pfchr
db2inst  24615  0.0  1.2 71048 6512 ?        S    12:22   0:00 db2pclnr
es       24789  0.0  0.6 12556 3296 pts/0    S    15:59   0:00 /home/db2inst1/sqllib/bin/db2bp 24739C40016 5
es       24813  0.0  0.1  1736  600 pts/0    S    16:01   0:00 grep db2

-------------------------------------------------
es@lngr3:~>mount
...
yo:/home/es on /home/es type nfs (rw,addr=10.0.20.2)
yo:/home/db2inst1 on /home/db2inst1 type nfs (rw,addr=10.0.20.2)


-------------------------------------------------

es@lngr3:~> db2 list db directory

 System Database Directory

 Number of entries in the directory = 3

Database 1 entry:

 Database alias                  = CREDAPP
 Database name                   = CREDAPP
 Node name                       = LNGR3
 Database release level          = 9.00
 Comment                         =
 Directory entry type            = Remote
 Authentication                  = CLIENT
 Catalog node number             = -1

Database 2 entry:

 Database alias                  = DBVERONA
 Database name                   = CREDAPP
 Node name                       = VERONA
 Database release level          = 9.00
 Comment                         =
 Directory entry type            = Remote
 Authentication                  = CLIENT
 Catalog node number             = -1

Database 3 entry:

 Database alias                  = SAMPLE
 Database name                   = SAMPLE
 Node name                       = LNGR3
 Database release level          = 9.00
 Comment                         =
 Directory entry type            = Remote
 Catalog node number             = -1

---------------------------------------------------------------------------
bash-2.05$ id
uid=40001(db2inst1) gid=40002(db2iadm1) groups=40002(db2iadm1),40001(db2asgrp)
bash-2.05$ db2 list node directory

 Node Directory

 Number of entries in the directory = 2

Node 1 entry:

 Node name                      = LNGR3
 Comment                        =
 Protocol                       = TCPIP
 Hostname                       = lngr3.office.logandgo.de
 Service name                   = 50000

Node 2 entry:

 Node name                      = VERONA
 Comment                        =
 Protocol                       = TCPIP
 Hostname                       = verona.office.logandgo.de
 Service name                   = db2cdb2inst1