IBM Support

IT33422: AUTO TABLE MAINTENANCE DB2ACD PROCESS FAILS TO CONNECT TO DATABASE WHEN DB2CLI.INI CONFIGURED TO ENFORCE TCP CONNECTIONS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When the db2cli.ini file is configured to enforce TCP/IP
    connections for the database, the db2acd process (which manages
    Admin Task Scheduler and Automatic Table Maintenance activties)
    will fail to establish a UDP connection to the database (which
    is done so without username/password).  A db2diag.log entry like
    so will appear in the db2diag.log:
    
    2020-05-14-19.11.35.764026-240 I40049A474           LEVEL:
    Warning
    PID     : 15859830             TID : 1029           PROC :
    db2acd 0
    INSTANCE: db2inst1              NODE : 000
    HOSTNAME: hostname1
    EDUID   : 1029                 EDUNAME: db2acd 0
    FUNCTION: DB2 UDB, Health Monitor,
    HmonMainCB::refreshDbAutonomicSwitches, probe:160
    MESSAGE : Failed connecting to database "DBNAME1 "
    ...
    

Local fix

  • Upgrade to fixpack inclusive of this APAR fix.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to fixpack inclusive of this APAR fix.               *
    ****************************************************************
    

Problem conclusion

  • See APAR description.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT33422

  • 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

    2020-07-03

  • Closed date

    2021-03-26

  • Last modified date

    2021-03-26

  • 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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
27 March 2021