William's Ingres Reference
To William's HotList
To William's Home Page
Have an Ingres question?
Please try to:
a) Search this site first.
b) Search the CA Technical support site.
c) Search Google News: d) Post to the comp.databases.ingres newsgroup or the Info-Ingres mailing list.
e) Send email to me.
Email William
© William Yuan 2006
In some articles, a familiarity with the particular topics discussed is assumed. Thanks to all the Ingres contributors out there :-)
A B C D E F G H I J K Laaaaaaaa.cnf - Modcnf Program
ABF Index for Compiles
ABF Maintenance Speedup (pre 6.4)
Accessing IIvariables
API Information
Automatic Shutdown
Batch and Online Processing
Btree Corruption (Solaris)
Btree Replace/Updates
Bulk Loading
C Global Variables and their Scope
Cache Lock Parameter
Caching Retrieved Data
Calculating Space for Secondary Indexes
Calling MSaccess from OpenRoad Ingres
Cancel a Running SQL Statement
Cannot Spawn a Subprocess
Case Insensitive Pattern Matching Search
Changing Table Owner
Checkpoint Compression
Checkpoint d*.dmp files
Checkpoint Validity
Checking Ingres Performance
Checkpoint Concerns
Checkpoint Location -- how to change it
Checkpoint Problems
Checkpoint Recovery
Checkpoint to Multiple Devices
Checkpoint to Tape
Checkpointing iidbdb
Colon usage in OpenRoad Ingres
Commit vs Rollback
Comparing Literal Strings
Compensation Log Record
Concurrency Discussion
Consistency Points
Copyin Statement with Null Strings
Copy.in/out Prefixes
Corrupted Table Problem
Create Image Error
Createdb Problem
Createdb Locking Problem
CS Mutex Bug
Cursor Select and Update
Cursors or Select Loops Speed
Data Archiving
Data and System Recovery Strategies
Database events
Database Maintenance and Tuning
Database Ownership Change
Database Parameters
Database Procedures with Deadlock
Database Storage Theory
Date with time (local zone)
Dates and the year 2000
Daylight savings in Ingres
Daylight Savings Timezone on HP
Db_id in aaaaaaaa.cnf
DBA general role
DbCGI Gateway
DBMS Server for Batch jobs
DBMS Server -> Process ID Mapping
Delay in connection to a database
Disallowing Database Access
Disappearing Ingres Environment
Disaster Recovery Plan (example)
Disk Readahead Stats
DM421 & DM1305 Trace Points
DMF cache Configuration/Optimization
DMF cache Stats
DMF reading
DMFRCP on Ingres 6.3/02
DMT_SHOW error
Dropping views from the ii_database partition
Dump files
Dummy (Fast) Checkpoints
Dumping checkpoint files to tape
Duplicate keys in a table (select)
Dynamic forms
E_GCfe05 -- Unable to make outgoing connection
Embedded SQLC example
Errlog Management
Error message
Error 4706
Escape characters
Exporting Ingres data to Oracle
Exporting money fields without $ signs
Extending Database Locations
Fast Commit
Fast Commits and Write Behinds
Field calculations on a form
Field update on a form
Field update using a fieldname variable
Finding the locking process id
Firewalls with Ingres
Float -> Hours and Minutes
Force Consistency Point
Forcing Ingres to Use an Index
Forked Processes from ESQLC
FRS Keymappings
GCC crashing (Ingres 6.3)
GCN -- How does it allocate sessions ?
Global Temporary Tables
GMT Dates
GQL 4
Hashing Algorithm
HTML Front End to Ingres
Ifnull bug (OpenIngres 1.2)
II_DATE_CENTURY_BOUNDARY and II_DATE_FORMAT
II_DATE_FORMAT changing
II_DMFRCP_STOP_ON_INCONS_DB variable
II_GC_PORT/II_GCC_PROT meaning
II_NUM_PROCESSORS
IIacct
Iidbdb locations and updates
IIdbdb journaling
IIgcc connections
IIprotect locking
II_RCP open/close
IIrelation attributes
IIslave processes
IIslaves setting
IItables duplicates
II_POLLDELAY
II_QSWITCH
IMA Query problem on locking info
IMA Sample Scripts
Improving bulk loading speed
Improving Ingres performance
Ingperl extensions
IngPerl + SQL
Ingres Caching and Data Access
Ingres Connection to a network
Ingres Data Sorts
Ingres Disk Setup
Ingres File Basics
Ingres II and OpenIngres
Ingres in a SMP machine
Ingres Installation Problem
Ingres link files
Ingres Net name change
Ingres Net over LAN
Ingres Net over WAN
Ingres Net Ports
Ingres Net Security
Ingres Net with OpenIngres 1.1 bug
Ingres NT Patch Level
Ingres vs Oracle
Ingres Web Access
Ingres with Java
Ingres with RAID
Ingres with RAID support
Ingres + Dec Alpha
Ingres + Powerbuilder Security
ING_SET (OpenIngres 1.2)
Ingres 5 -> 6 upgrade
Ingres 6.4 -> OpenIngres Upgrade
Ingres 6.4 -> OpenROAD Upgrade
Inline select
Inserts usings QEPs or Vifred
Integrity Constraints
Interrupt Query
Journal size during a checkpoint
Journals - Failed To Create
Journalling usage
Keeping two databases in sync
Kmem (/dev/kmem)
LicenseIT remarks
Loading a 6.4/05 database into OpenIngres
Location configurations
Locked databases
Locking handling
Locking Modes
Locking out users from a database
Lockstat output
Locking strategy
Log Buffers
Logging configuration
Logstat usage
Log File with copy from statement
Log File - Excessive Waiting
Log File - Force Abort
Log File Sizing
Log problem with deletes
Log Space Usage
Losing Ingres/Net Authorization
Loss of data in a heap table
Macros recording/playback
Maximum locks error in logfile
Maximum open files
Maxlocks
Maxpages parameter
Memlk Compile Error
Migrating databases to another machine
Minimum date handling
Modify logging
Modifying tables to readonly (OpenIngres)
Modifying large tables in OpenIngres
Moving checkpoint location
Multiple installations
Multiple sessions in ESQLC
Multiprocessor Settings
Mutex server
Mutex server (VMS)
Name of current frame/procedure
NFS
Nologging Recovery
NT problem
ODBC drivers
ODBC tracing
ODBC with Database procedures
ODBC with MS Access 2
ODBC with SQL
ODBC with Win95
ODBC + JDBC drivers (ad)
OpenIngres announcement
OpenIngres comments
OpenIngres config.dat
OpenIngres rollforward comment
OpenIngres NFS clients
OpenIngres with Ingres Net
OpenIngres with MC/Serviceguard
OpenIngres with Solaris
OpenIngres with Tools for Windows
OpenIngres 1.2 Problems
OpenIngres + OpenROAD on Windows NT
OpenRoad Default Database connection
OpenRoad Ingres Installation on Windows 3.1 File Server
OpenROAD PC Setup
OpenRoad scrolling
OpenRoad Software (LCT Advertisement)
OpenRoad tab-sequence
Open cursors with autocommit
Operating System Support - Release Codes
OPF Memory Usage
OPF Out of Memory
Optimize a column
Optimize this table
Optimizedb
Optimizedb - removing stats on specific columns
Optimzedb: -zw flag
Optimizer memory
Optimizer statistics & checkpoint anecdote
Out of Memory
Overflow chain size in a hash table
Page locking problem
Partial select
Performance Basics
Performance Tuning
QEF sort size
Qef_qep_mem
QEP and printqry
QSF pool size
QSF pool usage
Query server tuning
Quantum
Raid5 comments
Range variable limits
Raw log size checking
RDF cache with db rules and procedures
Read threads
Readlock
Recovering a single table
Recovery Failure
Recovery info on aaaaaaaa.cnf
Recovery of a Destroyed Database
Recovery Plan (example)
Relocating databases
Removing Database Location
Repeated queries
Repeated Select vs Normal Select
Replicator comments
Replicator resolver
Report Debugging
Report Parameters
Report Parameters in OpenIngres
Report Writer alternatives
Report Writer with Tabs
Resizing transaction log file
Restoring database from a checkpoint
Rollforward error with 6.4/04
Rollforward of Large Checkpoints
Rollforward - Table missing
Rollforwarddb with -v and #x flags
Rowstate for an array in OpenRoad Ingres
Row movement in compressed heaps
Rtree vs Btree
SCF error
Selects and dmf cache
Sequence_value in Windows 4GL
Sequence Value Usage
Sequential numbering of rows in a table
Server allocation
Server Crash
Server shutdown
Server starting
Session ID -> Process ID
Session Login Times
Session Parameters
Session (Server) Debug
Session timeouts
Sessions which are not disconnected properly
Set Nologging
Shutting down Ingres
Signal Handling
Sizes of II_ACP.LOG and II_RCP.LOG
Solaris upgrade
Speed up ABF compilations
SQL exists/in clause in QUEL
SQL Interrupt
SQL Query - Returning Y/N
SQL scripting (an example)
SQL tracing of ABF session
SQL Transaction running time
Sqlvar Integers/Floats
Statdump bug
String Search
Swap Space Drained
Swap Space vs Shared Memory
Symlinks
Table_Debug
Table Insertion logging
Table locking status
Table partitioning
Table query tracepoint
Table row update
Table size limits
Table Structures - Btree or Isam ?
Table timeouts
Tabs in Report Writer
Tar
TCP/IP versus Ingres Net
Terminal Monitor - abort processing
Timeout in Report frames
Trace point information to errlog.log
Trace Point qe90
Trace Point Usage
Trace Points - Ingres and OpenIngres
Trace Points - Karl's List for Ingres 2.6
Trace Points' List Extended
Trace Points/IImonitor List
Tracing an index back to its table.
Transaction logfile explained
Transaction locks at a table level
Transmit information using dbevents
Turning off database journaling
Unloading a database without the data
Unloading a database table larger than 2 Gig
Unloaddb to tape
Upfront comments
Upfront terminal settings
Variable page sizes
Verifydb locking
Views referencing tables
Vifred and default nulls
VMS and TCP
Waiting for Logging System
Windows 4GL frame on top
Windows 4GL List Field Selection
Windows 4GL on a Windows 95 client
Windows 4GL vs Xterminal
Windows 4GL with source code control (SCCS)
WWW client interface to Ingres databases
Y2k testing