How do I see if the DB2 product has root installed and what DB2 is installed?

Source: Internet
Author: User
Tags db2

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.