SQWareWeb:db2

From wiki_dbSQWare_3.1
Jump to: navigation, search

Presentation

Usage

It is the specific part of 'graphic' restitution of dbSQWare™ for DB2.
SQWareWeb DB2 formats (graphs or tables) datas uploaded in SQWareRepository DB2 by many scripts of SQWareProduction module for DB2. Almost all of the data presented are dynamically generated (volumes, versions, ...), only the data type repository or settings are stored manually in the relevant tables.
Example of static table : tsqw_Repository

Examples of pages presented for DB2:

  • Inventory of instances DB2 with volumetry, version, environnement, ...
  • Distribution of instance in number/volumetry per environnement/client/version
  • Detail of volumetry (Global, databases, tablespaces, FS, backups)
  • Trace of scripts executions of SQWareProduction DB2 (beginning, end, options, duration, return code, ...)
  • Performances datas
  • Capacity planning
  • ...


Presentation model of SQWareWeb™ for DB2.

Explanation of directories

Directories located in $gvsqw_RootexpdbWebdba/htdocs/db2 :

  • bin : Directory containing standard scripts
  • general : Directory containing general reports for all managed instances
  • detail : Directory containing contient specific report for one selected instance DB2
  • tech : Directory containing contient "technical" reports, some general and others specific per instance DB2
  • dashboard : Directory containing contient changes on instances (removed/created, patched/upgraded), and distributions



Nuvola apps important.png
Warning:
Do not change the standard configuration files of dbSQWare™.

Use directories $gvsqw_RootexpdbWebdba/custom/* for customizations. This will facilitate version upgrades.