Please collect a DB2 trace. Here are the instructions how to do this:
1) Minimize activity on the server. Ideally, only the application or query required should be performed while the trace is on.
2) Rename the db2diag.log and if possible upgrade diaglevel to 4 in the DBM CFG:
db2 update dbm cfg using diaglevel 4
3) Start the trace:
db2trc on -t -f XXXXX.dmp
4) Recreate the error - call the Stored procudure.
5) Turn off the trace:
db2trc off
6) Format and flow the trace files:
db2trc flw XXXXX.dmp XXXXX.flw
db2trc fmt XXXXX.dmp XXXXX.fmt
db2trc fmt -c XXXXX.dmp XXXXX.fmtc
(At this stage, the traces should not wrap.)
Example of a good trace:
Trace truncated : NO
Trace wrapped : NO
if trace continues to wrap, please contact me and we can determine whether the trace is usable or not.
7) From the above files generated, you would need to provide us with the .dmp, .flw, .fmt, .fmtc, and db2diag.log files.
Tar or zip the files. To tar do:
tar -cvf xxxxx.yyy.zzz.files.tar <list of files separated by spaces>
compress xxxxx.yyy.zzz.files.tar
Then send the xxxxx.yyy.zzz.files.tar.Z