Home > IT Answers > DataCenter > Changing the statement heap parameter on iSer...
Help

Question

  Asked: Jun 8 2005   6:10 AM GMT
  Asked by: sbkhole

Changing the statement heap parameter on iSeries


DataCenter, Data center operations, Physical security, Space/structure, E-business, IT architecture, Vendors, CIO, Application software, Operating system platforms, Services, Tech support, Third-party services, Hardware, Database Management Systems, DB2, DB2 Administration, Availability, Modeling, Performance/Tuning, DB2 Everyplace, DB2 Implementation, UDB for iSeries/i5, Development, Storage, Backup & recovery, Computer Associates


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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jun 8 2005  10:36 AM GMT  by Westfalle




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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on DataCenter, CIO and Channel.

Looking for relevant DataCenter Whitepapers? Visit the SearchDataCenter.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

TomLiotta  |   Jun 9 2005  3:18PM GMT

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.