Modules

dbSQWare is composed of four additional modules :

  SQWareProduction

  • Operation at large of DBMS
  • Backups : Oracle (RMAN), Sybase (dump), PgSQL (pg_dump+PITR), MySQL (mysqldump), MsSql (backup), DB2(backup)
  • Update statistics : Sybase (update index statistics), Oracle (DBMS_STATS), MySQL (analyze), MsSql (update statistics), DB2-LUW (RUNSTATS), PostgreSQL (analyze)
  • Réorganization : Sybase (reorg), DB2 (reorg), MySQL (optimize), MsSql(reindex), PostgreSQL (reindex)
  • Collecting indicators

  SQWareRepository

  • CMDB of the SGDB park
  • Various indicators, versions, granular volumetries, parameters
  • Script execution traces : start, end, duration, launch parameters, return code, log extract
  • Tracking of backups : start, end, duration, type, generated volumetry
  • Managing access to SQWareWeb

  SQWareCentral

  • Source repository and settings for operating scripts
  • Centralized scripting as indicators
  • Searching information for park (instances, schemas / databases)
  • DBA Rebound Server

  SQWareWeb

  • Presentation of indicators
  • Graphics, tables, exports Excel
  • Homogeneous restitution regardless of the DBMS
  • General view of instances, types, versions, volumetries
  • Detailed view of the instance, global volumetry, tablespaces / databases, objects
  • Technical view, follow up of jobs, backups, checks volumetries, checks backups
  • Dashboard view, tracking park changes, add / remove instances, patch / upgrade