------------------------------
TBS-TI Customer Support Finasta
------------------------------

Fact number 1:

Maximum length of BLOB (in bytes) is

2,147,483,647

Fact number 2:
Based on your request to increase it's size to 1 GB or 2 GB as per requirement I have to conclude that these requirements are impossible to be satisfied.

Fact number 3:
Most current driver version is:
C:\DB2V12R1M5F0\SQLLIB\java\jre\bin>java com.ibm.db2.jcc.DB2Jcc -version
IBM Data Server Driver for JDBC and SQLJ 4.37.3

I don't stipulate that upgrading driver will solve your issue, but you should start with current driver...

------------------------------
Jan Nelken
Db2 (LUW) DBA
Open for work
Katowice or Krakow
+48 783 109 863
------------------------------

Original Message:
Sent: Thu December 18, 2025 12:05 AM
From: TBS-TI Customer Support Finasta
Subject: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.19.66

Dear Team,

 

We encountered the following error during the EOD 

 

DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.19.66

 

Upon analysis, we found that the ITEM column in the CMS_ITEM table is defined as a BLOB data type with a size limit of 1,048,576 bytes (approximately 1 MB).

 

We request your assistance to:

 

1. Confirm the current maximum length allowed for this BLOB data type in ITEM column in CMS_ITEM table.

2. If the size is indeed limited to 1 MB, help us increase it to 1 GB or 2 GB as per requirement.

3. Confirm whether a DB reorganization will be necessary after changing the BLOB column size. If required, we would appreciate your assistance in performing the reorganization as well.

 

This change is critical to prevent the bank's EOD process from failing daily.

 

Please advise on the next steps. If needed, we are fine to set up a call with the bank to discuss how we can address these issues.

 

Thank you,

Sarojini Rajasekaran

------------------------------
TBS-TI Customer Support Finasta
------------------------------