Too many entries in sysprocplan table

Hi everybody, I've got an OLT system and unbuffered logging database, which suddenly started to make backups of logical logs quite very often, although there wasn't too much activity. I analized the problem following this steps: 1. I learnt the logs backuped with onlog tool. One of them was HINSERT and the other was ADDITEM. In both cases I saw in hexa the same tblspace number. After of this entries were HDELETE and DELITEM. The most entries in the logical log analized was the same tblspace number. 2. Tblspace number, but in hexa, is the same value that the partnum column of systable. Then, I saw that it was the sysprocplan table. 3. I checked the number of inserted rows, and they gave me near of 800 distribuited in 30 store procedure, aprox. which wouldn't to be so much. I execute the update statistics for all store procedure and tables, but didn't work. We realized to imporve a little if we change the optimization to SET OPTIMIZATION LOW. But this, where does it set? Because in the create procedure isn't show if it's low or high. Is this a parameter of onconfig file? Which is the SET OPTIMIZATION default? I hope you can help me. Thanks very much. Paola ------------------------------------------------- This mail sent through IMP: http://mail.info.unlp.edu.ar/

Have you aver done a drop distributions during an update statistics? Not positive, but isn't this one of those gotchas with sysprocplan? Anybody? cheers j. ----- Original Message ----- From: <pamadeo@info.unlp.edu.ar> To: <ids@iiug.org> Sent: Thursday, February 05, 2004 1:09 PM Subject: Too many entries in sysprocplan table [2518] > > > Hi everybody, I've got an OLT system and unbuffered logging database, which > suddenly started to make backups of logical logs quite very often, although > there wasn't too much activity. > I analized the problem following this steps: > 1. I learnt the logs backuped with onlog tool. One of them was HINSERT and the > other was ADDITEM. In both cases I saw in hexa the same tblspace number. After > of this entries were HDELETE and DELITEM. The most entries in the logical log > analized was the same tblspace number. > 2. Tblspace number, but in hexa, is the same value that the partnum column of > systable. Then, I saw that it was the sysprocplan table. > 3. I checked the number of inserted rows, and they gave me near of 800 > distribuited in 30 store procedure, aprox. which wouldn't to be so much. > > I execute the update statistics for all store procedure and tables, but didn't > work. > > We realized to imporve a little if we change the optimization to SET > OPTIMIZATION LOW. But this, where does it set? Because in the create procedure > isn't show if it's low or high. Is this a parameter of onconfig file? Which is > the SET OPTIMIZATION default? > > I hope you can help me. > > Thanks very much. > Paola > > > > ------------------------------------------------- > This mail sent through IMP: http://mail.info.unlp.edu.ar/ >