Index

• aaodir directory
• Access privileges
  • DBA (1), (2)
  • Resource (1), (2)
  • Select
• Accessibility
  • dotted decimal format of syntax diagrams
  • syntax diagrams, reading in a screen reader
• Active queue of RGM
• ADD keyword of ALTER FRAGMENT statement
• adtcfg configuration file
• ADTPATH configuration parameter
• AIX 5.x operating system
• Alarm for single-user mode
• Alias for a table
• ALL keyword in REVOKE statement
• ALTER FRAGMENT statement
• ALTER TABLE statement (1), (2)
• AS keyword
  • in CREATE VIEW statement
  • in GRANT statement
  • in REVOKE statement
• Asynchronous IO driver
• Attached index
• AVOID_EXECUTE keyword
  • in onmode -q command
  • in SET EXPLAIN statement

• BATCHSIZE keyword of onutil utility (1), (2)
• Boldface type
• BOUND_IMPL_PDQ session environment variable
• BYTE values
  • no light appends
  • silent truncation

• Cartesian product
• cfg option to onstat -g command
• Chunk number
• CLASS_DS_MAX_QUERIES configuration parameter
• CLASS_DS_MEM_QUOTA configuration parameter
• CLIENT_LOCALE environment variable
• Code examples, conventions for
• Code set ISO 8859-1
• Command-line conventions
  • example diagram
  • how to read
• Comment indicators
• Compliance
  • with industry standards
• Configuration parameters
  • ADTPATH
  • CLASS_DS_MAX_QUERIES
  • CLASS_DS_MEM_QUOTA
  • DISABLE_FILE_CLOSE_OPTIMIZATION
  • DS_CLASS_NAME
  • DS_TOTAL_MEMORY (1), (2)
  • DS_TOTAL_TEMPSPACE
  • DUMPDIR
  • END
  • MAX_PDQPRIORITY
  • REPACK_THREAD_MAX (1), (2)
• Contact information
• Conventions
  • code examples
  • command-line
  • documentation
  • syntax diagrams
  • syntax notation
  • typographical
• COSERVER keyword
  • in onutil REPACK DATA command
  • in onutil SET commands (1), (2)
• Cross-server queries
• Currency symbol in MONEY values

• DATA keyword of onutil utility
• Data Repack queue
• DB-Access utility (1), (2)
• DB_LOCALE environment variable
• DB2 load format
• DBA access privilege (1), (2)
• DBDATE environment variable
• DBMONEY environment variable
• dbschema utility
• DBTIME environment variable
• DDL statements
  • forcing execution
  • restricting storage spaces
• DEFAULT built-in resource class
• DEFAULT constraint
• DEFAULT keyword
  • in onconfig.xps file
  • in SET ENVIRONMENT statement (1), (2), (3)
• Default locale
• DEFAULT SPACE keywords in SET ENVIRONMENT statement
• Deferred close
• del file type of DB2
• DELIMITER keyword in CREATE EXTERNAL TABLE statement
• Demonstration databases
• Dependencies, software
• Disabilities, visual
  • reading syntax diagrams
• DISABLE_FILE_CLOSE_OPTIMIZATION configuration parameter
• Disk partition overflow
• DISPLAY PAGE keywords of onutil utility
• DML statements
  • aborting
  • available memory
  • distributed (1), (2)
  • query optimizer plans
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
• Documentation conventions
• Documentation Notes
• Documentation set of all manuals
• Dotted decimal format of syntax diagrams
• Double-hyphen ( – ) comment indicators
• Double quotation marks
  • delimiting character data
  • escaping
• DROP TABLE statement
• DS_CLASS_NAME configuration parameter
• DS_CLASS session environment variable (1), (2)
• DS_CLASSINFO
  • option to the onstat -g cfg command
  • option to the onutil set command
• DS_TOTAL_MEMORY configuration parameter (1), (2)
• DS_TOTAL_TEMPSPACE configuration parameter
• DUMPDIR configuration parameter

• en_us.8859-1 locale
• END configuration parameter
• env option to onstat -g command (1), (2)
• ENVIRONMENT keyword
  • in SET ENVIRONMENT statement (1), (2), (3), (4)
• Environment variables
  • CLIENT_LOCALE
  • DB_LOCALE
  • DBDATE
  • DBMONEY
  • DBTIME
  • GL_DATE
  • GL_DATETIME
  • IBM_XPS_PARAMS (1), (2), (3)
  • IFMX_AIXKAIO_NUM_REQ
  • IFMX_ROLES_WITH_GRANT (1), (2)
  • INFORMIXDIR (1), (2)
  • PDQPRIORITY
  • RASHELP
  • SERVER_LOCALE
• Error messages
• Example-code conventions
• EXPLAIN keyword
  • in onmode -q command
  • in SET EXPLAIN statement
• External table
  • formatting in DB2 load format
  • multibyte record delimiter
  • no repacking
  • Table Options clause

• FILE keyword
  • in onmode -q command
  • in SET EXPLAIN statement
• File type modifiers of DB2
• FILEAPPEND keyword in onmode -q command
• Fixed and Known Defects File
• FORCE_DDL_EXEC session environment variable (1), (2)
• FORMAT keyword in CREATE EXTERNAL TABLE statement
• FROM keyword
  • in REVOKE statement
  • in SELECT statement (1), (2)

• gcore files
• GL_DATE environment variable
• GL_DATETIME environment variable
• Global configuration parameter settings
• Global Language Support (GLS)
• Globally detached index (1), (2)
• Group iterator threads

• Hash join iterator threads
• Help
• HEX keyword in onutil DISPLAY PAGE command
• HOUR TO SECOND qualifier for DATETIME values

• IBM_XPS_PARAMS environment variable (1), (2), (3)
• IFMX_AIXKAIO_NUM_REQ environment variable
• IFMX_ROLES_WITH_GRANT environment variable (1), (2)
• IMMEDIATE keyword in onmode -q command
• IMMUTABLE keyword
  • in onmode -q command (1), (2)
  • in SET ENVIRONMENT statement (1), (2), (3), (4), (5)
• IMPLICIT_PDQ session environment variable (1), (2)
• IN INDEX keywords of onutil utility
• In-place alter
• IN TABLE keywords of onutil utility (1), (2)
• IN TABLESPACE keywords of onutil utility
• Index
  • creating
  • globally detached
  • on nonlogging tables
• Industry standards, compliance with
• Informix Dynamic Server documentation set
• INFORMIXDIR/bin directory
• Insecure file permissions
• Installation Guides
• INTO keyword of SELECT statement
• ISO 8859-1 code set
• ISO-compliant comment indicators

• j option
  • to oninit utility
  • to onmode utility
• Join
  • disabled self-join
  • hash-join iterators

• k option to onmode utility
• KAIO requests
• Keywords
  • in syntax diagrams
• Keywords of SQL

• Light appends (1), (2), (3)
• Linefeed character (1), (2)
• Linefeed characters
• LOAD statement of DB2
• Locales
  • default
  • en_us.8859-1
• Locally detached index
• LOCK keyword in SET LOCK MODE statement
• Logged table
• Logging type, changing (1), (2)
• Logical page number

• m option to onmode utility
• Machine notes
• MAX_PDQPRIORITY configuration parameter
• Microkernel mode
• MODE keyword in SET LOCK MODE statement
• mut option to onstat -g command (1), (2), (3)
• MUTABLE keyword
  • in onmode -q command (1), (2)
  • in SET ENVIRONMENT statement (1), (2), (3), (4), (5)

• N value in onstat -g ses displays
• New command-line options and displays
• New configuration parameters
• New environment variable settings
• New features
  • in XPS 8.50
  • in XPS 8.51
• New SQL keywords
• New SQL statement syntax
• New system catalog table entries
• Nondefault session environment variable settings
• Nonlogging table
• NOT keyword in SET LOCK MODE statement
• NOT NULL constraint

• ODBC clients
• OFF keyword
  • in onmode -q command
  • in SET ENVIRONMENT statement (1), (2)
  • in SET EXPLAIN statement
• Off-line mode
• ON keyword
  • in CREATE INDEX statement
  • in GRANT statement
  • in onmode -q command
  • in REVOKE statement
  • in SET ENVIRONMENT statement (1), (2), (3), (4)
  • in SET EXPLAIN statement
• On-line mode
• onconfig configuration file
• onconfig.std configuration file
• onconfig.xps configuration file
• oninit utility
  • -j option
• Online help
• Online manuals
• Online notes (1), (2)
• onlog utility
• onmode utility
  • -j option
  • -k option
  • -m option
  • -q option (1), (2), (3), (4), (5), (6), (7)
  • -s option
  • AVOID_EXECUTE keyword
  • DS_CLASS keyword
  • EXPLAIN keyword
  • FILE keyword
  • FILEAPPEND keyword
  • IMMEDIATE keyword
  • IMMUTABLE keyword (1), (2)
  • MUTABLE keyword (1), (2)
  • OFF keyword
  • ON keyword
  • USABLE_SPACES keyword
• onstat -g command
  • cfg option
  • ds_classinfo option
  • env option (1), (2), (3)
  • mut option (1), (2), (3), (4)
  • pak option (1), (2)
  • rgm option
  • ses option (1), (2), (3)
  • sql option
  • stm option
  • xmp option (1), (2)
  • xqp option
• onutil utility
  • BATCHSIZE keyword
  • COSERVER keyword (1), (2), (3)
  • DATA keyword
  • DISABLE_FILE_CLOSE_OPTIMIZATION keyword
  • DISPLAY keyword
  • DS_CLASSINFO keyword
  • HEX keyword
  • IN keyword (1), (2)
  • INDEX keyword
  • PAGE keyword
  • PERSISTENT keyword (1), (2)
  • PROPAGATE keyword (1), (2)
  • REPACK keyword
  • REPACK_THREAD_MAX keyword
  • SET keyword (1), (2), (3)
  • TABLE keyword (1), (2)
  • TABLESPACE keyword
• OPERATIONAL table
• OPTION keyword in GRANT statement (1), (2)
• Overflow of query operators

• Page granularity in repacking
• PAGE keyword of onutil utility
• Page offset
• pak option to onstat -g command
• Parallel KAIO requests
• Parameters, configuration
  • CLASS_DS_MAX_QUERIES
  • CLASS_DS_MEM_QUOTA
  • DS_CLASS_NAME
  • DS_TOTAL_MEMORY
  • END
  • REPACK_THREAD_MAX
• PDQ queries
• PDQPRIORITY environment variable
• PERSISTENT keyword in onutil SET commands (1), (2)
• Physical page address
• Printed manuals
• PROPAGATE keyword in onutil SET commands (1), (2)
• PTSHRINK log record
• PUBLIC keyword
  • in GRANT statement
  • in REVOKE statement
• public.sysdbopen( ) procedure (1), (2), (3)

• q option to the onmode utility (1), (2), (3), (4), (5)
• Query
  • available memory
  • avoiding execution
  • currently executing
  • distributed (1), (2)
  • operator overflow
  • optimizer plan
• Queue
  • Active
  • Data Repack
  • Wait
• Quiescent mode

• RASHELP environment variable
• Raw format for BYTE values
• RAW table
  • creating
  • indexing
  • repacking
• RECORDEND keyword in CREATE EXTERNAL TABLE statement
• Release Notes
• REPACK DATA IN keywords of onutil utility
• REPACK_THREAD_MAX configuration parameter (1), (2)
• Resource access privilege
• Resource class
  • associating with a session
  • built-in DEFAULT class
  • configuration parameters
  • defining in the configuration file
  • defining with onutil commands
  • dropping
  • modifying at runtime
• Resource Grant Manager (RGM)
• rgm option to onstat -g command
• ROLE keyword
  • in CREATE ROLE statement
  • in GRANT DEFAULT ROLE statement
  • in SET ROLE statement
• Row granularity in repacking
• ROWID values

• s option to onmode utility
• sales_demo database
• SCRATCH table
  • creating
  • indexing
• Screen reader
  • reading syntax diagrams
• Select access privilege
• SERVER_LOCALE environment variable
• ses option to onstat -g command (1), (2), (3)
• Session environment variables
  • BOUND_IMPL_PDQ
  • DS_CLASS (1), (2)
  • FORCE_DDL_EXEC (1), (2)
  • IMPLICIT_PDQ (1), (2)
  • USABLE_SPACES (1), (2)
• SET DISABLE_FILE_CLOSE_OPTIMIZATION option to the onutil utility
• SET DS_CLASSINFO option to onutil utility
• SET ENVIRONMENT statement
  • BOUND_IMPL_PDQ
  • DEFAULT keyword (1), (2)
  • DS_CLASS keyword (1), (2)
  • FORCE_DDL_EXEC keyword (1), (2)
  • IMMUTABLE keyword (1), (2), (3)
  • IMPLICIT_PDQ keyword
  • MUTABLE keyword (1), (2), (3)
  • OFF keyword
  • ON keyword
  • USABLE_SPACES keyword (1), (2)
• SET REPACK_THREAD_MAX option to the onutil utility
• SET TABLE_SPACE statement
• SET TEMP TABLE_SPACE statement
• Silent truncation
• Single-user mode (1), (2)
• sqexplain.out file (1), (2)
• SQL code
• sql option to onstat -g command
• STANDARD table
• STATIC table (1), (2), (3)
• STATISTICS keyword in UPDATE STATISTICS statement
• stm option to onstat -g command
• stores_demo database
• Syntax diagrams
  • conventions for
  • keywords
  • reading in a screen reader
  • variables
• Syntax segment
• syscolauth table
  • colauth
  • grantee
  • grantor
• sysdbopen( ) procedure (1), (2), (3)
• sysmaster database
• systabauth table
  • grantee
  • grantor
  • tabauth
• System catalog tables
  • syscolauth
  • systabauth
• sysutils database

• Table
  • changing logging type (1), (2)
  • creating
  • duplicate
  • external (1), (2)
  • in system catalog
  • logged
  • nonlogging (1), (2)
  • option to onutil REPACK DATA command
  • remote
  • repacking
  • static
  • temporary (1), (2)
• Table Options clause of CREATE EXTERNAL TABLE statement
• TABLESPACE keyword of onutil utility
• TEMP table
  • creating
  • indexing
• Temporary configuration parameter settings
• TEXT values
  • no light appends
  • silent truncation
• Thread
  • group iterator threads
  • hash-join iterator threads
  • repack threads (1), (2)
• TIME data type of DB2
• timeformat file type modifier
• TIMESTAMP data type of DB2
• timestampformat file type modifier
• TO keyword
  • in DATETIME qualifiers
  • in GRANT statement
  • in SET EXPLAIN statement
  • in SET LOCK MODE statement
• TOC Notes
• TRUNCATE TABLE statement
• Truncation of large object values
• Typographical conventions

• UNIX operating system
  • default locale
• UPDATE STATISTICS statement
• USABLE_SPACES session environment variable (1), (2)
• User informix (1), (2)
• user.sysdbopen( ) procedure (1), (2), (3)
• Utilities
  • dbaccess (1), (2)
  • dbschema
  • export
  • oninit
  • onlog
  • onmode (1), (2), (3), (4), (5)
  • onstat (1), (2), (3), (4), (5)
  • onutil (1), (2), (3), (4), (5), (6), (7), (8), (9)
  • setenv
  • xctl

• Variables, in syntax diagrams
• VIEW keyword in CREATE VIEW statement
• Views
• Visual disabilities
  • reading syntax diagrams

• WAIT keyword in SET LOCK MODE statement
• Wait queue of RGM
• Windows record separator
• WITH APPEND keywords in SET EXPLAIN statement
• WITH GRANT OPTION keywords in GRANT statement (1), (2)
• WITH NO LOG keywords in SELECT statement

• XA clients
• xctl utility
• xmp option to onstat -g command (1), (2)
• XMP query operators
• xqp option to onstat -g command

• Y value in onstat -g ses displays
• Y4MD0 setting for DBDATE
• YEAR TO FRACTION qualifier for DATETIME values

• Zero
  • CLASS_DS_MAX_QUERIES value
  • CLASS_DS_MEM_QUOTA value
  • DISABLE_FILE_CLOSE_OPTIMIZATION value
  • REPACK_THREAD_MAX value