Re: E_DM9063_LK_TABLE_MAXLOCKS

From: "Tim Ellis" <tellis3@xxxxxxx>
Date: 8 Aug 2005 08:56:15 -0700

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
messages...

.

References:
- E_DM9063_LK_TABLE_MAXLOCKS
  - From: Tim Ellis
- RE: [Info-ingres] E_DM9063_LK_TABLE_MAXLOCKS
  - From: Peter Gale

Prev by Date: Re: Fast_commit, sole_server, shared_cache combinations
Next by Date: writing VARCHAR strings including the backslash character into the database 'as is'
Previous by thread: RE: [Info-ingres] E_DM9063_LK_TABLE_MAXLOCKS
Next by thread: Re: [Info-ingres] DBA Job in Hammersmith
Index(es):
- Date
- Thread

Relevant Pages

Re: [Info-Ingres] Adding an index - sysmod still?
... Do I still need to run sysmod on the DB for the statistics to take effect? ... Optimizedb updates/inserts/deletes rows in the system catalogs, ... same way you'd regularly modify a table which had updates on it, ...
(comp.databases.ingres)
RE: [Info-ingres] Re: Problem with network based database connection
... serverwhere shutdown in order to allow the sysmod to run. ... would not shut the net server. ... Subject: Re: Problem with network based database connection ... We did an optimizedb and a sysmod. ...
(comp.databases.ingres)