Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    65

    Question Unanswered: About STAT_HEAP_SZ

    I was told to increase these two DB parameters.
    1) Statement Heap Sizes
    2) AGENT_STACK_SZ (?)

    I Havent found the second one.
    Does anybody know where to update it? (Control Center, Command Center, Command Windows , etc.)

    Thanks in advance...

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    AGENT_STACK_SZ on DB2 for Windows is a database manager (dbm) parameter. This parameter does not apply to UNIX-based platforms.

    The general syntax is:
    db2 update dbm cfg using AGENT_STACK_SZ <value>

    See the Administration Guide: Performance for more information.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jul 2004
    Posts
    65
    Thanks a lot Marcus...!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •