0 pts.
 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

Software/Hardware used:
ASKED: June 8, 2005  6:10 AM
UPDATED: June 9, 2005  3:18 PM

Answer Wiki:
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  Westfalle   0 pts.
All Answer Wiki Contributors:  Westfalle   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Since you’re trying to do this for DB2 UDB on an AS/400, I _think_ the answer is “You don’t.”

AFAIK, there’s no reasonable need for it. I certainly haven’t seen anything similar there.

Are you coming from a DB2 environment under Windows/Linux or z/OS? It would seem Windows/Linux since your question directly references attributes from there. I haven’t seen “stmtheap” for z/OS DB2 either although various heap functions are used.

 107,735 pts.