IBM Support

IT39569: INFORMIXHQ.SH LIST GIVES INCORRECT OUTPUT

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • In InformixHQ.sh file following line in the script is a problem:
    
    "ps -aef | grep informixhq | grep jar | awk '{print $2 " "$8 " "
    $11 " " $12}'
    
    For example my ps output is:
    
    1)running "ps -aef | grep informixhq | grep jar" gives:
    root      9308     1  0  2021 ?        00:00:00 sudo -E -u
    informix
    PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/l
    ib/mit/bin:/usr/lib/mit/sbin LD_LIBRARY_PATH= java
    -Dlog4j2.formatMsgNoLookups=true -Dfile.encoding=utf-8 -jar
    informixhq-server.jar informixhq-server.properties
    informix  9312  9308  0  2021 ?        00:06:22 java
    -Dlog4j2.formatMsgNoLookups=true -Dfile.encoding=utf-8 -jar
    informixhq-server.jar informixhq-server.properties
    root      9477     1  0  2021 ?        00:00:00 sudo -E -u
    informix
    PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/l
    ib/mit/bin:/usr/lib/mit/sbin LD_LIBRARY_PATH= java
    -Dlog4j2.formatMsgNoLookups=true -Dfile.encoding=utf-8 -jar
    informixhq-agent.jar informixhq-agent-example.properties
    
    2) running InformixHQ.sh list gives:
    
     ./InformixHQ.sh list
    
    ProcessId  Name  Jar  Properties
    9308 sudo informix
    PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/l
    ib/mit/bin:/usr/lib/mit/sbin
    9312 java -jar informixhq-server.jar
    9477 sudo informix
    PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/l
    ib/mit/bin:/usr/lib/mit/sbin
    9481 java -jar informixhq-agent.jar
    9529 sudo informix
    PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/l
    ib/mit/bin:/usr/lib/mit/sbin
    9533 java -jar informixhq-server.jar
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix HQ prior to 2.0.0 (Informix Server         *
    * 14.10.FC8).                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix HQ 2.0.0.                                *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix HQ 2.0.0 (Informix Server 14.10.FC8).
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT39569

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-01-06

  • Closed date

    2022-04-11

  • Last modified date

    2022-04-11

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
12 April 2022