IBM Support

IT40836: DOCUMENT THE " UINT2 RANGE LIMITATION OF SYSMASTER:SYSSQLTRACE.SQL_EXECUTIONS INTEGER COLUMN"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as Permanent restriction.

Error description

  • database: sysmaster table: syssqltrace
    database: sysadmin table: mon_syssqltrace
    
    In above 2 Tables, syssqltrace and mon_syssqltrace, we have
    Column: sql_executions as integer. But, Internally
    sql_executions is mapped to a variable which is declared as
    uint2 in Code. The Range of uint2 is 0 to 65535.
    
    https://www.ibm.com/docs/en/informix-servers/14.10?topic=types-i
    nteger-data#ids_esqlc_0163
    The integer data types
    
    In the above link in Documentation, there is NO where mentioned
    about DATATYPE: unsigned int and its Range.
    
    So, Please add this information to documentation.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * NONE                                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * NONE                                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • see Error Description
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT40836

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED PRS

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-05-04

  • Closed date

    2024-04-18

  • Last modified date

    2024-04-18

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 April 2024