Requirements for JSON compatibility

JSON compatibility has specific software dependencies and database server requirements.

Java requirements

JSON compatibility requires IBM® Informix® version 12.10.xC2 or later, with the J/Foundation component, which enables services that use Java™.

You must use a supported Java runtime environment. Java version 1.8 is recommended.

MongoDB version

JSON compatibility is based on MongoDB version 2.4, 2.6, and 3.0.

You set the version of the MongoDB API that the wire listener uses by setting the mongo.api.version parameter in the wire listener configuration file. The MongoDB API version affects the type of authentication that you can use. For example, MongoDB version 3.0 supports the MongoDB SCRAM-SHA-1 authentication method, but does not support database server authentication or connections with the REST API.

Database server requirements

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.


Copyright© 2018 HCL Technologies Limited