View previous topic :: View next topic
|
Author |
Message |
rushing
New User
Joined: 25 May 2005 Posts: 13 Location: DaLian?China
|
|
|
|
IF YOU KNOW PLS GIVE ME SOME EXPLANATION FOR THE ABOVE CODE, THANK U VERY MUCH! |
|
Back to top |
|
|
sunnyk
New User
Joined: 20 Oct 2004 Posts: 59
|
|
|
|
This is what i got from a link:
Statement Heap Size (stmtheap)
Although the size of the statement heap does not influence the optimizer in choosing different access paths, it can affect the amount of optimization performed for complex SQL statements.
If the stmtheap parameter is not set large enough, you might receive an SQL warning indicating that there is not enough memory available to process the statement. For example, SQLCODE +437 (SQLSTATE 01602) might indicate that the amount of optimization that has been used to compile a statement is less than the amount that you requested.
If you want to read more, try this link :
publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/c0005035.htm
Regds
Sunny |
|
Back to top |
|
|
rushing
New User
Joined: 25 May 2005 Posts: 13 Location: DaLian?China
|
|
|
|
ok,thank u so much!h |
|
Back to top |
|
|
|