ZB_VER_CMT - Intergraph Smart Materials - Version 10.2 - Administration & Configuration - Hexagon

Intergraph Smart Materials Classic Administration (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Materials/Smart Reference Data Version
10.2

This project default specifies the behavior of the commit operation in BOM jobs.

This project default controls whether BOM jobs (B.20.01.41) and Verifications jobs (B.20.01.35) perform a database commit of their current transaction once they have finished processing a complete BOM node.

The default setting (N) is to not perform a commit, that is, 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.

  • Module(s) affected by this setting: B200135, B200141

  • Default value: N

  • List of Values: N/Y