I am building a perl script that reads into the performance monitor table - The query that executes more than 3 minutes. In the process i am capturing into another table. The column stmt has a column definition of clob 16m. While my program is trying to insert values into the table i am getting the following error message
"[Tue Oct 17 12:20:30 2006] sql_snap_test.pl: DBD:B2::st fetch failed: [IBM][CLI Driver][DB2/NT] SQL0930N There is not enough storage available to process the statement. SQLSTATE=57011"
I did some research to increase the statement heap size. But i don't want to change any database configuration parameter.
Can you guys throw your thoughts please.
Certified Database adminstrator for linux unix and windows
Certified advance database adminstrator for linux unix and windows
Certified Database adminstrator for ZOS 8.1