Previous  Next          Contents  Index  Navigation  Glossary  Library

Locking Tables within the Snapshot Example

Consider a situation where you have a subinventory with a quantity of 100 units, and a discrete job for 25 units.

Between the time the snapshot reads the inventory information and the time the snapshot reads the discrete job information, 10 units are completed from the job. If you ran the snapshot and choose to lock tables, you would guarantee that the snapshot would read either 100 units in the subinventory and 25 units outstanding on the discrete job, or 110 units in the subinventory and 15 units outstanding on the discrete job.

If you ran the snapshot and selected not to lock tables, there is a chance the Snapshot would read 100 units in the subinventory and 15 units outstanding on the discrete job.

The chances of inconsistencies caused by launching the snapshot without locked tables is remote. The results you get from locked tables are better than those you get from the locked tables. However, you can still choose to run the Planning Engine with locked tables.

See Also

Locking Tables within the Snapshot

Defining Planning Parameters


         Previous  Next          Contents  Index  Navigation  Glossary  Library