DSNXSQSR

This is called to use a RID list to sort the selected rows. A RID sort is much faster than an actual physical sort.

Hints

Check the Db2 accounting detail for RID Pool failures and adjust the size of the RID Pool accordingly.

Reference Sources

IBM Db2 for OS/390, Installation Guide, GC26-8970

IBM Db2 for OS/390, Messages and Codes, GC26-8979

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

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