Database considerations - assure_dq - 10.1.0

Assure DQ Server Installation

Product type
Software
Portfolio
Verify
Product family
Assure
Product
Assure DQ
Version
10.1.0
ft:locale
en-US
Product name
Assure DQ, ER, Insight and Perceive
ft:title
Assure DQ Server Installation
Copyright
2025
First publish date
2005
ft:lastEdition
2025-11-28
ft:lastPublication
2025-11-28T07:35:54.959000
L1_Product_Gateway
Verify
L2_Product_Segment
Data Quality
L3_Product_Brand
Precisely Infogix
L4_Investment_Segment
Legacy Infogix DQ
L5_Product_Group
Legacy Infogix DQ
L6_Product_Name
Product Feature
Assure DQ

Some tablespaces are heavily used and will grow very large over time.

When you set up these tablespaces, which vary by product and database, be sure to allow sufficient space for growth.

Monitor the tablespaces regularly to accommodate additional disk space requirements.

Tip: Regular monitoring helps prevent unexpected outages due to insufficient disk space.

For Assure DQ, monitor the following tablespaces:

  • IA_DYNOBJECTS
  • IA_FILESTORE
  • IA_RULESMGMT

For ER, monitor the following tablespaces:

  • ER_UTILITY
  • For Oracle: ER_DYNOBJECTS
  • For SQL Server: the default file group used by the ER database, typically PRIMARY

For Insight, monitor the following tablespaces:

  • II_IIDATA

For Perceive, monitor the following tablespaces:

  • IV_UTILITY
  • For Oracle: IV_DYNOBJECTS
  • For SQL Server: the default file group used by the Perceive database, typically PRIMARY