SAP Note 24182 - Allocation - INFORMIX: Locking problems INDX

Symptom:

Key word: Allocation
Description: When an allocation is being carried out in the INFORMIX database, exclusive lock indicators are set for table INDX by the database system. This means that, when you work online, increasing numbers of transactions encounter this INDX lock indicator and are forced to wait.
Consequence: Considerable restrictions when working online
Transactions: KSU5, KSV5, KSUB, KSVB, KSW5, KEU5, GA15, GA35, GA2B GA4BProgram name: SAPMKGAL, ALxxYYYR (xx: serial number, yyy=client)

Cause and prerequisites

INFORMIX problems when an EXPORT statement is executed on table INDX

Solution
1. How to avoid error:
The only way to avoid the above-mentioned 'lock' problems is to let the allocation run on its own without online mode being activated or other background jobs running in parallel.



2. In order to avoid the locking problems completely, you must insert the correction shown below.
************************************************************************
* Programm: LKGA2U01
* Funktionsbaustein: K_ALLOCATIONS_RUN
************************************************************************

FUNCTION K_ALLOCATIONS_RUN.
:
:
:
:
*.generate specific report for allocation
PERFORM E01-GEN-ALLOCATION-JOB(SAPFKGA2)
TABLES
IT811CT
USING
IRKGA2U
RNAME
TITLE
RCODE.

IF RCODE <= EL-INFOR.
*...check if reverse already complete
IF REVERSE = TRUE.
CALL FUNCTION 'ENQUEUE_EK811D'
EXPORTING
TAB = EQ_T811D-TAB
CYCLE = EQ_T811D-CYCLE
SDATE = EQ_T811D-SDATE
GJAHR = EQ_T811D-GJAHR
PERIO = EQ_T811D-PERIO
DPOS = EQ_T811D-DPOS
_WAIT = TRUE
EXCEPTIONS
FOREIGN_LOCK.
IF SY-SUBRC <> 0.
MESSAGE A534 WITH SY-MSGV1 TITLE RAISING FOREIGN_LOCK_REV.
ENDIF.
ENDIF.

*...INFORMIX: dequeue all locks made by EXPORT commands <<<< if sy-dbsys = 'INFORMIX '. <<<< commit work. <<<< endif. <<<<
*...run generated report
IF SY-BATCH = TRUE.
:
:
: