Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get the value of a special parameter

Status
Not open for further replies.
Scooby74

Scooby74

Programmer
Jul 9, 2004
4
DE
Hi all,

probably it is an easy questions for specialists:

How can I get the value of the parameter "sort_heap_top"? I need this value to set the parameter "sheapthres".

Many thanks.
Ulrich
 
Sort by date Sort by votes
you mean 'sort heap threshold'?

issue the command line:

get dbm cfg

you get a long list of parameters for the database manager configuration....

T. Blom
Information analyst
tbl@shimano-eu.com
 
Upvote 0 Downvote
No, I mean 'sort_heap_top'. Does anyone know how to extract this parameter?

Thanks
Scooby
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Conditionally have a subfile display record blink
Replies
5
Views
396
mikrom
mikrom
evr72
  • Locked
  • Question
Get last field value into next row
Replies
6
Views
183
SkipVought
S
usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
111
usr1234
usr1234
C
  • Locked
  • Question
AS400 Compile Error
Replies
8
Views
359
chuckw0325
C
Rohit K Gupta
  • Locked
  • Question
DB2 Equivalent of IGNORE_DUP_KEY
Replies
0
Views
132
Rohit K Gupta
Rohit K Gupta

Part and Inventory Search

Sponsor

Back
Top