Differences

This shows you the differences between two versions of the page.

--- software:db2:quick_tips [2013/01/15 12:37] – seela
+++ software:db2:quick_tips [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Quick Tips ======
-====How to find the version number of Db2====
-<code>
-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".
-</code>
-====db2ls====
-<code>
-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
-</code>
-====db2val====
-<code>
-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
-</code>
-====DB2 Tools====
-  * db2icrt
-  * db2iupdt