You are here:

Ingres/Ingres descriptor block

Advertisement


Question
Hi Jean,

I'm back again. I am bothered with this Ingres error
message that sometimes halt our operation.

Here are the error messages...
E_RD0043 No more space in cache to build or extend a
descriptor block.
E_UL0104 No more space in the hash table.
E_PS0F01 The descriptor cache is currently full. Try again
later.

A restart on the server fix the problem. But i just want to
know what causes the error and if there are ways to
increase this descriptor cache.

Thanks in advance,
JB  

Answer
Hello JB,

Nice to read you again :-)

It seems your RDF resources are exhausted (RDF stand for Relational  Data Facility, ie it retain your table & index definition).

Please read this link http://www.webservertalk.com/archive288-2005-3-947500.html for knowladge.

I suggest you to "play" with one of these parameter :
rdf_max_tbls
rdf_memory
rdf_tbl_cols
rdf_tbl_synonyms

particulary rdf_max_tbls (depend on how many tables you have in your DB).

Hope this help you,
Regards,
Jean-Pierre ZUATE
http://lafageconseil.fr

Ingres

All Answers


Answers by Expert:


Ask Experts

Volunteer


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) - Ingres 9.x, Ingres 10.x - 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

Education/Credentials
Computing bachelor (1989)

Past/Present Clients
More than 100 customers during my 6 years of CA has an Ingres consultant, all around France and Africa (Togo, Cameroon, Morrocco, ...)

©2012 About.com, a part of The New York Times Company. All rights reserved.