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.

1. This is procedure (1) to view Informix log files:
   1. Use the following command to get the name of the Informix database server pod:

      oc -n <namespace> get pods --selector app.kubernetes.io/name=informix-server-cr
      Example:
      # oc -n cpd-instance get pods --selector app.kubernetes.io/name=informix-server-cr
      NAME                                                  READY   STATUS    RESTARTS   AGE
      informix-1679478255711465-cm-0                        1/1     Running   0          22h
      informix-1679478255711465-cp4dapi-6bd6d758b4-scth5    1/1     Running   0          22h
      informix-1679478255711465-monitor-5f5798f8f7-nzm8d    1/1     Running   0          22h
      informix-1679478255711465-server-0                    1/1     Running   0          22h
      informix-1679478255711465-wlistener-b9fc68775-6f8vf   1/1     Running   0          22h

   2. Use oc logs to view the Informix database container logs:

      oc -n <namespace> logs <Informix engine pod name> | more -
      Example:
      # oc -n cpd-instance logs informix-1679478255711465-server-0 | more -
      
      2023-03-22 09:48:01.212  Maximum server connections 2 
      2023-03-22 09:48:01.212  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 2, Plog used 195, Llog used 7121
      
      2023-03-22 09:48:14.620  Logical Log 4 Complete, timestamp: 0x5512d.
      2023-03-22 09:48:14.771  Logical Log 1 - Backup Started
      2023-03-22 09:48:14.888  Logical Log 1 - Backup Aborted
      2023-03-22 09:48:15.751  Expanding cooked chunk /opt/informix/data/dbspaces/ssl_informix0_plog_p_1 to full size...
      2023-03-22 09:48:18.662  Dynamically allocated new virtual shared memory segment (size 8192KB)
      2023-03-22 09:48:18.662  Memory sizes:resident:4796 KB, virtual:49040 KB, message:0, bufferpool:222208, no SHMTOTAL limit
      2023-03-22 09:48:19.018  Checkpoint Completed:  duration was 0 seconds.
      2023-03-22 09:48:19.018  Wed Mar 22 - loguniq 5, logpos 0x525654, timestamp: 0x57cd2 Interval: 7
      2023-03-22 09:48:19.018  Maximum server connections 2 
      2023-03-22 09:48:19.018  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 391, Llog used 6855
      2023-03-22 09:48:19.022  Increasing # of AIO VPs to 2
      2023-03-22 09:48:21.195  Checkpoint Completed:  duration was 0 seconds.
      2023-03-22 09:48:21.195  Wed Mar 22 - loguniq 5, logpos 0x528084, timestamp: 0x57cf1 Interval: 8
      2023-03-22 09:48:21.195  Maximum server connections 2 
      2023-03-22 09:48:21.195  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 25, Llog used 3
      2023-03-22 09:48:21.632  Checkpoint Completed:  duration was 0 seconds.
      2023-03-22 09:48:21.633  Wed Mar 22 - loguniq 5, logpos 0x52a0d0, timestamp: 0x57cfc Interval: 9
      --More--

2. This is procedure (2) to view Informix log files.
   1. Run the exec command on the Informix pod. For details, see Exec into the Informix pod.
   2. Go to the Informix server log directory folder /opt/informix/shared/server/informix[0-9]/log.
   3. Up to 10 server pods can be brought up. Log file corresponding to individual pod can be found in the respective informix[0-9] directory.
   4. View/tail the Informix log:

      tail -f  ssl_informix[0-9].log