Show TOC

Configuring AS JavaLocate this document in the navigation structure

Use
Note

This is a configuration steps that you have to take to manually configure SAP NetWeaver Development Infrastructure (NWDI), only in case the automatic configuration fails.

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

  1. 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 .

  2. 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 Start of the navigation path Configuration Next navigation step Parameters End of the navigation path:

    • CACHE_SIZE at least 100,000.

    • MAXLOCKS at least 300,000.

    • MAXUSERTASKS at least 50 (higher than sysDS.maximumConnections ).

  3. 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.

  1. 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.

  2. Choose Start of the navigation path Cluster Data Next navigation step <instance ID> Next navigation step server_ID<number> End of the navigation path .

  3. Adjust Max Heap Size :

    JDK/JRE Vendor

    Recommended Heap Size

    SUN

    512 MB

    IBM / Compaq

    1024 MB

3. Setting Maximum Database Connections

Note

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

  1. Open the Config Tool and navigate to the dbpool service.

  2. Choose the Properties tab and select sysDS.maximumConnections .

    Example

    For MaxDB, as a rule of thumb, set the value to 45.

  3. 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.