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

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