La version 2023.03 de dbSQWare est en ligne

de | 2023-02-11

La version 2023.03 de dbSQWare est en ligne depuis le 2023-02-11.

Release notes:

  • SQWareCentral for All: enhance, add CheckRunningDBMS script to find running DBMS on hosts
  • SQWareCentral for All: enhance, add follow SqlFiles
  • SQWareCentral for MsSql: bugfix, replacement of ins_date by ins_date to handle the case where ins_date is different in tsqwmsq_Files when check spaces
  • SQWareCentral for Oracle: enhance, add purge of tsqwora_Ctlfiles and tsqwora_Logfiles
  • SQWareCentral for Oracle: enhance, add purge of tsqwora_DbmsStats
  • SQWareProduction for All: bugfix, add « eval » in gfsqw_ExecCommandTeeReturnCode (thks Luc for the report)
  • SQWareProduction for MongoDB: enhance, add collect of adminCommand.getParameter when collect parameters indicators
  • SQWareProduction for MySQL: bugfix, add \ » when call gvsqw_RsyncOptions in sqwmys_CopyDumpDatabase.lib (thks Luc for the report)
  • SQWareProduction for MySQL: enhance, modify maj version for MariaDB case (add 0 at the end of major version because version 10.10 for exemple …) => 10.5 not 105 but 1005, 10.10 not 1010 but 10010
  • SQWareProduction for MySQL: enhance, split collect database and users indicators to avoid errors
  • SQWareProduction for Oracle: enhance, add collect of controlfiles
  • SQWareProduction for Oracle: enhance, add collect of DBMS_STATS default parameters
  • SQWareProduction for PostgreSQL: enhance, modify sqwpg_GatherStructure.lib to load in tsqwpg_AllIndexesTempo indexes like %ccnew% or %ccold%
  • SQWareRepository for Oracle: enhance, add tsqwora_Ctlfiles
  • SQWareRepository for Oracle: enhance, add tsqwora_DbmsStats
  • SQWareRepository for PostgreSQL: enhance, add table tsqwpg_AllIndexesTempo to trace indexes %ccnew% or %ccold% created when REINDEX CONCURRENTLY and fail to drop them
  • SQWareWeb for All: enhance, add report to follow SqlFiles
  • SQWareWeb for MongoDB: bugfix, replacement of NbDays=5 by NbMonth=12 when call all/parameters/ParametersChanges.html (in menu2)
  • SQWareWeb for Oracle: enhance, add reports (unit + all) of controlfiles and redologs
  • SQWareWeb for Oracle: enhance, add reports (unit + all) of DBMS_STATS default parameters
  • SQWareWeb for PostgreSQL: enhance, modify reports AllTempIndexes and TempIndexes to view contents of tsqwpg_AllIndexesTempo