PH50343: SYSTEM ERROR "RELATIONSHIP IS EMPTY"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is attempting to process, while EXTRACTing a table,
  a relationship based on a DB2 foreign key definition.
  Optim detects a possible change to the FK definition based
  on the current TIMESTAMP value from SYSRELS and initiates
  an update of the FK's shadow copy in Optim's directory.
  The update attempt and the entire user-initiated process end
  with a System Error.
  
  An Internal System Error has Occurred on 2022-03-21 11:02
  
  Relationship is empty
  DB2Rel=1215(NFM), Rel=11.7.0
  Code=-1, AuxInfo=
  01 FOPQKDAA 20180619 COPYSENT (001330) DS_ReplaceFK
  02 FOPQRDAA 20210512 PH36824 (002643) dsCreShadowforCID
  03 FOPQRDAA 20210512 PH36824 (002373) dsCmpRData
  
  Other failing scenarios may include Access Definition
  creation/Edit or Optim relationship listing.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Optim users.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Optim may abort processing with a       *
  *                      System Error while processing           *
  *                      relationships based on a DB2 foreign    *
  *                      key.                                    *
  ****************************************************************
  A coding error causes access to incorrect storage location and
  randomly detects a condition causing a System Error.
  

Problem conclusion

• Optim processing will be corrected.
  

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:

Modules/Macros

• FOP9APIM FOPCFPMN FOPCXLIB FOPHSTM  FOPI0000 FOPI0001 FOPINS0
  FOPINS2  FOPIX000 FOPK04   FOPMAIN  FOPMAMAI FOPMARCN FOPMCMAI
  FOPMCOLA FOPMCOLP FOPMDPRC FOPMECMN FOPMMUNU FOPMMUTL FOPMSELM
  FOPOMN   FOPRS10  FOPRS9   FOPTC710 FOPTC71Y FOPTC71Z FOPZFMMN
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI83295

     UP22/11/17 P F211 ¢

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.