IC89509: SCHEDULER MIGHT LOG SCHAPI ERROR -1215 MESSAGES IN ONLINELOG

APAR status

• Closed as program error.

Error description

• It's possible you see SCHAPI -1215 error messages in onlinelog,
  coming from scheduler tasks like mon_users, for example:
  
  03:28:49  SCHAPI: [mon_users 11-1130] Error -1215 Value exceeds
  limit of
  INTEGER precision
  
  
  Background is that several sysmaster table columns, which are
  used by the scheduler to collect data, are defined as BIGINT.
  However, some of those columns in scheduler's results tables are
  defined as INTEGER.
  So whenever values are returned from sysmaster tables which fit
  in BIGINT but not in INTEGER,
  this results in error -1215 being written to the onlinelog.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users who have the dbscheduler running on the system might   *
  * see this issue.                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC8                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC8
  

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

• RB70 PSY

     UP