DB2 V11 UI57390

Jorg Lueke

DB2 V11 UI57390

Has anyone run the query on SYSLGRNX, returned rows, then run the CATMAINT PI87933, and found rows remaining? I've only seen it once on a sandbox system but I should probably open a ticket anyway.

Jorg Lueke

RE: DB2 V11 UI57390
(in response to Jorg Lueke)

I can answer this one myself. UI57390 superseded UI53114 however serviceability APAR PH04042 supersedes the hold action of UI57390.

http://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1PH04042

 

Code in APARs PI87933 and PI94569 attempted to remove the orphan rows in SYSLGRNX during Db2 11 ENFM process. 00C900BF failures during the ENFM SYSLGRNX orphan row cleanup process prevent the ENFM from successfully completing so this code has been removed in this APAR.

 

Problem conclusion

  • Db2 code has been updated to correct the aforementioned issues.
    
    CATMAINT UPDATE UNLDDN PI04042 is provided to remove SYSLGRNX
    orphans.
    
    The CATMAINT UPDATE jobs provided in APARs PI87933 and PI94569
    should only be used if directed by IBM service personnel.