IT16576: INSERTING A JSON DOCUMENT LARGER THAN 4K INTO A TABLE USING ROUND ROBIN FRAGMENTATION ERRORS WITH -9810 AND ISAM ERROR -12053

APAR status

• Closed as documentation error.

Error description

• Inserting a JSON document larger than 4K into a table that uses
  round robin fragmentation with multiple dbspaces and sbspaces
  can error with -9810 ISAM -12053.
  

Local fix

• This problem can be worked around by adding one of the SBSPACE
  names from the round robin to the ONCONFIG default SBSPACENAME.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Informix 12.10                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * See Problem Conclusion.                                      *
  ****************************************************************
  

Problem conclusion

• JSON and BSON data is stored in sbspaces. You can specify the
  sbspace for JSON and BSON storage in the PUT clause of the
  INSERT statement. However, you must set a default sbspace with
  the SBSPACENAME configuration parameter. When you insert JSON or
  BSON data that exceeds 4 K in size, the data is temporarily
  saved in the default sbspace for processing before being saved
  in the sbspace that you specified.
  

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

Applicable component levels