IBM Support

Received error of "The SQLDA is too small"

Technote (FAQ)


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,


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


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


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.

Document information

More support for: InfoSphere Classic Federation Server for z/OS
General issues

Software version: All Versions

Operating system(s): z/OS

Software edition: All Editions

Reference #: 1606281

Modified date: 01 April 2016