Changing the statement heap parameter on iSeries

pts.
Tags:
Application software
Availability
Backup and Recovery
CIO
Computer Associates
Data center operations
Database Management Systems
DataCenter
DB2 administration
DB2 Everyplace
Development
E-business
Hardware
IBM DB2
IT architecture
Modeling
Operating systems
Performance/Tuning
Physical security
Services
Space/structure
Storage
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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.
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following