Administering Informix
You can perform administrative tasks for Informix such as managing users,
controlling audit logging, starting and stopping an instance, etc. to maintain Informix database in
production. Ensure that you have the required permissions to complete tasks.
Service configuration
| Task | Required permissions | Details |
|---|---|---|
| Changing the Informix license | Instance administrator | Change the license of your Informix service before or after creating the service instance. |
Database configuration
| Task | Required permissions | Details |
|---|---|---|
| Stopping and starting an Informix instance | Instance administrator | Stop and start an Informix instance inside a container. |
| Exec into the Informix pod | Instance administrator | Do some common administration tasks by running the exec command on the Informix pod. |
Security
| Task | Required permissions | Details |
|---|---|---|
| Exporting IBM® Software Hub audit records to a security information and event management solution | Instance administrator | Record user activities for Informix. |
| Managing Informix users | Instance administrator | Manage users' access to the database and create user IDs. |
| Control Informix audit logging | Instance administrator | Configure Informix audit to send audit log records in the format that is proposed by the Cloud Auditing Data Federation (CADF). |
| Security in Informix | Instance administrator | Encrypt data in transit and at rest using Transport Layer Security (TLS) supported by Informix on Cloud Pak for Data. |
| The in4mix and admin user passwords | Instance administrator | Obtain password for user in4mix after instance creation is done by the operator. |
Resource management
| Task | Required permissions | Details |
|---|---|---|
| Manually scaling resources for services | Instance administrator | Adjust Informix by scaling resources to support high availability or to increase processing capacity. Resources can be scaled based on predefined resource configurations. |
| Automatically scaling resources for services | Not supported | |
| Shutting down and restarting services | Instance administrator | Manually shut down Informix to prevent it from using resources. You can restart the service when you need to use it again. |
| Viewing Informix Data Management Console | Instance administrator | Manage and monitor integrated Informix databases from a single user interface, Informix Data Management Consolde. |
| Viewing Informix log files | Instance administrator | View the Informix database server log file which captures error messages and status information. |
| Restarting the Informix cluster | Instance administrator | Restart pods in the Informix cluster. |
| Monitoring Informix startup after rebooting a node | Instance administrator | Monitor the Informix startup progress. |
Backup and restore
| Task | Required permissions | Details |
|---|---|---|
| Backing up and restoring IBM Software Hub | Cluster administrator | Choose the correct method to back up and restore IBM Software Hub. |
Data migration
| Task | Required permissions | Details |
|---|---|---|
| Migrating Informix data between clusters | Instance administrator | Import or export Informix data between Cloud Pak for Data clusters. |