Was this helpful?
Facility Codes
Ingres facility codes consist of a two-character code that is generated by a particular facility. For example, the Abstract Data Type Facility has a facility code of AD so error messages generated by this facility have an error message format of:
E_ADxxxx_msg
Error messages often include an explicit reference to which internal function returned the error. A list of these modules and their functions can help you identify the source of errors requiring troubleshooting.
Facility Codes for Primary Components
The facility codes for the primary Ingres components, such as the DBMS Server and General Communications Facility, are shown in the following table:
Facility Code
Facility
AD
Abstract Data Type Facility (ADF)
DM
Data Manipulation Facility (DMF)
DU
Database Utility Facility (DUF)
GC
All General Communication Facilities (GCF), including:
Communications Server (GCC)
General Communications Area (GCA)
Name Server (GCN)
OP
Optimizer Facility (OPF)
PS
Parser Facility (PSF)
QE
Query Execution Facility (QEF)
QS
Query Storage Facility (QSF)
RD
Relation Description Facility (RDF)
SC
System Control Facility (SCF)
US
User Errors
Server-Only Components
The server-only components are mostly DMF routines. The facilities listed in the following table are all subcomponents for Compatibility Library (CL) and do not appear in the facility-code part of an error message. All messages involving these facilities start with E_CL, and usually contain the two-letter facility code in the abbreviated message part of the error text.
Facility Code
Name
Description
Used By
CS
Central System
Control of server
SCF, Utilities
DI
Database I/O
Access to Database files (different from SI)
DMF, Utilities
JF
Journal Files
Access to Journal files (different from DI)
DMF, Utilities
LG
Logging
Server logging (transaction log)
DMF
LK
Locking
DBMS data locking
DMF, Utilities
SR
Sorting
Sorting for queries
DMF
TR
Tracing
DBMS event tracing
Server components
Tools-Only Components
The Ingres Tools-only components are shown in the following table:
Facility Code
Name
Description
Used By
AR
ABF Runtime
Application-By-Forms runtime component
ABF
DY
Dynamic Utilities
Dynamic linking
ABF
OL
4GL Support
Produce Ingres 4GL object code
ABF
PC
Process Control
Fork, sleep, exit, and so forth
Tools components
PE
Permissions
Object access authority
Tools components
TE
Terminal Driver
Terminal I/O
Tools terminal driver
UT
Utility Invocation
Compile, link, call, print, and so forth
Tools components
Components for Stream File Management
Ingres components for stream file management are shown in the following table. The facilities listed below are all subcomponents for Compatibility Library (CL ) and do not appear in the facility-code part of an error message. All messages involving these facilities start with E_CL, and usually contain the two-letter facility code in the abbreviated message part of the error text.
Facility Code
Name
Description
Used By
CP
Switch protections
Special-purpose file permissions handling
auditdb
LO
Locations
Abstract file system support (hierarchical)
Tools components
SI
Stream I/O
Stream functions
Tools components
Components for Utility Routines
Ingres components for utility routines are shown in the following table:
Facility Code
Name
Description
Used By
CI
Authorization
Authorization string interpretation
Server and Tools components
ER
Error Messages
Error Message Handling/supports international
Server and Tools components
EX
Exception Handling
Establish routine chaining
All
GC
GCA CL
GCA (IPC) support
All
GV
Global Variables
Global symbols (Release ID, date, and so forth)
All
ID
Object IDs
User identifications
Usually Tools components
ME
Memory Allocation
Memory management
Usually Tools components
NM
Logical Symbols
Logical symbol management
(or simulation)
All
QU
Queue Manipulation
Management of queues
All
TM
Timing
Timing services
All; some timing is server only
Miscellaneous Components
Miscellaneous components are shown in the following table:
Facility Code
Name
Description
Used By
BT
Bit Manipulation
Utility routines to test, set, clear bits
All
CM
Character Manipulation
Character handling and for Kanji support
All
CV
Conversion
Convert internal representations
All
MH
Math
Functions (tan, ln, log, exp, and so forth)
All
ST
String Handling
Utilities for string operations
All
Last modified date: 01/30/2023