Greetings All,
We're doing some performance tuning on an XPS 8.50.FC2 server on an AIX
platform and I saw the output below when I ran "onstat -g scn." Can anyone
provide some feedback on what the "Forward row lookup, Must copy," notes
mean? Is this indicating something detrimental to performance versus a
light scan with nothing in the Notes section?
Thanks,
Bob
omzsam80 (diablo) /home/informix>onstat -g scn
IBM Informix Extended Parallel Server Version 8.50.FC2X3 -- On-Line -- Up
00:27:16 -- 11058304 Kbytes
RSAM sequential scan info
SesID Thread Partnum Rowid Rows Scan'd Scan Type Lock Mode Notes
18 203 590067 5be401 423234 Light Forward row
lookup,Must copy,
18 202 510067 579a01 403442 Light Forward row
lookup,Must copy,
18 201 490067 57fc01 405227 Light Forward row
lookup,Must copy,
18 200 410067 57aa01 403754 Light Forward row
lookup,Must copy,
18 199 390067 5a8401 416883 Light Forward row
lookup,Must copy,
18 198 310067 762001 544136 Light Forward row
lookup,Must copy,
18 197 290067 76d001 547276 Light Forward row
lookup,Must copy,
18 196 210067 7f6401 586799 Light Forward row
lookup,Must copy,
18 195 190034 821c01 599291 Light Forward row
lookup,Must copy,
RSAM index scan info
SesID Thread Partnum Scan Type Lock Mode Notes
sending to informix-list