	AllExperts > Ingres
	Search

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 descriptor block

Ingres - Ingres descriptor block

Expert: Jean-Pierre Zuate - 9/12/2008

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

Add to this Answer Ask a Question