DSNKFTCH

DSNKFTCH is used to obtain a RID from temporary space in an index for the Manipulative Services Recording Area.

Hints

DSNKFTCH should be a high usage module. The idea is to get data from the index rather than the table. Type 2 indexes are preferred to type 1, because there is no locking.

Reference Sources

IBM Db2 for OS/390, Application Programming and SQL Guide, SC26-8958

IBM Db2 for OS/390, Administration Guide, SC26-8957