PH34959: SQLCODE -901 WITH "REBIND PACKAGE. POSSIBLY DROP DBPARTITIONNUM WAS DONE."

APAR status

• Closed as fixed if next.

Error description

• An error may occur when executing a statement that includes a
  table function invocation after a node has been dropped. You
  will see the following error in the SQLCA in the db2diag.log:
  
  sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 55
  sqlerrmc: Rebind Package. Possibly DROP DBPARTITIONNUM was
  done.
  sqlerrp : SQLRI4FF
  
  and an FODC_AppErr data collection is triggered.
  
  Note that the package is not marked as invalid or needing
  to be rebound.  This is normal.
  
  The issue here is that the compiled section of a select
  from a table function may explicitly list the nodes
  available at the time of compilation, which might differ
  from what is available at runtime.  If a worker node has
  been dropped since the package was last rebound, this error
  may occur.
  

Local fix

• Manually rebind the package using the syntax:
  REBIND PACKAGE <schema>.<package_name>
  The package schema and name can be found in the messages
  written to the db2diag.log as part of the FODC_AppErr
  data collection.
  

Problem summary

• Please see the problem description.
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

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

Fix information

Applicable component levels