Dear DBA's,

I selected all the rows from a table and i got a error that the data is truncated due to shortage of system resources. How do i sovle this problem. I am running db2 8.2 on Linux server. The table has around 50000 rows. The errors are below.

[IBM][CLI Driver][DB2/LINUX] SQL10003C There are not enough system resources to process the request. The request cannot be processed. SQLSTATE=57011

[IBM][CLI Driver][DB2/LINUX] SQL0902C A system error (reason code = "192") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005

[IBM][CLI Driver] CLI0002W Data truncated. SQLSTATE=01004

Regards

Prem


DB2 & UDB email list listserv db2-l LazyDBA home page