JR33884: RULES IN IA DO NOT WORK WITH VERY LARGE TABLES.

APAR status

• Closed as fixed if next.

Error description

• Rules that runs on a 50.000.000 row table and brings   out
  115 records that matches a business rule.
  
   If you want  to bring the rows that meets my rule which is
  115 as the output. But db2 IADB get enormously
  big after some time up to 175 GB. When checking the  tables from
  table
  management screen from the console  there are 4 tables for
  each execution of the rule, and one of them has 50.000.000 rows!
  That table  does not contain the data of the table, but kind of
  a audit table
  and has the exactly same number of rows as the source table.
  
  
  Possibility not to generate those tables so
  that my IADB can be in an acceptable range. if not then the data
  rules
  becomes unable to be applied for companies that has large
  tables.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users running Data Rules against tables that contain a huge
  amount of data.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Rules that runs on a large tables use up a lot of space in IADB
  even if the number of output rows is small.
  ****************************************************************
  RECOMMENDATION:
  Upgrade to Information Analyzer 8.1.1 Rollup Patch 1
  ****************************************************************
  

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

• R810 PSN

     UP