Changing the statement heap parameter on iSeries
Hi,
I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400.
I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error "SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "Attach to V1 server is
invalid".) SQLSTATE=58004".
I have also tried the command ATTACH but it gives the same error.
Please guide me and let me know if there is a statement heap parameter on the AS/400 and if yes how to retrieve its value and change it.
Thanks



