performance improvement for deadline table – NW 711

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

Symptom
Long runtime to execute HC ITSAM_AP_BTM 00002
Other terms
Deadline table performance improvement, Reorganization functionality of the deadline table in transaction SWF_SLS_DEADL
Reason and Prerequisites
Read of table ‘SWFSLSDEADL’ is taking long time.
Solution
Table(SWFSLSDEADL) index ‘APP’ has been enhanced by including the field ‘STATUS’. It also fixes the reorganization functionality (cleanup of deadlines) of the deadline table in [...]

MaxDB Version 7.6 parameter settings for OLTP/BW

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

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 [...]

NetWeaver 7.0/7.10: System copy (supplementary note)

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

Symptom
This note contains additions to the guidelines.
Other terms
Partitioned tables, bitmap indexes, clustered indexes, encoded vector index (EVI), UMG_POOL_TABLE, performance during activation of transfer rule (control indicator L_PSAVER)
Reason and Prerequisites
You want to copy an NetWeaver system homogeneously or heterogeneously using R3load.
A heterogeneous database migration to INFORMIX is not supported.
Solution
Contents
——1. General prerequisites for SAP kernel WEB [...]

Reducing data volume before Unicode Conversion

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

Symptom
You want to reduce large data volume in particular tables
Other terms
Deletion/Archiving of table entries, improving system performance,
Unicode, conversion preparation, SPUMG
Reason and Prerequisites
System performance during Unicode conversion must be improved.
Read the Unicode Conversion Guide.
Solution
This note provides information about tables which show the largest growth in data volume. It is recommended to delete and/or archive [...]

Configuring Maximum Message Size Limits for OOM Error

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

Symptom
You notice that the J2EE Engine restarts frequently, due to an Out Of Memory Error(OOM) (i.e., “java.lang.OutOfMemoryError” ). Traces and thread dumps will exhibit, the following error message: “java.lang.OutOfMemoryError. The JVM(Java Virtual Machine) will exit with an exit code of 666″
Other terms
JDBC, JDBC Adapter, OutOfMemoryError, OOM , Message Size Limit, Limit Number of [...]

Applying SP2 to Enterprise Services Repository and SAP BASIS

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

Symptom
You are currently using the Enterprise services repository of the following version : SP01 of Enhancement Package 1 (EhP1). You would like to update to SP02.
Other terms
SP02 of Enhancement Package 1 (EhP1), SAP NetWeaver Process Integration, SAP NetWeaver Composition Environment, Enterprise Services Repository, SAP BASIS
Reason and Prerequisites
As part of the Enhancement package 1 [...]