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".