IBM Support

IT35700: DB2PREREQCHECK ON AIX DOESN'T CORRECTLY IDENTIFY POWER LEVEL OR IOPORTS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • For example, db2prereqcheck reports:
    $ sudo ./db2prereqcheck -i -v 11.1.4.5
    Password:
    ==========================================
    
    Checking prerequisites for DB2 installation. Version "11.1.4.5".
    Operating system "AIX"
    
    Validating "IOPORTS" ...
       ERROR : Requirement not matched.
    
    Validating "kernel level " ...
       Required minimum operating system kernel level: "7.1".
       Actual operating system kernel level: "7.1".
       Requirement matched.
    
    Validating "Power hardware " ...
       Required minimum operating system Power level: "6".
    sh: prtconf:  not found
       Actual operating system Power level: "0".
       ERROR : Requirement not matched.
    DBT3611E  The db2prereqcheck utility found that the Power
    hardware does not meet the minimum support level.
    
    Validating "AIX technology level and service pack " ...
       Required minimum technology level: "3" Service pack: "5"
       Actual technology level: "5" Service pack: "3"
       Requirement matched.
    
    Validating "Java for TSAMP" ...
       Required minimum "Java" version: "7.1.0.145 or 7.0.0.265 or
    6.0.0.265"
       Requirement matched.
    
    Validating "XL C/C++ Runtime" ...
       Required minimum "XL C/C++ Runtime" level:  "13.1.2.0"
       Actual version:  "13.1.3.1"
       Requirement matched.
    Requirement not matched for DB2 database "Server" . Version:
    "11.1.4.5".
    Summary of prerequisites that are not met on the current system:
       Required minimum operating system Power level: "6".
       Actual operating system Power level: "0".
    
    In this case, actual Power level is 8, and IO Ports are
    installed and available:
    $  lsdev -Cc iocp
    
    iocp0 Available  I/O Completion Ports
    
    
    This issue is delivered in wsdbu01458135 and wsdbu01459961.
    

Local fix

  • If you know that your Power level is 6 or greater, and 'lsdev
    -Cc iocp' reports
    iocp0 Available  I/O Completion Ports
    you can ignore the errors and proceed with installing or
    upgrading DB2
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of db2prereqcheck on AIX                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V11.1.4.6.                                        *
    ****************************************************************
    

Problem conclusion

  • Fixed in V11.1.4.6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT35700

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-01-26

  • Closed date

    2022-06-06

  • Last modified date

    2022-06-06

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
07 June 2022