This is an old revision of the document!
tsmbcit1:/tsmt2/server# . /home/tsmt2/.profile tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# env | grep DB2 DB2LIB=/home/tsmt2/sqllib/lib DB2_HOME=/home/tsmt2/sqllib DB2INSTANCE=tsmt2 tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# ./dsmserv_tsmt2 ANR7800I DSMSERV generated at 17:04:15 on Jun 8 2016.
IBM Tivoli Storage Manager for HP-UX Version 7, Release 1, Level 6.000
Licensed Materials - Property of IBM
(C) Copyright IBM Corporation 1990, 2016. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation.
ANR7801I Subsystem (master) process ID is 24407. ANR0900I Processing options file /tsmt2/server/dsmserv.opt. ANR7814I Using instance directory /tsmt2/server. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0152I Database manager successfully started. ANR0172I rdbdb.c(2566): Error encountered performing action ActivateDatabase. ANR0162W Supplemental database diagnostic information: -1031:SQLSTATE 58031: The connection was unsuccessful, because of a system error. :-1031 (SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 ). ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode. ANR0169E An unexpected error has occurred and the TSM server is stopping. ANR0162W Supplemental database diagnostic information: -1:58031:-1031 ([IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 ).
Transaction hash table contents (slots=256):
- no transactions found *
Lock hash table contents (slots=3002): Note: Enabling trace class TMTIMER will provide additional timing info on the following locks
- no locks found *
halt tsmbcit1:/tsmt2/server# cat /etc/services # @(#)B.11.31_LRservices $Revision: 1.32.214.7 $ $Date: 97/09/10 14:50:42 $ # # This file associates official service names and aliases with # the port number and protocol the services use. # # Some of the services represented below are not supported on HP-UX. # They are provided solely as a reference. # # The form for each entry is: # <official service name> <port number/protocol name> <aliases> # # See the services(4) manual page for more information. # Note: The entries cannot be preceded by a blank space. # tcpmux 1/tcp # TCP port multiplexer (RFC 1078) echo 7/tcp # Echo echo 7/udp # discard 9/tcp sink null # Discard discard 9/udp sink null # systat 11/tcp users # Active Users daytime 13/tcp # Daytime daytime 13/udp # qotd 17/tcp quote # Quote of the Day chargen 19/tcp ttytst source # Character Generator chargen 19/udp ttytst source # ftp-data 20/tcp # File Transfer Protocol (Data) ftp 21/tcp # File Transfer Protocol (Control) telnet 23/tcp # Virtual Terminal Protocol smtp 25/tcp # Simple Mail Transfer Protocol time 37/tcp timeserver # Time time 37/udp timeserver # rlp 39/udp resource # Resource Location Protocol whois 43/tcp nicname # Who Is domain 53/tcp nameserver # Domain Name Service domain 53/udp nameserver # bootps 67/udp # Bootstrap Protocol Server bootpc 68/udp # Bootstrap Protocol Client tftp 69/udp # Trivial File Transfer Protocol rje 77/tcp netrjs # private RJE Service finger 79/tcp # Finger http 80/tcp www # World Wide Web HTTP http 80/udp www # World Wide Web HTTP link 87/tcp ttylink # private terminal link supdup 95/tcp # hostnames 101/tcp hostname # NIC Host Name Server tsap 102/tcp iso_tsap iso-tsap # ISO TSAP (part of ISODE) pop 109/tcp postoffice pop2 # Post Office Protocol - Version 2 pop3 110/tcp pop-3 # Post Office Protocol - Version 3 portmap 111/tcp sunrpc # SUN Remote Procedure Call portmap 111/udp sunrpc # auth 113/tcp authentication ident # Authentication Service sftp 115/tcp # Simple File Transfer Protocol uucp-path 117/tcp # UUCP Path Service nntp 119/tcp readnews untp # Network News Transfer Protocol ntp 123/udp # Network Time Protocol netbios_ns 137/tcp # NetBIOS Name Service netbios_ns 137/udp # netbios_dgm 138/tcp # NetBIOS Datagram Service netbios_dgm 138/udp # netbios_ssn 139/tcp # NetBIOS Session Service netbios_ssn 139/udp # bftp 152/tcp # Background File Transfer Protocol snmp 161/udp snmpd # Simple Network Management Protocol Agent snmp-trap 162/udp trapd # Simple Network Management Protocol Traps xdmcp 177/tcp # X Display Manager Control Protocol xdmcp 177/udp # X Display Manager Control Protocol bgp 179/tcp # Border Gateway Protocol # PV performance tool services entries pvserver 382/tcp # PV server ovbbccb 383/tcp # OV Communication Broker svrloc 427/tcp # Server Location svrloc 427/udp # Server Location # Ports for IPSec isakmp 500/tcp isakmp # IPSec Key Management (ISAKMP) isakmp 500/udp isakmp # IPSec Key Management (ISAKMP) # # UNIX services # biff 512/udp comsat # mail notification exec 512/tcp # remote execution, passwd required login 513/tcp # remote login who 513/udp whod # remote who and uptime shell 514/tcp cmd # remote command, no passwd used syslog 514/udp # remote system logging printer 515/tcp spooler # remote print spooling talk 517/udp # conversation ntalk 518/udp # new talk, conversation route 520/udp router routed # routing information protocol efs 520/tcp # Extended file name server timed 525/udp timeserver # remote clock synchronization tempo 526/tcp newdate # courier 530/tcp rpc # conference 531/tcp chat # netnews 532/tcp readnews # netwall 533/udp # Emergency broadcasting uucp 540/tcp uucpd # uucp daemon dhcpv6-client 546/tcp # DHCPv6 Client dhcpv6-client 546/udp # DHCPv6 Client dhcpv6-server 547/tcp # DHCPv6 Server dhcpv6-server 547/udp # DHCPv6 Server remotefs 556/tcp rfs_server rfs # Brunhoff remote filesystem ingreslock 1524/tcp # # # Other HP-UX services # lansrm 570/udp # SRM/UX Server DAServer 987/tcp # SQL distributed access instl_boots 1067/udp # installation bootstrap protocol server instl_bootc 1068/udp # installation bootstrap protocol client nfsd-keepalive 1110/udp # Client status info nfsd-status 1110/tcp # Cluster status info msql 1111/tcp # Mini SQL database server hacl-qs 1238/tcp # HA cluster Quorum Server hacl-qs 1238/udp # HA cluster Quorum Server rlb 1260/tcp # remote loopback diagnostic clvm-cfg 1476/tcp # HA LVM configuration diagmond 1508/tcp # Diagnostic System Manager nft 1536/tcp # NS network file transfer sna-cs 1553/tcp # SNAplus client/server sna-cs 1553/udp # SNAplus client/server ncpm-pm 1591/udp # NCPM Policy Manager ncpm-hip 1683/udp # NCPM Host Information Provider cvmon 1686/udp # Clusterview cvmon-cvmap communication registrar 1712/tcp # resource monitoring service registrar 1712/udp # resource monitoring service ncpm-ft 1744/udp # NCPM File Transfer psmond 1788/tcp # Predictive Monitor psmond 1788/udp # Hardware Predictive Monitor pmlockd 1889/tcp # SynerVision locking daemon pmlockd 1889/udp # nfsd 2049/udp nfs # NFS server daemon (clts) nfsd 2049/tcp nfs # NFS server daemon (cots) lockd 4045/udp # NFS lockd daemon/manager for udp lockd 4045/tcp # NFS lockd daemon/manager for tcp netdist 2106/tcp # update(1m) network distribution service cvmmon 2300/tcp # ClusterView Management cluster support hpidsadmin 2984/tcp # HP-UX Host Intrusion Detection System admin hpidsadmin 2984/udp # HP-UX Host Intrusion Detection System admin hpidsagent 2985/tcp # HP-UX Host Intrusion Detection System agent hpidsagent 2985/udp # HP-UX Host Intrusion Detection System agent hp-clic 3384/tcp #Cluster Management Services hp-clic 3384/udp #Hardware Management hacl-monitor 3542/tcp # HA cluster monitor hacl-monitor 3542/udp # HA cluster monitor rfa 4672/tcp # NS remote file access veesm 4789/tcp # HP VEE service manager hacl-hb 5300/tcp # High Availability (HA) Cluster heartbeat hacl-hb 5300/udp # High Availability (HA) Cluster heartbeat hacl-gs 5301/tcp # HA Cluster General Services hacl-gs 5301/udp # HA Cluster General Services hacl-cfg 5302/tcp # HA Cluster TCP configuration hacl-cfg 5302/udp # HA Cluster UDP configuration hacl-probe 5303/tcp # HA Cluster TCP probe hacl-probe 5303/udp # HA Cluster UDP probe hacl-local 5304/tcp # HA Cluster Commands hacl-local 5304/udp # HA Cluster Commands hacl-test 5305/tcp # HA Cluster Test hacl-dlm 5408/tcp # HA Cluster distributed lock manager omni 5555/tcp # HP OpenView OmniBack lanmgrx.osB 5696/tcp # LAN Manager/X for B.00.00 OfficeShare hcserver 5710/tcp # HP Cooperative Services wbem-http 5988/tcp # Web-Based Enterprise Management HTTP wbem-http 5988/udp # Web-Based Enterprise Management HTTP wbem-https 5989/tcp # Web-Based Enterprise Management HTTPS wbem-https 5989/udp # Web-Based Enterprise Management HTTPS grmd 5999/tcp # graphics resource manager spc 6111/tcp # sub-process control desmevt 6868/tcp # DE/ Services Monitor, Event Service pdclientd 6874/tcp # Palladium print client daemon pdeventd 6875/tcp # Palladium print event daemon iasqlsvr 7489/tcp # Information Access recserv 7815/tcp # SharedX Receiver Service p7_c33upd 8545/tcp #TSD acceSS7 configuration update RPC server p7_c33 8546/tcp #TSD acceSS7 configuration RPC server p7_c32 8547/tcp #TSD acceSS7 communications status RPC server p7_c35 8548/tcp #TSD acceSS7 communications configuration RPC server p7_g06 8549/tcp #TSD acceSS7 application version registration RPC server p7_e30 8550/tcp #TSD acceSS7 event manager RPC server comms_normal 8551/tcp # acceSS7 normal priority messages comms_high 8552/tcp # acceSS7 high priority messages c34_main 8553/udp # acceSS7 Inter-Server messages ftp-ftam 8868/tcp # FTP→FTAM Gateway mcsemon 9999/tcp # MC/System Environment monitor console 10000/tcp # MC/System Environment console multiplexor actcp 31766/tcp # ACT Call Processing Server SrpSiteDaemon 6178/tcp # acceSS7 Statistics Remote Site query daemon SrpCentralDaemon 6179/tcp # acceSS7 Statistics Central Server query daemon erdb_svr 35100/tcp # acceSS7 Statistics Central Database erdb_bck 35101/tcp # acceSS7 Statistics Database Backup hp-sco 19410/tcp # HP SCO port number hp-sco 19410/udp # HP SCO port number hp-sca 19411/tcp # HP SCA port number hp-sca 19411/udp # HP SCA port number
# # Kerberos (Project Athena/MIT) services # kerberos5 88/udp kdc # Kerberos 5 kdc klogin 543/tcp # Kerberos rlogin -kfall kshell 544/tcp krcmd # Kerberos remote shell -kfall ekshell 545/tcp krcmd # Kerberos encrypted remote shell -kfall kerberos 750/udp kdc # Kerberos (server) udp -kfall kerberos 750/tcp kdc # Kerberos (server) tcp -kfall kerberos_master 751/tcp kadmin # Kerberos kadmin krbupdate 760/tcp kreg # Kerberos registration -kfall kpasswd 761/tcp kpwd # Kerberos “passwd” -kfall eklogin 2105/tcp # Kerberos encrypted rlogin -kfall # The X10_LI server for each display listens on ports 5800 + display number. # The X10_MI server for each display listens on ports 5900 + display number. # The X11 server for each display listens on ports 6000 + display number. # The X11 font server listens on port 7000. # Do NOT associate other services with these ports. # Refer to the X documentation for details.
hpoms-ci-lstn 5403/tcp #SAP spooler support hpoms-dps-lstn 5404/tcp #SAP spooler support samd 3275/tcp # sam daemon
dtspc 6112/tcp #subprocess control nuekks 6897/tcp # nuekks daemon
swat 901/tcp # SAMBA Web-based Admin Tool io-dist-data 5728/tcp #Dist. I/O Comm. Service Data and Control io-dist-group 5728/udp #Dist. I/O Comm. Service Group Membership DB2_tsmt2 60000/tcp DB2_tsmt2_1 60001/tcp DB2_tsmt2_2 60002/tcp DB2_tsmt2_3 60003/tcp DB2_tsmt2_4 60004/tcp DB2_tsmt2_END 60005/tcp tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# /opt/IBM/InstallationManager/eclipse/tools/imcl listInstalledPackages com.ibm.cic.agent_1.8.5000.20160506_1125 com.tivoli.dsm.license_7.1.6.20160608_1741 com.tivoli.dsm.server_7.1.6.20160608_1749 tsmbcit1:/tsmt2/server# /opt/tivoli/tsm/db2/adm/db2licm -l Product name: “DB2 Enterprise Server Edition” License type: “Restricted” Expiry date: “Permanent” Product identifier: “db2ese” Version information: “10.5” Features: IBM DB2 BLU Acceleration In-Memory Offering: “Not licensed” IBM DB2 Performance Management Offering: “Not licensed” IBM DB2 Encryption Offering: “Not licensed” IBM DB2 Business Application Continuity Offering: “Not licensed”
tsmbcit1:/tsmt2/server# /opt/tivoli/tsm/db2/instance/db2ilist tsmt2 tsmbcit1:/tsmt2/server# db2 list db directory SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 tsmbcit1:/tsmt2/server# env _=/usr/bin/env MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/VRTS/vxfs5.0/man:/opt/ipf/man:/opt/ldapux/share/man/%L:/opt/ldapux/share/man:/opt/ldapux/ypldapd/man:/opt/cifsclient/share/man:/opt/openssl/man:/opt/openssl/prngd/man:/opt/wbem/share/man/%L:/opt/wbem/share/man:/opt/graphics/common/man:/opt/hpvm/share/man/%L:/opt/amgr/man/%L:/opt/amgr/man:/opt/sec_mgmt/share/man:/opt/samba/man:/opt/samba/WTEC_Support_Tools/man:/opt/caliper/man/%L:/opt/caliper/man:/opt/drd/share/man/%L:/opt/drd/share/man:/opt/dsau/man:/opt/resmon/share/man/%L:/opt/resmon/share/man:/opt/perf/man/%L:/opt/perf/man:/usr/contrib/kwdb/share/man:/opt/perl_32/man:/opt/perl_64/man:/opt/prm/man/%L:/opt/prm/man:/opt/propplus/share/man:/opt/psb/healthtest/share/man:/opt/sfm/share/man:/opt/swm/share/man/%L:/opt/swm/share/man:/opt/swa/share/man/%L:/opt/swa/share/man:/opt/ssh/share/man:/opt/sentinel/man/%L:/opt/sentinel/man:/opt/langtools/share/man/%L:/opt/langtools/share/man:/opt/openssl/fips/0.9.7/man:/opt/openssl/fips/0.9.8/man:/opt/gwlm/man/%L:/opt/gwlm/man:/opt/icod/man/%L:/opt/icod/man:/opt/ignite/share/man/%L:/opt/ignite/share/man:/opt/iexpress/lsof/man:/opt/iexpress/tcpdump/man:/opt/iexpress/sudo/man DB2LIB=/home/tsmt2/sqllib/lib SSH_TTY=/dev/pts/0 PATH=/usr/sbin:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/contrib/Q4/bin:/opt/perl/bin:/opt/gvsd/bin:/opt/ipf/bin:/opt/nettladm/bin:/opt/fcms/bin:/opt/wbem/bin:/opt/wbem/sbin:/opt/sas/bin:/opt/graphics/common/bin:/opt/hpvm/bin:/opt/atok/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/sec_mgmt/bastille/bin:/opt/caliper/bin:/opt/drd/bin:/opt/dsau/bin:/opt/dsau/sbin:/opt/resmon/bin:/opt/firefox:/opt/perf/bin:/usr/contrib/kwdb/bin:/opt/perl_32/bin:/opt/perl_64/bin:/opt/prm/bin:/opt/propplus/bin:/opt/sfm/bin:/etc/cmcluster/scripts/tkit/vtn:/opt/swm/bin:/opt/sec_mgmt/spc/bin:/opt/ssh/bin:/opt/swa/bin:/opt/hpsmh/bin:/opt/thunderbird:/opt/sentinel/bin:/opt/langtools/bin:/opt/gwlm/bin:/opt/ignite/bin:/sbin:/home/root:.:.:/home/tsmt2/sqllib/bin:/home/tsmt2/sqllib/adm:/home/tsmt2/sqllib/misc IBM_DB_HOME=/home/tsmt2/sqllib COLUMNS=195 EDITOR=vi HISTFILE=/root/.sh_history CLASSPATH=/home/tsmt2/sqllib/java/db2java.zip:/home/tsmt2/sqllib/function:/home/tsmt2/sqllib/java/db2jcc_license_cu.jar:/home/tsmt2/sqllib/tools/clpplus.jar:/home/tsmt2/sqllib/tools/jline-0.9.93.jar:/home/tsmt2/sqllib/java/db2jcc.jar:. LOGNAME=root MAIL=/var/mail/root DSMI_CONFIG=/tsmt2/server/tsmt2/tsmdbmgr.opt SFTP_UMASK= ERASE=^H IBM_DB_INCLUDE=/home/tsmt2/sqllib/include PS1=tsmbcit1:$PWD\# SFTP_PERMIT_CHOWN=1 USER=root DB2_HOME=/home/tsmt2/sqllib SHELL=/sbin/sh HISTSIZE=10000 DSMI_LOG=/tsmt2/server/tsmt2 HOME=/root DB2INSTANCE=tsmt2 SSH_CONNECTION=10.90.194.17 50152 10.7.16.20 22 SSH_CLIENT=10.90.194.17 50152 22 LD_LIBRARY_PATH=/opt/ibm/gsk8_64/lib64:/home/tsmt2/sqllib/lib64:/home/tsmt2/sqllib/lib64/gskit:/home/tsmt2/sqllib/lib32 TERM=xterm IBM_DB_DIR=/home/tsmt2/sqllib PWD=/tsmt2/server TZ=MEZ-1MESZ SFTP_PERMIT_CHMOD=1 IBM_DB_LIB=/home/tsmt2/sqllib/lib LINES=39 DSMI_DIR=/opt/tivoli/tsm/server/bin/dbbkapi tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# db2 catalog db TSMDB1 SQL6028N Catalog database failed because database “TSMDB1” was not found in the local database directory. tsmbcit1:/tsmt2/server# ll total 340 -rw——- 1 tsmt2 tsmsrvrs 1113 Jul 21 17:25 NODELOCK drwx—— 2 tsmt2 tsmsrvrs 1024 Jul 22 08:18 bootstraps -rw——- 1 root sys 904 Jan 15 2015 cert.arm -rw——- 1 root sys 80 Jan 15 2015 cert.crl -rw——- 1 root sys 135080 Jan 15 2015 cert.kdb -rw——- 1 root sys 80 Jan 15 2015 cert.rdb -rw——- 1 root sys 129 Jan 15 2015 cert.sth -rw——- 1 root sys 1257 Jan 15 2015 cert256.arm -rw——- 1 tsmt2 tsmsrvrs 219 May 12 2014 cit.log -rw——- 1 tsmt2 tsmsrvrs 8721 May 12 2014 citScanOutput.xml -rw——- 1 root sys 7796 Jul 22 08:17 dsmffdc.log -rw——- 1 tsmt2 tsmsrvrs 27 Sep 9 2014 dsmserv.dbid -rw——- 1 tsmt2 tsmsrvrs 4075 Jul 19 13:15 dsmserv.err -rw——- 1 tsmt2 tsmsrvrs 622 Jan 15 2015 dsmserv.opt -rw——- 1 root sys 58 Jul 22 08:39 dsmserv.v6lock lrwx—— 1 tsmt2 tsmsrvrs 34 May 12 2014 dsmserv_tsmt2 → /opt/tivoli/tsm/server/bin/dsmserv -rw-rw-rw- 1 root root 65 Jul 22 08:40 dsmshowlock.err -rw-rw-rw- 1 root root 78 Jul 22 08:40 dsmshowtxnt.err -rw——- 1 tsmt2 tsmsrvrs 162 Jul 21 16:17 logattr.chk drwxr-xr-x 2 tsmt2 tsmsrvrs 96 May 7 2014 lost+found -rw-rw-rw- 1 root root 0 Jul 22 08:17 serverstart.err drwxrwxr-x 3 tsmt2 tsmsrvrs 1024 Jan 16 2015 tsmt2 tsmbcit1:/tsmt2/server# bdf Filesystem kbytes used avail %used Mounted on /dev/vg00/lvol3 1048576 267920 774920 26% / /dev/vg00/lvol1 1835008 566736 1258536 31% /stand /dev/vg00/lvol9 5177344 3289032 1878296 64% /var /dev/vg00/lvol8 16777216 10727716 5672776 65% /var/adm/crash /dev/vg00/lvol7 14680064 6223984 8390216 43% /usr /dev/vg00/lvol6 4194304 35656 4126640 1% /tmp /dev/vg00/lvol5 19660800 11992592 7610328 61% /opt /dev/vg00/lvol4 7733248 4904696 2807368 64% /home /dev/vg01/lvol1 1044480 34587 946894 4% /tsmt2/server /dev/vg01/lvol2 10481664 1462395 8455675 15% /tsmt2/tsmdb1 /dev/vg01/lvol3 10481664 4501643 5606397 45% /tsmt2/archlog /dev/vg01/lvol4 10481664 7900853 2419513 77% /tsmt2/log /dev/vg01/lvol5 10481664 10260070 207752 98% /tsmt2/disk tsmbcit1:/tsmt2/server# whoami root tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# tsmbcit1:/tsmt2/server# su - tsmt2 ©Copyright 1983-2006 Hewlett-Packard Development Company, L.P. ©Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California ©Copyright 1980, 1984, 1986 Novell, Inc. ©Copyright 1986-2000 Sun Microsystems, Inc. ©Copyright 1985, 1986, 1988 Massachusetts Institute of Technology ©Copyright 1989-1993 The Open Software Foundation, Inc. ©Copyright 1990 Motorola, Inc. ©Copyright 1990, 1991, 1992 Cornell University ©Copyright 1989-1991 The University of Maryland ©Copyright 1988 Carnegie Mellon University ©Copyright 1991-2006 Mentat Inc. ©Copyright 1996 Morning Star Technologies, Inc. ©Copyright 1996 Progressive Systems, Inc.
Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license.
$ $ $ db2stop 07/22/2016 08:46:44 0 0 SQL1064N DB2STOP processing was successful. SQL1064N DB2STOP processing was successful. $ $ $ db2start 07/22/2016 08:46:55 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. $ $ $ db2ilist tsmt2 $ db2 catalog db TSMDB1 SQL6028N Catalog database failed because database “TSMDB1” was not found in the local database directory. $ $ $ $ cat /home/tsmt2 $ $ cd /home/tsmt2 $ ll total 352 -rw——- 1 tsmt2 tsmsrvrs 168475 Nov 6 2014 db2reorgcheck.out drwxrwsr-t 24 tsmt2 tsmsrvrs 8192 Jul 22 08:45 sqllib $ cd sqllib $ ll total 368 lrwxr-xr-x 1 root tsmsrvrs 26 Jul 22 08:30 Readme → /opt/tivoli/tsm/db2/Readme drwxr-xr-x 2 tsmt2 tsmsrvrs 8192 Jul 22 08:30 adm lrwxr-xr-x 1 root tsmsrvrs 24 Jul 22 08:30 adsm → /opt/tivoli/tsm/db2/adsm drwxr-x— 2 tsmt2 tsmsrvrs 96 Jul 22 08:30 backup lrwxr-xr-x 1 root tsmsrvrs 23 Jul 22 08:30 bin → /opt/tivoli/tsm/db2/bin lrwxr-xr-x 1 root tsmsrvrs 23 Jul 22 08:30 bnd → /opt/tivoli/tsm/db2/bnd drwxrwsr-t 2 tsmt2 tsmsrvrs 8192 Jul 22 08:40 cfg drwxrwsr-t 2 tsmt2 tsmsrvrs 96 Jul 22 08:30 cfgcache lrwxr-xr-x 1 root tsmsrvrs 24 Jul 22 08:30 conv → /opt/tivoli/tsm/db2/conv drwxrwsr-t 2 tsmt2 tsmsrvrs 8192 Jul 22 08:46 ctrl drwxrwsr-t 2 tsmt2 tsmsrvrs 96 Jul 22 08:39 ctrlha drwxrwxr-x 2 tsmt2 tsmsrvrs 96 Jul 22 08:39 ctrlhamirror drwxrwsr-t 2 tsmt2 tsmsrvrs 8192 Jul 22 08:30 dasfcn -rwxr-xr-x 1 tsmt2 tsmsrvrs 13438 Jul 22 08:30 db2cshrc drwxrwsrwt 4 tsmt2 tsmsrvrs 8192 Jul 22 08:46 db2dump -r–r–r– 1 tsmt2 tsmsrvrs 13 Jul 22 08:30 db2nodes.cfg -rwxr-xr-x 1 tsmt2 tsmsrvrs 9128 Jul 22 08:30 db2profile -rw-rw-r– 1 tsmt2 tsmsrvrs 28672 Jul 22 08:46 db2systm lrwxr-xr-x 1 root tsmsrvrs 23 Jul 22 08:30 doc → /opt/tivoli/tsm/db2/doc -rw-r–r– 1 tsmt2 tsmsrvrs 268 Jul 22 08:31 fm.tsmbcit1.reg drwxrwsr-t 5 tsmt2 tsmsrvrs 8192 Jul 22 08:30 function lrwxr-xr-x 1 root tsmsrvrs 25 Jul 22 08:30 gskit → /opt/tivoli/tsm/db2/gskit drwx—— 3 tsmt2 tsmsrvrs 96 Jul 22 08:40 hmonCache lrwxr-xr-x 1 root tsmsrvrs 27 Jul 22 08:30 include → /opt/tivoli/tsm/db2/include lrwxr-xr-x 1 root tsmsrvrs 27 Jul 22 08:30 infopop → /opt/tivoli/tsm/db2/infopop lrwxr-xr-x 1 root tsmsrvrs 24 Jul 22 08:30 java → /opt/tivoli/tsm/db2/java lrwxr-xr-x 1 root tsmsrvrs 24 Jul 22 08:30 json → /opt/tivoli/tsm/db2/json lrwxr-xr-x 1 root tsmsrvrs 5 Jul 22 08:30 lib → lib64 lrwxr-xr-x 1 root tsmsrvrs 25 Jul 22 08:30 lib32 → /opt/tivoli/tsm/db2/lib32 lrwxr-xr-x 1 root tsmsrvrs 25 Jul 22 08:30 lib64 → /opt/tivoli/tsm/db2/lib64 drwxrwsr-t 2 tsmt2 tsmsrvrs 96 Jul 22 08:30 log lrwxr-xr-x 1 root tsmsrvrs 23 Jul 22 08:30 map → /opt/tivoli/tsm/db2/map lrwxr-xr-x 1 root tsmsrvrs 24 Jul 22 08:30 misc → /opt/tivoli/tsm/db2/misc lrwxr-xr-x 1 root tsmsrvrs 23 Jul 22 08:30 msg → /opt/tivoli/tsm/db2/msg drwxrwxr-x 2 tsmt2 tsmsrvrs 96 Jul 22 08:39 nodes -rw-rw-r– 1 tsmt2 tsmsrvrs 8 Jul 22 08:39 nodes.reg lrwxr-xr-x 1 root tsmsrvrs 22 Jul 22 08:30 pd → /opt/tivoli/tsm/db2/pd -rw-rw-r– 1 tsmt2 tsmsrvrs 339 Jul 22 08:39 profile.env lrwxr-xr-x 1 root tsmsrvrs 23 Jul 22 08:30 rdf → /opt/tivoli/tsm/db2/rdf lrwxr-xr-x 1 root tsmsrvrs 27 Jul 22 08:30 samples → /opt/tivoli/tsm/db2/samples drwxr-xr-x 3 tsmt2 tsmsrvrs 8192 Jul 22 08:30 security drwxr-xr-x 3 tsmt2 tsmsrvrs 96 Jul 22 08:30 security32 drwxr-xr-x 3 tsmt2 tsmsrvrs 96 Jul 22 08:30 security64 drwxr-x— 3 tsmt2 tsmsrvrs 96 Jul 22 08:39 spmlog drwxrwxr-x 2 root tsmsrvrs 96 Jul 22 08:45 sqldbdir drwxrwxr-x 2 root tsmsrvrs 96 Jul 22 08:40 sqlnodir drwxrwsrwx 2 tsmt2 tsmsrvrs 8192 Jul 22 08:46 tmp lrwxr-xr-x 1 root tsmsrvrs 25 Jul 22 08:30 tools → /opt/tivoli/tsm/db2/tools -rw——- 1 tsmt2 tsmsrvrs 32 Jul 22 08:39 tsmdbdata.TSMDB1 drwxrwxrwx 2 tsmt2 tsmsrvrs 96 Jul 22 08:39 uif -rwxr-xr-x 1 tsmt2 tsmsrvrs 64 Jul 22 08:33 usercshrc -rwxr-xr-x 1 tsmt2 tsmsrvrs 218 Jul 22 08:33 userprofile $ cat db2nodes.cfg 0 tsmbcit1 0 $ $ $ db2 list db directory on /home/ SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 $ db2 list db directory on /home/tsmt2 SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 $ db2 list db directory on /tsmt2/ SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 $ db2 list db directory on /tsmt2/server
Local Database Directory on /tsmt2/server
Number of entries in the directory = 1
Database 1 entry:
Database alias = TSMDB1 Database name = TSMDB1 Database directory = SQL00001 Database release level = 10.00 Comment = TSM SERVER DATABASE Directory entry type = Home Catalog database partition number = 0 Database member number = 0
$ $ $ $ $ db2 catalog db TSMDB1 on /tsmt2/server DB20000I The CATALOG DATABASE command completed successfully. DB21056W Directory changes may not be effective until the directory cache is refreshed.