Finish preparing earlier versions of 12.10 databases for JSON compatibility
To make databases that were created with earlier versions of Informix® 12.10 JSON compatible, you must complete some post-migration steps.
Procedure
-
Prepare any databases that were created in 12.10.xC1 for JSON
compatibility.
If you upgraded to 12.10.xC4 or later fixpacks, skip this step because all databases are made JSON compatible during conversion.
If you upgraded to 12.10.xC3 or 12.10.xC2, complete these steps:
- If you used the wire listener in 12.10.xC2 or 12.10.xC3, after you upgrade to 12.10.xC4 or later fixpacks you must drop and recreate any indexes that you created on your collections. You do not need to drop and recreate the index that is automatically created on the _id field of a collection.
-
If you had binary JSON (BSON) DATE fields in your documents
in 12.10.xC2, you must load the data from the external table that
you created before you upgraded to a later 12.10 fix pack.On the upgraded server:
- If you used the wire listener in 12.10.xC2 with a database that has any uppercase letters in its name, after you upgrade to a later fix pack you must update your applications to use only lowercase letters in the database name.