This is a configuration step that you have to take to manually configure SAP NetWeaver Development Infrastructure (NWDI) only if 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. To change the database properties, use your database management tool.
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.
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 100000.
● MAXLOCKS at least 300000.
● MAXUSERTASKS at least 50 (higher than sysDS.maximumConnections).
3. Restart the database.
i. 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”.
ii. Expand the tree view at <SAPSID>.
iii. Select the node with the blue cylinder showing the server’s name.
The Database Administration interface is opened.
iv. To restart the database, choose Offline, and wait until the state of the database change to offline.
v. Choose Online.
To Configure |
Use This Tool |
Max Heap Size |
J2EE Engine – Config Tool |
Maximum Database Connections |
Visual Administrator |
MaxRequestContentLength |
Visual Administrator |
Database Properties |
SAP Management Console |
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 SAP WAS ABAP.
2. Choose Cluster Data → <instance ID> → server_ID<number>.
3. Adjust Max Heap Size:
JDK/JRE Vendor |
Recommended Heap Size |
SUN |
512 MB |
IBM / Compaq |
1024 MB |
Perform this step only if you want to check or change the values.
...
1. Open the Visual Administrator tool.
○ <SAP-install-dir>\<SID>\JC<instance no.>\j2ee\admin\go.batfor a Java only system.
○ <SAP-install-dir>\<SID>\DVEBMGS<instance no.>\j2ee\ admin\go.bat if you also use SAP WAS ABAP.
2. Log on as an administrator.
3. Choose Server → Services → JDBC Connector.
4. Choose the Properties tab strip and select sysDS.maximumConnections.
For MaxDB, as a rule of thumb, set the value to 45.
5. Under Value, enter the new parameter value. To set the parameter, choose Update. Save your changes.
The JDBC Connector service is restarted. If this fails, start the SAP Management Console and restart the server completely.
You must increase the J2EE Engine parameter MaxRequestContentLength if you need to import archives larger than 131072 KB (128 MB).
...
1. In the Visual Administrator tool, choose Dispatcher → Services → HTTP Provider → Properties.
2. From the parameter list, select MaxRequestContentLength.
3. Under Value, enter the new parameter value.
As a rule of thumb, set the value to 1GB (1048576 KB).
4. To set the parameter, choose Update.
5. Save your changes and restart the service.