Skip to Content
0
Former Member
Feb 24, 2009 at 04:11 AM

UPDATESTAT_SAMPLE_ALGO not in cserv.pcf

30 Views

Using new maxdb-parameter-check.cfg file I get this suggested change but in DBMGUI there is now parameter with this name.

Also cserv.pcf does not list any parameter lke this.

Here is out put from check.

n4shost:n4sadm 250> dbanalyzer -d N4S -f maxdb-parameter-check.cfg -o db.file -i -c 1 -t 1,1 -n n4shost

MaxDB Database Analyzer, The Performance Analysis Tool, Version 7.6.00.18

Copyright 2000-2006 by SAP AG

Used protocol directory: /usr/local/download/db.file

Used configuration file: /usr/local/download/maxdb-parameter-check.cfg

===== #0 at 2009-02-23 21:00:08

  • I

  • I Database Analyzer configuration check version 1.08, December 29, 2008

  • I

  • I General information:

  • I --------------------

  • I Instance N4S (n4shost) is up since 2009-02-23 21:00:05

  • I Kernel version: Kernel 7.6.00 Build 018-123-119-055

  • I Number of logical CPUs: 4, physical CPUs: 4, processor type: x86_64

  • I Physical memory 3954 MB, virtual memory 4102 MB, memory allocated from instance: 999.68 MB

  • I Operating system: Linux 2.6.16.60-0.34-smp #1 SMP Fri Jan 16 14:59:01 UTC 2009

  • I Configuration of 'MAXCPU': 2, 'MAXUSERTASKS': 50

  • I Size of data cache 84126 pages, size of converter cache 1258 pages

  • I Number of data volumes 8, usable size 3455984 pages, used size 2314210 pages (66%)

  • I

  • I General checks:

  • I ---------------

  • W1 Recommended value for parameter 'UPDATESTAT_SAMPLE_ALGO' is 1, current value is 0

  • I

  • I If instance N4S is used for Data Warehouse applications, the following recommendations are of interest:

  • I ----------------------------------------------------------------------------------------------------------

  • W1 Recommended value for parameter 'LRU_FOR_SCAN' is YES, current value is NO

===== #1 at 2009-02-23 21:00:13

  • OK

{/CODE}

Yes this is a test drive instance. just trying to get better acquainted with MAXDB and tools to administrate it.

Regards,

Bryan