7.3 to 9.4 HELP went live with issues

We went live today with 9.4UC7 from 7.31. It is a new server with 9.4. We are seeing huge record lock issues in our 4GL programs. We tested in a dev environment and did not see any issues.... Anyone have any ideas?? Thanks Gary IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 04:13:58 -- 2500608 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 29336313 46320280 1708251104 98.31 970310 3907147 8701514 98.64 isamtot open start read write rewrite delete commit rollbk 381726294 6318487 39908101 189918079 2985913 1000441 43825 119688 136 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 28530.13 2794.44 27 54 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 6832888 47 18355927 0 0 182 47923 16258270 ixda-RA idx-RA da-RA RA-pgsused lchwaits 3188061 60356 18694454 21939293 272877 onstat -k IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up 04:15:27 -- 2500608 Kbytes Locks address wtlist owner lklist type tblsnum rowid key#/bsiz a4a2d58 0 8a411300 0 HDR+S 100002 207 0 a4a2db0 0 8dd93860 a4a7060 HDR+X 2001d8 0 0 a4a2e08 0 8a3ff498 a4a6f00 HDR+X 5001be 1274c06 0 a4a2e60 0 92118c30 a4a31d0 HDR+X 500d0b 1ab0b K- 1 a4a2eb8 0 8a3ff498 ec95740 HDR+X 5001be 1274c09 0 a4a2f10 0 9211c920 0 S 100002 207 0 a4a2f68 0 8dd93860 a4a80e0 HDR+X 500d0c 1ac0b K- 1 a4a2fc0 0 8a41c9d0 a4a9948 IS 500019 0 0 a4a3018 0 8a407490 0 S 100002 207 0 a4a30c8 0 9211e180 0 S 100002 207 0 a4a3120 0 9211db68 0 S 100002 207 0 a4a3178 0 8dd9e300 a4a3490 HDR+X 500d0b 1ab0f K- 1 a4a31d0 0 92118c30 a4a5010 HDR+X 5004c0 1ab0b 0 a4a32d8 0 8dd9b858 a4abec0 HDR+X 500ddc 649701 K- 1 a4a3388 0 8a413178 0 S 100002 207 0 a4a3438 0 8dd93860 a4a4778 HDR+X 500d0b 1ac0c K- 1 a4a3490 0 8dd9e300 a4a4670 HDR+X 5004c0 1ab0f 0 a4a34e8 0 8a419f28 0 S 100002 207 0 a4a3540 0 8dd83870 0 S 100002 207 0 a4a3598 0 8a40f488 0 S 100002 207 0 a4a35f0 0 8a40c9e0 0 S 100002 207 0 a4a3648 0 8dd7e320 0 S 100002 207 0 a4a36f8 0 8dd80dc8 0 S 100002 207 0 a4a37a8 0 8a4149d8 1048c778 HDR+X 5001be 1274c0b 0 a4a3800 0 8dd80dc8 a4a8a28 IX 5001be 0 0 a4a38b0 0 8dd9e300 a4a4d50 HDR+X 500cf8 1c01 K- 1 a4a3908 0 8a417480 a4a8298 IX 5004b1 0 0 a4a3960 0 8dd9b858 0 S 100002 207 0 a4a39b8 0 8dd9e300 a4a6c98 IS 500019 0 0 a4a3a10 0 8a4049e8 a4a51c8 IX 5001be 0 0 a4a3a68 0 92128608 13485bb0 IS 500019 0 0 a4a3ac0 0 8dd86318 0 S 100002 207 0 a4a3bc8 0 921079f8 0 S 100002 207 0 a4a3c20 0 9211f9e0 10491d68 HDR+X 20017f 0 0 a4a3d80 0 8a4149d8 134842f0 HDR+X 5001be 1274c0c 0 a4a3dd8 0 8a411f30 0 S 100002 207 0 a4a3e30 0 8dd8e310 11c88c40 IX 5001be 0 0 a4a3ee0 0 8a3ff498 11c8b738 HDR+X 5008f2 1274c0a K- 1 a4a3f38 0 8dd8e310 a4a3e30 HDR+X 5001be 127500c 0 a4a3fe8 0 92114f40 0 S 100002 207 0 a4a4040 0 8a401f40 a4a7270 HDR+X 200246 0 0 a4a4098 0 921036f0 0 S 100002 207 0 a4a41a0 0 8a3fe250 0 S 100002 207 0 a4a41f8 0 92129e68 ec94fb0 HDR+X 500d0c 1a905 K- 1 a4a4250 0 8dda0da8 a4a5ab8 IX 5001be 0 0 a4a42a8 0 92118c30 ec93328 HDR+X 5004c0 1ab0c 0 a4a4300 0 8dd93860 ec92720 IS 500019 0 0 a4a4358 0 8a406e78 a4a5a60 HDR+X 500cf8 1c0b K- 1 a4a43b0 0 92104f50 1048eea8 HDR+X 500d0b 1aa04 K- 1 a4a4408 0 9210b6e8 0 S 100002 207 0 a4a44b8 0 8a3f9f48 0 S 100002 207 0 a4a4510 0 92120c28 0 S 100002 207 0 a4a4568 0 9211b0c0 0 S 100002 207 0 a4a45c0 0 92100630 13482a88 HDR+X 50054c 648f12 0 a4a4618 0 9211d550 11c8a920 IX 50024e 0 0 a4a4670 0 8dd9e300 a4a38b0 IX 5004c0 0 0 a4a46c8 0 8a401928 13485898 S 100002 201 0 a4a4720 0 9212b6c8 0 S 100002 207 0 a4a4778 0 8dd93860 a4a2f68 HDR+X 5004c0 1ac0c 0 a4a4828 0 8dd93860 a4a3438 HDR+X 500d0c 1ac0c K- 1 a4a4930 0 8dd90db8 a4a92c0 IS 500019 0 0 a4a4988 0 8dd9e300 a4a6fb0 HDR+X 2002aa 0 0 a4a49e0 0 921136e0 a4a9420 HDR+X 2003a9 0 0 a4a4a38 0 8a4049e8 a4a5c70 HDR+X 5001be 127530f 0 a4a4a90 0 8dd9e300 0 S 100002 207 0 a4a4ae8 0 921136e0 a4a4cf8 HDR+X 500d0c 1a812 K- 1 a4a4b40 0 8dda2608 1048fa00 HDR+X 500cf7 1c0d K- 1 a4a4bf0 0 9212b0b0 0 S 100002 207 0 a4a4c48 0 8a40ee70 13485478 IX 50031b 0 0 a4a4ca0 0 8dd9e300 a4a4988 HDR+X 2002c0 0 0 a4a4cf8 0 921136e0 ec94ae0 HDR+X 500d0b 1a812 K- 1 a4a4d50 0 8dd9e300 a4a6980 HDR+X 500cf7 1c01 K- 1 a4a4da8 0 92108c40 a4aa550 HDR+X 50054c 649707 0 a4a4e58 0 92106198 0 S 100002 207 0 a4a4eb0 0 9212e170 a4aa8c0 HDR+X 20005f 0 0 a4a4f60 0 92118c30 ec93430 HDR+X 500cf8 1c14 K- 1 a4a5010 0 92118c30 a4a4f60 IX 5004c0 0 0 a4a5068 0 92108c40 11c89320 IS 500019 0 0 a4a50c0 0 8a3fc9f0 0 S 100002 207 0 a4a5118 0 92108c40 a4a5bc0 IX 5003e3 0 0 a4a5170 0 8a401f40 a4a7530 HDR+X 500d0b 1ab11 K- 1 a4a51c8 0 8a4049e8 a4a5d78 IS 500019 0 0 a4a5220 0 8a3ff498 a4a3ee0 HDR+X 5001be 1274c05 0 a4a5278 0 92108c40 a4b4108 HDR+X 500ddd 649707 K- 1 a4a5328 0 8dd93860 a4a5f88 HDR+X 500cf6 1d02 K- 1 a4a5380 0 8dd8e310 a4a3f38 HDR+X 5008f2 127500c K- 1 a4a53d8 0 8dd93860 a4a6b90 HDR+X 5004c0 1ac0b 0 a4a5430 0 92118c30 ec955e0 H

UPDATE STATISTICS? -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "Gary Quiring" <gquiring@gmail.com> wrote in message news:1150128278.102693.150550@j55g2000cwa.googlegroups.com... > We went live today with 9.4UC7 from 7.31. It is a new server with 9.4. > We are seeing huge record lock issues in our 4GL programs. We tested > in a dev environment and did not see any issues.... Anyone have any > ideas?? > > Thanks > Gary > > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up > 04:13:58 -- 25> 00608 Kbytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 29336313 46320280 1708251104 98.31 970310 3907147 8701514 98.64 > > isamtot open start read write rewrite delete commit > rollbk > 381726294 6318487 39908101 189918079 2985913 1000441 43825 119688 > 136 > > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs > 0 0 0 0 0 0 0 > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 28530.13 2794.44 27 54 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 6832888 47 18355927 0 0 182 47923 16258270 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 3188061 60356 18694454 21939293 272877 > > > > onstat -k> > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line -- Up > 04:15:27 -- 25> 00608 Kbytes > > Locks > address wtlist owner lklist type tblsnum rowid > key#/bsiz > a4a2d58 0 8a411300 0 HDR+S 100002 207 0 > a4a2db0 0 8dd93860 a4a7060 HDR+X 2001d8 0 0 > a4a2e08 0 8a3ff498 a4a6f00 HDR+X 5001be 1274c06 0 > a4a2e60 0 92118c30 a4a31d0 HDR+X 500d0b 1ab0b K- 1 > a4a2eb8 0 8a3ff498 ec95740 HDR+X 5001be 1274c09 0 > a4a2f10 0 9211c920 0 S 100002 207 0 > a4a2f68 0 8dd93860 a4a80e0 HDR+X 500d0c 1ac0b K- 1 > a4a2fc0 0 8a41c9d0 a4a9948 IS 500019 0 0 > a4a3018 0 8a407490 0 S 100002 207 0 > a4a30c8 0 9211e180 0 S 100002 207 0 > a4a3120 0 9211db68 0 S 100002 207 0 > a4a3178 0 8dd9e300 a4a3490 HDR+X 500d0b 1ab0f K- 1 > a4a31d0 0 92118c30 a4a5010 HDR+X 5004c0 1ab0b 0 > a4a32d8 0 8dd9b858 a4abec0 HDR+X 500ddc 649701 K- 1 > a4a3388 0 8a413178 0 S 100002 207 0 > a4a3438 0 8dd93860 a4a4778 HDR+X 500d0b 1ac0c K- 1 > a4a3490 0 8dd9e300 a4a4670 HDR+X 5004c0 1ab0f 0 > a4a34e8 0 8a419f28 0 S 100002 207 0 > a4a3540 0 8dd83870 0 S 100002 207 0 > a4a3598 0 8a40f488 0 S 100002 207 0 > a4a35f0 0 8a40c9e0 0 S 100002 207 0 > a4a3648 0 8dd7e320 0 S 100002 207 0 > a4a36f8 0 8dd80dc8 0 S 100002 207 0 > a4a37a8 0 8a4149d8 1048c778 HDR+X 5001be 1274c0b 0 > a4a3800 0 8dd80dc8 a4a8a28 IX 5001be 0 0 > a4a38b0 0 8dd9e300 a4a4d50 HDR+X 500cf8 1c01 K- 1 > a4a3908 0 8a417480 a4a8298 IX 5004b1 0 0 > a4a3960 0 8dd9b858 0 S 100002 207 0 > a4a39b8 0 8dd9e300 a4a6c98 IS 500019 0 0 > a4a3a10 0 8a4049e8 a4a51c8 IX 5001be 0 0 > a4a3a68 0 92128608 13485bb0 IS 500019 0 0 > a4a3ac0 0 8dd86318 0 S 100002 207 0 > a4a3bc8 0 921079f8 0 S 100002 207 0 > a4a3c20 0 9211f9e0 10491d68 HDR+X 20017f 0 0 > a4a3d80 0 8a4149d8 134842f0 HDR+X 5001be 1274c0c 0 > a4a3dd8 0 8a411f30 0 S 100002 207 0 > a4a3e30 0 8dd8e310 11c88c40 IX 5001be 0 0 > a4a3ee0 0 8a3ff498 11c8b738 HDR+X 5008f2 1274c0a K- 1 > a4a3f38 0 8dd8e310 a4a3e30 HDR+X 5001be 127500c 0 > a4a3fe8 0 92114f40 0 S 100002 207 0 > a4a4040 0 8a401f40 a4a7270 HDR+X 200246 0 0 > a4a4098 0 921036f0 0 S 100002 207 0 > a4a41a0 0 8a3fe250 0 S 100002 207 0 > a4a41f8 0 92129e68 ec94fb0 HDR+X 500d0c 1a905 K- 1 > a4a4250 0 8dda0da8 a4a5ab8 IX 5001be 0 0 > a4a42a8 0 92118c30 ec93328 HDR+X 5004c0 1ab0c 0 > a4a4300 0 8dd93860 ec92720 IS 500019 0 0 > a4a4358 0 8a406e78 a4a5a60 HDR+X 500cf8 1c0b K- 1 > a4a43b0 0 92104f50 1048eea8 HDR+X 500d0b 1aa04 K- 1 > a4a4408 0 9210b6e8 0 S 100002 207 0 > a4a44b8 0 8a3f9f48 0 S 100002 207 0 > a4a4510 0 92120c28 0 S 100002 207 0 > a4a4568 0 9211b0c0 0 S 100002 207 0 > a4a45c0 0 92100630 13482a88 HDR+X 50054c 648f12 0 > a4a4618 0 9211d550 11c8a920 IX 50024e 0 0 > a4a4670 0 8dd9e300 a4a38b0 IX 5004c0 0 0 > a4a46c8 0 8a401928 13485898 S 100002 201 0 > a4a4720 0 9212b6c8 0 S 100002 207 0 > a4a4778 0 8dd93860 a4a2f68 HDR+X 5004c0 1ac0c 0 > a4a4828 0 8dd93860 a4a3438 HDR+X 500d0c 1ac0c K- 1 > a4a4930 0 8dd90db8 a4a92c0 IS 500019 0 0 > a4a4988 0 8dd9e300 a4a6fb0 HDR+X 2002aa 0 0 > a4a49e0 0 921136e0 a4a9420 HDR+X 2003a9 0 0 > a4a4a38 0 8a4049e8 a4a5c70 HDR+X 5001be 127530f 0 > a4a4a90 0 8dd9e300 0 S 100002 207 0 > a4a4ae8 0 921136e0 a4a4cf8 HDR+X 500d0c 1a812 K- 1 > a4a4b40 0 8dda2608 1048fa00 HDR+X 500cf7 1c0d K- 1 > a4a4bf0 0 9212b0b0 0 S 100002 207 0 > a4a4c48 0 8a40ee70 13485478 IX 50031b 0 0 > a4a4ca0 0 8dd9e300 a4a4988 HDR+X 2002c0 0 0 > a4a4cf8 0 921136e0 ec94ae0 HDR+X 500d0b 1a812 K- 1 > a4a4d50 0 8dd9e300 a4a6980 HDR+X 500cf7 1c01 K- 1 > a4a4da8 0 92108c40 a4aa550 HDR+X 50054c 649707 0 > a4a4e58 0 92106198 0 S 100002 207 0 > a4a4eb0 0 9212e170 a4aa8c0 HDR+X 20005f 0 0 > a4a4f60 0 92118c30 ec93430 HDR+X 500cf8 1c14 K- 1 > a4a5010 0 92118c30 a4a4f60 IX 5004c0 0 0 > a4a5068 0 92108c40 11c89320 IS 500019 0 0 > a4a50c0 0 8a3fc9f0 0 S 100002 207 0 > a4a5118 0 92108c40 a4a5

Neil Truby wrote: > UPDATE STATISTICS?> My problem is dostats. I am running an older copy. The current version core dumps on my 9.4. I didn't know it was dependent on versions. I ran update stats high on critical tables which seems to somewhat fix the problems. Do I need to do anything with the sysmaster? Thanks Gary

Gary Quiring wrote: > Neil Truby wrote: > > UPDATE STATISTICS?> > > My problem is dostats. I am running an older copy. The current > version core dumps on my 9.4. I didn't know it was dependent on > versions. I ran update stats high on critical tables which seems to > somewhat fix the problems. Do I need to do anything with the > sysmaster? > > Thanks > Gary I called IBM. I was not dostats. The first support person did not see it right, 2nd call in they figured it out. It was the OPTCOMPID was set to 2 which was doing many reads sequentially even though we had indexes and update stats was properly run. Changing it to 0 resolved the problems. THANK YOU IBM!!!