IBM Support

Received error of "The SQLDA is too small"

Question & Answer


Question

What should I do if I receive the following error? The error returned with CDA is: java.sql.SQLException: The SQLDA is too small. The error returned with DataStage is: main_program: [WS Classic][ODBC/CLI Driver][Data Server] SQLPrepare - Error code: x000B0024. The SQLDA is too small. SQLEXT(x000229fc, x002a03a4)

Cause

It appears that the FETCHBUFFERSIZE in JDBC isn't big enough to handle the request.

Answer

Add the FETCHBUFFERSIZE to the connection URL following the steps below.

1. First. select EDIT CONNECTION



2. Then add to the following to the end of Connection URL

:FETCHBUFFERSIZE=1000000



and click FINISH.

NOTE: Now, Classic is capped at a 5000 column definition, so check to see how many columns there are. With such a large definition, there may be other downstream issues as the server configuration. You may need to increase MESSAGEPOOLSIZE, along with other sizes to allow this to work.

[{"Product":{"code":"SSDP9S","label":"InfoSphere Classic Federation Server for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General issues","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21606281