AllExperts > Ingres 
Search      
Ingres
Volunteer
Answers to thousands of questions
 Home · More Ingres Questions · Answer Library  · Encyclopedia ·
More Ingres Answers
Question Library

Ask a question about Ingres
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Jean-Pierre Zuate
Expertise
Any questions about database Ingres (owned by Computer Associates then Ingres Corp) : - Ingres 6.4 - OpenINGRES from 1.0 to 2.0 - IngresII from 2.0 to 2.6 - Ingres R3, Ingres 2006 (Open Source version) - All tool around Ingres : ABF, Report Writer, Replicator, OpenROAD (3.5 to 2006), Ingres/NET Ingres/STAR, ...

Experience
16 years of computing experience as :
- AS400 programmer
- AIX / Ingres administrator and developer (OpenROAD and korn shell)
- Ingres DataBase Administrator
- Ingres expert - Data modelisation - ETL - Reporting - Many of Computer Associates sofwares - ITIL / CMDB / Change Management

Organizations
http://lafageconseil.fr

 
   

You are here:  Experts > Computing/Technology > Databases > Ingres > ingres down

Ingres - ingres down


Expert: Jean-Pierre Zuate - 9/21/2007

Question
dear Mr.Zuate i have installed ca scm with ingres on my windows 2003 sp2 storage server since the begining of the year, ever since almost every 2 weeks ingres notifies me that it's partially started and i had to restart my server in order for ingres to work, 2days ago ingres was completely down and CA support suggested to replace it with sql. what do u think i should do knowing that i only have 40 users ?

Answer
Hello,

No comment about the CA support response (for Ingres replacement). When you said "replace it with sql" you mean MS SQL I guess ?

What can be interesting is to know why you Ingres installation partially shut. Can you send me by email a zipped version of your errlog.log file (check in %II_SYSTEM%\ingres\files) ? My corporate email is jean-pierre.zuate@lafageconseil.fr

The users you have probably doesn't matter because tools like CA USM deal with their own database connection. The tool maintain perhaps 5 or 10 or more or less connections to the DB and then many users (40 for you) are connected to the tool. Not directly to Ingres (usualy).

Hope this help.

Best regards,
Jean-Pierre ZUATE

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.