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

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
ASKED: Jun 8 2005  6:10 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Westfalle
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jun 8 2005  10:36 AM GMT by Westfalle   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

TomLiotta   7410 pts.  |   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.

 
0