MaxDB Version 7.6 parameter settings for OLTP/BW

July 24, 2009 at 10:39 am

[] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] [] []

Symptom
This note describes how to set the database parameters for MaxDB Version 7.6 for OLTP systems, CRM systems and BW systems.
Other terms
Parameter, SHAREDSQL, -9, -8, -4000, SIMULATE_VECTORIO, AWE, SQLDBC, out of memory, PTS:1142200, PTS: 1139530, memory leak, PTS: 1149611, memory, -1105, MAXLOCKS, JOIN_MAXTABLEVEL9, LOG_QUEUE_COUNT, _IOPROCS_FOR_READER, AK Datapart too short, -9405
Reason and Prerequisites
This note [...]

FAQ: SAP MaxDB OLTP cluster table attribute

June 14, 2009 at 5:49 pm

[] [] [] [] []

Symptom
As of Version 7.6, SAP MaxDB provides the option to specify the cluster attribute for tables. This note explains the advantages of table clustering in the OLTP environment and where it can be used. This note deals with questions about table clustering in the database. It provides answers and refers you to [...]