IBM Support

IT29557: MORE ROBUST CLEANUP STATUS CHECKING

Subscribe

You can track all active APARs for this component.

 

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

  • RB10 PSN

       UP

[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022