APAR status
Closed as program error.
Error description
The table mon_table_profile in sysadmin database defines nrows as integer and not as bigint like in sysmaster:sysptnhdr or float in systables. So if nrows > maxint, than the mon_table_profile job gets the error: -1215 Value too large to fit in an INTEGER. The INTEGER or SERIAL data type can accept numbers with absolute values from 0 through 2,147,483,647 (plus or minus (2 to the 31st power) - 1). So we have no historical table data in sysadmin database ...
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users who have large number of row records (> maxint) in * * their table * **************************************************************** * 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 number
IT06744
Reported component name
IFMX ULT WHSE E
Reported component ID
IM0019BOS
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-01-26
Closed date
2015-10-16
Last modified date
2015-10-16
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
IFMX ULT WHSE E
Fixed component ID
IM0019BOS
Applicable component levels
RC10 PSN
UP
RC10 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBJS3","label":"Informix Ultimate Warehouse Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
16 October 2015