Enterprise Edition Home | Express Edition Home | Previous Page | Next Page  

Contents

Introduction
In This Introduction
About This Manual
Types of Users
Software Dependencies
Assumptions About Your Locale
Demonstration Databases
New Features in Extended Parallel Server, Version 8.50
New Features in Extended Parallel Server, Version 8.51
Documentation Conventions
Typographical Conventions
Syntax Diagrams
Example Code Conventions
Additional Documentation
IBM Informix Information Center
Installation Guides
Online Notes
Informix Error Messages
Manuals
Online Help
Accessibility
IBM Informix Extended Parallel Server Version 8.51 and CSDK Version 2.90 Documentation Set
Compliance with Industry Standards
IBM Welcomes Your Comments
Summary of New Features in XPS 8.51
In This Chapter
Overview of New Features in Version 8.51
Single-User Mode
Reformatting XPS Data for DB2 or Windows
Resource Classes for Shared Memory Allocation
Consolidating the Storage Space of a Table
Restricting Storage Spaces in DDL Operations
Forcing the Execution of DDL Operations
Granting Privileges to Roles Using the WITH GRANT OPTION Keywords
Expanded Parallel KAIO Requests on AIX Platforms
Prohibiting Globally Detached Indexes on Nonlogging Tables
Setting a Secure Default Directory for Audit Files
Setting a Secure Default Directory for Shared Memory Dumps
Displaying the Optimizer Plan of an Executing Query
Displaying Bitmap Pages
Enhanced onstat -g Output Displays
onstat -g ses session_id
onstat -g sql session_id
onstat -g xmp query_id
onstat -g xqp query_id
Switching to or Starting the Server in Single-User Mode
In This Chapter
Operating Modes of Extended Parallel Server
Single-User Mode
Starting the Server in Single-User Mode
Switching the Server to or from Single-User Mode
Single-User Mode in Conversion and Reversion
Formatting External Tables for DB2 or Windows
In This Chapter
External Tables and Data Migration
Data Migration to DB2
Data Migration to Windows Platforms
Output from the dbschema Utility
Displaying the Optimizer Plan of an Executing Query
In This Chapter
Displaying Query Plans with onmode -q explain Commands
Displaying the Plan of a Currently Executing Query
Limitations on Displaying Current Query Plans
Allocating Memory Through Resource Classes
In This Chapter
Resource Classes
Resource Class Configuration Parameters
The SET ENVIRONMENT DS_CLASS Statement
The onutil SET DS_CLASSINFO Command
The onmode -q ... DS_CLASS Command
The onstat -g ... cfg DS_CLASSINFO Command
Resource Classes in Distributed Queries
Consolidating Table Storage Spaces Online
In This Chapter
Repack Threads
The onutil REPACK DATA command
The REPACK_THREAD_MAX Configuration Parameter
The onutil SET REPACK_THREAD_MAX Command
Monitoring the Progress of Repack Threads
Interrupted Repack Threads
Repacking RAW Tables
Tables That Cannot Be Repacked
Propagating Access Privileges Through Roles
In This Chapter
Granting Privileges to Roles and the WITH GRANT OPTION Keywords
The IFMX_ROLES_WITH_GRANT Environment Variable
System Catalog Enhancements
Roles in Creating Views
Privileges Granted Through Roles
Privileges Revoked Through Roles
Restricting DDL Storage Spaces
In This Chapter
The USABLE_SPACES Session Environment Setting
Setting USABLE_SPACES in the Shell
The SET ENVIRONMENT USABLE_SPACES Statement
The Mutability Attribute
Limitations of this Feature
Forcing DDL Execution
In This Chapter
The FORCE_DDL_EXEC Session Environment Setting
Disabling Deferred Close
Summary of User Interface Enhancements
In This Chapter
Command-Line Options
dbschema
oninit
onmode
onstat -g
onutil
Configuration Parameters
Environment Variables
SQL Statement Syntax
System Catalog Tables
Appendix A. Syntax Summaries of Selected Utilities
oninit
onmode
onstat
onutil
Appendix B. SQL Keywords of Extended Parallel Server
A
B
C
D
E
F
G
H
I
J-K
L
M
N
O
P
R
S
T
U
V
W
X-Z
Appendix C. Accessibility
Dotted Decimal Syntax Diagrams
Notices
Trademarks
Index
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]