Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Glossary

Considerations for Using Row-level Locking

Considerations for Using Row-level Locking

When using row-level locking in a
Informatica MDM Hub
implementation, consider the following issues:
  • A batch process can lock individual records for a significant period of time, which can interfere with
    SIF
    access over the web.
  • There can be small windows of time during which
    SIF
    requests will be locked out. However, these should be few and limited to less than ten minutes.
  • The
    Hub Store
    needs to be sufficiently sized to support the combined resource demand load of executing batch processes and
    SIF
    requests concurrently.
Interoperabilty must be enabled if Batch jobs are being run together. If, you have multiple parents that attempt access to the same child (or parent) records when running different Batch jobs, one job will fail if it attempts to lock records being processed by the other batch and it holds them longer than the batch wait time. The maximum wait time is defined in C_REPOS_TABLE.

0 COMMENTS

We’d like to hear from you!