IT05848: AFTER YOU SELECT FROM SYSMACHINEINFO INTO ANOTHER TABLE, YOU MIG HT GET ERROR -1284 OR GARBAGE RESULTS SELECTING FROM THAT TABLE

APAR status

• Closed as program error.

Error description

• The sysmaster database contains many tables that you can use to
  monitor your system.
  Among those tables is sysmachineinfo, which contains columns of
  OS related information.
  
  However, on Windows, if you select from that table into a target
  table (like it is usually done when creating scheduler sensors),
  you might get error -1284 or garbage results when selecting from
  that target table.
  So far this has been observed for the contents of columns
  os_semnumperid and os_semops.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Windows server users                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC5                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC5
  

Temporary fix

Comments

APAR Information

• 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

• RC10 PSN

     UP

• RC10 PSY

     UP