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
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.
In order to set the Statement Heap size you would need to issue the UPDATE DATABASE CONFIGURATION command in order to update the SQL Statement Heap size in the Database Configuration File.
Command parameters for the UPDATE DATABASE CONFIGURATION include FOR and USING. FOR specifies the database alias to updated and USING specifies the configuration parameter to be updated.
Last Wiki Answer Submitted: June 8, 2005 10:36 am by Westfalle0 pts.