Hi dudes,
I'm trying to write a small forms based application and wanted to use
compiled forms as the application had no reason to connect to any
database at all.

Hi folks,
I want to ask for help to get a checklist to improve the performance of my
database.
My server don't even use 5% of processor and 10% of memory and the

We use Ingres II 2.0/0011 on VMS 7.2-3.
This morning we redirected and redefined the logical of the II_WORK
location to point at a new location on a different disk. We changed the
logicals online and also in the command procedure that is run when the

Telegram arrived this morning...
The new Australian Ingres Corp support number is  1800 614 435
Paul White
OpenROAD Users List Admin

I've been reading another thread in this group on extending the
transaction log and saw the discussion on the cp_timer parameter.
On Adv.Ingres 2.6 - hp-ux Itanium, we've been setting the
archiver_interval to 2 and cp_interval to 1. Transaction log size : 5

We are experiencing occasional slowdowns in the database and in most of
those slow periods, we see multiple lines like the following:
25-JAN-2006 08:20:28.80 Sem Wait: pid 21401456 ses 1beddee0, spid
21401455 sses 1c356ae0 adr bf4090 t 1 s 1 LK RSB mutex     1038

The end of daylight saving time for Australia will be extended by a
week to 2/4/2006.  I have a patch from Microsoft for the OS and also an
update for the HP-UX.  I am currently waiting for my account to be
created on Ingres support, however wanted to know what thoughts people

  Does anyone have any information pertaining to if Ingres R3 uses more
tr log space than 2.6... in what contexts... what % more... etc.
And a follow-up question to that...
 We are considering increasing the size of the tr log which is

hi , i m programig a c admin tool that play whith the imadb database, im
know what resource_id are locks and who lock but not what table
somebody can say me how go to table from resource_id
thx

We have an Ingres 2.0 server installation on Alpha OpenVMS 7.3-2.  We
have configured Windows XP clients running Ingres 3.0.2 Ingres/NET to
talk to this server.  Installation passwords have been implemented (and
these work from other servers).  We have no passwords required on the

Hi Dudes and Dudettes,
What are peoples thoughts on the IngresCorp support web site?
Here are a few of my thoughts.
1. The login screen user/password doesn't remember me. Which is

O.S. SunOS
Ingres: Ingres SPARC SOLARIS Version II 2.6/0305 (su4.us5/00)
Is there a way to unextend a database?
I have a multi location database and want to get rid of one of the

I have a problem with an update statement I'm porting from Microsoft
SQL.
I have to update an element in a table with a value taken from another
table where i want to use a default value if the element in the other

We've got a problem here with BAD_FILE_PAGE_ADDR on the ii_encodings
catalog.  Since this holds encoded 4GL frames and procedures, is it
possible to rebuild it without having to do a rollforward (this hasn't
been spotted for a while so we'd have to go back to an old backup to get

the INGRES 6.4 manual set I mentioned in a previous post is destined for
the skip on Friday morning (UK time...). If anyone actually wants them,
let me know before then.
Roy Hann has apparently recently shipped a similar set to the US and