User Tools

Site Tools


software:db2:quick_tips

This is an old revision of the document!


Quick Tips

How to find the version number of Db2

ON any client host 
     You will have to source the client's profile

     source ~<clientUserID>/sqllib/db2cshrc
     eg: source ~db2leduc/sqllib/db2cshrc

     Issue the following Command

      % db2level
     

     DB21085I  This instance or install (instance name, where applicable: "db2cli") 
     uses "64" bits and DB2 code release "SQL10012" with level identifier 
     "0203010E".
     Informational tokens are "DB2 v10.1.0.2", "s121127", "IP23394", and Fix Pack 
     "2".
     Product is installed at "/cse/local/pkg/db2/V10.1".


    Using client db2c64

    DB21085I  Instance "db2c64" uses "64" bits and DB2 code release "SQL09017" with 
      level identifier "02080107".
     Informational tokens are "DB2 v9.1.0.7", "s090308", "MI00273", and Fix Pack  
     " 7".
     Product is installed at "/cse/local/pkg/db2/V9.1".

db2ls

To list the path where DB2 database products are installed on your system and 
list the DB2 database product level, enter:

   db2ls
   This lists the installation path , level, fixpak, special install number , 
   installation    date , installer UID
   
db2ls -q -p -b baseInstallDirectory
    where q is querying a product or feature 
          p specifies that the listing displays products      
          b specifies the installation directory of the product 

db2val

The db2val tool verifies the core function of a DB2 copy by validating installation files,
instances, database creation, connections to that database, and the state of partitioned 
database environments. This validation can be helpful if you have manually deployed a DB2
 copy on Linux and UNIX operating systems using tar.gz files. The db2val command can 
quickly ensure that all the configuration has been correctly done and ensure that the DB2
 copy is what you expect it to be. You can specify instances and databases or you can run
 db2val against all of the instances. The db2val command can be found in the DB2-install-
path\bin and sqllib/bin directory

DB2 Tools

  • db2icrt
  • db2iupdt
software/db2/quick_tips.1358271432.txt.gz · Last modified: 2013/01/15 12:37 by seela

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki