Changes the display of the output of the status mode of the cm_ctl command.

(If it has been modified by the P number PH21029, and you have applied an urgent fix that includes it, FUJITSU Enterprise Postgres 14 will work.)

When the cm_ctl command was executed in status mode, there was omission of the output of the header "pid" displayed in "application_information" which outputs the information of the application.

Correct the following in PH21029.

• Add ':' to 'application_information' to output application information
  Output "application_information:"

• Add the header "pid" output to "application_information"
  Outputs "pid" whose header information is missing.

• Changes the number of digits in the numeric portion of connected_time
  Change the display start position of the date and time connected to the conmgr process to correct the gap between the start position of the header and the numeric part. (5 digits backward)

  
  

This fix causes the following incompatibilities when running the cm_ctl command in status mode:

• Add ":" to the display of "application_information"

• Display the header "pid" in "application_information"

• Change the output start position of the "connected_time" header of "application_information"

• Change the start of the date and time output of "connected_time" in "application_information" to 5 digits later.

FUJITSU Enterprise Postgres 13 or earlier

application_information
addr         port  connected_time
10.xxx.x.xx  99999 21655 2021-10-20 09:18:51

FUJITSU Enterprise Postgres 14

application_information:
addr         port  pid       connected_time
10.xxx.x.xx  99999 21655     2021-10-20 09:18:51

When analyzing the output of the cm_ctl command in status mode in a batch or shell script, it may not work correctly if the header is referenced and the third is "connected_time".

For example, when identifying a row of data (numeric part), a string up to the header "addr", "port", and "connected_time" one row before is searched for and identified.

If you are using a batch or shell script to parse the output of the cm_ctl command in status mode, modify it to take into account the number of digits in the header and numeric part of the output.