Database Instance
Each PS is associated with one MD DB Instance and at least one Warehouse DB Instance.
Database Instance stores the following information:
- Database Connection
- Type of DB (Oracle, SQL Server, Informix, etc.)
- Maximum number of connections allowed for the DB Instance
- DB specific optimizations (I.e. VLDB properties)
- Warehouse table prefixes (if required)
- Location for intermediate table storage
- Prioritization scheme to be used when submitting jobs to the DB
-