Number of questions: 70
Time allowed in minutes: 90
Required passing score: 68%
IBM Certified System Administrator – Informix 12.10
This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to install, administer and tune, configure, monitor, and troubleshoot Informix v12.10.
Section 1 – Installation and Configuration (17%)
Determine appropriate connection types and communication protocols
Plan for Distributed System capabilities
Determine the number and size and placement of logical and physical logs to accommodate transaction activity
Set up Operating System files and parameters
Knowledge of migration and upgrading
Knowledge of installation options
Knowledge of activation of built-in technologies
Knowledge of Dynamic and automatic configuration parameters
Understanding different operating modes
Knowledge of data movement utilities
Knowledge of Mobile database
Section 2 – Space Management (11%)
Configure and manage dbspaces and sbspaces
Knowledge of Online Table Management
Knowledge of dynamic storage
Knowledge of pro-active/reactive space allocation
Knowledge of fragmentation and database design
Knowledge of compression
Section 3 – System Activity Monitoring and Troubleshooting (13%)
Monitor and isolate problems using system databases
Monitor the message log file for abnormal activity
Use the Informix utilities to view information about the database server
Use the admin API to view information about the database server
SQL concurrency and locking
Section 4 – Performance Tuning (16%)
Configure shared memory parameters
Best practices for logical and physical design of dbspaces
Utilize Parallel Database Query (PDQ) to optimize query performance
Use UPDATE STATISTICS to achieve optimal performance
Manage network parameters for optimal communication performance
Knowledge of DSS vs OLTP tuning differences
Manage temporary tables and files
Knowledge of autonomic features of the engine
Section 5 – OAT and Database Scheduler (4%)
Knowledge of general OAT functionality
Understanding, using and administering tasks and sensors
Section 6 – Backup and Restore (10%)
Understand the different backup and restore tools, functionality, and levels
Configure Onbar parameters for optimal backup and restore performance
Configure ontape parameters for optimal backup and restore performance
Knowledge of archecker functionality
Understanding various restore options
Understanding and using Informix Primary Storage Manager (PSM)
Section 7 – Replication and High Availability (16%)
Demonstrate the ability to manage and configure ER
Demonstrate the ability to manage and configure GRID
Demonstrate the ability to manage and configure an H/A cluster
Demonstrate knowledge of Connection Manager
Demonstrate the ability to manage and use ifxclone
Knowledge of new replication and H/A cluster features
Performing rolling application and database software upgrades
Section 8 – Warehousing (4%)
Knowledge of general warehousing functionality in the engine
Knowledge of Informix Warehouse Accellerator (IWA)
Section 9 – Security (9%)
Knowledge of Non OS users
Knowledge of auditing
Knowledge of trusted context and trusted connections
Knowledge of authentication and authorization
Knowledge of privileges and roles
Demonstrate knowledge of session, replication and ondisk encryption
IBM Certified System Administrator – Informix 12.10
Job Role Description / Target Audience
This certification demonstrates that the successful candidate has important knowledge, skills, and abilities necessary to install, administer and tune, configure, monitor, and troubleshoot Informix v12.10
Recommended Prerequisite Skills
Significant experience with intermediate or advanced level skills as an Informix v12.10 system/database administrator.
This certification requires 1 test(s).
Test C2090-619 – IBM Informix 12.10 System Administrator
Which configuration parameter can toggle the automatic expansion of storage spaces?
Which statement is FALSE about dbspace configurable page sizes?
A. Dbspace page size can only be set for non-critical dbspaces.
B. Possible page sizes are multiples of the default page size up to 16 kb.
C. Configure page sizes as close to the backup / restore and network buffer size as possible for efficient data transfer across the wire.
D. Dbspace page size should be configured to accommodate the greatest number of average row sizes with a minimum of remainder pages being used.
An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?
A. Increase the value of MAX_INCOMPLETE_CONNECTIONS.
B. Increase the value of NUMFDSERVERS and add more poll threads.
C. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.
D. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.
Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?
Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?
C. FORCE AUTO