You can use the db2prereqcheck command to check the software prerequisites of a specific DB2® version, generate a report file, and perform other tasks.
Using the db2prereqcheck command, you can determine whether your system satisfies the DB2 installation prerequisites without having to start the DB2 installation. This command checks prerequisites such as operating system level, the Linux distribution, the AIX® Technology Level, C library and runtime patches, and prerequisites that are related to the client, uDAPL, GPL, and DB2 pureScale®.
The DB2 product comes with the db2prereqcheck binary and the DB2prereqs.xml file. These files are found in the folder where the installation image is located.On AIX operating systems, the DB2prereqs.xml file is in both the db2/aix/install and db2/aix/bin directories. The DB2prereqs.xml file contains the prerequisite from Version 9.8 Fix Pack 2 to Version 10.5. You must not modify the contents of the file. You must run the db2prereqcheck command in the directory where the installation image is located.
If you run the db2prereqcheck command with no parameters, it determines whether the system meets the prerequisites for all the DB2 releases and fix packs that are defined in the resource XML file.
Important: The behavior of the db2prereqcheck command is changed as of DB2 Cancun Release 10.5.0.4. For more information, see db2prereqcheck - Check installation prerequisites topic.
To check the prerequisites for the latest DB2 version that you defined in the resource XML file, issue the db2prereqcheck command with the -i parameter as shown in the following example:
$ ./db2prereqcheck -i
In DB2 Cancun Release 10.5.0.4 and later fix packs, to check the prerequisites for the latest DB2 version that you defined in the resource XML file, issue the db2prereqcheck command with -l parameter, as shown in the following example:
$ ./db2prereqcheck -l
To check whether the system meets the prerequisite for the specific DB2 version that you defined in the resource XML file, issue the db2prereqcheck command with the -v version_number parameter. For example, to check whether the prerequisites are met for DB2 Version 10.5, issue the following command:
$ ./db2prereqcheck -v 10.5.0.0
To check whether the prerequisites are met for DB2 Cancun Release 10.5.0.4, issue the following command:
$ ./db2prereqcheck -v 10.5.0.4
To generate a report file that contains validation information and output from the db2prereqcheck command (including a summary section that lists all failing tests), use the -o <filename> parameter. Specify the full report file name path to generate the report in another directory. The prerequisites for installing the DB2 product are displayed on the command screen without the -o <filename> parameter, as shown in the following example:
$ ./db2prereqcheck -v 10.5.0.0 -o report.rpt
You can use the -f parameter to specify the XML file, as shown in the following example:
$ ./db2prereqcheck -i -f ./newDB2prereqs.xml
If
you do not specify the -f parameter, the default
XML file (DB2 installation/cfg/DB2prereqs.xml)
is used. $ ./db2prereqcheck -p -v 10.5.0.0
$ ./db2prereqcheck -v 10.5.0.0 -p -t <network configuration type>
If the db2prereqcheck command indicates that the system fails to meet the prerequisite, DBT3507E, as shown in the following example,
Validating ofed ...
Required minimum version and release for ofed: 1.5.2-(null)
DBT3507E The db2prereqcheck utility failed to verify installation prerequisites
because the utility failed to find the following package or file: "ofed".
ERROR: Requirement not matched.
check the requirement page under related reference and run it again. For more information, search the DBT message (for example DBT3507E) on V10.5 Information Center.
The following sample output was generated on a AIX operating system. Use the -p parameter for a DB2 pureScale installation.
> db2prereqcheck -p -v 10.5.0.0
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.5.0.0 on operating
system "AIX"
Validating kernel level ...
Required minimum operating system kernel level : "6.1".
Actual operating system kernel level: "6.1".
Requirement matched.
Validating AIX technology level and service pack ...
Required minimum technology level: 6 Service pack: 5
Requirement matched.
Validating XL C/C++ Runtime ...
Required minimum XL C/C++ Runtime level: 11.1.0.1
Actual version: 11.1.0.1
Requirement matched.
Validating uDAPL ...
Required minimum uDAPL level: 6.1.6.1
Actual version: 6.1.6.1
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database server with DB2 pureScale
feature. Version: "10.5.0.0".
The following sample output was generated on a AIX operating system. Use the -u parameter for DB2 pureScale uDAPL only.
> db2prereqcheck -u -v 10.5.0.0
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.5.0.0 on operating
system "AIX"
Validating uDAPL ...
Required minimum uDAPL level: 6.1.6.1
Actual version: 6.1.6.1
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database server . Version: "10.5.0.0".
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.5.0.0 on operating
system "AIX"
Validating uDAPL ...
Required minimum uDAPL level: 6.1.6.1
Actual version: 6.1.6.1
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database server with DB2 pureScale
feature. Version: "10.5.0
The following sample output was generated on a AIX operating system. Use the -c parameter for a client installation.
> db2prereqcheck -c -v 10.5.0.0
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.5.0.0 on operating
system "AIX"
Validating kernel level ...
Required minimum operating system kernel level : "6.1".
Actual operating system kernel level: "6.1".
Requirement matched.
Validating AIX technology level and service pack ...
Required minimum technology level: 6 Service pack: 5
Requirement matched.
Validating XL C/C++ Runtime ...
Required minimum XL C/C++ Runtime level: 11.1.0.1
Actual version: 11.1.0.1
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database client . Version: "10.5.0.0".
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.5.0.0 on operating
system "AIX"
Validating kernel level ...
Required minimum operating system kernel level : "6.1".
Actual operating system kernel level: "6.1".
Requirement matched.
Validating AIX technology level and service pack ...
Required minimum technology level: 6 Service pack: 5
Requirement matched.
Validating XL C/C++ Runtime ...
Required minimum XL C/C++ Runtime level: 11.1.0.1
Actual version: 11.1.0.1
Requirement matched.
Validating uDAPL ...
Required minimum uDAPL level: 6.1.6.1
Actual version: 6.1.6.1
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database client with DB2 pureScale
feature. Version: "10.5.0.0".
The following sample output was generated on a AIX operating system. Use the -s parameter to display a validation summary only.
> db2prereqcheck -s -v 10.5.0.0
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database server . Version: "10.5.0.0".
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database server with DB2 pureScale
feature. Version: "10.5.0.0".
The following sample output was generated on a Linux operating system. Use the -p parameter for aDB2 pureScale installation.
> db2prereqcheck -p -v 10.5.0.0
==========================================================================
Checking DB2 Prerequisites for DB2 Version 10.5.0.0 on Linux
Validating Linux distribution ...
Required minimum SUSE version : (null) SP (null)
Validating sles-release ...
Required minimum version and release for sles-release: 10-15.45.8
Actual version of package: 11.1
Requirement matched.
Validating kernel level ...
Required minimum kernel level : 2.6.16
Actual kernel level: 2.6.32.45
Requirement matched.
Validating C++ Library version ...
Required minimum C++ library: libstdc++.so.6
Standard C++ library is located at: /usr/lib64/libstdc++.so.6.0.10
Actual C++ library: CXXABI_1.3.1
Validating 32 bit version of libstdc++.so.6 ...
Found the 64 bit /usr/lib64/libstdc++.so.6 at /usr/lib64
Found the 32 bit /usr/lib/libstdc++.so.6 at /usr/lib
Requirement matched.
Validating libc.so version ...
glibc library is located at: /lib64/libc-2.11.1.so
Required minimum glibc library version: 2.4.0
Actual glibc library version: 2.11.1
Requirement matched.
Validating libaio.so version ...
Loading of libaio.so.1 on system succeed.
Requirement matched.
Validating ofed ...
Required minimum version and release for ofed: 1.5.2-(null)
Requirement matched.
Validating sg3_utils ...
Package (or file) found: sg3_utils
Requirement matched.
Validating sg_persist ...
Package (or file) found: /usr/bin/sg_persist
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database server with DB2 pureScale feature.
Version: "10.5.0.0".
The following sample output was generated on a Linux operating system. Use the -p and -t parameters to validate prerequisites for a specific network configuration. The output shows the results of validating a single InfiniBand port cluster configuration in a DB2 pureScale environment.
db2prereqcheck -v 10.5.0.0 -p -t SINGLE_IB_PORT_CLUSTER
Checking DB2 prerequisites for DB2 database version 10.5.0.0 on
operating system "Linux"
Validating Linux distribution ...
Required minimum operating system distribution: "RHEL";
Version: "5"; Service pack: "6".
Actual operating system distribution Version: "6";
Service pack: "1".
Requirement matched.
...
Validating Infiniband Support Package: libibcm.x86_64 ...
Package (or file) found: libibcm.x86_64
Requirement matched.
Validating Infiniband Support Package: librdmacm.x86_64 ...
Package (or file) found: librdmacm.x86_64
Requirement matched.
...
Validating Reliable Scalable Cluster Technology Package:
librdmacm.i686 ...
Package (or file) found: librdmacm.i686
Requirement matched.
Validating Reliable Scalable Cluster Technology Package:
libcxgb3.i686 ...
Package (or file) found: libcxgb3.i686
Requirement matched.
...
DBT3533I The db2prereqcheck utility has confirmed that
all installation prerequisites were met for DB2 database
server with DB2 pureScale feature. Version: "10.5.0.0".
The following sample output was generated on a Linux operating system. The output shows the results of validating a multiple RoCE port cluster configuration in a DB2 pureScale environment.
db2prereqcheck -v 10.5.0.0 -p -t MULTI_ROCE_PORT_CLUSTER
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.5.0.0 on operating
system "Linux"
Validating Linux distribution ...
Required minimum operating system distribution: "RHEL"; Version: "6";
Service pack: "1".
Actual operating system distribution Version: "6"; Service pack: "1".
Requirement matched.
...
Validating Infiniband Support Package: libibcm.x86_64 ...
Package (or file) found: libibcm.x86_64
Requirement matched.
Validating Infiniband Support Package: librdmacm.x86_64 ...
Package (or file) found: librdmacm.x86_64
Requirement matched.
...
Validating High Performance Networking Package: libibverbs-rocee.x86_64 ...
Package (or file) found: libibverbs-rocee.x86_64
Requirement matched.
Validating High Performance Networking Package: libmlx4-rocee.x86_64 ...
Package (or file) found: libmlx4-rocee.x86_64
Requirement matched.
Validating Reliable Scalable Cluster Technology Package: libibcm.i686 ...
Package (or file) found: libibcm.i686
Requirement matched.
Validating Reliable Scalable Cluster Technology Package: librdmacm.i686 ...
Package (or file) found: librdmacm.i686
Requirement matched.
...
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database server with DB2 pureScale
feature. Version: "10.5.0.0".
The following sample output was generated on a Linux operating system. For DB2 pureScale uDAPL only, use the -u parameter.
> db2prereqcheck -u -v 10.5.0.0
==========================================================================
Checking DB2 Prerequisites for DB2 Version 10.5.0.0 on Linux
Validating ofed ...
Required minimum version and release for ofed: 1.5.2-(null)
Requirement matched.
Validating sg3_utils ...
Package (or file) found: sg3_utils
Requirement matched.
Validating sg_persist ...
Package (or file) found: /usr/bin/sg_persist
Requirement matched.
All requirement matched for DB2 Server version 10.5.0.0 .
==========================================================================
Checking DB2 Prerequisites for DB2 Version 10.5.0.0 on Linux
Validating ofed ...
Required minimum version and release for ofed: 1.5.2-(null)
Requirement matched.
Validating sg3_utils ...
Package (or file) found: sg3_utils
Requirement matched.
Validating sg_persist ...
Package (or file) found: /usr/bin/sg_persist
Requirement matched.
All requirement matched for DB2 Server version 10.5.0.0 DB2 pureScale
feature.
The following sample output was generated on a Linux operating system. Use the -c parameter for a client installation.
> db2prereqcheck -c -v 10.5.0.0
==========================================================================
Checking DB2 Prerequisites for DB2 Version 10.5.0.0 on Linux
Validating Linux distribution ...
Required minimum SUSE version : (null) SP (null)
Validating sles-release ...
Required minimum version and release for sles-release: 10-15.45.8
Actual version of package: 11.1
Requirement matched.
Validating kernel level ...
Required minimum kernel level : 2.6.16
Actual kernel level: 2.6.32.45
Requirement matched.
Validating C++ Library version ...
Required minimum C++ library: libstdc++.so.6
Standard C++ library is located at: /usr/lib64/libstdc++.so.6.0.10
Actual C++ library: CXXABI_1.3.1
Validating 32 bit version of libstdc++.so.6 ...
Found the 64 bit /usr/lib64/libstdc++.so.6 at /usr/lib64
Found the 32 bit /usr/lib/libstdc++.so.6 at /usr/lib
Requirement matched.
All requirement matched for DB2 Client version 10.5.0.0 .
==========================================================================
Checking DB2 Prerequisites for DB2 Version 10.5.0.0 on Linux
Validating Linux distribution ...
Required minimum SUSE version : (null) SP (null)
Validating sles-release ...
Required minimum version and release for sles-release: 10-15.45.8
Actual version of package: 11.1
Requirement matched.
Validating kernel level ...
Required minimum kernel level : 2.6.16
Actual kernel level: 2.6.32.45
Requirement matched.
Validating C++ Library version ...
Required minimum C++ library: libstdc++.so.6
Standard C++ library is located at: /usr/lib64/libstdc++.so.6.0.10
Actual C++ library: CXXABI_1.3.1
Validating 32 bit version of libstdc++.so.6 ...
Found the 64 bit /usr/lib64/libstdc++.so.6 at /usr/lib64
Found the 32 bit /usr/lib/libstdc++.so.6 at /usr/lib
Requirement matched.
Validating libc.so version ...
glibc library is located at: /lib64/libc-2.11.1.so
Required minimum glibc library version: 2.4.0
Actual glibc library version: 2.11.1
Requirement matched.
Validating ofed ...
Required minimum version and release for ofed: 1.5.2-(null)
Requirement matched.
Validating sg3_utils ...
Package (or file) found: sg3_utils
Requirement matched.
Validating sg_persist ...
Package (or file) found: /usr/bin/sg_persist
Requirement matched.
All requirement matched for DB2 Client version 10.5.0.0 DB2 pureScale
feature.
The following sample output was generated on a Linux operating system. Use the -s parameter to display a validation summary only.
> db2prereqcheck -s -v 10.5.0.0
All requirement matched for DB2 Server version 10.5.0.0 .
All requirement matched for DB2 Server version 10.5.0.0 DB2 pureScale
feature.
The following sample output was generated on a Linux operating system. Use the -nm parameter or the -nl parameter to validate the type of adapter.
> ./db2prereqcheck -v 10.5.0.3 -p -nm coralinst09-ib0
Validating ....
Validating....
Validating "Adapter and " ...
The db2prereqcheck utility found that Interface Adapter "coralinst09-ib0" is an InfiniBand Adapter
which is currently RDMA capable on host "coralinst09".