recover from a bad disk

We have an Ingres installation on a Digital Unix 4.0, with 2 drives:
Disk A: /local/ingres
Disk B: /local/ingres/data

Lately Disk B went bad. I created "/local/ingres/data" on Disk A and
recovered the data from backup take into this location. File/owner
permissions are set as before (owned by ~ingres and have directories
700 and files 600). Then I restarted the Ingres DBM. Now when I try
to get to Database it complains:

"E_US002B Could not open the iidbdb database"

Any hint what this could be and how shall I get it to work?

Thanks in advance!

Zhiliang

Hi Zhiliang

Good old Alpha Unix - most important thing is you have a
backup :-)

First login as ingres and have a look at the file ~/files/
errlog.log (%II_SYSTEM%/ingres/files/errlog.log)

In here you will see a more detailed reason as to why the system
cannot open the iidbdb database. This should be your first point of
call in diagnosing what is wrong with the system. The command infodb
may also display further information. I'm wondering if you've got an
error of inconsistent database or something - but first we need to
know what your errlog.log file contains. Post that information and
people can give you more pointers.

Cheers

Gary

Nice to know someone else are also using Ingres/Alpha machines.

Never realize error logs are in /files/, not in /log/, something
learned ;-)
Now I figured out by looking at the error log, that I missed out /
default/ layer
in ~ingres/data/default/iidbdb. Now it's back to life!

Many thanks!!

Zhiliang

On Aug 22, 2:59 pm, ghing...@yahoo.co.uk wrote:
> Hi Zhiliang
>
> Good old Alpha Unix - most important thing is you have a
> backup :-)
>
> First login as ingres and have a look at the file ~/files/
> errlog.log (%II_SYSTEM%/ingres/files/errlog.log)
>
> In here you will see a more detailed reason as to why the system
> cannot open the iidbdb database. This should be your first point of
> call in diagnosing what is wrong with the system. The command infodb
> may also display further information. I'm wondering if you've got an
> error of inconsistent database or something - but first we need to
> know what your errlog.log file contains. Post that information and
> people can give you more pointers.
>
> Cheers
>
> Gary

Hello,
Could someone please tell me what the Ingres equivalent of Memo field is?
We need a text field to contain notes of up to any length, accepting thatit will not be searchable.
Many Thanks & Regards,
Phil
__________________________________________________ _______________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q...n-US&form=QBRE

Hello again,
Has anyone experienced running an Ingres database on a Virtual Server (in our case Windows 2003) in a VMWare environment on an ESX Server?
I guess that it must have pros and cons.. can anyone give their experience or recommendations please?
Many Thanks,
Phil
__________________________________________________ _______________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q...n-US&form=QBRE

Phil Hudson wrote:

> Hello,
> Could someone please tell me what the Ingres equivalent of Memo field is?
> We need a text field to contain notes of up to any length, accepting that it will not be searchable.

LONG VARCHAR maybe?

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to http://www.iua.org.uk/join to get on the mailing list.

Phil Hudson wrote:

> Hello again,
> Has anyone experienced running an Ingres database on a Virtual Server (in our case Windows 2003) in a VMWare environment on an ESX Server?
> I guess that it must have pros and cons.. can anyone give their experience or recommendations please?

I've not got a live production system running on VMWare, but it is
certainly a promising idea, as this somewhat related posting points out:

http://groups.google.com/groups?as_u...oglegroups.com

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to http://www.iua.org.uk/join to get on the mailing list.

Hi Phil,



I'm running quite a few small scale production installations on VMWare
with no problems whatsoever. And quite frankly, I didn't really expect
any. To my knowledge Ingres is actually developed on a virtual host.



The hosts I use for my production sites use 64 bit Linux RHEL5. The
Ingres versions are a mixture of Ingres2006R1 and R2, but I have no
doubt that older versions would be cool.



The databases are all <10G in size with only small scale transaction
processing. I'd be hesitant on a system with significant interactive
activity, but I'd have little qualm rolling this out on batch oriented
systems with much larger databases.



In short...It works.



Martin Bowes

From: info-ingres-bounces-at-kettleriverconsulting.com
[mailto:info-ingres-bounces-at-kettleriverconsulting.com] On Behalf Of Phil
Hudson
Sent: 25 August 2008 13:38
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Ingres with VMWare




Hello again,
Has anyone experienced running an Ingres database on a Virtual Server
(in our case Windows 2003) in a VMWare environment on an ESX Server?
I guess that it must have pros and cons.. can anyone give their
experience or recommendations please?
Many Thanks,
Phil



________________________________

Discover the new Windows Vista Learn more!

Phil,

I have the following experience:

- Development Ingres installations (2006) on a VMWare virtual machine running Windows 2000/2003R2 and 64-bit RedHat 5.0 (Linux)
- Development Oracle installation on a VMWare virtual machine running Linux

I haven't run a production Ingres or Oracle server on a VMWare virtual machine.
Most of my production servers are heavily I/O oriented, an the whitepapers I've
read about running I/O intensive SQL Servers on virtual machines haven't been glowing.

I guess it depends on

- the iron you run it on
- how much performance you need
- your I/O platform. A good NetApp properly provisioned on the back end will help immensely

Cheers,

Mike Leo


Phil Hudson wrote:
>
> Hello again,
> Has anyone experienced running an Ingres database on a Virtual Server
> (in our case Windows 2003) in a VMWare environment on an ESX Server?
> I guess that it must have pros and cons.. can anyone give their
> experience or recommendations please?
> Many Thanks,
> Phil

Hi All,

Side-issue...

Has anyone heard of systems under vmware environments gaining time?

Ingres is running fine, just SuSE linux running in a vmware set up is
gaining about an hour a day.

Regards,
Andrew.