JR61941: IBM INFORMATION SERVER DATA QUAALITY DQEC PURGE GENERATES EXCEPTION AND FAILS

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as program error.

Error description

• Purge of exceptions fail with 'ORA-00942: table or view does
  not exist'. This occurs multiple times. IBM script ESDBAdmin.sh
  outputs a number of exceptions in exception tables greater than
  the number of exception tables in the seen in the database.
  Also, Oracle database shows tables in the exception database
  schema that does not appear to be known by IIS.
  

Local fix

• None.
  
  APAR code fix will clean up the tables upfront purging.
  In addition the fix will be combined with another fix that
  improves the performance of the purge command.
  

Problem summary

• ESDB database could become inconsistent during exception
  set purge
  

Problem conclusion

• Improved ESDB purging code. Added consistency checks and clean
  up code.
  

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

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• RB50 PSY

     UP

• RB70 PSY

     UP

• RB71 PSY

     UP