Increasing the TMF Lock Limit

Few options for Increasing the TMF Lock limit

Option 1

Put the alternate key files on other volumes. Since the locks are counted by volume and not by file this may solve the issue.

Option 2

Increase the maximum lock limit by use of SCF application.

You can control the number of locks that a transaction can hold on a specific volume and lock escalation by using SCF to change MaxLocksPerTCB to a maximum of 100,000. Use this command:

More information can be found in the attached manual.

SCF ALTER $volume, MAXLOCKSPERTCB n

2-> info $data4,detail

STORAGE - Detailed Info Magnetic DISK \ETDEV1.$DATA4

Common Disk Configuration Information:

*BackupCpu............................. 1

*HighPin............................... ON

*PrimaryCpu............................ 0

*Program............................... $SYSTEM.SYSTEM.TSYSDP2

*StartState............................ STARTED

Disk Type Specific Information:

*AuditTrailBuffer/SQLMXBuffer (MB)..... 0

*AutoRevive............................ OFF

*AutoSelect............................ n/a

*AutoStart............................. ON

*CapacityMismatch...................... OFF

*CBPoolLen............................. 1000

*FastBulkWrite......................... OFF

*FSTCaching............................ OFF

*FullCheckpoints....................... ENABLED

*HaltOnError........................... 1

*LKIDLongPoolLen....................... 8

*LKTableSpaceLen....................... 15

*MaxLocksPerOCB........................ 5000 (This is it!!!)

*MaxLocksPerTCB........................ 5000 (This is it!!!)

*NonAuditedInsert...................... OFF

*NumDiskProcesses...................... 4

*OSSCaching............................ ON

*PhysvolSelect......................... n/a

*Pool.................................. None