CODEWITHSUNDEEP
db2
user1340582
user1340582

Reputation: 19729

Altering the IBM DB2 9.7 STMTHEAP

How can I get the current value of my DB2 9.7 DB's STMTHEADP, and how can I alter it?

Upvotes: 1

Views: 2326

Answers (2)

Ampp3
Ampp3

Reputation: 640

Leons is correct, but if you ever need to figure out STMTHEAP size and don't want to use the command line, you can use the following SQL:

SELECT NAME, VALUE, VALUE_FLAGS, MEMBER
FROM SYSIBMADM.DBCFG
WHERE NAME = 'stmtheap'
ORDER BY NAME, MEMBER WITH UR;

Upvotes: 0

Leo
Leo

Reputation: 1514

Open up the command line. On Windows, search your Start Menu for Command Window - Administrator.

To get the current value, use the GET DB CFG command:

db2 get db cfg for MY_DATABASE

To set a new value, use the UPDATE DB CFG command:

db2 update db cfg for MY_DATABASE using STMTHEAP 8192 AUTOMATIC

There's more info in the STMTHEAP information center topic.

Upvotes: 1

Related Questions