Home > IT Answers > Development > Changing the statement heap parameter on iSeries
Sbkhole
0 pts.
 Changing the statement heap parameter on iSeries
Application software, Availability, Backup & recovery, CIO, Computer Associates, Data center operations, Database Management Systems, DataCenter, DB2, DB2 administration, DB2 Everyplace, DB2 Implementation, Development, E-business, Hardware, IT architecture, Modeling, Operating system platforms, Performance/Tuning, Physical security, Services, Space/structure, Storage, Tech support, Third-party services, UDB for iSeries/i5, Vendors
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
RELATED QUESTIONS
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.


RSS - Discussions Help
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.

TomLiotta
 107,735 pts.