La version 2024.01 de dbSQWare est en ligne

de | 2024-02-25
0 Commentaire

La version 2024.01 de dbSQWare est en ligne depuis le 2024-02-25.

Release notes:

  • SQWareCentral for All: bugfix, add check option to sqwScheduler
  • SQWareCentral for All: bugfix, modify formatting return code
  • SQWareCentral for All: bugfix, replace ls by find for search AsyncFiles
  • SQWareCentral for All: enhance, add ExecFromSQWareWeb to exec scripts from SQWareWeb
  • SQWareCentral for All: enhance, add purge of tables tsqw_AuditJobsOnDemandParam, tsqw_AuditJobsOnDemandSchedule and tsqw_JobsOnDemandFollow
  • SQWareCentral for All: enhance, add restart sqwScheduler when dbspatch
  • SQWareCentral for All: enhance, take into acount EndDate for all check exceptions in morning mail
  • SQWareCentral for All: functionality, add deamon sqwScheduler to exec OnDemandJobs
  • SQWareCentral for All: functionality, add script sqwctl_ExecOnDemandJob.ksh to exec OnDemandJobs
  • SQWareCentral for All: functionality, add sqwctl_ExecOnDemandJobKiller.ksh for kill on demand job from SQWareWeb
  • SQWareCentral for MongoDB: bugfix, for check db backup when status « KEEP »
  • SQWareCentral for MongoDB: enhance, add check backup in morning report
  • SQWareCentral for MySQL: enhance, add follow of perf files volumetry
  • SQWareCentral for PostgreSQL: bugfix, for check db backup when status « KEEP »
  • SQWareCentral for SQWareRepository: enhance, add follow of SQWareRepository version in tsqw_RepositoryVersion
  • SQWareCentral for Sybase: bugfix, for check db backup when status « KEEP »
  • SQWareProduction for All: bugfix, modify formatting return code
  • SQWareProduction for All: bugfix, replace ls by find for search AsyncFiles
  • SQWareProduction for All: bugfix, take into acount parameters name with more than on space
  • SQWareProduction for All: enhance, modify trap in Global lib to preserve log
  • SQWareProduction for MongoDB: bugfix, modify gen list databases in gather indicator (when multiple node)
  • SQWareProduction for MongoDB: enhance, autodetect if we are on primary or not
  • SQWareProduction for MongoDB: enhance, exclude « config » database from backup because of rights issue
  • SQWareProduction for MongoDB: enhance, modify mongosh usage when available
  • SQWareProduction for MongoDB: enhance, use ‘show dbs’ to list db and enhance errors management
  • SQWareProduction for Mssql: bugfix, take into acount database name with more than on space in Global lib and gather indicators
  • SQWareProduction for MsSql: enhance, add ‘PARTITION = ALL’ when rebuild not partitionned index (better result)
  • SQWareProduction for MySQL: bugfix, use ‘show global variables’ instead of ‘show variables’ in indicators and rotate slowquery
  • SQWareProduction for PostgreSQL: enhance, generate drop tmp indexes even if rebuild indexes fail
  • SQWareProduction for Sybase: enhance, add exclude ‘proxy database’, ‘has proxy database’, ‘user created tempdb’, ‘archive databases’ by default from gen list db
  • SQWareRepository for All: enahance, add tsqw_AuditJobsOnDemandPrivs
  • SQWareRepository for All: enhance, add column EndDate to tsqw_VolBackupsThreshold, tsqw_VolBackupsExclude, tsqw_VolBackupsExcludeDb, tsqw_VolBackupsExcludeGlobalDb, tsqw_VolThreshold
  • SQWareRepository for All: enhance, add table tsqw_JobsOnDemandFollow to follow OnDemandJobs execution
  • SQWareRepository for All: enhance, add table tsqw_JobsOnDemandParam and tsqw_AuditJobsOnDemandParam to param OnDemandJobs
  • SQWareRepository for All: enhance, add table tsqw_JobsOnDemandPrivs to manage OnDemandJobs privilleges
  • SQWareRepository for All: enhance, add table tsqw_JobsOnDemandSchedule and tsqw_AuditJobsOnDemandSchedule to schedule OnDemandJobs
  • SQWareRepository for All: enhance, add tsqw_JobsOnDemandStatus and tsqw_JobsOnDemandStatusTranslate
  • SQWareRepository for Oracle: enhance, Modify support date for 19c and 21c (MOS Doc ID 742060.1)
  • SQWareRepository for PostgreSQL: bugfix, table_rows column of tsqwpg_VolTables to accept more than 10 billion
  • SQWareRepository for SQWareCentral: enhance, add table tsqw_RepositoryVersion to follow version
  • SQWareWeb for All: enhance, add column EndDate in CheckBackups and Thresholds
  • SQWareWeb for All: enhance, add jobupid and jobpidctl in reports batches execution (to spot JobsOnDemand)
  • SQWareWeb for All: enhance, add unit/OnDemandJobs and all/AllOnDemandJobs in jobs menu
  • SQWareWeb for All: enhance, modify or in menu 2 to be more efficient
  • SQWareWeb for All: enhance, take into acount EndDate for all check exceptions reports
  • SQWareWeb for All: functionality, add JobsParam, JobsParamPrivs and JobsSchedule report and admin
  • SQWareWeb for All: functionality, add kill in JobsSchedule
  • SQWareWeb for All: functionality, add reports OnDemandJobs and AllOnDemandJobs to display OnDemandJobs execution traces
  • SQWareWeb for MongoDB: bugfix, for check db backup when status « KEEP »
  • SQWareWeb for PostgreSQL: bugfix, for check db backup when status « KEEP »
  • SQWareWeb for SQWareCentral: enhance, add AsyncFiles and PerfFiles report to follow volumetry of log, sql and perf files
  • SQWareWeb for SQWareRepository: enhance, add SQWareRepositoryVersions and SQWareRepositoryFiles report to follow SQWareRepository patches
  • SQWareWeb for Sybase: bugfix, for check db backup when status « KEEP »