Index

• -b option
  • creating a blobspace
  • onspaces utility
• -d option
  • dbexport utility
    • TEXT or BYTE data descriptor
• -g mem opool
  • onstat utility
• -O option
  • onstat utility
• -pD option
  • oncheck utility

• Accessibility
  • dotted decimal format of syntax diagrams
  • syntax diagrams, reading in a screen reader
• ALTER OPTICAL CLUSTER statement (1), (2)
• API.
  • See also Application programming interface.
• Application programming interface
  • external layer (1), (2)
  • internal layer (1), (2)
• Assigning a TEXT or BYTE column to optical disk (1), (2)
• Autochanger

• BLOB data type
• Blobspace
  • creating the staging-area
  • creating with onspaces -b option
• Boldface type
• BYTE
  • column
    • in catalog table (1), (2)
    • storing on optical disk
  • data type, multiple copies

• CLOB data type
• Cluster key
  • choosing the
  • composed of
  • CREATE OPTICAL CLUSTER statement (1), (2)
  • defining
  • specifying
• Cluster size
  • altering (1), (2)
  • calculating (1), (2)
  • specifying (1), (2)
• Clustered storage
• Clustering TEXT and BYTE
  • columns, how it occurs
  • objects
• Code, sample, conventions for
• Code set, ISO 8859-1
• Column, TEXT or BYTE
  • assigning to optical family
  • changing
  • CREATE OPTICAL CLUSTER statement
  • defining
• Column-definition portion of CREATE TABLE statement (1), (2)
• Command-line conventions
  • how to read
  • sample diagram
• Compliance
  • with industry standards
• Configuration parameter
  • OPCACHEMAX
  • OPTICAL_LIB_PATH
  • STAGEBLOB (1), (2)
• Contact information
• Conventions
  • command-line
  • documentation
  • sample-code
  • syntax diagrams
  • syntax notation
  • typographical
• CREATE OPTICAL CLUSTER statement
  • cluster key
  • clustering TEXT and BYTE columns
  • clustering TEXT and BYTE objects
  • clustersize
  • example (1), (2)
  • logically ordering TEXT and BYTE columns
  • requirements
  • restrictions on TEXT and BYTE columns
  • syntax and use
• CREATE TABLE statement
  • assigning a column to optical platter
  • assigning a TEXT or BYTE column to optical disk (1), (2)
  • column-definition portion (1), (2)
  • creating optical family name
  • defining TEXT or BYTE column for catalog table
  • example
  • IN clause

• Data descriptor, multiple copies
• Data type
  • BLOB
  • CLOB
  • TEXT and BYTE
• DB-Access utility
• dbexport utility
  • -d option
  • migrating database
• dbimport utility
  • migrating database
• Default locale
• Demonstration databases
• DESCR() function expression
  • in an INSERT statement
  • syntax and use
• Descriptor, TEXT and BYTE data
  • DESCR() function expression
  • using
• Disabilities, visual
  • reading syntax diagrams
• Documentation, types of
  • machine notes
  • online manuals
  • printed manuals
• Documentation conventions
• Documentation Notes
• Documentation set of all manuals
• Dotted decimal format of syntax diagrams
• DROP OPTICAL CLUSTER statement (1), (2)

• en_us.8859-1 locale
• Environment variable
  • INFORMIXOPCACHE
• Environment variables
• Error messages
• ESQL/C
  • Optical Subsystem

• Family
  • defined
• FAMILY() function expression
  • locating data (1), (2)
• Features of this product, new
• Fixed and Known Defects File
• Function expressions
  • DESCR()
  • FAMILY()
  • VOLUME()

• Global Language Support
• GLS.
  • See also Global Language Support.

• Help
• High Performance Loader
  • migrating database
• HPL.
  • See also High Performance Loader.

• Industry standards, compliance with
• Informix Dynamic Server documentation set
• INFORMIXDIR/bin directory
• INFORMIXOPCACHE environment variable
• Inmigration
  • activity
  • definition of
• Inserting TEXT and BYTE data descriptors
• Installation Guides
• Installing
  • creating optical families
  • creating the staging-area blobspace
  • STAGEBLOB parameter
  • testing the connection
  • verifying that database server recognizes optical subsystem
• ISO 8859-1 code set

• Jukebox

• Keywords
  • in syntax diagrams

• Locale
  • default
  • en_us.8859-1
• Long identifiers

• Machine notes
• Managing optical-storage subsystem
• Memory cache
  • how space is allocated
  • how to assess size
  • monitoring available and allocated resources
  • purpose
  • relationship to staging-area blobspace
  • setting for client with INFORMIXOPCACHE
  • setting for system with OPCACHEMAX
• Migrating a database
  • dbexport, dbimport
  • High Performance Loader
  • TEXT and BYTE data on optical platter
• Monitoring
  • resources
    • onstat utility
• Multiple optical virtual processor
  • guidelines for determining number
• Multiple optical VPs
  • support

• New features of this product

• oncheck utility
  • -pD option
• Online help
• Online manuals
• Online notes (1), (2)
• onspaces utility
  • -b option
• onstat utility
  • -g mem opool
  • -O option
  • using to monitor resources
• OPCACHEMAX configuration parameter
• opool
  • memory, optical transfer buffer
• Optical drive, performance
• Optical family
• OPTICAL_LIB_PATH configuration parameter
• Optical media
  • accessing
  • advantages
  • platter
  • storing TEXT and BYTE data
• Optical platter
  • component of subsystem
  • exchanges
• Optical-storage subsystem
  • assigning a TEXT or BYTE column to an optical family
  • components
  • interaction between the API and the subsystem
  • management software
  • relationship with Optical Subsystem and the API
  • stand-alone
  • vendor library
• Optical Subsystem
  • defined
  • description of
  • prerequisites for installation
  • virtual processors
• Optical transfer buffer
• Optical virtual processor
  • Multiple, guidelines for determining number
  • support for multiple
• Outmigration
  • activity
  • definition of

• Performance
  • application
• Printed manuals

• Release Notes
• RELEASE statement
  • example
  • reserve counter
  • syntax and use
• RESERVE statement
  • FAMILY() function expression
  • reserve counter
  • syntax and use
  • VOLUME() function expression

• Sample-code conventions
• Screen reader
  • reading syntax diagrams
• SELECT statement
  • obtaining family name
  • obtaining volume number
  • reading a TEXT or BYTE column
  • with FAMILY() function expression
  • with VOLUME() function expression
• Sequential storage, TEXT and BYTE data
• SET MOUNTING TIMEOUT statement
  • number of seconds option
  • syntax and use
  • using
• Shelf
• Software dependencies
• SQL code
• SQL extensions, purpose
• SQL statement
  • using Optical Subsystem
• STAGEBLOB configuration parameter
  • blobspace_name
  • naming the staging-area blobspace
• Staging-area blobspace
  • creating
  • creating with ON-Monitor or onspaces
  • how to assess size
  • using onstat utility to monitor resources
• stores_demo database
• Storing optical platters
  • automated library
• superstores_demo database
• Syntax diagrams
  • conventions for
  • keywords in
  • reading in a screen reader
  • variables in
• Syntax segment
• sysblobs system catalog table
• sysopclstr table
• System catalog table
  • sysblobs

• TEXT and BYTE data
  • clustered storage
  • data descriptor
  • defined (1), (2), (3)
  • description of (1), (2)
  • sequential storage
  • storage location
• TEXT column
  • in catalog table
  • storing on optical disk
• TOC Notes
• Typographical conventions

• UNIX operating system
  • default locale for
• Users, types of
• Utility program
  • dbexport
  • dbimport
  • oncheck
  • onload
  • onspaces
  • ontape
  • onunload

• Variables, in syntax diagrams
• Virtual processor
• Visual disabilities
  • reading syntax diagrams
• Volume
  • defined
  • managing on the optical drive
  • SET MOUNTING TIMEOUT statement
• VOLUME() function expression
  • identifying an optical volume
  • syntax and use
• VP.
  • See also Virtual processor.

• Waiting
  • for volume to mount
• Windows
  • default locale for
• WORM.
  • See also Write-once-read-many.
• Write-once-read-many
  • optical media