Perform the folowing commands below to check the DB2 products and features installed on your system:

Examples:

To query what DB2 database features are installed to a particular path, issue:

db2ls -q -b /opt/ibm/db2/V9.5

Output:

Install Path : /opt/ibm/db2/V9.5

Feature Response File ID                                        Level   Fix Pack   Feature Description
---------------------------------------------------------------------------------------------------------------------
BASE_CLIENT                                                         9.5.0.3          3   Base client support
JAVA_SUPPORT                                                     9.5.0.3          3   Java support
SQL_PROCEDURES                                              9.5.0.3          3   SQL procedures
BASE_DB2_ENGINE                                              9.5.0.3          3   Base server support
JDK                                                                             9.5.0.3          3   IBM Software Development Kit (SDK) for Java(TM)
CONNECT_SUPPORT                                           9.5.0.3          3   Connect support
COMMUNICATION_SUPPORT_TCPIP              9.5.0.3          3   Communication support - TCP/IP
REPL_CLIENT                                                         9.5.0.3          3   Replication tools
CONTROL_CENTER                                              9.5.0.3          3   Control Center
DB2_DATA_SOURCE_SUPPORT                       9.5.0.3          3   DB2 data source support
LDAP_EXPLOITATION                                           9.5.0.3          3   DB2 LDAP support
INSTANCE_SETUP_SUPPORT                           9.5.0.3          3   DB2 Instance Setup wizard
SPATIAL_EXTENDER_CLIENT_SUPPORT      9.5.0.3          3   Spatial Extender client
XML_EXTENDER                                                    9.5.0.3          3   XML Extender
APPLICATION_DEVELOPMENT_TOOLS          9.5.0.3          3   Base application development tools
FIRST_STEPS                                                          9.5.0.3          3   First Steps
DB2_SAMPLE_DATABASE                                   9.5.0.3          3   Sample database source
TEXT_SEARCH                                                        9.5.0.3          3   DB2 Text Search
INFORMIX_DATA_SOURCE_SUPPORT            9.5.0.3          3   Informix data source support

To check whether a specific DB2 database feature is installed or not, issue:

db2ls -q -b /opt/ibm/db2/V9.5 -f <feature>