THE Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
  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


== Error When starting TSM Server on secondary Node ==

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

== Ports in Services ==

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

== List installed Packages ==
      
   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"

== List DB Instances ==

   tsmbcit1:/tsmt2/server# /opt/tivoli/tsm/db2/instance/db2ilist
   tsmt2
   
== List DB Directory ==
   
   tsmbcit1:/tsmt2/server# db2 list db directory
   SQL1031N  The database directory cannot be found on the indicated file system.
   SQLSTATE=58031

   == Check if this is the correct directory ==   
    
   $ 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
   
== Catalog TSM DB2  ==

   tsmbcit1:/tsmt2/server# db2 catalog db TSMDB1
   SQL6028N  Catalog database failed because database "TSMDB1" was not found in
   the local database directory.
  

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