Home | Previous Page

Index

A B C D E F G H I J K L M N O P Q R S T U V W

A

Abbreviated years
Accessibility
- dotted decimal format of syntax diagrams
- syntax diagrams, reading in a screen reader
AFDEBUG environment variable
AFF_NPROCS configuration parameter
AFF_SPROC configuration parameter
ALARMPROGRAM configuration parameter (1), (2), (3), (4)
ALL keyword
- dbschema utility
ALLOW_NEWLINE configuration parameter
ALRM_ALL_EVENTS configuration parameter
Applications
- client
  - Communications Support Module
archecker utility
ASCII file, produced by unloading
ASF_SOCTCP_BACKLOG configuration parameter
Authentication
- policy (1), (2)

B

Backup
- Dynamic Server 10.0 (1), (2)
- Dynamic Server source when converting
- logical logs
- ON-Bar (1), (2), (3)
- ontape utility (1), (2), (3)
- source database
Binary files, loading (1), (2), (3)
BladeManager
- installing and registering DataBlade modules
- removing extensions during reversion
Blobs.
- See also Simple large objects.
Blobspace
- backing up
- moving, with onunload and onload
Boldface type
boot90.sql and boot901.sql
BUFFERPOOL configuration parameter (1), (2)
BUFFERS configuration parameter (1), (2)

C

Case-sensitive name space
CDR_DBSPACE configuration parameter
CDR_ENV configuration parameter
CDR_LOGBUFFERS configuration parameter
CDR_LOGDELTA configuration parameter
CDR_LOGDELTA environment variable
CDR_MAX_DYNAMIC_LOGS configuration parameter
CDR_NIFRETRY configuration parameter
CDR_NUMCONNECT configuration parameter
CDR_PERFLOG environment variable
CDR_QDATA_SBFLAGS configuration parameter
CDR_QDATA_SBSPACE configuration parameter (1), (2)
CDR_QHDR_DBSPACE configuration parameter
CDR_RMSCALEFACT environment variable
CDR_ROUTER environment variable
CDR_SUPPRESS_ATSRISWARN configuration parameter
Character-position form of FILE and INSERT statements
Checking available space
- Dynamic Server 10.0
Checking database integrity
Choosing a migration method
Chunk
- format
- reserve pages
  - and reversion from Dynamic Server
Client application
- Communications Support Module
Closing
- Dynamic Server (1), (2)
Code, sample, conventions for
Code-set conversion
- HPL
Column-level encryption
Command file
- dbload
Command-line conventions
- how to read
- sample diagram
Communications Support Module
- client applications
- configuring
- removing
- saving configuration
Compliance
- with industry standards
concsm.cfg file
- creating
- deleting
- saving
Configuration file
- customizing (1), (2)
- replacing after reversion from Dynamic Server 10.0
- saving a copy of current version
- saving during conversion
Configuration parameter
- ALARMPROGRAM (1), (2)
- ALLOW_NEWLINE
- ALRM_ALL_EVENTS
- altered in Dynamic Server 9.30
  - JDKVERSION
  - JVPJAVAHOME
  - JVPJAVALIB
  - JVPJAVAVM
- altered in Dynamic Server 9.40
  - ALARMPROGRAM
  - CDR_QDATA_SBSPACE
  - DBSERVERALIASES
  - LRU_MAX_DIRTY
  - LRU_MIN_DIRTY
  - LTAPEBLK
  - LTAPESIZE
  - OPTICAL_LIB_PATH
  - TAPEBLK
  - TAPESIZE
- ASF_SOCTCP_BACKLOG
- BUFFERPOOL (1), (2)
- BUFFERS (1), (2)
- CDR_DBSPACE
- CDR_ENV
- CDR_MAX_DYNAMIC_LOGS
- CDR_QDATA_SBSPACE
- CDR_QHDR_DBSPACE
- CDR_SUPPRESS_ATSRISWARN
- DD_HASHMAX
- DD_HASHSIZE
- DEF_TABLE_LOCKMODE
- DR_IDXAUTO
- DRAUTO (1), (2)
- DS_HASHSIZE
- DS_NONPDQ_MEM
- DS_POOLSIZE
- DYNAMIC_LOGS
- ENCRYPT_CDR
- ENCRYPT_CIPHER
- ENCRYPT_MAC
- ENCRYPT_MACFILE
- ENCRYPT_SWITCH
- EXT_DIRECTIVES
- FAST_RESTART_CKPT_FUZZYLOG
- FAST_RESTART_PHYSLOG
- HPL_DYNAMIC_LIB_PATH (1), (2)
- IFX_EXTEND_ROLE
- IFX_LISTEN_TIMEOUT
- LRU_MAX_DIRTY (1), (2), (3)
- LRU_MIN_DIRTY
- LRUS (1), (2)
- LTAPEBLK
- MAX_INCOMPLETE_CONNECTIONS
- new in Dynamic Server 10.0
- new in Dynamic Server 9.20
- new in Dynamic Server 9.21
- new in Dynamic Server 9.30
- new in Dynamic Server 9.40
- ONLIDX_MAXMEM
- OPT_GOAL
- OPTICAL_LIB_PATH
- PC_HASHSIZE
- PC_POOLSIZE
- PLOG_OVERFLOW_PATH
- removed in Dynamic Server 9.30
  - AFF_NPROCS
  - AFF_SPROC
  - CDR_LOGBUFFERS
  - CDR_LOGDELTA
  - CDR_NIFRETRY
  - CDR_NUMCONNECT
  - LBU_PRESERVE
  - LOGSMAX
  - LTXEHWM
  - LTXHWM
  - NOAGE
  - NUMAIOVPS
  - NUMCPUVPS
- removed in Dynamic Server 9.40
  - CDR_QDATA_SBFLAGS
- ROOTOFFSET
- ROOTPATH
- ROOTSIZE
- SBSPACETEMP
- STMT_CACHE
- STMT_CACHE_HITS
- STMT_CACHE_NOLIMIT
- STMT_CACHE_NUMPOOL
- STMT_CACHE_SIZE
- SYSSBSPACENAME
- TAPEBLK
- TBLTBLFIRST
- TBLTBLNEXT
conpload.sh script
conploadlegacy.sh script
Contact information
Conventions
- command-line
- documentation
- sample-code
- syntax diagrams
- syntax notation
- typographical
Converting
- monitoring status with online.log
Converting to Dynamic Server 10.0 with Enterprise Replication
CREATE PROCEDURE statement, use of dbschema
CREATE SEQUENCE statement
CREATE SYNONYM statement
- use of dbschema
CREATE TABLE statement
- use of dbschema
CREATE VIEW statement
- use of dbschema
Creating a dbload command file
Customizing
- configuration file

D

Data integrity
Data type
- user defined
  - converting from Dynamic Server 9.2x
Database
- ownership, set by onload
- verifying integrity
Database server
- platforms and versions
- upgrading (1), (2)
DataBlade API
- enhancements (1), (2)
DataBlade module
- installing and registering
dbexport
- SELECT triggers, disabling
dbexport utility
- -c option (1), (2)
- -d option
- -q option
- -ss option (1), (2)
- -V option
- -X option
- defined (1), (2)
- destination options (1), (2)
- schema output
- syntax
dbimport utility
- -c option (1), (2)
- -l option
- -q option
- -V option
- -X option
- create options
- database logging mode
- defined (1), (2)
- importing from another computer
- input file location options (1), (2)
- Interrupt key
- locale, changing
- syntax
- using with GLS
- using with NLS
dbload utility
- -c command file option
- -d database option
- -e errors option
- -e option
- -i ignore rows option
- -i option
- -k option
- -l error log file option
- -n commit interval option
- -p option
- -r option (1), (2)
- -s option
- -V option
- -X option
- compared to LOAD
- creating a command file
- defined
- FILE statement
- ignoring rows
- importing from another computer
- INSERT statement
  - compared to SQL INSERT statement
  - using (1), (2)
- Interrupt key
- moving data to Workgroup Edition
- number errors to allow
- speed, increasing
- syntax (1), (2)
- table locking
- using
- writing a command file
  - in character-position form
  - in delimiter form
dbschema utility
- -ss option
- create schema for a database (1), (2)
- defined (1), (2)
- distribution information
- moving data to Workgroup Edition
- obtaining
- owner conventions
- specifying a table, view, or procedure
- specifying the role schema
- using
DBSERVERALIASES configuration parameter
Dbspace
- backing up
- moving tables to another dbspace
DD_HASHMAX configuration parameter
DD_HASHSIZE configuration parameter
DEF_TABLE_LOCKMODE configuration parameter
Default locale
Delimiter form of FILE and INSERT statements
Dependencies, software
Detached index
Diagnostic information to gather
Diagnostics table
- displayed by dbschema utility (1), (2)
Directory
- installation
Disabilities, visual
- reading syntax diagrams
Disabling
- High-Availability Data Replication
Display schema for a database
Distributed transactions
- limitation on using routines
Distribution information for tables
Documentation, types of
- machine notes
- online manuals
- printed manuals
Documentation conventions
Documentation Notes
Documentation set of all manuals
Dotted decimal format of syntax diagrams
DR_IDXAUTO configuration parameter
DRAUTO configuration parameter (1), (2)
DRDA database
DS_HASHSIZE configuration parameter
DS_NONPDQ_MEM configuration parameter
DS_POOLSIZE configuration parameter
DYNAMIC_LOGS configuration parameter
Dynamic Server
- 10.0
  - authentication policies (1), (2)
  - backing up (1), (2)
  - bringing down
  - bringing up
  - DataBlade modules, installing
  - installing
  - performance tuning
  - release notes
  - saving configuration file
  - space requirements
- 7.3x
  - using dbexport and dbimport
- 9.x or later
- new features
- platforms and versions
- reverting
- reverting from current version
Dynamic Server 10.0
- initializing
- starting
Dynamic Server 7.3x
- moving data between computers
Dynamic Server 9.x or later
- importing data
- moving data between computers
- using dbimport
- using dbload

E

en_us.8859-1 locale
ENCRYPT_CDR configuration parameter
ENCRYPT_CIPHER configuration parameter
ENCRYPT_MAC configuration parameter
ENCRYPT_MACFILE configuration parameter
ENCRYPT_SWITCH configuration parameter
Enterprise Gateway Manager
Enterprise Gateway with DRDA
Enterprise Replication
- enhancements (1), (2)
Environment variable
- AFDEBUG
- CDR_LOGDELTA
- CDR_PERFLOG
- CDR_RMSCALEFACT
- CDR_ROUTER
- CLIENT_LOCALE
- DB_LOCALE (1), (2)
- DBCENTURY
- DBDATE
- DBTEMP
- IFX_DEF_TABLE_LOCKMODE
- IFX_EXTDIRECTIVES
- IFX_LONGID
- IFX_NO_TIMELIMIT_WARNING
- IFX_ONPLOAD_AUTO_UPGRADE (1), (2)
- IFX_UPDDESC
- INFORMIXSERVER
- INFORMIXSQLHOSTS
- JAR_TEMP_PATH
- JAVA_COMPILER
- JVM_MAX_HEAP_SIZE
- ONCONFIG
- PATH
- reverting Dynamic Server
- SERVER_LOCALE
- STDIO
- STMT_CACHE
- TEMP
- TMP
- USETABLENAME
Environment variables
Error messages
Example
- calculating free space
EXT_DIRECTIVES configuration parameter
Extents, checking
Extracting schema information

F

Fast recovery
- initiating
FAST_RESTART_CKPT_FUZZYLOG configuration parameter
FAST_RESTART_PHYSLOG configuration parameter
File
- oncfg (1), (2)
- onconfig
- ONCONFIG (1), (2)
- sqlhosts (1), (2)
- tctermcap
  - saving
- termcap
FILE statement
- character-position form
- delimiter form
- syntax for
  - character-position form
  - delimiter form
- with dbload
Fixed and Known Defects File
Formula
- free space
Free space required

G

Gateway, importing from another computer
Global Language Support
- dbimport utility
- locales
- new features
- using onload and onunload (1), (2), (3)
GLS.
- See also Global Language Support.
GRANT statement
- role privileges (1), (2)
- use of dbschema

H

Help
High-Availability Data Replication
High-Performance Loader
- custom-code shared library
- ipload utility
- loading ASCII or COBOL data (1), (2)
- onpladm utility
- using (1), (2)
HPL.
- See also High-Performance Loader.
HPL_DYNAMIC_LIB_PATH configuration parameter (1), (2)
HPLAPIVERSION configuration parameter (1), (2)

I

IBM Informix Server Administrator
IBM Informix Storage Manager
- migrating catalogs
IFX_DEF_TABLE_LOCKMODE environment variable
IFX_EXTDIRECTIVES environment variable
IFX_EXTEND_ROLE configuration parameter
IFX_LISTEN_TIMEOUT configuration parameter
IFX_LONGID environment variable
IFX_NO_TIMELIMIT_WARNING environment variable
IFX_ONPLOAD_AUTO_UPGRADE environment variable (1), (2)
IFX_UPDDESC environment variable
Importing
- non-Informix data
Index
- checking
- dbload utility
- detached
- rebuilding
Industry standards, compliance with
Informix Dynamic Server documentation set
INFORMIXDIR/bin directory
INFORMIXDIR directory
INFORMIXSERVER environment variable
INFORMIXSQLHOSTS environment variable
Initializing
- Dynamic Server 10.0
INSERT statement
- character-position form
- delimiter form
- syntax for
  - character-position form
  - delimiter form
- with dbload
Installation
- directory
- enhancements
Installation Guides
Installing
- Dynamic Server 10.0
- storage manager
Interrupt key
- with dbimport
- with dbload
ipload utility
ISO 8859-1 code set

J

K

Kernel parameters on UNIX or Linux
Keywords
- in syntax diagrams

L

LBU_PRESERVE configuration parameter
Level-0 backup (1), (2), (3)
- after moving data
Linux
- migrating on
LOAD SQL statement
- for locales that support multibyte code sets
- syntax
Loading
- ASCII files (1), (2)
- binary data (1), (2), (3)
- COBOL data (1), (2), (3)
Locale
Locking
- set by onload
Logging
- onload and onunload
Logical log
LOGSMAX configuration parameter
LRU_MAX_DIRTY configuration parameter (1), (2), (3), (4)
LRU_MIN_DIRTY configuration parameter (1), (2)
LRUS configuration parameter (1), (2)
LTAPEBLK configuration parameter (1), (2)
LTAPEDEV configuration parameter
- onunload/onload
LTAPESIZE configuration parameter
LTXEHWM configuration parameter
LTXHWM configuration parameter

M

Machine notes
MAX_INCOMPLETE_CONNECTIONS configuration parameter
Migrating
- between 32-bit and 64-bit database servers
Migrating a database
- using dbexport and dbimport
- using UNLOAD, dbschema, and LOAD
Migrating a database to
Migration
- before you begin
- checklist
- diagnostic information that you need before upgrading
- on Linux
- on same operating system
- on UNIX
- on Windows 2000
- on Windows NT
- on Windows XP
- onload utility (1), (2)
- onunload utility
- paths (1), (2)
Migration procedure
- between UNIX and Windows NT
- general guidelines for
Mode
- checking
Monitoring conversion status
Moving data

N

Name space
- case-sensitive
Native Language Support (NLS)
- populating with dbimport
New features
- 7.30 features in Dynamic Server 9.20
- Java Virtual Machine 1.3 support
- MaxConnect support in Version 9.21
- of Dynamic Server 10.0
- of Dynamic Server 9.20 (1), (2)
- of Dynamic Server 9.21
- of Dynamic Server 9.30
- of Dynamic Server 9.40 (1), (2)
- Universal Server 9.1x features in Dynamic Server 9.20
NOAGE configuration parameter
Non-Informix data, importing
NUMAIOVPS configuration parameter
NUMCPUVPS configuration parameter

O

ON-Bar (1), (2)
ON-Bar utility
- backing up
  - Dynamic Server 10.0 (1), (2)
- backing up Dynamic Server
- backing up Dynamic Server 10.0 (1), (2)
ON-Bar Utility
- command changes between Version 7.x and 9.x or later
oncfg file in %INFORMIXDIR%/etc
oncfg file in $INFORMIXDIR/etc
oncheck utility
- -cc database_name option (1), (2)
- -cD database_name option (1), (2)
- -ce option (1), (2)
- -cI database_name option (1), (2)
- -cr option (1), (2)
- -cs sbspace_name option
- -cS sbspace_name option
- before moving data
- rebuilding table indexes
- verifying database integrity (1), (2)
ONCONFIG environment variable
onconfig file
- saving
ONCONFIG file (1), (2)
oninit utility
- -s option
- starting Dynamic Server
ONLIDX_MAXMEM configuration parameter
Online help
online.log
Online manuals
Online notes (1), (2)
onload and onunload utilities (1), (2)
onload utility
- constraints on use
- create options (1), (2)
- logging status
- moving a database
- moving a table (1), (2)
- moving locales (1), (2)
- moving to another dbspace
- ownership and privileges
- specifying tape parameters
- steps for using
- syntax
- using between computers (1), (2)
onmode-b command
onmode utility
- -b option (1), (2)
- -d standard option
- -ky option
- -m option
- -sy option
- -yuk option
- reverting from the current Dynamic Server version
- shutting down
- shutting down Dynamic Server
onpladm utility
onpload database
- reverting
- upgrading
onstat utility (1), (2)
ontape utility
- -a option
- backing up
  - Dynamic Server 10.0
  - Dynamic Server source database server
- backing up Dynamic Server 10.0
onunload utility
- constraints on use (1), (2)
- locking
- logging mode
- moving a database
- moving a table (1), (2)
- moving locales (1), (2)
- moving to another dbspace
- ownership and privileges
- steps for using
- syntax
- system catalog tables
- use without tape parameters
- using (1), (2)
- what is included with a
  - database
  - table
Operating system
- reconfiguring
OPT_GOAL configuration parameter
OPTICAL_LIB_PATH configuration parameter (1), (2)
Optical storage manager library
Owner, in dbschema

P

PATH environment variable
PC_HASHSIZE configuration parameter
PC_POOLSIZE configuration parameter
Performance comparison
Performance tuning
Planning
- data migration overview
Platforms, moving data between
- compatible computers (1), (2), (3)
PLOG_OVERFLOW_PATH configuration parameter
Printed manuals
Privileges
- access privileges for tables
- required for onload
- required for onunload (1), (2)

Q

Quiescent mode

R

Recompiling Java UDRs
Reconfiguring the operating system
Registering DataBlade modules
Release notes
- Dynamic Server 10.0
- location of
Release Notes
Reserve pages, checking
Reversion utility
Reverting
- chunk reserve pages
- determining if it is possible
- disabling High-Availability Data Replication
- from Dynamic Server 10.0 (1), (2), (3)
- from Dynamic Server 10.0 with Enterprise Replication to Dynamic Server 7.31 (1), (2)
- from Dynamic Server 10.0 with Enterprise Replication to Dynamic Server 9.2x (1), (2)
- from Dynamic Server 10.0 with Enterprise Replication to Dynamic Server 9.30 (1), (2)
- removing 10.0 features
- restrictions for
- restrictions for reverting to prior versions
- using the onmode -b command
revpload.sh script
revploadlegacy.sh script
ROOTOFFSET configuration parameter
ROOTPATH configuration parameter
ROOTSIZE configuration parameter
Running the reversion utility

S

Sample-code conventions
SBSPACETEMP configuration parameter
Screen reader
- reading syntax diagrams
SELECT triggers, disabling with dbexport
SERIAL data type, treatment by dbschema
Server Studio JE
SET ENVIRONMENT OPTCOMPIND
SHMADD configuration parameter
SHMVIRTSIZE configuration parameter
Simple large objects
- moving with onload (1), (2)
sm_versions.std file
- renaming to sm_versions
Software dependencies
Space
- checking what is available
- configuring
- for sysmaster database
SQL
- enhancements
SQL code
SQL reserved words
SQL statement
- CREATE SEQUENCE
- FILE
- INSERT
- UPDATE STATISTICS
  - data distributions
SQLHOSTS Connectivity Information
sqlhosts file, UNIX
- changing name or path
- csm option (1), (2)
- save a copy when migrating
Starting
- Dynamic Server 10.0
- target database server after reversion (1), (2)
STDIO environment variable
STMT_CACHE configuration parameter
STMT_CACHE environment variable
STMT_CACHE_HITS configuration parameter
STMT_CACHE_NOLIMIT configuration parameter
STMT_CACHE_NUMPOOL configuration parameter
STMT_CACHE_SIZE configuration parameter
Storage manager
Stored Procedure Parameter Limit
stores_demo database
superstores_demo database
Syntax diagrams
- conventions for
- keywords in
- reading in a screen reader
- variables in
Syntax segment
sysindexes
- changes to
sysmaster database
- and logical logs
- changes to (1), (2)
- space required to build
- when created
SYSSBSPACENAME configuration parameter
System catalogs
- boot scripts
- changes to (1), (2)
- checking tables
System requirements
- database
- software
sysutils database

T

TAPEBLK configuration parameter (1), (2)
TAPEDEV configuration parameter, with onunload and onload
TAPESIZE configuration parameter
TBLTBLFIRST configuration parameter
TBLTBLNEXT configuration parameter
tctermcap file
- saving
termcap file in $INFORMIXDIR/etc
TOC Notes
Tools, migration
Transactions
- checking for open ones
Tuning
- Dynamic Server 10.0
Typographical conventions

U

ulimit
UNIX
- migrating on
UNLOAD SQL statement
- for locales that support multibyte code sets
- moving data
- syntax (1), (2)
- using
UPDATE STATISTICS statement
Upgrading, ISM
User-defined data type, converting from Dynamic Server 9.2x
Users, types of
USETABLENAME environment variable
Utilities
- dbexport (1), (2), (3)
- dbexport syntax
- dbimport (1), (2), (3)
- dbimport syntax
- dbload (1), (2)
- dbschema (1), (2), (3)
- onload
- onload and onunload (1), (2)
- onpladm
- onpload
- onunload
Utilities for data migration
- dbexport (1), (2), (3)
- dbimport (1), (2)
- dbload (1), (2)
- dbschema (1), (2)
- onload (1), (2)
- onunload (1), (2)

V

Validated storage manager
VARCHAR Column Limit
Variables, in syntax diagrams
Verifying data integrity
Verifying storage-manager validation
Versions
- database servers
View, display description with dbschema
Visual disabilities
- reading syntax diagrams

W

Windows 2000
- migrating
Windows NT
- migrating
Windows XP
- migrating on
Workgroup Edition 7.24
- moving data between computers
- using onload and onunload
Workgroup Edition 7.3x
- moving data between computers
- using onload and onunload
Writing a dbload command file
- in character-position form
- in delimiter form

Home | [ Top of Page | Previous Page | Contents | Index ]