Course Content
Introduction To Informix Dynamic Server (IDS) Terminology
- Define basic Informix Dynamic Server terms
- Query the spymaster database for information about the server
IDS Installation & Setup
- Identify the right product
- Extract & Install the IDS product
- Setup raw chunks for space
- Setup Environment
- CONFIG parameter changes
- SQLHOSTS file changes
- Instance creation
- Bounce Informix Server Instance
- Switching between server modes
Managing Disk Space
Physical Units
Logical Unit.
- Shared Memory
- Resident portion
- Virtual portion
- Message portion
Monitoring Message Log File
Managing Configuration Parameter File
SMI Tables
Monitor/Manage Database Server Activity Using Tools
- onstat
- onmode
- oncheck
- onparams
- onmonitor
- oninit
- ondblog
- onspaces
Backing Up Data And Logical Log Files (Ontape, Onbar)
Data Migration Tools
- load/unload
- dbexport/dbimport
- onunload/onload
- dbschema
Checkpoints
- Finder Utility
- Update Statistics
- Set Explain
Database Logging
Physical Logging
Logical Logging
Session Management
IDS Data Types
- Identify the Informix data types
- Choose the appropriate data type for a data column
Creating Databases And Tables
- Create databases and tables
- Determine database logging and storage requirements
- Locate where the database server stores a table on disk
- Create temporary tables
- Locate where the database server stores temporary tables
- Use the system catalog tables to gather information
- Use the DB schema utility
Altering and Deleting Databases and Tables
- Drop a database and Drop a table
- Alter a table
- Convert a simple large object to a smart large object
Create, Alter, And Drop Indexes
- Build an index, Alter, drop and rename an index
- Identify the four index characteristics
Managing And Maintaining Indexes
- Explain the benefits of indexing
- Evaluate the costs involved when indexing
- Explain the maintenance necessary with indexes
- Describe effective management of indexes
- Enable or disable indexes
Table And Index Partitioning
- List the ways to fragment a table
- Create a fragmented table
- Create a detached fragmented index
- Describe temporary fragmented table and index usage
Managing and Maintaining Indexes
- Explain the benefits of indexing
- Evaluate the costs involved when indexing
- Explain the maintenance necessary with indexes
- Describe effective management of indexes
- Enable or disable indexes
Data Security
- Use the database, table, and column-level privileges
- Use the GRANT and REVOKE statements
- Use role-based authorization
Views
- Create views
- Use views to present derived and aggregate data
- Use views to hide joins from users
Introduction To Stored Procedures
- Explain the purpose of stored procedures
- Explain the advantages of using stored procedures
Triggers
- Create and execute a trigger
- Drop a trigger
- Use the system catalogs to access trigger information