Informix: Using Docker Compose for Informix
Many years ago, at the beginning of my IT carreer, I was a member of the software support (and hotline) for an ERP software. The main database system was (and still is) Oracle, but we supported also Microsoft SQL Server, IBM DB/2 and Informix.
I liked Informix, because it was quite easy to install. Luckily, I had very few support request for it, because I didn't know very much of it.
Although Informix was baught by IBM many years ago an assumed to be dead since decades (by those who weren't enthusiasts), new major and minor version are still released. Version 15 was released at the end of November 2024...
If you need an Informix database, for tests or as a part of a project, you can use Docker Compose.
Here's my docker-compose.yml:
services:
informix:
image: icr.io/informix/informix-developer-database
privileged: true
environment:
- LICENSE=accept
ports:
- 9088:9088
- 27017:27017
- 27018:27018
- 27883:27883Let's pull the image and start the container:
# docker compose pull
# docker compose up -d[+] Pulling 9/9
✔ informix Pulled 219.6s
✔ 4a5cf5a9d206 Pull complete 14.9s
✔ 8edfc3594276 Pull complete 14.9s
✔ 5a243fbe941c Pull complete 15.0s
✔ 89060167b7e4 Pull complete 84.1s
✔ 0a221ba3895c Pull complete 84.2s
✔ 0d0f440961c7 Pull complete 84.2s
✔ cc948c0188ca Pull complete 189.4s
✔ b646dbf71fc6 Pull complete 207.4s
[+] Running 2/2
✔ Network informix_default Created 0.2s
✔ Container informix-informix-1 StartedThen let's have a look at the log files:
informix-1 | [2025-01-16T06:54:29Z] >>>
informix-1 | [2025-01-16T06:54:29Z] >>> LICENSE: ACCEPT
informix-1 | [2025-01-16T06:54:29Z] >>> LICENSE_SERVER:
informix-1 | [2025-01-16T06:54:29Z] >>> DBA_USER:
informix-1 | [2025-01-16T06:54:29Z] >>> INFORMIX_PASSWORD: in4mix
informix-1 | [2025-01-16T06:54:29Z] >>> DBA_PASSWORD:
informix-1 | [2025-01-16T06:54:29Z] >>> HQADMIN_PASSWORD: Passw0rd
informix-1 | [2025-01-16T06:54:29Z] >>> USER_MANAGEMENT:
informix-1 | [2025-01-16T06:54:29Z] >>> SIZE: SMALL
informix-1 | [2025-01-16T06:54:29Z] >>> TYPE: OLTP
informix-1 | [2025-01-16T06:54:29Z] >>> STORAGE:
informix-1 | [2025-01-16T06:54:29Z] >>> MEMORY_PERCENTAGE:
informix-1 | [2025-01-16T06:54:29Z] >>> CPU_PERCENTAGE:
informix-1 | [2025-01-16T06:54:29Z] >>> BUFFERS_PERCENTAGE: 80
informix-1 | [2025-01-16T06:54:29Z] >>> SHMVIRT_PERCENTAGE: 19
informix-1 | [2025-01-16T06:54:29Z] >>> NONPDQ_PERCENTAGE: 1
informix-1 | [2025-01-16T06:54:29Z] >>> DISK_ENCRYPTION: OFF
informix-1 | [2025-01-16T06:54:29Z] >>> DEBUG: OFF
informix-1 | [2025-01-16T06:54:29Z] >>>
informix-1 | [2025-01-16T06:54:29Z] >>> MAPPED_HOSTNAME: 07d4d8965b20
informix-1 | [2025-01-16T06:54:29Z] >>> MAPPED_SQLI_PORT: 9088
informix-1 | [2025-01-16T06:54:29Z] >>>
informix-1 | [2025-01-16T06:54:29Z] >>> ONCONFIG_FILE:
informix-1 | [2025-01-16T06:54:29Z] >>> SQLHOSTS_FILE:
informix-1 | [2025-01-16T06:54:29Z] >>> REST_PROP_FILE:
informix-1 | [2025-01-16T06:54:29Z] >>> MONGO_PROP_FILE:
informix-1 | [2025-01-16T06:54:29Z] >>> MQTT_PROP_FILE:
informix-1 | [2025-01-16T06:54:29Z] >>> DBSERVERNAME:
informix-1 | [2025-01-16T06:54:29Z] >>> DBSERVERALIAS:
informix-1 | [2025-01-16T06:54:29Z] >>> INIT_FILE:
informix-1 | [2025-01-16T06:54:29Z] >>> RUN_FILE_PRE_INIT:
informix-1 | [2025-01-16T06:54:29Z] >>> RUN_FILE_POST_INIT:
informix-1 | [2025-01-16T06:54:29Z] >>> CONFIGURE_INIT:
informix-1 | [2025-01-16T06:54:29Z] >>> EDITION_INSTALLER:
informix-1 | [2025-01-16T06:54:29Z] >>>
informix-1 | [2025-01-16T06:54:29Z] >>> PORT_DRDA: ON
informix-1 | [2025-01-16T06:54:29Z] >>> PORT_REST: ON
informix-1 | [2025-01-16T06:54:29Z] >>> PORT_MONGO: ON
informix-1 | [2025-01-16T06:54:29Z] >>> PORT_MQTT: ON
informix-1 | [2025-01-16T06:54:29Z] >>> TLS_CONNECTIONS: OFF
informix-1 | [2025-01-16T06:54:29Z] >>> TLS_CONNECTIONS_STATUS_FILE: /opt/ibm/config/tls_connections_status_file
informix-1 | [2025-01-16T06:54:29Z] >>> WL_CREDENTIALS_STATUS_FILE: /opt/ibm/config/wl_credentials_status_file
informix-1 | [2025-01-16T06:54:29Z] >>>
informix-1 | [2025-01-16T06:54:29Z] >>> HA:
informix-1 | [2025-01-16T06:54:29Z] >>> HA_PRIMARY:
informix-1 | [2025-01-16T06:54:29Z] >>> HA_PRI_DBSERVERNAME:
informix-1 | [2025-01-16T06:54:29Z] >>> HQSERVER:
informix-1 | [2025-01-16T06:54:29Z] >>> HQAGENT:
informix-1 | [2025-01-16T06:54:29Z] >>> HQSETUP:
informix-1 | [2025-01-16T06:54:29Z] >>> HQSERVER_MAPPED_HOSTNAME:
informix-1 | [2025-01-16T06:54:29Z] >>> HQSERVER_MAPPED_HTTP_PORT: 8080
informix-1 | [2025-01-16T06:54:29Z] >>> HQSERVER_MAPPED_HTTPS_PORT: 8081
informix-1 | [2025-01-16T06:54:29Z] >>>
informix-1 | [2025-01-16T06:54:29Z] >>> Start container
informix-1 | [2025-01-16T06:54:29Z] >>> Continue with existing connection setup
informix-1 | [2025-01-16T06:54:29Z] >>> Check for edition installer
informix-1 | [2025-01-16T06:54:29Z] >>> Create data directories
informix-1 | [2025-01-16T06:54:29Z] >>> /opt/ibm/data
informix-1 | [2025-01-16T06:54:29Z] >>> [COMPLETED]
informix-1 | [2025-01-16T06:54:29Z] >>> Create sqlhosts file
informix-1 | [2025-01-16T06:54:29Z] >>> /opt/ibm/informix/etc/sqlhosts
informix-1 | [2025-01-16T06:54:29Z] >>> /opt/ibm/config/sqlhosts FILEEXISTS=0
informix-1 | [2025-01-16T06:54:29Z] >>> Create default sqlhosts
informix-1 | [2025-01-16T06:54:29Z] >>> touch /opt/ibm/config/sqlhosts
informix-1 | [2025-01-16T06:54:29Z] >>> [COMPLETED]
informix-1 | [2025-01-16T06:54:29Z] >>> Create ONCONFIG file
informix-1 | [2025-01-16T06:54:29Z] >>> /opt/ibm/informix/etc/onconfig
informix-1 | [2025-01-16T06:54:29Z] >>> Create DEFAULT onconfig
informix-1 | [2025-01-16T06:54:29Z] >>> Copy onconfig.std /opt/ibm/config/onconfig
informix-1 | [2025-01-16T06:54:29Z] >>> Set up small system
informix-1 | [2025-01-16T06:54:29Z] >>> MODIFY ONCONFIG: /opt/ibm/scripts/informix_config.small
informix-1 | [2025-01-16T06:54:29Z] >>> MODIFY ONCONFIG: /opt/ibm/informix/etc/onconfig
informix-1 | [2025-01-16T06:54:29Z] >>> ONCONFIG UPDATE: AUTO_TUNE - 1
informix-1 | [2025-01-16T06:54:29Z] >>> ONCONFIG UPDATE: DIRECT_IO - 1
informix-1 | [2025-01-16T06:54:29Z] >>> ONCONFIG UPDATE: DUMPSHMEM - 0
informix-1 | [2025-01-16T06:54:30Z] >>> ONCONFIG UPDATE: LOGFILES - 10
informix-1 | [2025-01-16T06:54:30Z] >>> ONCONFIG UPDATE: LOGBUFF - 128
informix-1 | [2025-01-16T06:54:30Z] >>> ONCONFIG UPDATE: PHYSBUFF - 128
informix-1 | [2025-01-16T06:54:30Z] >>> ONCONFIG UPDATE: ROOTSIZE - 350000
informix-1 | [2025-01-16T06:54:30Z] >>> ONCONFIG UPDATE: SINGLE_CPU_VP - 1
informix-1 | [2025-01-16T06:54:30Z] >>> [COMPLETED]
informix-1 | [2025-01-16T06:54:30Z] >>> Set up sch_init_informix.sql file
informix-1 | [2025-01-16T06:54:30Z] >>> Use small setup sch_init_informix.sql
informix-1 | [2025-01-16T06:54:30Z] >>> [COMPLETED]
informix-1 | [2025-01-16T06:54:30Z] >>> Update hostname in file(s)
informix-1 | [2025-01-16T06:54:30Z] >>> /opt/ibm/informix/etc/sqlhosts
informix-1 | [2025-01-16T06:54:30Z] >>> Updating HOSTNAME in /opt/ibm/informix/etc/sqlhosts
informix-1 | [2025-01-16T06:54:30Z] >>> [COMPLETED]
informix-1 | [2025-01-16T06:54:30Z] >>> Create MSGPATH file
informix-1 | [2025-01-16T06:54:30Z] >>> /opt/ibm/data/logs/online.log
informix-1 | [2025-01-16T06:54:30Z] >>> [COMPLETED]
informix-1 | [2025-01-16T06:54:30Z] >>> Create rootdbs
informix-1 | [2025-01-16T06:54:30Z] >>> /opt/ibm/data/spaces/rootdbs.000
informix-1 | [2025-01-16T06:54:30Z] >>> [COMPLETED]
informix-1 | [2025-01-16T06:54:30Z] >>> Run informix_custom_install.sh
informix-1 | [2025-01-16T06:54:30Z] >>> Remove existing WL properties files
informix-1 | [2025-01-16T06:54:30Z] >>> Clean up existing server
informix-1 | [2025-01-16T06:54:30Z] >>> INFORMIX_CLEAN param1: ALWAYS
informix-1 | [2025-01-16T06:54:30Z] >>> Clean up oninit processes
informix-1 | [2025-01-16T06:54:30Z] >>> PIDS:
informix-1 | [2025-01-16T06:54:30Z] >>> Remaining oninit processes - if any
informix-1 | [2025-01-16T06:54:30Z] >>> PIDS:
informix-1 | [2025-01-16T06:54:30Z] >>> Clean up all SHM
informix-1 | [2025-01-16T06:54:30Z] >>> Clean up all SEM
informix-1 | [2025-01-16T06:54:30Z] >>> Informix disk initialization
informix-1 | Warning: The IBM Informix Dynamic Server Developer Edition license restriction limits
informix-1 | the total shared memory size for this server to 16777216 KB. The
informix-1 | maximum allowable shared memory will be set to this size. (SHMTOTAL)
informix-1 | [2025-01-16T06:54:41Z] >>> Waiting for sysadmin
informix-1 | [2025-01-16T06:54:46Z] >>> Waiting for sysadmin
informix-1 | [2025-01-16T06:54:51Z] >>> Waiting for sysadmin
informix-1 | [2025-01-16T06:54:56Z] >>> Waiting for sysadmin
informix-1 | [2025-01-16T06:55:01Z] >>> Waiting for sysadmin
informix-1 | [2025-01-16T06:55:06Z] >>> Waiting for sysadmin
informix-1 | [2025-01-16T06:55:07Z] >>> [COMPLETED]
informix-1 | [2025-01-16T06:55:07Z] >>> Set up Wire Listener (WL)
informix-1 | [2025-01-16T06:55:07Z] >>> Start WL (2025-01-16T06:55:07Z)
informix-1 | [2025-01-16T06:55:07Z] >>> Create default WL Mongo properties file
informix-1 | [2025-01-16T06:55:07Z] >>> WL Mongo: 0 0
informix-1 | [2025-01-16T06:55:07Z] >>> WL: REST properties file /opt/ibm/config/wl_rest.properties does not exist
informix-1 | [2025-01-16T06:55:07Z] >>> Create default WL REST properties file
informix-1 | [2025-01-16T06:55:07Z] >>> WL REST: 0 0
informix-1 | [2025-01-16T06:55:07Z] >>> Create default WL MQTT properties
informix-1 | [2025-01-16T06:55:07Z] >>> WL MQTT: 0 0
informix-1 | [2025-01-16T06:55:07Z] >>> WL cmd: java -jar '/opt/ibm/informix'/bin/jsonListener.jar -config /opt/ibm/informix/etc/wl_rest.properties -config /opt/ibm/informix/etc/wl_mongo.properties -config /opt/ibm/informix/etc/wl_mqtt.properties -logfile /opt/ibm/informix/etc/json_listener_logging.log -loglevel info -start &
informix-1 | [2025-01-16T06:55:08Z] >>> [COMPLETED]
informix-1 | [2025-01-16T06:55:08Z] >>> Execute init-startup scripts
informix-1 | [2025-01-16T06:55:08Z] >>> [COMPLETED]
informix-1 | [2025-01-16T06:55:08Z] >>> ###
informix-1 | [2025-01-16T06:55:08Z] >>> ### Informix container login information:
informix-1 | [2025-01-16T06:55:08Z] >>> ### user: informix
informix-1 | [2025-01-16T06:55:08Z] >>> ### password: in4mix
informix-1 | [2025-01-16T06:55:08Z] >>> ###
informix-1 | [2025-01-16T06:55:08Z] >>> ### Type exit to quit the startup shell
informix-1 | [2025-01-16T06:55:08Z] >>> ### This will stop the container
informix-1 | [2025-01-16T06:55:08Z] >>> ###
informix-1 | [2025-01-16T06:55:08Z] >>> ### For interactive shell run:
informix-1 | [2025-01-16T06:55:08Z] >>> ### docker exec -it <container-name | -id> bash
informix-1 | [2025-01-16T06:55:08Z] >>> ###
informix-1 | [2025-01-16T06:55:08Z] >>> ### To start the container run:
informix-1 | [2025-01-16T06:55:08Z] >>> ### docker start <container-name | -id>
informix-1 | [2025-01-16T06:55:08Z] >>> ###
informix-1 | [2025-01-16T06:55:08Z] >>> ### To safely shut down the container run:
informix-1 | [2025-01-16T06:55:08Z] >>> ### docker stop <container-name | -id>
informix-1 | [2025-01-16T06:55:08Z] >>> ###
informix-1 | 06:54:30 IBM Informix Dynamic Server Started.
informix-1 | 06:54:30 Requested shared memory segment size rounded from 4500KB to 4992KB
informix-1 |
informix-1 | Thu Jan 16 06:54:32 2025
informix-1 |
informix-1 | 06:54:32 Requested shared memory segment size rounded from 111028KB to 111032KB
informix-1 | 06:54:32 Successfully added a bufferpool of page size 2K.
informix-1 |
informix-1 | 06:54:32 Event alarms enabled. ALARMPROG = '/opt/ibm/informix/etc/alarmprogram.sh'
informix-1 | 06:54:32 Booting Language <c> from module <>
informix-1 | 06:54:32 Loading Module <CNULL>
informix-1 | 06:54:32 Booting Language <builtin> from module <>
informix-1 | 06:54:32 Loading Module <BUILTINNULL>
informix-1 | 2025-01-16 06:54:37.367 DR: DRAUTO is 0 (Off)
informix-1 | 2025-01-16 06:54:37.367 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
informix-1 | 2025-01-16 06:54:37.368 Event notification facility epoll enabled.
informix-1 | 2025-01-16 06:54:37.491 IBM Informix Dynamic Server Version 14.10.FC9W1DE
informix-1 | 2025-01-16 06:54:37.492 Performance Advisory: Currently IBM Informix Dynamic Server cannot
informix-1 | support KAIO on the device containing
informix-1 | '/opt/ibm/data/spaces/rootdbs.000'
informix-1 | 2025-01-16 06:54:37.492 Results: Direct and concurrent I/O are disabled for this chunk.
informix-1 | 2025-01-16 06:54:37.493 Action: Standard AIO (possibly buffered) will be used for I/O
informix-1 | to this chunk.
informix-1 | 2025-01-16 06:54:37.495 Expanding cooked chunk /opt/ibm/data/spaces/rootdbs.000 to full size...
informix-1 | 2025-01-16 06:54:39.875 IBM Informix Dynamic Server Initialized -- Complete Disk Initialized.
informix-1 | 2025-01-16 06:54:39.876 Started 1 B-tree scanners.
informix-1 | 2025-01-16 06:54:39.876 B-tree scanner threshold set at 5000.
informix-1 | 2025-01-16 06:54:39.876 B-tree scanner range scan size set to -1.
informix-1 | 2025-01-16 06:54:39.876 B-tree scanner ALICE mode set to 6.
informix-1 | 2025-01-16 06:54:39.876 B-tree scanner index compression level set to med.
informix-1 | 2025-01-16 06:54:39.906 Dataskip is now OFF for all dbspaces
informix-1 | 2025-01-16 06:54:39.933 Building 'sysmaster' database ...
informix-1 | 2025-01-16 06:54:39.969 Checkpoint Completed: duration was 0 seconds.
informix-1 | 2025-01-16 06:54:39.969 Thu Jan 16 - loguniq 1, logpos 0x418, timestamp: 0xae Interval: 2
informix-1 |
informix-1 | 2025-01-16 06:54:39.969 Maximum server connections 0
informix-1 | 2025-01-16 06:54:39.970 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 6, Llog used 1
informix-1 |
informix-1 | 2025-01-16 06:54:39.977 On-Line Mode
informix-1 | 2025-01-16 06:54:43.239 Dynamically allocated new virtual shared memory segment (size 8192KB)
informix-1 | 2025-01-16 06:54:43.239 Memory sizes:resident:4992 KB, virtual:32656 KB, message:0, bufferpool:111032, SHMTOTAL:16777216 KB
informix-1 | 2025-01-16 06:54:43.356 Performance Advisory: Based on the current workload, the physical log might be too small to
informix-1 | accommodate the time it takes to flush the buffer pool.
informix-1 | 2025-01-16 06:54:43.356 Results: The server might block transactions during checkpoints.
informix-1 | 2025-01-16 06:54:43.356 Action: If transactions are blocked during the checkpoint, increase the size of the
informix-1 | physical log to at least 716800 KB.
informix-1 | 2025-01-16 06:54:43.356 Performance Advisory: The physical log is too small for automatic checkpoints.
informix-1 | 2025-01-16 06:54:43.356 Results: Automatic checkpoints are disabled.
informix-1 | 2025-01-16 06:54:43.356 Action: To enable automatic checkpoints, increase the physical log to at least 716800 KB.
informix-1 | 2025-01-16 06:54:46.899 Booting Language <spl> from module <>
informix-1 | 2025-01-16 06:54:46.899 Loading Module <SPLNULL>
informix-1 | 2025-01-16 06:54:50.478 Unloading Module <SPLNULL>
informix-1 | 2025-01-16 06:54:50.487 Loading Module <SPLNULL>
informix-1 | 2025-01-16 06:54:53.863 Checkpoint Completed: duration was 0 seconds.
informix-1 | 2025-01-16 06:54:53.863 Thu Jan 16 - loguniq 1, logpos 0x12e6018, timestamp: 0x1462a Interval: 3
informix-1 |
informix-1 | 2025-01-16 06:54:53.863 Maximum server connections 1
informix-1 | 2025-01-16 06:54:53.863 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 9, Llog used 4838
informix-1 |
informix-1 | 2025-01-16 06:54:55.356 Logical Log 1 Complete, timestamp: 0x1b90e.
informix-1 | 2025-01-16 06:54:57.488 Checkpoint Completed: duration was 0 seconds.
informix-1 | 2025-01-16 06:54:57.489 Thu Jan 16 - loguniq 2, logpos 0x64e018, timestamp: 0x1b94b Interval: 4
informix-1 |
informix-1 | 2025-01-16 06:54:57.489 Maximum server connections 1
informix-1 | 2025-01-16 06:54:57.489 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 30, Llog used 1776
informix-1 |
informix-1 | 2025-01-16 06:55:00.218 Checkpoint Completed: duration was 0 seconds.
informix-1 | 2025-01-16 06:55:00.218 Thu Jan 16 - loguniq 2, logpos 0xd3e018, timestamp: 0x22c04 Interval: 5
informix-1 |
informix-1 | 2025-01-16 06:55:00.218 Maximum server connections 1
informix-1 | 2025-01-16 06:55:00.218 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 58, Llog used 1776
informix-1 |
informix-1 | 2025-01-16 06:55:00.297 'sysmaster' database built successfully.
informix-1 | 2025-01-16 06:55:00.356 'sysutils' database built successfully.
informix-1 | 2025-01-16 06:55:00.363 'sysuser' database built successfully.
informix-1 | 2025-01-16 06:55:07.363 Building 'sysadmin' database ...
informix-1 | 2025-01-16 06:55:07.789 Performance Advisory: Logical log file size might be too small for a
informix-1 | checkpoint to complete.
informix-1 | 2025-01-16 06:55:07.789 Results: The size of individual logical log files is too small for
informix-1 | the current workload, resulting in each log file filling very
informix-1 | quickly. If log files fill in less than 30 seconds, the checkpoint
informix-1 | might remain blocked because the last log file fills during the time
informix-1 | needed to perform the checkpoint.
informix-1 | 2025-01-16 06:55:07.789 Action: Increase the size of the individual logical log files so
informix-1 | that it takes at least 30 seconds to fill each one. Look at the
informix-1 | online log to determine how quickly the log files are filling, and
informix-1 | then increase the size of the files proportionately.
informix-1 | 2025-01-16 06:55:08.357 Logical Log 2 Complete, timestamp: 0x2a7a5.
informix-1 | starting rest listener on port 27018
informix-1 | starting mongo listener on port 27017
informix-1 | starting mqtt listener on port 27883
informix-1 | 2025-01-16 06:55:09.267 Dynamically allocated new virtual shared memory segment (size 8192KB)
informix-1 | 2025-01-16 06:55:09.267 Memory sizes:resident:4992 KB, virtual:40848 KB, message:0, bufferpool:111032, SHMTOTAL:16777216 KB
informix-1 | 2025-01-16 06:55:13.745 SCHAPI: Using (/opt/ibm/informix/etc/sysadmin/sch_init_informix.sql) to initialize this instance.
informix-1 |
informix-1 | 2025-01-16 06:55:13.835 SCHAPI: Started dbScheduler thread.
informix-1 | 2025-01-16 06:55:13.835 'sysadmin' database built successfully.
informix-1 | 2025-01-16 06:55:13.861 Auto Registration is synced
informix-1 | 2025-01-16 06:55:14.105 Updating Low Memory Manager to version 11
informix-1 | 2025-01-16 06:55:14.112 Installing patch to Low Memory Manager code. version(11.01)
informix-1 | 2025-01-16 06:55:14.550 Installing patch to upgrade ph_task code. version(13.10)
informix-1 | 2025-01-16 06:55:14.589 SCHAPI: Started 2 dbWorker threads.
informix-1 | 2025-01-16 06:55:17.288 Checkpoint Completed: duration was 3 seconds.
informix-1 | 2025-01-16 06:55:17.288 Thu Jan 16 - loguniq 3, logpos 0xa94080, timestamp: 0x3522e Interval: 6
informix-1 |
informix-1 | 2025-01-16 06:55:17.288 Maximum server connections 1
informix-1 | 2025-01-16 06:55:17.288 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 178, Llog used 5277
informix-1 |
informix-1 | 2025-01-16 07:00:37.980 Checkpoint Completed: duration was 0 seconds.
informix-1 | 2025-01-16 07:00:37.980 Thu Jan 16 - loguniq 3, logpos 0x1021018, timestamp: 0x39354 Interval: 7
informix-1 |
informix-1 | 2025-01-16 07:00:37.980 Maximum server connections 1
informix-1 | 2025-01-16 07:00:37.980 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 344, Llog used 1421
informix-1 |
informix-1 | 2025-01-16 07:10:37.449 Checkpoint Completed: duration was 0 seconds.
informix-1 | 2025-01-16 07:10:37.449 Thu Jan 16 - loguniq 3, logpos 0x1023018, timestamp: 0x39362 Interval: 8
informix-1 |
informix-1 | 2025-01-16 07:10:37.449 Maximum server connections 1
informix-1 | 2025-01-16 07:10:37.449 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 14, Llog used 2Informix is now running, and we can access it - either locally using dbaccess, or any other database client that supports Informix JDBC.