Its not on sale
Reputable Poster
Holey inserts is a feature of AS400. It is activated by using a call to api QDBENCWT.
I am wondering if somebody has any further info about it. PS support says that JDE comes pre-installed with holey inserts enabled. From them it seems like it table by table but I am still not sure.
I would like to know if there are any drawback of turning that on. Any further information is greatly appreciated.
For those who not know, Holey inserts allows you to insert multiple records in the file at the same time. For example 5 batch job running can insert records into the same file at same instance where as without it turn on each job helds an exclusive lock on the file on each insert and other job wait till the lock is released.
Regards
I am wondering if somebody has any further info about it. PS support says that JDE comes pre-installed with holey inserts enabled. From them it seems like it table by table but I am still not sure.
I would like to know if there are any drawback of turning that on. Any further information is greatly appreciated.
For those who not know, Holey inserts allows you to insert multiple records in the file at the same time. For example 5 batch job running can insert records into the same file at same instance where as without it turn on each job helds an exclusive lock on the file on each insert and other job wait till the lock is released.
Regards