Troubleshooting
Problem
Db2 JSON Data load in tables
Db2 data can be inserted in JSon tables using following config
Symptom
While inserting data -sometimes following error
Example :
db2 create table JSonTest (test BLOB(52428800) LOGGED NOT COMPACT )
db2 "insert into JSonTest values (SYSTOOLS.JSON2BSON('{Name:"xxxx"}'))"
SQL0443N Routine "JSON2BSON" (specific name "*2445498") has returned an error
SQLSTATE with diagnostic text "JSON parsing error for: {Name:xxxx}, error
code: 4 ". SQLSTATE=22546
SQLSTATE with diagnostic text "JSON parsing error for: {Name:xxxx}, error
code: 4 ". SQLSTATE=22546
Document Location
Worldwide
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
All Versions
Operating system(s):
AIX, Linux
Document number:
887967
Modified date:
01 May 2025
UID
ibm10887967
Manage My Notification Subscriptions