Discussion:
SQL0930N There is not enough storage available to process the statement.
(too old to reply)
g***@us.ibm.com
2009-06-07 04:00:01 UTC
Permalink
I did migration for db2 zlinux from V8 to V9.5,migration for database completed, but for some datanases I can't connected and have :SQL0930N There is not enough storage available to process the statement.SQLSTATE=57011db2diag.log DB2 UDB, buffer pool services, sqlbinit, probe:550MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
blair kenneth adamache
2009-06-08 14:08:32 UTC
Permalink
Post by g***@us.ibm.com
I did migration for db2 zlinux from V8 to V9.5,migration for database completed, but for some datanases I can't connected and have :SQL0930N There is not enough storage available to process the statement.SQLSTATE=57011db2diag.log DB2 UDB, buffer pool services, sqlbinit, probe:550MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
Perhaps you need to allocate more memory to the bufferpool(s)?

e.g.

db2 update db cfg for <<dbname>> using buffpage nnnn

Loading...