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 ---------------------------------------------------------- @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