Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Ingres Topics / August 2008

Tip: Looking for answers? Try searching our database.

recover from a bad disk

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Zhiliang Hu - 22 Aug 2008 15:44 GMT
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 db 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
ghingres@yahoo.co.uk - 22 Aug 2008 20:59 GMT
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
Zhiliang Hu - 23 Aug 2008 01:37 GMT
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
>
[quoted text clipped - 15 lines]
>
> Gary
Phil Hudson - 25 Aug 2008 13:31 GMT
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.
Many Thanks & Regards,
Phil
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
Roy Hann - 26 Aug 2008 08:39 GMT
> 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?

Signature

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 - 25 Aug 2008 13:38 GMT
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=windows+vista&mkt=en-US&form=QBRE
Roy Hann - 26 Aug 2008 08:45 GMT
> 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_umsgid=578de3e9-de80-45eb-99c3-cf1550ea0446@2
7g2000hsf.googlegroups.com


Signature

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.

Paul White - 26 Aug 2008 12:00 GMT
Did anyone else find the link leads to a discussion on parallel query
execution.

This should do the trick
http://groups.google.com/group/comp.databases.ingres/search?q=vmware

I use VMware for development and testing with OpenROAD. I run 2 separate VMs
simultaneously. Performance is pretty good on my laptop. Intel core 2 CPU
T7200 @ 2GHz with 3Gb RAM.

Paul

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com]On Behalf Of Roy
Hann
Sent: Tuesday, 26 August 2008 5:46 PM
To: info-ingres@kettleriverconsulting.com
Subject: Re: [Info-Ingres] Ingres with VMWare

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_umsgid=578de3e9-de80-45eb-99c3-cf1550ea04
46@27g2000hsf.googlegroups.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.

_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.