Professional Web Applications Themes

Private Sort Memory Allocation Problem - IBM DB2

Hi folks, The following is an error that is logged to the db2diag.log file whenever I run a db2look command. "Not enough memory available for a (private) sort heap of size 8192" Can someone please advise which instance / db parameter I have to increase to satisfy this memory requirement. Many thanks, Tim...

  1. #1

    Default Private Sort Memory Allocation Problem

    Hi folks,

    The following is an error that is logged to the db2diag.log file
    whenever I run a db2look command.

    "Not enough memory available for a (private) sort heap of size
    8192"

    Can someone please advise which instance / db parameter I have to
    increase to satisfy this memory requirement.

    Many thanks,

    Tim
    Tim.D Guest

  2. #2

    Default Re: Private Sort Memory Allocation Problem

    The parm. is at the db cfg level and is called SORTHEAP
    It is set at 8192 pages or 32mb approx.
    It is assigned to each statement where the optimizer identifies a piped
    sort meaning the soreted result set is held there.

    Careful about setting it to high as db2 has at the instance (dbm cfg) a
    parm. that you should also look at which is: SHEAPTHRESH

    HTH, Pierre.

    Tim.D a écrit:
    > Hi folks,
    >
    > The following is an error that is logged to the db2diag.log file
    > whenever I run a db2look command.
    >
    > "Not enough memory available for a (private) sort heap of size
    > 8192"
    >
    > Can someone please advise which instance / db parameter I have to
    > increase to satisfy this memory requirement.
    >
    > Many thanks,
    >
    > Tim
    Pierre Saint-Jacques Guest

Similar Threads

  1. #40701 [NEW]: Memory allocation error
    By michaeldaly at magma dot ca in forum PHP Bugs
    Replies: 25
    Last Post: April 25th, 07:56 PM
  2. How do i adjust memory allocation on mac osx for Freehand MX ??
    By James Noon in forum Macromedia Freehand
    Replies: 2
    Last Post: December 18th, 09:14 PM
  3. memory allocation problems in PHP and how to optimize?
    By lawrence in forum PHP Development
    Replies: 2
    Last Post: October 16th, 04:24 AM
  4. Mapping a session to an allocation of virtual memory
    By Zev Berezin in forum Informix
    Replies: 1
    Last Post: August 3rd, 11:06 AM
  5. Replies: 2
    Last Post: July 25th, 01:27 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139