Configuring AS Java

Use

The shared database for the entire SAP NetWeaver Development Infrastructure (NWDI) is automatically configured by the configuration template. Here you will find information and recommendations in case you want to manually configure some database properties.

Procedure

1. Setting Database Properties

To change the database properties, use can your database management tool.

Example

For an installation with the MaxDB, you find the database console under <database_installation_directory>\SDB\DBM\DBMGui3.exe .
Select the parameters for your database instance according to the example below - for the default values, see Database Settings for DTR and NWDI .
Example

For an installation with the MaxDB, use the Database Managers to connect to the database and select the following values under Configuration Parameters:
- CACHE_SIZE at least 100,000.
- MAXLOCKS at least 300,000.
- MAXUSERTASKS at least 50 (higher than sysDS.maximumConnections ).
Restart the database.
Example
1. For an installation with the MaxDB, open the SAP Management Console which should be available on your Windows desktop, otherwise execute the following command: mmc.exe "<windows-dir>\SAPMMC.MSC" .
2. Expand the tree view at <SAPSID> .
3. Select the node with the blue cylinder showing the server's name.
  
  The database administration interface is opened.
4. To restart the database, choose Offline , and wait until the state of the database change to offline.
5. Choose Online .

2. Setting the Heap Size

Perform this step only if you want to check or change the values.

Open the Config Tool.
- <SAP-install-dir>\<SID>\JC<instance no.>\j2ee\configtool\configtool for Java only system.
- <SAP-install-dir>\<SID>\DVEBMGS<instance no.>\j2ee\configtool\configtool.bat if you also use AS ABAP.
Choose Cluster Data <instance ID> server_ID<number> .

Adjust Max Heap Size :

JDK/JRE Vendor	Recommended Heap Size
SUN	512 MB
IBM / Compaq	1024 MB

3. Setting Maximum Database Connections

Open the Config Tool and navigate to the dbpool service.
Choose the Properties tab and select sysDS.maximumConnections .

Example

For MaxDB, as a rule of thumb, set the value to 45.
Under Value , enter the new parameter value. Save your changes.

The JDBC Connector service is restarted. If this fails, start the SAP Management Console and restart the server completely.