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)