Database Settings for DTR and NWDI
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.
|
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.) |
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.