User Tools

Site Tools


software:db2:quick_tips

This is an old revision of the document!


Table of Contents

Quick Tips

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.1357658279.txt.gz · Last modified: 2013/01/15 12:37 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki