Zero value represents

[Esha1]

I was going through one of the system in which db6 parameter instance_memory should be set to automatic.

Value is set correctly in the system as automatic.

If instance_memory is set to AUTOMATIC, it is possible to determine its value using the following commands:

db2 attach to instance_name (where instance_name is the name of the instance)

db2 get dbm cfg show detail

While in db02 database manager parameter is currently showing value as zero.

Value zero represent initial value or infinite value?

Normally if set as automatic it should represent some value calculated at that time based upon database load.

Edited by: Esha Rajpal on Dec 22, 2008 11:04 AM

[malte_schuenemann]

To me, it seems that you are running an outdated version of the DBACOCKPIT. What is your level of

- the database softwrae

- SAP including patch levels

As an example, for SAP release 700, you should run basis support package 12 or higher.

Malte

[Esha1]

SAP basis release in the system is:

SAP_BASIS SAPKB70013

SAP ECC 6.0

Database system DB6

Release 08.02.0005

DB21085I Instance "db2he1" uses "64" bits and DB2 code release "SQL08025" with

level identifier "03060106".

Informational tokens are "DB2 v8.1.1.112", "s060429", "U807381", and FixPak

"12".

Product is installed at "/usr/opt/db2_08_01".

Edited by: Esha Rajpal on Dec 22, 2008 12:18 PM

[malte_schuenemann]

It seems that the DBACOCKPIT is a victim of v8 design here. In v8.2.2, the cockpit is using table function GT_DBM_CONFIG. You can test this following the documentation

[http://publib.boulder.ibm.com/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/admin/r0011861.htm]

Unfortunately, I do not have anything good for you apart from a hint to a higher version of DB2.

Malte