Results 1 to 11 of 11
  1. #1
    Join Date
    Oct 2003
    Posts
    93

    Unanswered: what db2 product is installed ?

    An AIX machine can have UDB ESE, Run time client, Admin Client, ADMCL or App client installed.
    db2level only provides the version and fix pack.

    How can one find out what product is installed ?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Try db2licm -v

    It may not help you with the client software, since there is no license required.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Oct 2003
    Posts
    93
    Marcus,
    db2licm -v will only tell the version.
    -l gives me the Product Name only if UDB ESE or EEE is installed.

    it doesnt work for Client software...

    What can be done if only Admin Client is installed for ex ??

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Run db2level and post the entire exact output here.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Oct 2003
    Posts
    93

    Question

    DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08016"
    with level identifier "02070106".
    Informational tokens are "DB2 v8.1.1.58", "s040914", "U800265", and FixPak "6".
    Product is installed at "/usr/opt/db2_08_01"

    I fail to understand where u are going with this ???

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You are right, I can't tell you what client is installed from db2level. But I can tell that you have fixpak 6a installed.

    You could look for db2cc program in the sqllib/bin path, which is only installed with the Admin and App Dev clients. Only the App Dev client has a program called db2dc (Development Center).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Mar 2004
    Posts
    448
    if you go to <instance_home>/sqllib/cfg . you will find *.lvl files.
    It will show you what product you have installed.
    Also the packages that have been installed will help you find the
    product that has been installed.I have an old document(don't know
    where I put it), it shows what package a specific product will install.

    regards

    Mujeeb

  8. #8
    Join Date
    Jan 2004
    Posts
    49

    product is installed - db2 udb

    Quote Originally Posted by mgupta
    An AIX machine can have UDB ESE, Run time client, Admin Client, ADMCL or App client installed.
    db2level only provides the version and fix pack.

    How can one find out what product is installed ?

    Hi,

    I know on windows environment, that u can check installation logs.

    Bala

  9. #9
    Join Date
    Oct 2003
    Posts
    93
    thanks everyone for the response.
    bmujeeb's answer does the trick on AIX box.

  10. #10
    Join Date
    Aug 2014
    Posts
    1

    Hi

    Hi

    db2ls will show you what product has been installed and their respective version along with FP

  11. #11
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    The command line that I find useful with scripting, when multiple products and multiple modern db2-versions are installed on the same lpar is:
    (as root)

    Code:
    db2ls -q -p -c

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •