You can use the db2prereqcheck command to check the software and firmware prerequisites of a specific DB2® version.
With the db2prereqcheck command, you can determine if your system satisfies the DB2 installation prerequisite without having to start the installation of a specific DB2 version. This command checks prerequisites such as operating system level, Linux distribution, AIX® Technology Level, C library & runtime patch, Client, uDAPL, GPL or DB2 pureScale® specific requirements.
The DB2 product comes with the db2prereqcheck binary and the DB2prereqs.xml file in the cfg folder. The DB2prereqs.xml file contains the prerequisite from Version 9.8 Fix Pack 2 to Version 10.1, and the contents should not be modified. You must run the db2prereqcheck command in the directory where the installation image is located.
For DB2 Version 10.1 Fix Pack 1 or earlier, you must extract the binary file and the XML file to your temporary folder in your desktop before you can run the db2prereqcheck command. You do not need to extract the files if your operating system has DB2 product installed. You need read and write access to the system to run db2prereqcheck command (that is, read access for reading in DB2prereqs.xml and write access to generate the output file).
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.
You can check prerequisites requirement for the latest DB2 version, a specific DB2 version, generate a report file, and more with the db2prereqcheck command.
To check the prerequisites for the latest DB2 version that is defined in the resource XML file, run db2prereqcheck command with -i parameter. For example,
$ ./db2prereqcheck -i
To check whether the system meets the prerequisite for the specific DB2 version that is defined in the resource XML file, run db2prereqcheck command with -v <version number> parameter. For example,
$ ./db2prereqcheck -v 10.1.0.0
To generate a report file containing validation information and output from the db2prereqcheck command (including a summary section listing all failing tests), use the -o <filename> parameter. Specify the full report filename path to generate the report in another directory. The prerequisites for installing the DB2 product will only be displayed on the command screen without the -o <filename> parameter.
$ ./db2prereqcheck -i -o report.rpt
The default XML file (with file path : DB2 installation/cfg/DB2prereqs.xml) will be used if the -f parameter is not specified. If this default XML file is not found, -f <filename> can be used to specify the XML file.
$ ./db2prereqcheck -i -f ./newDB2prereqs.xml
To check whether the system meets the basic pureScale prerequisites for a specific DB2 version, run the db2prereqcheck command with -p ,-v <version number>, -h1 <set of hosts (member and cf hosts)>, -dl <one ore more shared disks for GPFS file system>, and -iu <pureScale instance userid> parameters. For example,
$ ./db2prereqcheck -p -v 10.1.0.0 -hl <host1,host2..> -dl <shared_disk1,shared_disk2..> -iu <user>
To check whether the system meets the comprehensive pureScale prerequisites for a specific type of network configuration (Linux operating systems only) and for a specific DB2 version, run the db2prereqcheck command with -p ,-v <version number>, -h1 <set of hosts(member and cf hosts)>, -dl <one ore more shared disks for GPFS file system>, -iu <pureScale instance userid>, and -nl <list of networks> parameters. For example,
$ ./db2prereqcheck -p -v 10.1.0.0 -hl <host1,host2..> -dl <shared_disk1,shared_disk2..> -iu <user> -nl <netname1,netname2..>
$ ./db2prereqcheck -i -p
$ ./db2prereqcheck -i -p -t <network configuration type>
If the db2prereqcheck command indicates that the system fails to meet the prerequisite, DBT3507E, for 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.1 Information Center.
Sample db2prereqcheck command output on AIX operating system. For DB2 pureScale installation, use the -p option.
> db2prereqcheck -p -v 10.1.0.0
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.1.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.1.0.0".
Sample db2prereqcheck command output on AIX operating system. For DB2 pureScale uDAPL only, use the -u option.
> db2prereqcheck -u -v 10.1.0.0
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.1.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.1.0.0".
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.1.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.1.0
Sample db2prereqcheck command output on AIX operating system. For client installation, use the -c option.
> db2prereqcheck -c -v 10.1.0.0
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.1.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.1.0.0".
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.1.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.1.0.0".
Sample db2prereqcheck command output on AIX operating system. To display validation summary only, use the -s option.
> db2prereqcheck -s -v 10.1.0.0
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database server . Version: "10.1.0.0".
DBT3533I The db2prereqcheck utility has confirmed that all installation
prerequisites were met for DB2 database server with DB2 pureScale
feature. Version: "10.1.0.0".
Sample db2prereqcheck command output on Linux operating system. For DB2 pureScale installation, use the -p option.
> db2prereqcheck -p -v 10.1.0.0
==========================================================================
Checking DB2 Prerequisites for DB2 Version 10.1.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.1.0.0".
Sample db2prereqcheck command output on Linux operating system. Use -p and -t option to validate prerequisites requirement for a specific network configuration. For example, to validate for a single InfiniBand port cluster configuration in a DB2 pureScale environment:
db2prereqcheck -v 10.1.0.0 -p -t SINGLE_IB_PORT_CLUSTER
Checking DB2 prerequisites for DB2 database version 10.1.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.1.0.0".
On supported Linux operating systems, to validate for a multiple RoCE port cluster configuration in a DB2 pureScale environment:
db2prereqcheck -v 10.1.0.0 -p -t MULTI_ROCE_PORT_CLUSTER
==========================================================================
Checking DB2 prerequisites for DB2 database version 10.1.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.1.0.0".
Sample db2prereqcheck command output on Linux operating system. For DB2 pureScale uDAPL only, use the -u option.
> db2prereqcheck -u -v 10.1.0.0
==========================================================================
Checking DB2 Prerequisites for DB2 Version 10.1.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.1.0.0 .
==========================================================================
Checking DB2 Prerequisites for DB2 Version 10.1.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.1.0.0 DB2 pureScale
feature.
Sample db2prereqcheck command output on Linux operating system. For client installation, use the -c option.
> db2prereqcheck -c -v 10.1.0.0
==========================================================================
Checking DB2 Prerequisites for DB2 Version 10.1.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.1.0.0 .
==========================================================================
Checking DB2 Prerequisites for DB2 Version 10.1.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.1.0.0 DB2 pureScale
feature.
Sample db2prereqcheck command output on Linux operating system. To display validation summary only, use the -s option.
> db2prereqcheck -s -v 10.1.0.0
All requirement matched for DB2 Server version 10.1.0.0 .
All requirement matched for DB2 Server version 10.1.0.0 DB2 pureScale
feature.