rendered paste bodyHostnames:
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
----------------------------------------------------------
@verona/user: db2inst1
db2 => list db directory
System Database Directory
Number of entries in the directory = 1
Database 1 entry:
Database alias = CREDAPP
Database name = CREDAPP
Local database directory = /home/db2inst1
Database release level = 9.00
Comment =
Directory entry type = Indirect
Catalog node number = 0
....
[db2inst1@verona SQL00001]$ db2level
DB21085I Instance "db2inst1" uses DB2 code release "SQL07020" with level
identifier "03010105" and informational tokens "DB2 v7.1.0.40", "s010415" and
"U475381".
-------------------------------------------------
@lngr3:/user: db2inst1.
bash-2.05$ db2 list tablespace containers for 0
SQL1092N "DB2INST1" does not have the authority to perform the requested
command.
bash-2.05$ id
uid=40001(db2inst1) gid=40002(db2iadm1) groups=40002(db2iadm1),40001(db2asgrp)
bash-2.05$ db2level
DB21085I Instance "db2inst1" uses DB2 code release "SQL07026" with level
identifier "03070105" and informational tokens "DB2 v7.1.0.72", "s021110" and
"U484617".
-------------------------------------------------
root 1306 0.0 0.5 44960 2140 ? S Jul11 0:00 db2wdog
db2as 1307 0.0 0.6 44968 2344 ? S Jul11 0:27 db2sysc
root 1308 0.0 0.5 44960 2152 ? S Jul11 0:00 db2gds
db2as 1309 0.0 0.5 44968 2232 ? S Jul11 0:00 db2ipccm
db2as 1310 0.0 0.6 44964 2388 ? S Jul11 0:00 Scheduler
db2as 1311 0.0 0.5 44968 2264 ? S Jul11 0:00 db2tcpcm
db2as 1312 0.0 0.5 44968 2284 ? S Jul11 0:00 db2tcpdm
root 1389 0.0 0.3 35748 1380 ? S Jul11 0:00 db2wdog
db2inst1 1390 0.0 0.7 45196 2692 ? S Jul11 0:26 db2sysc
root 1391 0.0 0.3 35748 1404 ? S Jul11 0:00 db2gds
db2inst1 1392 0.0 0.4 35752 1732 ? S Jul11 0:02 db2ipccm
db2inst1 1393 0.0 0.6 45196 2604 ? S Jul11 0:00 db2tcpcm
db2inst1 1394 0.0 0.3 35748 1528 ? S Jul11 0:01 db2resyn
db2inst1 1395 0.0 0.3 35748 1428 ? S Jul11 0:00 db2srvlst
db2inst1 22178 0.4 3.3 82808 12908 ? S Aug21 61:38 db2agent (CREDAPP)
db2inst1 22185 0.8 3.9 84076 15176 ? S Aug21 127:25 db2agent (CREDAPP)
db2inst1 25720 0.7 3.9 82796 15260 ? S Aug22 91:55 db2agent (CREDAPP)
db2inst1 28304 1.1 2.5 81256 9620 ? S Aug23 131:25 db2agent (CREDAPP)
db2inst1 2584 0.0 0.8 78504 3152 ? S Aug27 0:07 db2loggr
db2inst1 2585 0.0 0.4 69908 1712 ? S Aug27 0:04 db2dlock
db2inst1 2586 0.5 1.7 69908 6716 ? S Aug27 35:35 db2pfchr
db2inst1 2587 0.1 1.7 69908 6700 ? S Aug27 9:22 db2pfchr
db2inst1 2588 0.0 1.7 69908 6688 ? S Aug27 1:53 db2pfchr
db2inst1 2589 0.0 1.5 69940 6136 ? S Aug27 0:24 db2pclnr
db2inst1 14306 1.3 2.2 46512 8832 ? S Aug29 45:27 db2agent (idle)
root 17945 0.0 0.9 12420 3776 pts/0 S 16:24 0:00 /home/db2inst1/sqllib/bin/db2bp 17850 5
db2inst1 18025 0.0 1.6 79452 6244 ? S 16:24 0:00 db2agent (CREDAPP)
root 18226 0.0 0.2 2336 1004 pts/0 S 16:27 0:00 su db2inst1
db2inst1 18227 0.0 0.3 2532 1360 pts/0 S 16:27 0:00 bash
db2inst1 18302 0.0 0.9 12420 3584 pts/0 S 16:27 0:00 /home/db2inst1/sqllib/bin/db2bp 18227 5
db2inst1 18304 3.4 3.0 80996 11728 ? R 16:29 0:10 db2agent (CREDAPP)
db2inst1 18314 0.0 0.1 2620 704 pts/0 R 16:35 0:00 ps auxww
db2inst1 18315 0.0 0.1 1764 636 pts/0 S 16:35 0:00 grep db2