Show TOC

Database Settings for DTR and NWDILocate this document in the navigation structure

Use

The values of the parameters for the Design Time Repository (DTR) in the following table are the minimum requirements if the used AS Java is running the DTR server application only.

Note

It may be necessary to fine-tune the database settings to meet your specific performance requirements. For more information, refer to your database administration manual.

At the beginning, it may be necessary to frequently update the database statistics. For more information, see DTR Web UI Configuration Areas .

Database Platform

Cache Size

Maximum number of simultaneous line locks

Maximum number of currently active connections.

MaxDB

CACHE_SIZE = 500 MB

MAXLOCKS = 300000

MAXUSERTASKS = 50

Microsoft SQL Server

max server memory = 500 MB

Locks = 0 (unlimited)

user connections = 0 (unlimited)

Oracle

(Primary data cache) DB_CACHE_SIZE = 48 MB

Max: unlimited

N/A

(unlimited)

PROCESSES = 80, SESSIONS = 96

Max: unlimited (2^31)

IBM DB2 for i5/OS

No global parameter

Set parameter BP = 5000 (16k pages)

LOCKLIST = 50 (4k pages = 200k)

MAXAPPLS = AUTOMATIC (unlimited)

IBM i5/OS

System managed; covered by system sizing process.

Not configurable. System limit: 500 million

Not configurable. (Configure JDBC connection pool of AS Java instead.)

Note

IBM DB2 and IBM i5/OS: To enforce a maximum temporary storage consumption onto all JDBC database jobs on a machine, a separate shared (memory) pool can be assigned to them.

Database Logs and Backups

Since the DTR is the primary storage for source code in the NWDI and all DTR data is stored in the database, it is vital to set up database logs and regular backups properly to prevent any loss of data in case of system failures.

Note

For best performance and safety, the database log volumes should be located on different physical disks than the data volumes.