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.
1. Setting Database Properties
To change the database properties, use can your database management tool.
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 .
For an installation with the MaxDB, use the Database Managers to connect to the database and select the following values under :
CACHE_SIZE at least 100,000.
MAXLOCKS at least 300,000.
MAXUSERTASKS at least 50 (higher than sysDS.maximumConnections ).
Restart the database.
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" .
Expand the tree view at <SAPSID> .
Select the node with the blue cylinder showing the server's name.
The database administration interface is opened.
To restart the database, choose Offline , and wait until the state of the database change to offline.
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
.Adjust Max Heap Size :
JDK/JRE Vendor |
Recommended Heap Size |
---|---|
SUN |
512 MB |
IBM / Compaq |
1024 MB |
3. Setting Maximum Database Connections
Perform this step only if you want to check or change the values.
Open the Config Tool and navigate to the dbpool service.
Choose the Properties tab and select sysDS.maximumConnections .
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.