Note: Mainframe DB2 is included in the standard Mainframe service rates, with DBA support provided during normal business hours. After‑hours DBA support is provided on a best-effort basis or on-call through a Service Agreement and billed at an hourly rate for professional services.
MNIT’s shared database hosting service offerings provide a lower cost option for agency applications in a multi-tenant environment. Databases in the shared hosting environment should fit all these criteria: small, simple, and low volume workloads.
This service offering includes the following:
Hardware
- The cost of the necessary hosting hardware is invoiced directly to the agency.
- Database platforms are hosted in the MNIT Enterprise Data Center and the Offsite Disaster Recovery site, which are physically secure with appropriate environmental components such as conditioned power, emergency power, fire detection and suppression, and temperature control.
Basic Database System Administration
- Database availability monitoring.
- Database specific performance tuning and troubleshooting.
- Work with agency support teams to troubleshoot database performance issues.
- Database job scheduling.
- Database data exports.
Database System Level Configuration
- Coordinate with MNIT storage teams to allocate storage for initial database installation based on MNIT database storage best practices.
- Work with the agency application data owners to determine future storage needs.
- Create the database, database instance, tablespaces, database files and schema owners.
- Grant database system privileges to agency application owners.
- Manage the database instance configuration settings, including the amount of server memory and how it is allocated.
- Control and monitor the number of concurrent user connections.
- Work with MNIT server system administrators to configure server operating system parameters and apply relevant operating system patches.
Database Systems Maintenance
- Administration and maintenance of databases to ensure that they are available and performing optimally during the defined target availability hours.
- Document major changes to database servers.
Database Systems Support and Monitoring
- Ensure databases are sized properly.
- Increase or add storage for database files as required.
- Configure new storage space for database files as required.
- Execute the necessary parameter adjustments to the system configuration settings for performance optimization.
- Proactive monitoring of database with monitoring tools.
- Troubleshoot and resolve unscheduled service outages.
- Escalate database system software problems to the vendor for resolution.
- 24/7 support through the MNIT Enterprise Service Desk.
Databases on distributed platforms are hosted on dedicated servers/virtual machines (VMs). This service offering is suitable for databases that are large, complex, have high volume workloads or compliance requirements which mandate database segregation.
Agencies may choose to have dedicated hosts for databases based solely on a preference for a segregated database environment for their application
Not included with this service:
- Hosting on server/virtual machines/cloud is charged separately through the appropriate Hosting service.
- Database software and licensing are billed separately to the agency through MNIT Procurement and are not included in the database cost.
Choice of Service
- Production Databases: This is for databases with production data.
- Includes high availability, with backups performed every two hours. The agency may choose opt to use the high availability feature.
- Incidents for production databases may be escalated to a Severity 1 if justified, resulting in the fastest incident resolution target available.
- Support is available during normal business hours. After-hours support is provided on a best-effort basis or on-call through a Service Agreement and billed at an hourly rate for professional services.
- Non-Production Databases: this is for databases with development data.
- High availability is not offered for non-production databases, Backups are performed once per day.
- Incidents may not be escalated to Severity 1.
- Support is available during normal business hours.
