Re: Chatr on HPUX and Informix

En Susan Elliott (ISG) va escriure el dia 7 Nov 99, a les 17:11: > > Howdy Folks, > > We have just recently upgraded our database from 7.24uc5 to 7.30 uc7. > We are running on HPUX 10.20, Application is Baan. > > Since we have performed this upgrade, we are expierencing the database > gradually becoming slower and slower. Load averages on the top > display are getting higher over the period of the day (around 5) which > is pretty high for our system. The database seems to require more > than 900 meg of memory as it seems to dynamically allocate more > segments. B4 the upgrade we were using below the 900meg mark. I have > been advised to alter the Informix binaries with "chatr -M" I have > tested this on a test system but I am getting error messages on > startup of DB. I am wondering if I have missed something.... > > Has anyone already set up / using this on a HPUX system, using more > than 1 gb of shared memory (7.30 Uc7). > > Would you please advise the process you used / followed?? What issues > did you come across implementing chatr ?? > > > TIA > > Regards > Suze. > > > Please refer to the attached copy of my online.log > > > Fri Nov 5 14:02:19 1999 > > 14:02:19 Informix Dynamic Server Stopped. > 16:00:52 Segment locked: addr=0x40000000, size=956596224 > 16:00:52 The number of configured CPU poll threads exceeds> 'NUMCPUVPS'. > NETTYPE 'baantcp' poll threads started on NET VPs. > > > Sun Nov 7 16:00:52 1999 > > 16:00:52 Event alarms enabled. ALARMPROG = > '/opt/informix/etc/ifx_alarm.sh' > 16:00:58 DR: DRAUTO is 0 (Off) > 16:00:58 Requested shared memory segment size rounded from 588KB to> 592KB 16:00:59 Informix Dynamic Server Version 7.30.UC7 Software > Serial Number AAC#J578294 16:01:00 Informix Dynamic Server > Initialized -- Shared Memory Initialized. 16:01:00 Physical Recovery > Started. 16:01:00 Physical Recovery Complete: 0 Pages Restored. > 16:01:00 Logical Recovery Started. 16:01:03 Logical Recovery > Complete.> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 16:01:03 Onconfig parameter LTAPEDEV modified from /dev/rmt/0m to > /dev/null. 16:01:03 Dataskip is now OFF for all dbspaces 16:01:03 > HPUX Version B.10.20 -> Using flag/select style KAIO 16:01:04> On-Line Mode 16:01:04 Checkpoint Completed: duration was 1 seconds. > 16:01:54 Informix Dynamic Server Stopped.> > I altered the onconfig for SHMVERT to be approx 1200 meg and started > the intance. Error messages below. > > 16:05:00 shmat: [EINVAL][22]: shared memory base address illegal > > 16:05:00 using 0x60000000, needs 0xc1483000 > > 16:05:00 Could not create single shared memory segment with resident> and non-resident par > > titions. Proceeding to create 2 shared memory segments instead. > 16:05:03 Segment locked: addr=0x40000000, size=117719040 > 16:05:03 shmat: [EINVAL][22]: shared memory base address illegal > > 16:05:03 using 0x67044000, needs 0x80000000 > > 16:05:03 mt_shm_init: can't create virtual segment> > uxfgrn4:/opt/informix> > > > Susan Elliott > ______________________ > Host Team Leader > Information Services Group > Concrete Group > * (09) 520 8608 > * susane@fclcis.co.nz > > > If I am not mistaken I believe that when passing from the version 7.2X.XXX to 7.3X.XXX yield problems exist. I believe to remember that the advice given to solve this problem is: erase the indexes create the indexes of New. Update statistics (you don't forget this) Be happy. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------