Received error of "The SQLDA is too small"

Technote (FAQ)


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.

Rate this page:

(0 users)Average rating

Add comments

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:

2012-08-02

Translate my page

Machine Translation

Content navigation