IBM Support

IT29557: MORE ROBUST CLEANUP STATUS CHECKING

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

  • db2_kill or failures may result in ipclean being initiated.
    Db2 processes may attempt to start before ipclean completes the
    clean
    up of Db2 resources properly, leading to db2sycs startup to
    fail.
    

Local fix

  • Possible work-around being attempted: Edit the TSA monitor
    scripts to add a check for the port no longer being listened
    before invoking db2gcf to start the instance. Write a script to
    kill DB2, check for port still allocated and wait in a loop
    until free, then restart DB2 using db2gcf and check port is
    opened OK.
    
    
    
    Testing work-around output:
    
    
    
    Workaround added before db2gcf ?u calls in
    /usr/sbin/rsct/sapolicies/db2/db2V111_start.ksh and
    /usr/sbin/rsct/sapolicies/db2/hadrV111_start.ksh:
    
    
    
      if [[ -x $INSTHOME/sqllib/bin/db2gcf ]]; then
    
         ((sato=nln*2+60))
    
    
    
    ################################################################
    ##############################
    
    # Defect 372: DB2 fails to open SSL and TCPIP port. Possibly
    because defunct processes
    
    #            not yet cleaned up completely by ipclean. Therefore
    loop here until
    
    #            port is no longer being used.
    
    
    
         loop_counter=0
    
         while [[ $loop_counter -lt 20 ]]; do
    
            port_used=$(netstat -anp|grep 1565|wc -l)
    
            if [ $port_used -eq 1 ]; then
    
               log notice "SSL Port still in use. Waiting 10
    secs..."
    
               sleep 10
    
               ((loop_counter+=1))
    
            else
    
               loop_counter=100
    
            fi
    
         done
    
    
    
    ################################################################
    ##############################
    
         su - ${DB2INSTANCE} -c "$INSTHOME/sqllib/bin/db2gcf -t
    $sato -u -p ${NN?} -i ${DB2INSTANCE?} -L"
    
         rcg=$?
    
    
    
      else
    
         log err "$LINENO: Cannot find executable
    $INSTHOME/sqllib/bin/db2gcf"
    
         sleep 30
    
         rcg=1
    
      fi
    
    }
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29557

  • 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

    2019-06-26

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

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

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

    IT37337

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":"BU029","label":"Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
19 June 2021