Table 28 lists sources of information about various tasks related to using and managing sbspaces.
Task | Reference |
---|---|
Setting memory configuration parameters for smart large objects | Managing Shared Memory |
Understanding sbpages | Sbpages |
Specifying I/O characteristics for an sbspace | onspaces option in Storage Characteristics of Sbspaces |
Allocating space for an sbspace | Creating an Sbspace |
Adding a chunk to an sbspace | Adding a Chunk to an Sbspace |
Defining or altering storage characteristics for a smart large object | Altering Storage Characteristics of Smart Large Objects
PUT clause of CREATE TABLE or ALTER TABLE statement in IBM Informix Guide to SQL: Syntax |
Monitoring sbspaces | Monitoring Sbspaces
Chapter on table performance considerations in IBM Informix Dynamic Server Performance Guide |
Setting up logging for an sbspace | Logging Sbspaces and Smart Large Objects |
Backing up an sbspace | Backing Up Sbspaces |
Checking consistency of an sbspace | Validating Metadata |
Understanding an sbspace structure | Chapter on disk structures in the IBM Informix Administrator's Reference |
Using onspaces for sbspaces | Chapter on utilities in the IBM Informix Administrator's Reference |
Creating a table with CLOB or BLOB data types | IBM Informix Guide to SQL: Syntax |
Accessing smart large objects in an application | IBM Informix DataBlade API Programmer's GuideIBM Informix ESQL/C Programmer's Manual |
Calculating the metadata area size
Improving metadata I/O Changing storage characteristics |
Chapter on table performance in IBM Informix Dynamic Server Performance Guide |
Understanding smart-large-object locking | Chapter on locking in IBM Informix Dynamic Server Performance Guide |
Configuring sbspaces for temporary smart large objects | Chapter on configuration effects on I/O activity in IBM Informix Dynamic Server Performance Guide |