Version majeure 3.1

Version 3.1.13 – 2017-05-17

  • SQWareCentral for generic: enhance, Add license info in indicators report
  • SQWareProduction for Cassandra: enhance, Add parallelism limitation for backup script
  • SQWareProduction for Cassandra: enhance, Some adjusts for backup script
  • SQWareProduction for Genric: enhance, Add lock in rsync script
  • SQWareProduction for PostgreSQL: bugfix, for backup PITR with rsync method and large database mode 3 attempts to rm old backups
  • SQWareRepository for PostgreSQL: enhance, add support for PG 10
  • SQWareWeb for All: enhance, change images for licence, console …

Version 3.1.12 – 2017-03-08

  • SQWareRepository for PostgreSQL: bugfix, remove « -d » flag when pg version < 9.3
  • SQWareRepository for PostgreSQL: enhance, some adjust for PG 9.6

Version 3.1.11 – 2017-01-20

  • SQWareProduction for Cassandra: enhance, Some adjusts to support C* v3.0 in indicators script
  • SQWareProduction for PostgreSQL: enhance, Modify dump script for distant access
  • SQWareProduction for PostgreSQL: enhance, Modify global lib for distant access
  • SQWareRepository for MySQL: bugfix, modify column table_rows in tsqwmys_VolTables from int to decimal
  • SQWareRepository for MySQL: enhance, add purge of global_log

Version 3.1.10 – 2016-12-23

  • SQWareCentral for generic: enhance, Modify expiration date for « free edition »
  • SQWareCentral for generic: enhance, Modify ssh key gen
  • SQWareProduction for MySQL: enhance, Add backup footprint in dump script
  • SQWareProduction for Oracle: enhance, Add backup footprint in RMAN script
  • SQWareProduction for Oracle: enhance, Add capability to generate distant Statspack report
  • SQWareProduction for Oracle: enhance, Add manage Statspack script (snap,purge)
  • SQWareProduction for PostgreSQL: enhance, Add backup footprint in dump and PITR scripts
  • SQWareProduction for Sybase: enhance, Add backup footprint in dump script
  • SQWareRepository for All: enhance, Add backup footprint table
  • SQWareWeb for All: enhance, Add env in growth instance report
  • SQWareWeb for MySQL: enhance, Add backup footprint reports
  • SQWareWeb for Oracle: enhance, Add ASM support in sqwArchmon
  • SQWareWeb for Oracle: enhance, Add backup footprint reports
  • SQWareWeb for Oracle: enhance, Add env in growth instance report
  • SQWareWeb for PostgreSQL: enhance, Add backup footprint reports
  • SQWareWeb for Sybase: enhance, Add backup footprint reports

Version 3.1.09 – 2016-09-20

  • SQWareCentral for Adabas: bugfix, Some adjusts
  • SQWareCentral for generic: enhance, Add backup custom env for dbSQWare
  • SQWareCentral for PostgreSQL: enhance, Add PITR in check backup
  • SQWareProduction for Adabas: bugfix, Some adjusts
  • SQWareProduction for Cassandra: enhance, Add Backup (all nodes) full/inc script
  • SQWareProduction for MySQL: enhance, Add RsyncBackup script
  • SQWareProduction for Oracle: enhance, Add -PdbList option for GenerateAwr
  • SQWareProduction for Oracle: enhance, Add RsyncBackup script
  • SQWareProduction for Oracle: enhance, Add -Split option for RmanBackup and sqwArchmon scripts
  • SQWareProduction for PostgreSQL: enhance, Add RsyncBackup script
  • SQWareProduction for Sybase: enhance, Add RsyncBackup script
  • SQWareWeb for Adabas: bugfix, Some adjusts

Version 3.1.08 – 2016-09-05

  • SQWareProduction for Adabas: enhance, Add backup script
  • SQWareProduction for Adabas: enhance, Add reorg script
  • SQWareProduction for Adabas: enhance, Add delete checkpoint script

Version 3.1.07 – 2016-08-10

  • SQWareCentral for All: limit mail sending for indicators
  • SQWareCentral for Oracle: limit mail sending for AWR scripts
  • SQWareProduction for Adabas: first support, indicators
  • SQWareProduction for Generic: add pstree info when ptree not available
  • SQWareProduction for Generic: limit size of mail
  • SQWareProduction for MsSQL: bugfix, modify indicators to ignore table with name > 128 because sp_spaceused no support that
  • SQWareProduction for Oracle: bugfix, modify head of AWR summary
  • SQWareRepository for Adabas: first support
  • SQWareRepository for MongoDB: bugfix, add case sensitive on tablename indicators table
  • SQWareWeb for Adabas: first support

Version 3.1.06 – 2016-04-27

  • SQWareProduction for MongoDB: bugfix modify indicators for v3.2
  • SQWareProduction for MongoDB: enhance add v3.2 options in backup script
  • SQWareProduction for Oracle: enhance, Add « Top x event » in AWR summary report
  • SQWareProduction for Oracle: enhance, Add detail PDB for Oracle 12c multitenant in AWR script
  • SQWareRepository for Oracle: enhance, Add detail PDB for Oracle 12c multitenant in AWR tables
  • SQWareWeb for Oracle: enhance, Add detail PDB for Oracle 12c multitenant in AWR reports

Version 3.1.05 – 2016-01-29

  • SQWareProduction for Cassandra: enhance add RollingRestart script
  • SQWareProduction for Generic: enhance add dbSQWare logfile concat (hourly or daily)
  • SQWareProduction for Generic: enhance limit size of « mail » trace insert
  • SQWareProduction for MsSql: enhance add -Rename option in RestoreAllDatabases script
  • SQWareProduction for MySQL: bugfix for trap « corrupt » message when mysqldump
  • SQWareProduction for Oracle: enhance add -SkIna for RMAN backup script
  • SQWareProduction for PostgreSQL: enhance backup archiveXlogs in //

Version 3.1.04 – 2015-11-30

  • SQWareCentral for Generic: enhance, add dbspatch command
  • SQWareProduction for All: enhance insert mail in trace table
  • SQWareProduction for Cassandra: bugfix, add –no-color flag for cqlsh commands
  • SQWareProduction for MsSql: bugfix, suppress trap of ‘Msg 5060, Level 0 … Nonqualified transactions are being rolled back’ message as error
  • SQWareProduction for Oracle: bugfix, modify indicators to trap messages from login.sql
  • SQWareProduction for Oracle: enhance add begin/end snap in monitor perf
  • SQWareProduction for Oracle: enhance add monitor hourly archivelog generation in monitor perf
  • SQWareRepository for All: enhance add column on batch table
  • SQWareRepository for Oracle: enhance add begin/end snap in monitor perf tables
  • SQWareRepository for Oracle: enhance add monitor hourly archivelog generation tables
  • SQWareWeb for All: enhance add all batchs reports
  • SQWareWeb for All: enhance add failed batchs reports
  • SQWareWeb for All: enhance add mail column for all batchs reports
  • SQWareWeb for All: enhance add running/broken batchs reports
  • SQWareWeb for All: enhance, add detail table in distribution reports (general view)
  • SQWareWeb for DB2: enhance add change parameters report (hide)
  • SQWareWeb for DB2: enhance add parameters view (hide)
  • SQWareWeb for Generic: enhance, add targets reports (total, per dbms, per client)
  • SQWareWeb for MongoDB: enhance add change parameters report (hide)
  • SQWareWeb for MongoDB: enhance add parameters view (hide)
  • SQWareWeb for MsSql: enhance add change parameters report (hide)
  • SQWareWeb for MsSql: enhance add parameters view (hide)
  • SQWareWeb for MySQL: enhance add change parameters report (hide)
  • SQWareWeb for MySQL: enhance add parameters view (hide)
  • SQWareWeb for Oracle: enhance add begin/end snap in monitor perf report
  • SQWareWeb for Oracle: enhance add change parameters report (hide)
  • SQWareWeb for Oracle: enhance add monitor hourly archivelog generation in monitor perf
  • SQWareWeb for Oracle: enhance add parameters view (hide)
  • SQWareWeb for PostgreSQL: enhance add change parameters report (hide)
  • SQWareWeb for PostgreSQL: enhance add parameters view (hide)
  • SQWareWeb for Sybase: enhance add change parameters report (hide)
  • SQWareWeb for Sybase: enhance add parameters view (hide)

Version 3.1.03 – 2015-11-11

  • SQWareCentral for All: functionality add RunJob and ParallelRun for central
  • SQWareProduction for All: bugfix, modify break link in « databases » and « GrowthMonth » reports
  • SQWareProduction for MsSql: bugfix, add « ^ » when search backup to delete
  • SQWareProduction for MsSql: bugfix, enforce trap of error when « bsqldb: Msg » and « fisql: Msg » messages
  • SQWareProduction for MsSql: bugfix, modif gen default conf – SQWareProduction
  • SQWareProduction for MsSql: enhance add get backup indicators from msdb
  • SQWareProduction for Oracle: bugfix, add trap of ORA- when delete backup
  • SQWareProduction for Oracle: enhance, modify Rman tools when nocatalog=true
  • SQWareProduction for PostgreSQL: bugfix, add « ^ » when search dump to delete
  • SQWareRepository for MsSql: enhance add tables for backup indicators from msdb
  • SQWareWeb for All: format #####
  • SQWareWeb for MsSql: enhance add backup indicators from msdb

Version 3.1.02 – 2015-09-25

  • SQWareCentral for Cassandra: enhance, add union on tsqw_RepositoryNoSQL for GenLstUniqueOn
  • SQWareCentral for Teradata: enhance add detail by AMP for databases check
  • SQWareProduction for Cassandra: enhance change connection credentials for cqlsh
  • SQWareProduction for Cassandra: enhance, modify cqlsh connection string (based on « nodetool status » or cassandra.yaml)
  • SQWareProduction for Oracle: bugfix, .profile_confort for RAC env
  • SQWareProduction for Oracle: bugfix, gather indicateur when ASM and gvsqw_OraBin with ~user/…
  • SQWareProduction for Oracle: bugfix, suppress warning RMAN-08073 and RMAN-08517 when delete RMAN backup in 8i
  • SQWareProduction for Oracle: bugfix, Trap « ORA-13605: The specified task or object does not exist for the curren » message when AWR generation
  • SQWareProduction for Teradata: enhance add detail by AMP for databases indicators
  • SQWareProduction for Teradata: enhance add detail by AMP for tables indicators
  • SQWareRepository for Teradata: enhance add detail by AMP for databases indicators
  • SQWareRepository for Teradata: enhance add detail by AMP for tables indicators
  • SQWareWeb for All: Graph Multi Courbes
  • SQWareWeb for DB2: bugfix, DB2 table detailed reports
  • SQWareWeb for Teradata: enhance add detail by AMP for databases reports
  • SQWareWeb for Teradata: enhance add detail by AMP for tables reports

Version 3.1.01 – 2015-08-08

Les grands changements sont:

  • ajout du support de Cassandra
  • ajout du support de Teradata
  • support de l’Oracle 12c mutitenant architecture

 

  • SQWareCentral for All: enhance, add test sendmail script
  • SQWareCentral for All: enhance, add test SQWareRepository connection script
  • SQWareCentral for PostgreSQL: enhance, add purge tables for monitoring of ArchiveXlog
  • SQWareCentral for Teradata: functionality add support of teradata
  • SQWareProduction for All: enhance, add test sendmail script
  • SQWareProduction for All: enhance, add test SQWareRepository connection script
  • SQWareProduction for Cassandra: enhance add gather Keyspace indicators
  • SQWareProduction for Cassandra: enhance add keyspaces and columnfamilly detail gather indicators
  • SQWareProduction for Cassandra: functionality add gather indicators
  • SQWareProduction for Cassandra: functionality add nodetool execution on all nodes
  • SQWareProduction for MongoDB: bugfix, supress –password in Dump lib
  • SQWareProduction for Oracle: enhance add support of 12c mutitenant
  • SQWareProduction for Oracle: enhance, add support of Oracle 8i for RMAN backup script
  • SQWareProduction for PostgreSQL: enhance, add monitoring of ArchiveXlog generation
  • SQWareProduction for PostgreSQL: enhance, limit sendmail (2 per hour by default) for ArchiveXlog script
  • SQWareProduction for Teradata: functionality add support of teradata
  • SQWareRepository for Cassandra: enhance add keyspaces and columnfamilly detail tables
  • SQWareRepository for Oracle: enhance add support of 12c mutitenant
  • SQWareRepository for PostgreSQL: enhance, add tables for monitoring of ArchiveXlog
  • SQWareRepository for Teradata: functionality add support of teradata
  • SQWareWeb for Cassandra: enhance add Keyspace indicators
  • SQWareWeb for Cassandra: enhance add keyspaces and columnfamilly
  • SQWareWeb for Cassandra: functionality add indicators
  • SQWareWeb for Oracle: enhance add support of 12c mutitenant
  • SQWareWeb for PostgreSQL: enhance, add report of ArchiveXlog generation
  • SQWareWeb for Teradata: functionality add support of teradata

 

Version majeure 3.0

Version 3.0.08 – 2015-05-04

Ce sera le dernier patch de Version 3.0, la 3.1 devant sortir avant la fin du premier semestre 2015.

  • SQWareRepository for MySQL: bugfix, case sensitive for tablename
  • SQWareCentral for Teradata: enhance, First step for Teradata support
  • SQWareCentral for Adabas: enhance, First step for Adabas support
  • SQWareProduction for Teradata: enhance, First step for Teradata support
  • SQWareProduction for Adabas: enhance, First step for Adabas support
  • SQWareRepository for Teradata: enhance, First step for Teradata support
  • SQWareRepository for Adabas: enhance, First step for Adabas support
  • SQWareWeb for Teradata: enhance, First step for Teradata support
  • SQWareWeb for Adabas: enhance, First step for Adabas support
  • SQWareProduction for Oracle: bugfix, when generate backup list « ToTape » for RMAN archives backups in 9i

Version 3.0.07 – 2015-03-08

  • SQWareProduction for Oracle: enhance, treat messages like « RMAN-06554: WARNING: file 1 is in backup mode » as warning and not error in RMAN script
  • SQWareProduction for MsSql: enhance, add -PurgeDiff to backup scripts for remove all diff and log files
  • SQWareProduction for MsSql: enhance, check if full backup exists when diff (make full instead if not)

Version 3.0.06 – 2015-01-11

  • SQWareProduction for MsSql: bugfix, add filter to exclude RO databases for AllDatabases Rebuild and Statistics scripts
  • SQWareProduction for Oracle: bugfix, error in export script, « EXP-00067: Table XXX will be exported in conventional path » is trap as warning
  • SQWareProduction for Oracle: enhance, add -Consistent option in export script to force « direct=n consistent=y » for « full » mode
  • SQWareProduction for Oracle: bugfix, no trace backup when failed
  • SQWareRepository for Sybase: bugfix, growth field in tsqwsyb_GenInfos and tsqwsyb_VolDb (for repo in MySQL 5.6)
  • SQWareRepository for MsSql: bugfix, growth field in tsqwmsq_VolDb (for repo in MySQL 5.6)
  • SQWareRepository for MySQL: enhance, add Check scripts (thanks to JF Bernard)

Version 3.0.05 – 2014-12-08

  • SQWareRepository for All: bugfix, add « table_schema=database() » clause for create indexes
  • SQWareCentral for Oracle: enhance, add gen all instance
  • SQWareWeb for MySQL: bugfix, table name tsqwmys_LogSlowQuery (lack mys)
  • SQWareProduction for Sybase: bugfix, table name tsqwsyb_Parameters (lack syb)
  • SQWareProduction for PostgreSQL: enhance, modify BackupArchiveXlog and ArchiveXlog script for no purge trace logs (purge by PITR script for perf)
  • SQWareProduction for PostgreSQL: enhance, modify PITR (not copy archives)
  • SQWareCentral core: bugfix, suppress delete of tsqwsyb_VolTablesDetail (does not exist)
  • SQWareWeb core bugfix format number
  • SQWareProduction for Sybase: enhance, add detail for gather tables indicators (numrows, reserved, data, indexes)
  • SQWareWeb for Sybase: enhance, add detail for tables indicators (numrows, reserved, data, indexes)
  • SQWareRepository for Sybase: enhance, modify indicator table for tables (numrows, reserved, data, indexes)
  • SQWareCentral for MongoDB: enhance, add purge indicators
  • SQWareProduction for Sybase: enhance, add -Local option for CopyDump script to make cp instead of scp (for NAS/NFS copy …)
  • SQWareProduction for MsSql: enhance, support ‘diff’ for Restore scripts (only full before)

Version 3.0.04 – 2014-10-05

  • SQWareCentral core: enhance, add gvsqw_SshOptionsInteractive option for interactive ssh connection
  • SQWareWeb for MongoDB: enhance, first support of MongoDB
  • SQWareWeb for PostgreSQL: bugfix, query for detail view table
  • SQWareProduction for PostgreSQL: bugfix, file name to tape backup in dump scripts
  • SQWareRepository for MongoDB: enhance, first support of MongoDB
  • SQWareProduction for MongoDB: enhance, first support of MongoDB
  • SQWareCentral for Sybase: enhance, add sql.ini generation
  • SQWareProduction for Sybase: bugfix, bad database name in check space for LoadDatabase script
  • SQWareProduction for Oracle: bugfix, grep « EXP- » message in export scripts
  • SQWareProduction for MsSql: bugfix, suppress ‘all’ information messages when backup or restore
  • SQWareCentral for All: enhance, add clean dbSQWare v2 cfg files script
  • SQWareProduction for MySQL: enhance, add copy dump scripts
  • SQWareProduction for MySQL: enhance, add restore database scripts
  • SQWareProduction for Sybase: enhance, add trap « it is SUSPECT » message in ‘update stat’ scripts (ex: Index id 2 cannot be used to access table id 592770188 as it is SUSPECT. Please have the SA run the DBCC REINDEX command on the specified table.)
  • SQWareProduction for MsSql: bugfix, modify generate rebuild command for table name with space !
  • SQWareProduction for All: bugfix, add gvsqw_NetBackupPath var in generic directory for NetBackup script (work only for Oracle and Sybase before)
  • SQWareProduction for Sybase: bugfix, change SybaseDumpFiles in SybaseBackups for files list in DumpAllDatabases script (for tape backups)
  • SQWareProduction for Oracle: enhance, suppress « ORA-01422: exact fetch returns more than requested number of rows » message in DBMS_STATS script

Version 3.0.01 – 2014-04-30

De gros changements structurels sont apportés dans cette version, le changement majeur étant le regroupement des 7 référentiels en 1 seul, sous MySQL.
 

Version majeure v2.1

Version 2.1.04 – 2013-11-22

  • SQWareProduction for Oracle, bugfix: Modify monitoring AWR + Statspack for 11.2.0.4 patchset
  • SQWareProduction for Sybase, enhance: Add -RD option in dump scripts
  • SQWareProduction for MsSql, enhance: Add -SortInTempdb option for rebuild index script
  • SQWareProduction for MsSql, enhance: Add -Online option for rebuild index script
  • SQWareProduction for MsSql, enhance: Add -Force option for rebuild index script
  • SQWareProduction for MsSql, enhance: Add ‘CopyOnly’ backup type
  • SQWareProduction for MsSql, enhance: Active stripping for differential backup (as full)
  • SQWareProduction for Oracle, enhance: Add -NoConsistent option for expdp script (don’t put ‘flashback_time=systimestamp’ in expdp)
  • SQWareProduction for Oracle, enhance: Add -NoConsistent option for refresh schema expdp (don’t put ‘flashback_time=systimestamp’ in expdp)
  • SQWareProduction for Oracle, enhance: Add -LockKill option for refresh schema expdp (lock user and kill sessions)
  • SQWareProduction for Oracle, enhance: Add -F option for refresh schema expdp (list of tables to keep)
  • SQWareWeb for All, enhance: Modify some field length
  • SQWareProduction for MySQL, bugfix: Modify grep error global variable
  • SQWareWeb for Oracle, enhance: Modify display off table/chart in detail directories
  • SQWareWeb for Sybase, enhance: Modify display off table/chart in detail directories
  • SQWareWeb for MsSql, enhance: Modify display off table/chart in detail directories
  • SQWareWeb for MySQL, enhance: Modify display off table/chart in detail directories
  • SQWareWeb for PostgreSQL, enhance: Modify display off table/chart in detail directories
  • SQWareWeb for DB2, enhance: Modify display off table/chart in detail directories
  • SQWareWeb for Ingres, enhance: Modify display off table/chart in detail directories
  • SQWareWeb Core, enhance: add buttons chart, table, export excel
  • SQWareProduction for Oracle, enhance: Add « consistent » mode by default for Expdp script
  • SQWareProduction for Oracle, enhance: Add « -NoConsistent » option for Expdp script
  • SQWareProduction for Oracle, enhance: Add « consistent » mode by default for SchemaRefreshExpdp script
  • SQWareProduction for Oracle, enhance: Add « -NoConsistent » option for SchemaRefreshExpdp script
  • SQWareProduction for Oracle, enhance: Add « -LockKill » option for SchemaRefreshExpdp script
  • SQWareProduction for Oracle, enhance: Add « -OptExp » option for SchemaRefreshExpdp script
  • SQWareProduction for Oracle, enhance: Add « -OptImp » option for SchemaRefreshExpdp script
  • SQWareWeb Core, enhance: modify truncate and resize for performance

Version 2.1.03 – 2013-11-04

  • SQWareProduction for Sybase, enhance: Add before and after scripts for UpdtStatsRebuildWithFlag
  • SQWareProduction for Oracle, bugfix: Modify « / as sysdba » connection for version < 10g !
  • SQWareProduction for Oracle, enhance: Add monitoring with Statspack
  • SQWareProduction for Oracle, enhance: Add Statspack automatic report generation (like AWR)
  • SQWareCentral for Oracle, enhance: Add monitoring with Statspack (list and auto)
  • SQWareCentral for Oracle, enhance: Add Statspack automatic report generation (list and auto)
  • SQWareProduction for PostgreSQL, bugfix: Change concat function by || (not exist before 9.1)
  • SQWareProduction for MySQL, bugfix: Add trap off « Couldn.t execute » error message

Version 2.1.02 – 2013-10-09

  • SQWareProduction for MsSql, enhance: Add -Before and -After options for restore script
  • SQWareProduction for Oracle, enhance: Add csv stat files generation for audit with awr
  • SQWareProduction for Oracle, enhance: Add tedt_VolTapeBackups purge
  • SQWareProduction for Sybase, enhance: Add tedt_VolTapeBackups purge
  • SQWareProduction for MsSql, bugfix: Modidify edtmsq_BackupAllDatabases.ksh to force full backup on master database
  • SQWareWeb for Sybase, bugfix: Modify some date format in charts
  • SQWareWeb for MsSql, bugfix: Modify some date format in charts
  • SQWareProduction for Sybase, functionality: Add NetBackup tape backup script
  • SQWareProduction for Oracle, enhance: Add list genaration off RMAN backup files (for tape backup)
  • SQWareProduction for Oracle, functionality: Add NetBackup tape backup script
  • SQWareProduction for MySQL, enhance: Add list generation off dump files (for tape backup)
  • SQWareWeb for Sybase, enhance: Add tape backups reports
  • SQWareWeb for Oracle, enhance: Add tape backups reports
  • SQWareRepository for Sybase, enhance: Add tape backups table
  • SQWareRepository for Oracle, enhance: Add tape backups table
  • SQWareWeb for Oracle, bugfix: Modify some table settings
  • SQWareWeb for Core, bugfix: Modify some settings for Chrome
  • SQWareProduction for Sybase, enhance: Add list off dump generation for dump scripts (for tape backup)
  • SQWareWeb core: bugfix, change link to client.png
  • SQWareCentral for Db2, bugfix: Modify default version to v2.1
  • SQWareCentral for Oracle, bugfix: Modify default version to v2.1
  • SQWareCentral for Sybase, bugfix: Modify default version to v2.1
  • SQWareCentral for MsSql, bugfix: Modify default version to v2.1
  • SQWareCentral for MySQL, bugfix: Modify default version to v2.1
  • SQWareCentral for Ingres, bugfix: Modify default version to v2.1

Version 2.1.01 – 2013-04-20

Le fork officiel de la v2.0 vers la v2.1 est la v2.0.15 qui est en ligne depuis fin avril 2013.

A partir d’aujourd’hui, seuls les bugs référencés seront corrigés dans la v2.0 et ceci, jusqu’à fin décembre 2013. Au-delà, dès janvier 2014, il faudra migrer en v2.1 pour avoir les corrections.

Nombre de modifications sont présentes dans le v2.1 pour la partie web qui est la plus touchée.

Nous sommes passés pour les tableaux de ActiveWidgets à JQuery avec les plugins DataTables, ColVis, TableTools, FixedColumns,…

Nous avons abandonné le flash pour les graphiques (Open Flash Chart) au profit du pur HTML5/JavaScript avec Highcharts !

Voici quelques-unes des nouvelles fonctionnalités qui sont présentes au niveau des tableaux:

  • pagination avec choix du nombre de lignes à afficher
  • filtre global
  • filtre par colonne
  • masquage de colonne
  • sélection de ligne
  • couleur pour les critical/warning
  • affichage des dates au format ISO

Version majeure 2.0

Version 2.0.15 – 2013-04-19

Pour rappel, à partir de maintenant, seuls les bugs référencés seront corrigés dans la v2.0 et ceci, jusqu’à fin décembre 2013. Au-delà, dès janvier 2014, il faudra migrer en v2.1 pour avoir les corrections.

  • SQWareProduction for MySQL, bugfix: Modfify query for check dump database
  • SQWareProduction for MsSql, enhance: Add type of install (express, standard, enterprise) in indicators
  • SQWareProduction for Sybase, bugfix: Modify kill script to accept spid => 1000 !
  • SQWareProduction for Sybase, enhance: Add « dbcc dbreboot(‘shutdown_load’,dbname) » option before load database
  • SQWareProduction for Sybase, bugfix: Force float for curunreservedpgs to avoid ‘Arithmetic overflow’ in some case (ASE 15.7)
  • SQWareProduction for Sybase, enhance: add -Lock option for LoadDatabase and LoadAllDatabases script
  • SQWareCentral for Ingres, bugfix: Modify edtcGenRefIngres.ksh
  • SQWareProduction for Sybase, enhance: add scripts in spm
  • SQWareProduction for MsSql, enhance: add backup type option in BackupAllDatabases script
  • SQWareCentral for Oracle, enhance: add AWR Monitor action and modify status for prod/noprod list generator
  • SQWareProduction for Sybase, enhance: Syntax for dump,copy,load scripts ‘OldSyntax’ (compress::compress_level::…) or ‘NewSyntax’ (with compression = compress_level)
  • SQWareWeb PostgreSQL: bugfix, Change symbolic link of common.ini
  • SQWareProduction for MsSql, enhance: Add SqlServer 7 support !
  • SQWareProduction for MySql, enhance: Add ‘DIST,MIX,…’ status for check mysqldump
  • SQWareWeb for MySql, enhance: Add ‘DIST,MIX,…’ status for check mysqldump

Version 2.0.14 – 2013-03-19

  • SQWareCentral for Sybase, enhance: Suppress space at end of lists
  • SQWareProduction for MsSql, bugfix: Rebuild index for >= 2008 ‘set ansi_defaults, concat_null_yields_null on’
  • SQWareProduction for Sybase, functionality: Add LoadAllDatabases script
  • SQWareProduction for Sybase, functionality: Add CopyDumpAllDatabases script
  • SQWareProduction for Sybase, enhance: Add send report option for Load script
  • SQWareProduction for Sybase, enhance: Add suppress dump history for CopyDump script
  • SQWareProduction for Sybase, bugfix: Suppress Msg 5806, Level 16, State 1 => when ‘allow updates to system tables’ for load database
  • SQWareProduction for Oracle, functionality: Add refresh schema with expdp/impdp
  • SQWareProduction for MsSql, enhance: Add support off SQL 2012
  • SQWareProduction for MySQL, bugfix: Change USER variable by « id » for shutdown (su – …)
  • SQWareRepository for MySQL, enhance: Add 5.6 infos
  • SQWareProduction for Oracle, enhance: Add flag to disable trace for monitoring workload AWR script
  • SQWareProduction for Oracle, enhance: Accept not open for RMAN menu
  • SQWareProduction for Oracle, bugfix: Pb in edtArchmon insert in v2.0.13
  • SQWareWeb for MySQL, enhance: Add 5.6 infos
  • SQWareWeb Core, enhance: Add ico and patch custom script

Version 2.0.13 – 2013-01-18

  • SQWareProduction for Oracle, bugfix: Change for RMAN scripts and RH 4 (pb |read) !
  • SQWareProduction for Oracle, enhance: Modify call of gfedt_Purge
  • SQWareProduction for Oracle, enhance: Add snap (begin-End) selection for GenerateAwr script
  • SQWareProduction for Oracle, bugfix: Change query for started instance (RAC)
  • SQWareProduction for Sybase, enhance: Add call off lfedt_GatherOverloaded in gather indicators
  • SQWareProduction for Sybase, enhance: Modify call of gfedt_Purge
  • SQWareProduction for MsSql, enhance: Modify call of gfedt_Purge
  • SQWareProduction for MySQL, enhance: Modify call of gfedt_Purge
  • SQWareProduction for MySQL, enhance: Modify purge of tedt_JobsLog (perf)
  • SQWareProduction for DB2, enhance: Modify call of gfedt_Purge
  • SQWareProduction for PostgreSQL, enhance: Add PostgreSQL support
  • SQWareProduction for Ingres, enhance: Modify call of gfedt_Purge
  • SQWareRepository for MySQL, enhance: Add index on tedt_JobsExec
  • SQWareRepository for PostgreSQL, enhance: Add PostgreSQL support
  • SQWareWeb Core, bugfix: Pb hide menu DB2 and PG
  • SQWareWeb for PostgreSQL, enhance: Add PostgreSQL support
  • SQWareCentral for Oracle, enhance: Add verbose for « started instances »
  • SQWareCentral for PostgreSQL, enhance: Add PostgreSQL support

Version 2.0.12 – 2012-12-17

  • SQWareProduction for Oracle, enhance: Add monitoring workload AWR
  • SQWareProduction for Oracle, enhance: Add monitor workload with AWR
  • SQWareProduction for Oracle, bugfix: No log upload for export scripts
  • SQWareProduction for Oracle, bugfix: Modify AWR generation (DBID/date)
  • SQWareProduction for Oracle, enhance: Add gfedt_SetMailSender in global lib to choose mail sender
  • SQWareProduction for Oracle, bugfix: Modify indicators for parameters with CR or ‘ in value
  • SQWareProduction for Oracle, enhance: Add drop type and VM for refresh schema
  • SQWareProduction for Sybase, bugfix: Modify dataserver param for « AllDatabases » scripts
  • SQWareProduction for Sybase, enhance: Add gfedt_SetMailSender in global lib to choose mail sender
  • SQWareProduction for MsSql, enhance: Add gfedt_SetMailSender in global lib to choose mail sender
  • SQWareProduction for MsSql, bugfix: Modify trap message in restore
  • SQWareProduction for MsSql, bugfix: Change command for table indicators ( name with ‘ . space $ # …)
  • SQWareProduction for MySQL, bugfix: Suppress -i for grep error messages
  • SQWareProduction for MySQL, enhance: Add debug mode for RotateLogSlowQuery
  • SQWareProduction for MySQL, enhance: Add gfedt_SetMailSender in global lib to choose mail sender
  • SQWareProduction for DB2, feature: Add DB2-LUW support
  • SQWareProduction for Ingres, enhance: Add gfedt_SetMailSender in global lib to choose mail sender
  • SQWareRepository for Oracle, enhance: Add GlobalHost, Custom1 and Custom2 fields
  • SQWareRepository for Oracle, enhance: Add monitoring workload AWR
  • SQWareRepository for Oracle, enhance: Add monitor workload with AWR
  • SQWareRepository for Sybase, enhance: Add GlobalHost, Custom1 and Custom2 fields
  • SQWareRepository for MsSql, enhance: Add GlobalHost, Custom1 and Custom2 fields
  • SQWareRepository for MsSql, bugfix: Modify for EndLife (not null)
  • SQWareRepository for MySQL, enhance: Add GlobalHost, Custom1 and Custom2 fields
  • SQWareRepository for DB2, feature: Add DB2-LUW support
  • SQWareWeb Core, enhance: Prepare for DB2 and Postgres integration
  • SQWareWeb for Oracle, enhance: Add GlobalHost, Custom1 and Custom2 fields
  • SQWareWeb for Oracle, enhance: Add monitoring workload AWR
  • SQWareWeb for Oracle, enhance: Add monitoring workload with AWR
  • SQWareWeb for Oracle, enhance: Add monitor workload with AWR
  • SQWareWeb for Sybase, enhance: Add GlobalHost, Custom1 and Custom2 fields
  • SQWareWeb for MsSql, enhance: Add GlobalHost, Custom1 and Custom2 fields
  • SQWareWeb for MySQL, enhance: Add GlobalHost, Custom1 and Custom2 fields
  • SQWareWeb for DB2, feature: Add DB2-LUW support
  • SQWareCentral for Oracle, enhance: Add monitor workload with AWR
  • SQWareCentral for MsSql, bugfix: change format list command
  • SQWareCentral for MySQL, bugfix: Suppress -i for grep error messages
  • SQWareCentral for MySQL, bugfix: change message list error
  • SQWareCentral for DB2, feature: Add DB2-LUW support

Version 2.0.11 – 2012-10-09

  • SQWareProduction for Oracle, bugfix: Disable upload log for export scripts
  • SQWareProduction for Oracle, bugfix: Modify gather indicators for Oracle 8.0 !
  • SQWareProduction for Oracle, enhance: Add support of multi catalog in Rman Clone script
  • SQWareProduction for Sybase, enhance: Modify echo message for Linux spm
  • SQWareProduction for Sybase, bugfix: Add lvedt_FlagTrtUni for specific option file on database
  • SQWareProduction for MsSql, bugfix: Add shema_name and change tsql by fisql command
  • SQWareProduction for MsSql, bugfix: Add filter for FreeTds information message in edtmys_Global.lib
  • SQWareWeb for MsSql, bugfix: Modify data format for dashboard reports
  • SQWareCentral for MsSql, enhance: change tsql by fisql command

Version 2.0.10 – 2012-10-01

  • SQWareProduction for Oracle, enhance: Add support of Oracle v7 for indicators
  • SQWareProduction for Sybase, bugfix: Modify source env
  • SQWareProduction for MsSql, bugfix: Suppress commit in purge function
  • SQWareRepository for Oracle, enhance: Add tedt_EndLife for supported/unsupported versions
  • SQWareRepository for Sybase, enhance: Add tedt_EndLife for supported/unsupported versions
  • SQWareRepository for MsSql, enhance: Add tedt_EndLife for supported/unsupported versions
  • SQWareRepository for MySQL, enhance: Add tedt_EndLife for supported/unsupported versions
  • SQWareWeb for Oracle, enhance: Add supported/unsupported report
  • SQWareWeb for Sybase, enhance: Add supported/unsupported report
  • SQWareWeb for MsSql, enhance: Add supported/unsupported report
  • SQWareWeb for MySQL, enhance: Add supported/unsupported report
  • SQWareCentral for Oracle, enhance: Modify size of line in inventory file
  • SQWareCentral for MsSql, enhance: Add filter for ‘using default charset’ message

Version 2.0.09 – 2012-09-11

  • SQWareProduction for Oracle, enhance: Insert values in tedt_GenHisto for not started instances if not exist
  • SQWareProduction for Oracle, enhance: Add tedt_RepositoryExclude table
  • SQWareProduction for Oracle, enhance: Force a case for instance name parameter, UpperCase or LowerCase or NoCase
  • SQWareProduction for Oracle, bugfix: Change gvedt_LogFileNameConvert in lvedt_LogFileNameConvert for edtora_RmanClone.ksh
  • SQWareProduction for Oracle, enhance: Add -AddMail flag for check indicators
  • SQWareProduction for Sybase, enhance: Insert values in tedt_GenHisto for not started dataserver if not exist
  • SQWareProduction for Sybase, enhance: Add tedt_RepositoryExclude table
  • SQWareProduction for Sybase, enhance: Force a case for instance name parameter, UpperCase or LowerCase or NoCase
  • SQWareProduction for Sybase, enhance: Add -AddMail flag for check indicators
  • SQWareProduction for MsSql, enhance: Insert values in tedt_GenHisto for not started instances if not exist
  • SQWareProduction for MsSql, enhance: Add tedt_RepositoryExclude table
  • SQWareProduction for MsSql, enhance: Force a case for instance name parameter, UpperCase or LowerCase or NoCase
  • SQWareProduction for MsSql, enhance: Add -AddMail flag for check indicators
  • SQWareProduction for MySQL, enhance: Insert values in tedt_GenHisto for not started instances if not exist
  • SQWareProduction for MySQL, enhance: Add tedt_RepositoryExclude table
  • SQWareProduction for MySQL, enhance: Force a case for dataserver name parameter, UpperCase or LowerCase or NoCase
  • SQWareProduction for MySQL, enhance: Add -AddMail flag for check indicators
  • SQWareProduction for Ingres, enhance: Force a case for instance name parameter, UpperCase or LowerCase or NoCase
  • SQWareProduction for Ingres, enhance: Add -AddMail flag for check indicators
  • SQWareRepository for Oracle, enhance: Add exclude check lack indicators
  • SQWareRepository for Oracle, bugfix: Add ‘grant create public synonym’ for repo owner
  • SQWareRepository for Sybase, enhance: Add exclude check lack indicators
  • SQWareRepository for MsSql, enhance: Add exclude check lack indicators
  • SQWareRepository for MySQL, enhance: Add exclude check lack indicators
  • SQWareWeb for Oracle, bugfix: Add segtype on segment reports
  • SQWareCentral for Oracle, bugfix: StrictHostKeyChecking=no for add ssh key scripts
  • SQWareCentral for Sybase, bugfix: StrictHostKeyChecking=no for add ssh key scripts
  • SQWareCentral for MsSql, bugfix: StrictHostKeyChecking=no for add ssh key scripts
  • SQWareCentral for MySQL, bugfix: StrictHostKeyChecking=no for add ssh key scripts
  • SQWareCentral for Ingres, bugfix: StrictHostKeyChecking=no for add ssh key scripts

Version 2.0.08 – 2012-08-01

  • SQWareProduction for Oracle, enhance: Add gather DG and +ASM indicators
  • SQWareProduction for Oracle, enhance: Add Flash Recovery Area and detail archivelog by instance indicators
  • SQWareProduction for Oracle, enhance: Add RAC and Dataguard environnement basic support
  • SQWareProduction for MySQL, bugfix: Modifiy duration display in edtmys_Global.lib
  • SQWareRepository for Oracle, enhance: Add tables tedt_RepositoryRac, tedt_MaxLog, vedt_DataguardLag, tedt_RepositoryDg, vedt_VolArchlogs, tedt_VolArchlogsInst, tedt_Fra*
  • SQWareRepository for Oracle, enhance: Add check DG tables tables
  • SQWareRepository for Oracle, enhance: Add Flash Recovery Area and detail archivelog by instance tables
  • SQWareRepository for Oracle, for Oracle,enhance: Add reports for Flash Recovery Area
  • SQWareRepository for Oracle, enhance: Add reports for Disk Groups ASM (with FS)
  • SQWareRepository for Oracle, enhance: Add detail arch log by instance for RAC environnement
  • SQWareCentral for Oracle, enhance: Add ssh batch flags on automatics commands
  • SQWareCentral for Oracle, enhance: Add gen list+auto for Dataguard instances
  • SQWareCentral for Sybase, enhance: Add ssh batch flags on automatics commands
  • SQWareCentral for MsSql, enhance: Add ssh batch flags on automatics commands
  • SQWareCentral for MySQL, enhance: Add ssh batch flags on automatics commands
  • SQWareCentral for Ingres, enhance: Add ssh batch flags on automatics commands

Version 2.0.07 – 2012-07-19

  • SQWareProduction for Oracle, enhance: Add informations messages
  • SQWareProduction for Oracle, enhance: Modifiy gvedt_OraBin overload in edtora_Global.lib
  • SQWareProduction for Oracle, enhance: Modifiy archive log indicators (for NOARCHIVELOG case)
  • SQWareProduction for Oracle, enhance: Add generate sqlnet.ora in GenerateCreateDatabase
  • SQWareProduction for Sybase, enhance: Add informations messages
  • SQWareProduction for Sybase, enhance: Modifiy gvedt_SybBin overload in edtsyb_Global.lib
  • SQWareProduction for Sybase, enhance: Add more flexibility in CreateDataserver
  • SQWareProduction for Sybase, bugfix: Modifiy return code edtsyb_LoadDatabase.ksh when file not found
  • SQWareProduction for MsSql, enhance: Add informations messages
  • SQWareProduction for MsSql, enhance: Modifiy gvedt_MsqBin overload in edtmsq_Global.lib
  • SQWareProduction for MySQL, enhance: Add informations messages
  • SQWareProduction for MySQL, enhance: Modifiy gvedt_MysBin overload in edtmys_Global.lib
  • SQWareProduction for MySQL, bugfix: Modify calculation of the duration
  • SQWareProduction for MySQL, enhance: Add -Consistent and -Opt option in DumpAllDatabases
  • SQWareProduction for Ingres, enhance: Add informations messages
  • SQWareProduction for Ingres, enhance: Modifiy gvedt_IngBin overload in edting_Global.lib
  • SQWareRepository for MsSql, bugfix: Modifiy patch scrit (one line for tsql!)
  • SQWareWeb Core, enhance: Prepare to add PosgreSQL and DB2 in v2.1
  • SQWareWeb for Oracle, enhance: Add alter session set nls_numeric_characters=’.,’

Version 2.0.06 – 2012-04-29

  • SQWareProduction for Oracle, bugfix: Correction information message
  • SQWareProduction for Oracle, enhance: comment for wait end of background commands in // script
  • SQWareProduction for Sybase, enhance: Update Sybase supported versions to <= 15.7
  • SQWareProduction for Sybase, bugfix: Error in help -W instead of -WCD in « AllDatabases » scripts
  • SQWareProduction for Sybase, bugfix: Correction information message
  • SQWareProduction for Sybase, enhance: comment for wait end of background commands in // script
  • SQWareProduction for MsSql, bugfix: Error in help -W instead of -WCD in « AllDatabases » scripts
  • SQWareProduction for MsSql, bugfix: Correction information message
  • SQWareProduction for MsSql, enhance: comment for wait end of background commands in // script
  • SQWareProduction for MsSql, enhance: Adding MySql tables indicators
  • SQWareProduction for MySQL, bugfix: Modify indicator (parameters) for MySql ( \ and ‘ )
  • SQWareProduction for MySQL, bugfix: Error in help -W instead of -WCD in « AllDatabases » scripts
  • SQWareProduction for MySQL, bugfix: Correction information message
  • SQWareProduction for MySQL, enhance: comment for wait end of background commands in // script
  • SQWareProduction for Ingres, bugfix: Correction information message
  • SQWareProduction for Ingres, enhance: comment for wait end of background commands in // script
  • SQWareRepository for MySQL, enhance: Adding MySql tables indicators
  • SQWareWeb for MsSql, bugfix: Modify Host menu
  • SQWareWeb for MySQL, enhance: Adding MySql tables indicators
  • SQWareCentral for Oracle, enhance: Add gvedtc_DistSQWareProdUser_xxx and ssh connection for distant mode
  • SQWareCentral for Oracle, bugfix: generation of files RefDb_oracle.csv, dbsqware_tnsnames.ora, Ref_oracle.txt
  • SQWareCentral for Sybase, enhance: Add gvedtc_DistSQWareProdUser_xxx and ssh connection for distant mode
  • SQWareCentral for MySQL, enhance: Modify list unique generation (« ON », »MIX »)
  • SQWareCentral for MySQL, bugfix: Modify generation of Ref_mysql.txt
  • SQWareCentral for MySQL, enhance: Add gvedtc_DistSQWareProdUser_xxx and ssh connection for distant mode
  • SQWareCentral for MySQL, bugfix: lists generator

Version 2.0.05 – 2012-03-25

  • SQWareProduction for Sybase, bugfix: Indicators Sybase (quote in option and OS type)
  • SQWareProduction for Sybase, bugfix: Change name format for Sybase dump files [ old format (before v2.0.05) _fstripe1_ / new format (after v2.0.05) _fstripe01_ ]
  • SQWareProduction for MsSql, bugfix: Change name format for MsSql backup files [ old format (before v2.0.05) _fstripe1_ / new format (after v2.0.05) _fstripe01_ ]
  • SQWareProduction for MsSql, for MySQL, bugfix: Put gvedt_UserExec var in GlobalVar
  • SQWareRepository for Oracle, enhance: Add table tedt_RepositoryVersion and change patch file format name
  • SQWareRepository for Sybase, enhance: Add table tedt_RepositoryVersion and change patch file format name
  • SQWareRepository for MsSql, enhance: Add table tedt_RepositoryVersion and change patch file format name
  • SQWareRepository for MsSql, enhance: Modify enable/disable xp_cmdshell method
  • SQWareRepository for MySQL, enhance: Add table tedt_RepositoryVersion and change patch file format name
  • SQWareRepository for Ingres, enhance: Add table tedt_RepositoryVersion and change patch file format name
  • SQWareCentral for Sybase, bugfix: edtcGenRefSybase.ksh (port)

Version 2.0.04 – 2012-01-23

  • SQWareProduction for Oracle, enhance: Adjust compute duration and size backup
  • SQWareProduction for Oracle, bugfix: Correction in MenuRman for ‘cross incarnation’ restore
  • SQWareProduction for Oracle, bugfix: Modify name generation for multiple schema expdp
  • SQWareProduction for Oracle, feature: Adding licenses and parameters info
  • SQWareProduction for Oracle, bugfix: modify AWR error check
  • SQWareProduction for Oracle, bugfix: modify gen AWR (new TAG in 11.2.0.3 …)
  • SQWareProduction for Oracle, bugfix: AWR generation modification for 11.2.0.3 and 10.2.0.5
  • SQWareProduction for Oracle, enhance: Support 9i for RMAN backup scripts
  • SQWareProduction for Oracle, bugfix: default number of threads in physical cold backup
  • SQWareProduction for Oracle, bugfix: Modify awr for suppress ##### in hit ratio
  • SQWareProduction for Sybase, enhance: Adjust compute duration and size backup
  • SQWareProduction for Sybase, feature: Adding licenses and parameters info
  • SQWareProduction for Sybase, enhance: Add gather indicators parameter, license and tables volumetry
  • SQWareProduction for Sybase, enhance: update MsSql indicators (gather and check)
  • SQWareProduction for Sybase, feature: Adding licenses and parameters info
  • SQWareRepository for Oracle, feature: Adding licenses and parameters info
  • SQWareRepository for Sybase, feature: Adding licenses and parameters info
  • SQWareRepository for MsSql, feature: Adding licenses and parameters info
  • SQWareRepository for MySQL, feature: Adding licenses and parameters info
  • SQWareWeb for Oracle, feature: Adding licenses info
  • SQWareWeb for Sybase, feature: Adding licenses info
  • SQWareWeb for MsSql, feature: Adding licenses info
  • SQWareWeb for MySQL, SQWareWeb feature: Adding licenses info
  • SQWareCentral for Oracle, enhance: Modify GenRef scripts
  • SQWareCentral for Oracle, feature: MAJ for CMDB
  • SQWareCentral for Sybase, enhance: Modify GenRef scripts
  • SQWareCentral for Sybase, feature: MAJ for CMDB
  • SQWareCentral for MsSql, enhance: Modify GenRef scripts
  • SQWareCentral for MySQL, enhance: Modify GenRef scripts
  • SQWareCentral for MySQL, feature: MAJ for CMDB
  • SQWareCentral for Ingres, enhance: Modify GenRef scripts

Version 2.0.03 – 2011-11-25

  • SQWareProduction for Oracle, bugfix: Convert to UNIX format *_GatherDistantFsSize.*
  • SQWareProduction for Oracle, bugfix: Change for Oracle scripts ‘:’ in ‘_’ because sqlnet <10g not accept this (9i client for example to connect to 8i instances …)
  • SQWareProduction for Oracle, enhance: Put trunc(sysdate) for insert indicators
  • SQWareProduction for Oracle, feature: Add cpu_count, OS type and Oracle edition in indicators
  • SQWareProduction for Oracle, bugfix: Add chmod to tmp dir
  • SQWareProduction for Sybase, bugfix: Convert to UNIX format *_GatherDistantFsSize.*
  • SQWareProduction for Sybase, bugfix: Add chmod to tmp dir
  • SQWareProduction for MsSql, bugfix: Add chmod to tmp dir
  • SQWareProduction for MySQL, bugfix: Add chmod to tmp dir
  • SQWareProduction for MySQL, feature: Add no check backup in check indicators script
  • SQWareProduction for Ingres, bugfix: Add chmod to tmp dir
  • SQWareRepository for Oracle, feature: Add host information table
  • SQWareWeb for Oracle, feature: Add cpu_count, OS type and Oracle edition in indicators
  • SQWareCentral for Oracle, enhance: Add ‘OLD%’ status in scripts
  • SQWareCentral for Oracle, bugfix: Change for Oracle scripts ‘:’ in ‘_’ because sqlnet <10g not accept this (9i client for example to connect to 8i instances …)

Version 2.0.02 – 2011-11-07

  • SQWareProduction for Oracle, bugfix: Suppress blank line for AWR configuration file
  • SQWareProduction for Oracle, enhance: Gather FS size from ssh
  • SQWareProduction for Oracle, feature: Suppress ‘TYPE2 UNDO’ from Oracle indicators
  • SQWareProduction for Oracle, enhance: Adding DBMS_STATS script
  • SQWareProduction for Oracle, enhance: Adding activate monitoring script
  • SQWareProduction for Oracle, enhance: Test if background_dump_dest or diagnostic_dest contain $ORACLE_HOME, not supported for edtora_PurgeAlert.ksh
  • SQWareProduction for Sybase, enhance: Gather FS size from ssh
  • SQWareProduction for Sybase, enhance: Modify gather backup size method (for old linux version)
  • SQWareProduction for MsSql, bugfix: Activate xp_cmdshell for MsSql 2005
  • SQWareRepository for Oracle, enhance: Add script to update ORACLE_SID
  • SQWareRepository for MsSql, enhance: Increase database name size
  • SQWareWeb for MySQL, bugfix: corrections in dashboard charts

Version 2.0.01 – 2011-09-28

  • SQWareProduction for MsSql, bugfix: Correct some bugs for GatherIndicators and GenerateConfigureInstance
  • SQWareCentral for Oracle, enhance: Add aliases in .profile_confort
  • SQWareCentral for Sybase, enhance: Add aliases in .profile_confort
  • SQWareCentral for MsSql, enhance: Add aliases in .profile_confort
  • SQWareCentral for MsSql, enhance: Add FreeTds config file generator
  • SQWareCentral for MySQL, enhance: Add aliases in .profile_confort
  • SQWareCentral for Ingres, enhance: Add aliases in .profile_confort

Version 2.0.RC3 – 2011-09-24

  • SQWareProduction for Oracle, enhance: Add gvedt_TraceBackup in configuration of SQWareProduction to disable backup trace
  • SQWareProduction for Sybase, enhance: Add gvedt_TraceBackup in configuration of SQWareProduction to disable backup trace
  • SQWareProduction for MsSql, enhance: Add gvedt_TraceBackup in configuration of SQWareProduction to disable backup trace
  • SQWareProduction for MsSql, bugfix: Change for databases with spaces in name
  • SQWareProduction for MsSql, enhance: Modify exit code
  • SQWareProduction for MySQL, enhance: Add gvedt_TraceBackup in configuration of SQWareProduction to disable backup trace
  • SQWareProduction for Ingres, enhance: Add gvedt_TraceBackup in configuration of SQWareProduction to disable backup trace
  • SQWareWeb for Oracle, bugfix: Correct /1024 => /1024.0
  • SQWareWeb for Oracle, enhance: Delete unused files
  • SQWareWeb for Sybase, bugfix: Correct /1024 => /1024.0
  • SQWareWeb for Sybase, enhance: Delete unused files
  • SQWareWeb for MsSql, bugfix: Correct /1024 => /1024.0
  • SQWareWeb for MySQL, bugfix: Correct /1024 => /1024.0
  • SQWareWeb for Ingres, bugfix: Correct /1024 => /1024.0
  • SQWareCentral for Oracle, enhance: Change help files
  • SQWareCentral for Sybase, enhance: Change help files
  • SQWareCentral for MsSql, enhance: Change help files
  • SQWareCentral for MySQL, enhance: Change help files
  • SQWareCentral for Ingres, enhance: Change help files

Version 2.0.RC2 – 2011-09-18

  • SQWareProduction for MsSql, enhance: Change search dump file to load (for PJC)
  • SQWareRepository for MySQL, enhance: Some adjust
  • SQWareRepository for Ingres, enhance: Some adjust
  • SQWareWeb Core, enhance: Some adjust
  • SQWareWeb for Oracle, enhance: Change detail for volumetry in Go, round(x,2)
  • SQWareWeb for Sybase, enhance: Change detail for volumetry in Go, round(x,2)
  • SQWareWeb for MsSql, enhance: Change detail for volumetry in Go, round(x,2)
  • SQWareWeb for MySQL, enhance: Change detail for volumetry in Go, round(x,2)
  • SQWareWeb for Ingres, enhance: Some adjust
  • SQWareWeb for Ingres, enhance: Change detail for volumetry in Go, round(x,2)

Version 2.0.RC1 – 14/09/2011

  • SQWareRepository for Sybase, enhance: sql to update SQWareRepository Sybase
  • SQWareWeb for Sybase, bugfix: Bug of GatherIndicator Sybase for databases in distant mode
  • SQWareWeb for Sybase, bugfix: Pb date dashboard Sybase
  • SQWareCentral for Oracle, enhance: Add help to deploy
  • SQWareCentral for Sybase, enhance: Add help to deploy
  • SQWareCentral for MySQL, enhance: Add help to deploy

Version 2.0.alpha – 2011-05-15

  • SQWareProduction for Oracle, feature: Adding the remote connection to the majority of scripts
  • SQWareProduction for Oracle, enhance: Adding automatic log generation for scripts execution
  • SQWareProduction for Oracle, feature: Adding dmpdp script
  • SQWareProduction for Oracle, enhance: Adding variable for user connexion
  • SQWareProduction for Sybase, feature: Adding the remote connection to the majority of scripts
  • SQWareProduction for Sybase, enhance: Adding automatic log generation for scripts execution
  • SQWareProduction for Sybase, enhance: Adding variable for user connexion
  • SQWareProduction for MsSql, feature: Adding the remote connection to the majority of scripts
  • SQWareProduction for MsSql, enhance: Adding automatic log generation for scripts execution
  • SQWareProduction for MsSql, enhance: Adding variable for user connexion
  • SQWareProduction for MySQL, feature: Adding the remote connection to the majority of scripts
  • SQWareProduction for MySQL, enhance: Adding automatic log generation for scripts execution
  • SQWareProduction for MySQL, enhance: Adding variable for user connexion
  • SQWareProduction for Ingres, enhance: Adding automatic log generation for scripts execution
  • SQWareProduction for Ingres, enhance: Adding variable for user connexion
  • SQWareRepository for Oracle, feature: Store logs summary of SQWareProduction execution
  • SQWareRepository for Sybase, feature: Store logs summary of SQWareProduction execution
  • SQWareRepository for MsSql, feature: Store logs summary of SQWareProduction execution
  • SQWareRepository for MySQL, feature: Store logs summary of SQWareProduction execution
  • SQWareRepository for Ingres, feature: Store logs summary of SQWareProduction execution
  • SQWareWeb Core, enhance: Script to display raw files (like logs)
  • SQWareWeb for Oracle, feature: Display logs of SQWareProduction execution
  • SQWareWeb for Sybase, feature: Display logs of SQWareProduction execution
  • SQWareWeb for MsSql, feature: Display logs of SQWareProduction execution
  • SQWareWeb for MySQL, feature: Display logs of SQWareProduction execution
  • SQWareWeb for Ingres, feature: Display logs of SQWareProduction execution
  • SQWareCentral Core, feature: New menu for automatic scripts execution
  • SQWareCentral for Oracle, enhance: Script for ssh key deployment
  • SQWareCentral for Sybase, enhance: Script for ssh key deployment
  • SQWareCentral for MsSql, enhance: Script for ssh key deployment
  • SQWareCentral for MySQL, enhance: Script for ssh key deployment
  • SQWareCentral for Ingres, enhance: Script for ssh key deployment

 

Version majeure v1.2

Version 1.2.11 – 2011-01-11

  • SQWareProduction for Oracle, bugfix: BSPO20101231, bad command to save password in edtora_RmanClone.lib
  • SQWareProduction for Oracle, enhance: help file for edtora_GlobalVar.cfg variables files
  • SQWareProduction for Oracle, enhance: help file for edtora_DbRefVar.cfg variables files
  • SQWareProduction for Oracle, enhance: help file for edtora_IndicatorsVar.cfg variables files
  • SQWareProduction for Sybase, enhance: help file for edtsyb_GlobalVar.cfg variables files
  • SQWareProduction for Sybase, enhance: help file for edtsyb_DbRefVar.cfg variables files
  • SQWareProduction for Sybase, enhance: help file for edtsyb_IndicatorsVar.cfg variables files
  • SQWareProduction for MsSql, enhance: help file for edtmsq_GlobalVar.cfg variables files
  • SQWareProduction for MsSql, enhance: help file for edtmsq_DbRefVar.cfg variables files
  • SQWareProduction for MsSql, enhance: help file for edtmsq_IndicatorsVar.cfg variables files
  • SQWareProduction for MySQL, enhance: help file for edtmys_GlobalVar.cfg variables files
  • SQWareProduction for MySQL, enhance: help file for edtmys_DbRefVar.cfg variables files
  • SQWareProduction for MySQL, enhance: help file for edtmys_IndicatorsVar.cfg variables files
  • SQWareProduction for Ingres, enhance: help file for edting_GlobalVar.cfg variables files
  • SQWareProduction for Ingres, enhance: help file for edting_DbRefVar.cfg variables files
  • SQWareRepository for Oracle, bugfix: lack grant on tedt_AwrCpuBef111 to _LEC user

Version 1.2.10 – 2011-01-01

  • SQWareProduction for Oracle, enhance: new name of module
  • SQWareProduction for Oracle, enhance: new option ‘-s’ for bin script to display usage examples
  • SQWareProduction for Sybase, enhance: new name of module
  • SQWareProduction for Sybase, enhance: new option ‘-s’ for bin script to display usage examples
  • SQWareProduction for MsSql, enhance: new name of module
  • SQWareProduction for MsSql, enhance: new option ‘-s’ for bin script to display usage examples
  • SQWareProduction for MySQL, enhance: new name of module
  • SQWareProduction for MySQL, enhance: new option ‘-s’ for bin script to display usage examples
  • SQWareProduction for Ingres, enhance: new name of module
  • SQWareProduction for Ingres, enhance: new option ‘-s’ for bin script to display usage examples
  • SQWareRepository for Oracle, enhance: new name of module
  • SQWareRepository for Sybase, enhance: new name of module
  • SQWareRepository for MsSql, enhance: new name of module
  • SQWareRepository for MySQL, enhance: new name of module
  • SQWareRepository for Ingres, enhance: new name of module
  • SQWareWeb Core, enhance: new name of module
  • SQWareWeb for Oracle, enhance: new name of module
  • SQWareWeb for Sybase, enhance: new name of module
  • SQWareWeb for MsSql, enhance: new name of module
  • SQWareWeb for MySQL, enhance: new name of module
  • SQWareWeb for Ingres, enhance: new name of module
  • SQWareCentral Core, enhance: new name of module
  • SQWareCentral Core, enhance: new option ‘-s’ for bin script to display usage examples
  • SQWareCentral for Oracle, enhance: new name of module
  • SQWareCentral for Sybase, enhance: new name of module
  • SQWareCentral for MsSql, enhance: new name of module
  • SQWareCentral for MySQL, enhance: new name of module
  • SQWareCentral for Ingres, enhance: new name of module

Version 1.2.09 – 2010-12-20

  • SQWareProduction for Oracle, enhance: save password before clone
  • SQWareProduction for Sybase, bugfix: list generation of tables in stat script
  • SQWareProduction for Sybase, enhance: filter of database list genarator (include and exclude in like format + where clause)
  • SQWareProduction for MsSql, bugfix: list generation of tables in stat script
  • SQWareProduction for MsSql, enhance: filter of database list genarator (include and exclude in like format + where clause)
  • SQWareProduction for MySQL, enhance: filter of database list genarator (include and exclude in like format + where clause)
  • SQWareWeb for Sybase, SQWareWeb enhance: lack backup report
  • SQWareWeb for MsSql, SQWareWeb enhance: lack backup report
  • SQWareWeb for MySQL, enhance: lack backup report

Version 1.2.xx 2010-09-01

  • SQWareProduction for Oracle, enhance : email report in html format
  • SQWareProduction for Oracle, enhance : check lack backups
  • SQWareProduction for Oracle, feature: RMAN clone to copy database
  • SQWareProduction for Oracle, feature: RMAN partial clone to restore tablespace list in menu_rman
  • SQWareProduction for Sybase, enhance : email report in html format
  • SQWareProduction for Sybase, enhance : check lack backups
  • SQWareProduction for Sybase, feature: new update statistcs (index with auto sample size)
  • SQWareProduction for Sybase, enhance: new rebuild method (only indexes if table is not necessary)
  • SQWareProduction for MsSql, enhance : email report in html format
  • SQWareProduction for MsSql, enhance : check lack backups
  • SQWareProduction for MsSql, feature: new rebuild index method for 2005 and 2008
  • SQWareProduction for MySQL, enhance : email report in html format
  • SQWareProduction for MySQL, enhance : check lack backups
  • SQWareProduction for Ingres, First version that support Ingres
  • SQWareRepository for Oracle, New tables for AWR reports to support 11g reports formats
  • SQWareRepository for Oracle, New view to aggregate AWR table reports for all versions
  • SQWareRepository for Sybase, New tables to exclude check backup of instances and databases
  • SQWareRepository for MsSql, New tables to exclude check backup of instances and databases
  • SQWareRepository for MySQL, New tables to exclude check backup of instances and databases
  • SQWareRepository for Ingres, New tables to exclude check backup of instances and databases
  • SQWareWeb Core, feature: new debug flags for chart and table generators
  • SQWareWeb Core, enhance: new method to trap errors in main menu
  • SQWareWeb for Oracle, feature: new sub-menu dashboard
  • SQWareWeb for Oracle, enhance: check backup page in technical sub-menu
  • SQWareWeb for Ingres, First version that support Ingres
  • SQWareCentral Core, feature: change of principal directory
  • SQWareProduction for Oracle, feature: Crontab example
  • SQWareProduction for Sybase, feature: Crontab example
  • SQWareProduction for MsSql, feature: Crontab example
  • SQWareProduction for MySQL, feature: Crontab example
  • SQWareCentral for Ingres, First version that support Ingres

A noter, l’apparition de l’option ‘-s’ permettant d’avoir des exemples d’utilisation en ligne pour compléter l’option ‘-h’ d’aide en ligne.