-904 Resource not available error

[nshen]

Whenever I use CLI interface to execute a SQL Procedure with 30 input VARCHAR(8000) parameters, DB2 would yield -904 Resource not available error. I have changed DB2 server DBM CFG DRDA_HEAP_SZ to 5000, DB CFG APPLHEAPSZ to 5000 and STAT_HEAP_SZ to 32000, but these didn't seem to help.
Any suggestions are appreciated.
Thank you!
Regards, Nancy

 

[MarcLodge]

Hi Nancy,
Sounds as if you have might have some sort of size problem. I would try cutting the number of varchars from 30 to say 15, and beginning to build it back up from there. This may hopefully give you the actual size parameter that is being exceeded, and you may recognise it, and being able to correct.
Hope this helps in some small way
Marc

 

[nshen]

Marc,
Size of stored procedure is definitely the cause, but changing the size is not the solution. I want to find out which DBM or DB parameter that needs to be adjusted so my procedure could run.

- Nancy