Administering Informix

The following information describes common tasks that an administrator performs to maintain an Informix database in production.

The in4mix and admin user passwords
This topic explains how to obtain password for user in4mix after instance creation is done by the operator. The Informix service is using a private-server installation. The Informix instance user is in4mix because currently it is not possible to let the user informix own a private-server installation. A private-server installation can not perform OS user authentication. For remote connections to the database server a database user admin is automatically generated – after clicking on the instance name in the Instance overview page of CPD.
Managing Informix users
User management involves tasks such as granting users access to the database and creating user IDs.
Exec into the Informix pod
To do some common administration tasks, you must be able to run the exec command on the Informix pod.
Stopping and starting an Informix instance
Stop and start an Informix instance inside a container to perform maintenance tasks.
Restarting the Informix cluster
This topic explains the procedure to restart pods in the Informix cluster.
Monitoring Informix startup after rebooting a node
When a node is restarted, confirm that Informix successfully starts up by monitoring the startup progress.
Security in Informix
Informix on Cloud Pak for Data supports Transport Layer Security (TLS) to encrypt data in transit and Encryption at rest to encrypt data at rest.
Control Informix audit logging
You can configure Informix® audit to send audit log records in the format that is proposed by the Cloud Auditing Data Federation (CADF).
Viewing Informix log files
This topic explains two different procedures to view the Informix database server log file which contains error messages and status information.
Viewing Informix Data Management Console
Informix Data Management Console is a tool that you can use to manage and monitor your integrated Informix databases from a single user interface.