DSNIRNXT

During sequential access to data, module DSNIRNXT moves the record Cursor Usage Block (CUB) to the next record (ROW) for the application program to retrieve. The amount of CPU resources this module uses depends upon how many rows are being returned to the application.

Hints

Large amounts of CPU time reported to this module usually indicates that many rows and columns of data are being returned to the application. Use the Attribution of CPU Usage report to identify which SQL statements invoke this module. Evaluate these database calls to determine if the number of rows can be reduced. Also, confirm that a sequential access, and not a direct access, was anticipated. For example, check to see an index was created to access the data but is inadvertently going unused.

Reference Sources

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