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