Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the default TurboIMAGE locking and how do I obtain more concurrency ?

April 26, 2017Concurrency Default locking obtain turboimage

0

Posted

What is the default TurboIMAGE locking and how do I obtain more concurrency ?

1 Answer

0

Posted

By default, Warehouse will lock at the TurboIMAGE dataset level. To alter the locking option, use the SET LOCKING statement. The SET LOCKING MANUAL statement enables manual locking and increased concurrency. By selecting this option you are then responsible for issuing LOCK and UNLOCK statements at appropriate points in the processing. It is useful to develop a systematic locking strategy for all scripts that access datasets in this manner.