mercoledì 10 luglio 2013

Database Cache Hit Ratio is too low. Condition (92,9 < 98)



SETOPT command
Use this command to update a server option dynamically without stopping and restarting the server. A SETOPT command contained in a macro or a script cannot be rolled back.

Privilege class

To issue this command, you must have system privilege.

Syntax

Read syntax diagramSkip visual syntax diagram>>-SETOPT--option_name--option_value---------------------------><

Parameters


option_name (Required)
Specifies a text string of information identifying the server option to be updated. The maximum length of the text string is 255 characters. The following options are available:
  • BUFPOOLSIZE
  • COMMTIMEOUT
  • EXPINTERVAL
  • EXPQUIET
  • IDLETIMEOUT
  • LOGWARNFULLPERCENT
  • MAXSESSIONS
  • MOVEBATCHSIZE
  • MOVESIZETHRESH
  • RESTOREINTERVAL
  • SHREDDING
  • THROUGHPUTDATATHRESHOLD
  • THROUGHPUTTIMETHRESHOLD
  • TXNGROUPMAX
option_value (Required)
Specifies the value for the server option.


Syntax


Read syntax diagramSkip visual syntax diagram>>-BUFPoolsize--kilobytes--------------------------------------><

Parameters


kilobytes
Specifies the size of the database buffer pool in kilobytes. The minimum value is 256. The maximum value is limited by available virtual memory size. The default value is 32768.

Examples


bufpoolsize 512


MODIFICA IL dsmserv.opt e metti il valore di memoria pari ad 1/8 del valore complessivo della RAM di sistema .
















alle