Preparing to Install ER/Studio Repository
Go Up to Repository Installation
Contents
For Microsoft SQL Server
If you are using Microsoft SQL Server and case-sensitive nomenclature, you may get connection error messages from ER/Studio Repository. To remedy this, create an empty database with a non-case-sensitive character set (such as Latin1_General_CI_AS), then initialize the database with the Repository utility. Also, ensure you are using Mixed Authentication for server security.
For IBM DB2 for LUW
If ER/Studio Repository will be stored on IBM DB2 for LUW, perform the following procedures to ensure optimal Repository performance:
Creating an IBM DB2 for LUW User Temporary Tablespace
The DB2 UDB database must have a user temporary tablespace with at least a 4 KB page size to create the temporary tables.
Tip: Use a system-managed user temporary tablespace because when managed by the system the user temporary tablespace can grow automatically.
Tip: You can use DBArtisan to create a system managed user temporary tablespace.
Create a user temporary tablespace using the tool of your choice or you can use the following SQL:
Note: Before you run this script, modify the path for the container.
CREATE USER TEMPORARY TABLESPACE REPOTEMP
PAGESIZE 4096
MANAGED BY SYSTEM
USING('D:\DB2\NODE0000\SQL00002\SQLT0004.0')
// here you specify the physical location of the table space
EXTENTSIZE 32
PREFETCHSIZE 16
BUFFERPOOL IBMDEFAULTBP
OVERHEAD 24.10
TRANSFERRATE 0.90
Tuning the IBM DB2 for LUW Database
This procedure tunes the DB2 database so that it does not run out of memory and log space.
- Increase the application heap size and application control heap size to 2048 × 4KB. ===
Tip: To increase the application heap size, right-click the database in the DB2 Control Center, and then click Configure. Then, switch to Performance and modify the values for Application Heap Size (applheapsz) and Application Control Heap Size (appctlheapsz).
- Increase the log file space to 10,000 × 4 KB (or 40 MB).
- Change the number of primary and secondary log files from 3 and 2, to 10 and 10. This provides for a total of 400 MB of primary log space, which should be sufficient for medium to large diagrams.
- Tip: To increase primary and secondary log file sizes, use the Logs tab of the Database Configuration page in the IBM Control Center.
