Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in


   Database Forums (Home) -> Ingres RSS
Next:  can't create database cause access failure in db2..  
Author Message
Tim Ellis


Since: Feb 25, 2005
Posts: 21

(Msg. 1) Posted: Fri Aug 05, 2005 8:42 am
Post subject: E_DM9063_LK_TABLE_MAXLOCKS
Archived from groups: comp>databases>ingres (more info?)

We have a weekly job that takes a COPY.OUT from the "Live" database and
then does a COPY.IN to a development database in a separate
installation. I've noticed that in one instance, the ERRLOG is getting
a number of messages of the general form
"E_DM9063_LK_TABLE_MAXLOCKS Current logical lock ( 11 ) on resource
iihistogram in database test_cars_sol exceeds the specified maximum (
10 ). Escalating to table level lock"
(this also occurs on iidbdepends, iiqrytext,iirule and iitree (although
in that case the numbers are 51 and 50...)

The CBF parameter system_maxlocks is set to 10 on every installation,
and although there are differences in other parameters (the affected
installation is on a much smaller/less powerful machine) I can't see
any that I would expect to have an effect...

It's not really a problem as such - the job completes, and it runs over
the weekend so even if every escalation causes a delay it does not
prevent the refreshed database being available by Monday morning, but
it does puzzle me as to why it only occurs in this one case...

 >> Stay informed about: E_DM9063_LK_TABLE_MAXLOCKS 
Back to top
Login to vote
Tim Ellis


Since: Feb 25, 2005
Posts: 21

(Msg. 2) Posted: Mon Aug 08, 2005 12:56 pm
Post subject: Re: E_DM9063_LK_TABLE_MAXLOCKS [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Peter,
The process that copies the database ends up with an optimizedb and a
sysmod, so the answer is every week. - a lot of the messages referring
to iihistogram relate to the optimize. However this morning I ran
onother sysmod, followed by an optimizedb which generated no

 >> Stay informed about: E_DM9063_LK_TABLE_MAXLOCKS 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Process hanging on Endselect - We have a process which needs to produce an average figure over the last 16 qualifying weeks. The way it currently works is to select the rows from the two relevant tables ordered by date descending, then in a select loop check if the week qualifies and...

Help fo vnode - I am going to use the ingres replication. For that I have set vnodes using "netutil". I have configured all the things for replication on my local database using repmgr. Now I want to move the Configuration to the Remote Server database. When I...

Help for starting the replication server - I have configured the database for replication using repmgr command I also started the replication server. It is started and its status is active. But there are one error message comming which is related to the authorization of the remote database. Using...

[Info-ingres] vnode puzzle - Hi Dudes, I have a 2.6 installation with several vnodes defined pointing to other installations. All of which test perfectly well using netutil test mode. But when I try to use a simple sql vnode::dbname connection I get the following: sql rat::iidbd...

NAIUA meeting at CA World 2005? - Anyone planning on attending CA World this November? Was hoping to have a NAIUA meeting there, however can't seem to get ahold of Carmen Huff (new pres.) Anyone know if she is planning on attending? Thanks, T. McGraw
   Database Forums (Home) -> Ingres All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum

[ Contact us | Terms of Service/Privacy Policy ]