Today I saw a group of friends asked two questions comparison basis:
1 How to confirm my DB2 is the root What about the installation?
In fact, from DB2 UDB V9.1 have db2ls This command, the problem is much simpler, we just need to simply run down the db2ls, and then see the output of the Installer UID is 0(Root uid), as shown in:
[[email protected] ~]$ db2lsinstall Path level Fix Pack Special install number install Date Installer UID----------------------------------------------------------------------------------------- ----------------------------/opt/ibm/db2/v10.1 10.1.0.2 2 ed Nov 02:27:07 PST0/opt/ibm/db2/v9.1 9.1.0.8 8 Sun Dec 1 23:14:06 PST 0/opt/ibm/db2/v9.5 9.5.0.6 6a Sun Dec 1 23:17:40 PST 0/opt/ibm/db2/v9.7 9.7.0.5 5 Sun Dec 1 23:21:11 PST 0[[email protected] Install]$ ID rootuid =0 (Root)Gid=0 (Root) groups=0 (root), 1 (BIN), 2 (daemon), 3 (SYS), 4 (ADM), 6 (disk), 10(wheel)[[email protected] Install]$
You can see that the four DB2 on my virtual machine are root-mounted.
2 How did you know I was DB2? What products (DB2 ese,connect,client,aese...etc) it?
This problem can also be solved with db2ls , this time we need to use several parameters of Db2ls :
-Q
Signifies that the query was to list installed DB2 products and features. By default, only the visible components (features) were displayed unless the-a parameter is also specified.
-P
Lists products only. This would give a brief list of which products the customer have installed rather than listing the features.
-B Base-install-path
When using the Global db2ls command In/usr/local/bin, your need to specify which directory is querying. The Global db2ls command would simply call the Db2ls from this install path and pass in the rest of the parameters.
DB2 's Db2ls can be listed in the specified installation directory of what is the DB2 product.
Example:
[[email protected] Install] db2ls-q-p-b/opt/ibm/db2/v10.1 Install Path:/opt/ibm/db2/v10. 1product Response File ID level Fix Pack Product Description-------------------------------------------------------------------------------------------------------------- -------enterprise_server_edition 10.1.0.2 2 DB2 ENTERPRISE SERVER EDITION[ [email protected] Install]$
Attached: Db2ls-list installed DB2 products and features command
http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.cmd.doc%2Fdoc% 2fr0023668.html&resultof%3d%2522%2564%2562%2532%256c%2573%2522%2520%2522%2564%2562%2532%256c%2522%2520