Syslocks table

Hello, We just upgraded to 7.31FC4 on HPUX. Everything seems to be working fine except for a few lock overflows when trying to load a table. We currently have 50,000 locks on the system and are trying to load in about 30,000 records. We are averaging about 30 - 50 locks during normal use. The settings are the same as the previous version since we didn't need to do much tweaking (yet). While researching the overflow problem I found that the syslocks table doesn't contain any entries in it. When checking the status it shows a null value for Number of Rows. Of course our 'onlocks' utility is a bust since it reads from this table; however the onstat -k seems to show the correct values. I say correct but I don't have any way to check it. I have seen a few posts about the syslocks issue but nothing referring to lock overflows. I've RTFM concerning performance and upgrading in case of something different with the 64-bit but I can't find an answer. My next step is support but I know that can take awhile. Any ideas? TIA Brian Sent via Deja.com http://www.deja.com/ Before you buy.

Hi Brian , Brian Fink wrote in message <8nka3b$s1c$1@nnrp1.deja.com>... |Hello, | |We just upgraded to 7.31FC4 on HPUX. Everything seems to be working |fine except for a few lock overflows when trying to load a table. We |currently have 50,000 locks on the system and are trying to load in |about 30,000 records. We are averaging about 30 - 50 locks during |normal use. The settings are the same as the previous version since we |didn't need to do much tweaking (yet). Are you taking into account the number of indexes that the table has. If you have no indexes you require 30,000 locks for the insert. If you have 1 index you need another 30,000 locks. Total 60,000 and so on. |While researching the overflow problem I found that the syslocks table |doesn't contain any entries in it. When checking the status it shows a |null value for Number of Rows. Of course our 'onlocks' utility is a |bust since it reads from this table; however the onstat -k seems to |show the correct values. I say correct but I don't have any way to |check it. I have seen a few posts about the syslocks issue but nothing |referring to lock overflows. I've RTFM concerning performance and |upgrading in case of something different with the 64-bit but I can't |find an answer. My next step is support but I know that can take awhile. Only suggestion is to ring tech support. Sorry. Maybe some body else can help on this one. |Any ideas? | |TIA | |Brian Hope this helps Cheers Pankaj

This is a business critical problem. Tell the tech support engineer you want the case elevated to a priority level 2 (3 is default, 4 non-critical, 1 the engineer does not get to go home until your problem is solved or he can hand off to a higher level engineer who is then in the same boat). Art S. Kagel Brian Fink wrote: > > Hello, > > We just upgraded to 7.31FC4 on HPUX. Everything seems to be working > fine except for a few lock overflows when trying to load a table. We > currently have 50,000 locks on the system and are trying to load in > about 30,000 records. We are averaging about 30 - 50 locks during > normal use. The settings are the same as the previous version since we > didn't need to do much tweaking (yet). > While researching the overflow problem I found that the syslocks table > doesn't contain any entries in it. When checking the status it shows a > null value for Number of Rows. Of course our 'onlocks' utility is a > bust since it reads from this table; however the onstat -k seems to > show the correct values. I say correct but I don't have any way to > check it. I have seen a few posts about the syslocks issue but nothing > referring to lock overflows. I've RTFM concerning performance and > upgrading in case of something different with the 64-bit but I can't > find an answer. My next step is support but I know that can take awhile. > > Any ideas? > > TIA > > Brian > > Sent via Deja.com http://www.deja.com/ > Before you buy.

Hi Art , How did you come to that conclusion ? Just want to know if my posting is wrong in my understanding of the way Informix locking works. Cheers Pankaj Art S. Kagel wrote in message <39A2DDC3.74A54842@bloomberg.net>... |This is a business critical problem. Tell the tech support engineer you |want the case elevated to a priority level 2 (3 is default, 4 non-critical, |1 the engineer does not get to go home until your problem is solved or he |can hand off to a higher level engineer who is then in the same boat). | |Art S. Kagel | |Brian Fink wrote: |> |> Hello, |> |> We just upgraded to 7.31FC4 on HPUX. Everything seems to be working |> fine except for a few lock overflows when trying to load a table. We |> currently have 50,000 locks on the system and are trying to load in |> about 30,000 records. We are averaging about 30 - 50 locks during |> normal use. The settings are the same as the previous version since we |> didn't need to do much tweaking (yet). |> While researching the overflow problem I found that the syslocks table |> doesn't contain any entries in it. When checking the status it shows a |> null value for Number of Rows. Of course our 'onlocks' utility is a |> bust since it reads from this table; however the onstat -k seems to |> show the correct values. I say correct but I don't have any way to |> check it. I have seen a few posts about the syslocks issue but nothing |> referring to lock overflows. I've RTFM concerning performance and |> upgrading in case of something different with the 64-bit but I can't |> find an answer. My next step is support but I know that can take awhile. |> |> Any ideas? |> |> TIA |> |> Brian |> |> Sent via Deja.com http://www.deja.com/ |> Before you buy.