SQL-IMS

Monitoring and Service Level Agreement

Monitoring is more than knowing if a system is up and running. It is maintaining a data warehouse with appropriate statistics and information from the past to the present. So first you can use it and analyze long running or periodical problems, or with the right tool like our SQL-IMS/SLA you can export information from SLA for internal or external usage.
Our SLA tool is used at IBM Switzerland and Austria to fulfill and document SLA for approximately a few hundred servers.

Features of SQL-IMS

SQL-IMS general features

  • Multi-tenant capable
  • security controls
  • No access to productive data of the managed systems
  • Monitoring (PRTG) with history specifically for database systems On Call Service/operation time
  • Integrated monitoring of Web pages specifically for WME
  • Integrated analysis of log-files with definable by dialogue rules
  • Interface for ticket generation; additional SMS and / or e-mails can be generated
  • Excel reporting included for easy data export


SQL-IMS/INFO for database-services

  • Hardware / Instance / Service-(De-)Activation and Change (CUSTOMER-Process-supporting)
  • Database / used / reserved disk space
  • Database / user and group rights / privileged accounts
  • Database / Jobs (maintenance) On Call Service/operation time
  • GSD, URT/MEF3 User-Revalidierung
  • Reports


SQL-IMS/BACKUP-CONTROL for databases, WME and eMail & eMail &collaboration (for example Notes)

  • Supports TSM/TDP
  • Supports backup on disc
  • Definition of different Backup-Plans, definition of a Default-Backup-Plan
  • Monitoring of Backups


SQL-IMS/SLA

Based on monitoring of individual data the SLA required for data compression of appropriate specific parameters (defined via dialogue) will be generated in exact time. The data will be automatically submitted by e-mail.

Architecture, Security and Performance

Analyzing complex software-systems and requirements to find the gaps and close them is something that needs experience and good education. In our team are specialists from OS to DB from Coding to Project- and Quality Management.

>> SQL-IMS Overview (PDF)