The following tables summarizes the initial tasks, routine tasks, and configuration tasks that you perform to administer the database server. Table 1 lists initial administration tasks.
Initial Tasks | Reference |
---|---|
Plan for database server | Planning for the Database Server |
Preinstallation operating-system changes | Configuring the Operating System |
Install the database server | IBM Informix: Installation Guide |
Configure the database server | Coserver Configuration |
Define connectivity | Client/Server Communications |
Initialize the database server | Initializing the Database Server |
Table 2 lists database server configuration tasks.
Configuration Tasks | Reference |
---|---|
Manage disk space and storage spaces | Managing Disk Space |
Loading external tables | IBM Informix: Administrator's Reference |
Analyze disk configuration | Data Storage |
Changing database-logging status | LoggingManaging Database-Logging Status |
Administer the logical log:
|
Logical LogManaging Logical-Log Files |
Administer the physical log | Managing the Physical LogCheckpoints and Fast Recovery |
Manage mirroring | MirroringUsing Mirroring |
Manage shared memory | Shared MemoryManaging Shared Memory |
Manage virtual processors | Managing Virtual Processors |
Manage Parallel Data Query (PDQ) | IBM Informix: Performance Guide |
Migrate to a different database server version | IBM Informix: Migration Guide |
Table 3 lists routine administration tasks.
Routine Tasks | Reference |
---|---|
Change database server modes | Managing Database Server Operating Modes |
Refresh data warehousing tables | IBM Informix: Administrator's Reference |
Back up data and logical-log files:
|
IBM Informix: Backup and Restore Guide
IBM Informix: Storage Manager Administrator's Guide |
Monitor activity | Monitoring information in relevant chapters of this book |
Check for data consistency | Consistency Checking |
Tune database server performance | IBM Informix: Performance Guide |