ZB_VER_CMT - Intergraph Smart Materials - 10.2 - Help - Hexagon

Intergraph Smart Materials Web Help (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

This project default controls whether the Bill of Materials (BOM) jobs and Verifications jobs perform a database commit of their current transaction once they have finished processing a complete BOM node or not.

  • Module(s) affected by this setting: Verifications.

  • List of Values: Y and N (default).

    • If set to N, the whole job runs in a single transaction. Using commits can reduce rollback segment usage, but on the other hand, if multiple concurrent transactions or queries against BOM data are being performed in the database, using intermediate commit points increases the probability of hitting the "ORA-1555: Snapshot too old" problem, which indicates inappropriate usage of rollback space due to extensive use of the "Fetch Across Commit" feature. Use the Commit option only if either the processed data volume or the concurrent transaction workload is relatively low on your database.