SELECT from z/OS much data -> DB29320W

When we select the data using CLI or Command Editor on Windows from
VARCHAR(32000) field on DB2 for z/OS v8, we get the data truncated with the
following message:



DB29320W Output has been truncated. Explanation: The full query result cannot be
fetched as supplied. Command line processor output can be a maximum of
MAX_STATETMENT_SIZE characters. However the output of any particular column
cannot exceed MAX_COLUMN_SIZE characters in length. User response: The CLP query
can be rewritten to fetch a shorter string. Use of another interface to DB2 can
also help in overcoming the CLP’s limitation.

 


Selecting the same data from db2/Windows to db2/Windows works fine, e.g. without
truncation. So, something wrong with db2 on z/OS or with DB2 Connect on Windows.




Is there any way to increase MAX_* parameters?