Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL0954C How do I update the applheapsz

756 views
Skip to first unread message

Jeff Neill

unread,
Nov 5, 2001, 5:00:40 AM11/5/01
to
I'm getting an error SQL0954C.

How do I increase the database configuration parameter (applheapsz) to allow a
larger application heap?

Thanks,

Jeff.


--
Posted from [212.250.177.149]
via Mailgate.ORG Server - http://www.Mailgate.ORG

Larry Edelstein

unread,
Nov 5, 2001, 8:41:49 AM11/5/01
to
DB2 UPDATE DB CFG FOR dbalias USING APPLHEAPSZ nnn

Do not be surprised, however, if you need to tune or tweak a few other db or dbm
parms ... they tend to be interdependent.

Larry Edelstein

Larry Menard

unread,
Nov 5, 2001, 9:02:46 AM11/5/01
to
Jeff,

From a command line (or if Windows, a DB2 Command Window), make sure the
Instance is started ("db2start"), then:

"db2 update db cfg for yyy using applheapsz zzz" (where 'zzz' = the db name and
'zzz' = the required heap size)

Then to activate that change, all applications must disconnect from the
database. I find the surest way to do that is to restart the Instance ("db2stop
force", "db2start").

Jeff Neill wrote:

--
Larry Menard
IBM Workstation Database (DB2) Performance Team
Defender of Geese and of all things Natural


0 new messages