RELEASE NOTES

• SQWareCentral for All: enhance, test system prerequisites like ksh + rsync
• SQWareCentral for MsSql: enhance, modify "c" for mssql Linux
• SQWareCentral for PostgreSQL: enhance, modify check of PITR (full/incr/diff)
• SQWareProduction for All: enhance, add .bashrc_example and .vimrc links
• SQWareProduction for All: enhance, add collect of path and version for ksh, rsync, openssl, ...
• SQWareProduction for All: enhance, add function gfsqw_CheckCommandPathVersion to check command
• SQWareProduction for MsSql: enhance, some adapt for MsSql Linux
• SQWareProduction for MsSql: enhance, suppress call of sp_recompile when version >= 2017
• SQWareProduction for MsSql: functionnality, add support for Linux version (>=2017)
• SQWareProduction for PostgreSQL: bugfix, delete Dump when fail with "rm -rf" for -d format
• SQWareProduction for PostgreSQL: enhance, modify trace of PITR
• SQWareProdution for Oracle: enhance, add EXPIRY_DATE in field info3 of table tsqw_UsersDb (for UserDb report)
• SQWareProdution for Oracle: enhance, add LOCK_DATE in field info4 of table tsqw_UsersDb (for UserDb report)
• SQWareRepository for All: enhance, add new versions support dates
• SQWareRepository for All: enhance, add tsqw_CommandPathVersion
• SQWareRepository for Oracle: enhance, modify end of support for Oracle 19c ...
• SQWareRepository for PostgreSQL: enhance, modify check and traces of PITR
• SQWareWeb for All: bugfix, menu display according to admin rights
• SQWareWeb for All: bugfix, run and kill jobs on demand for all users
• SQWareWeb for All: enhance, add a message when loading a job kill report
• SQWareWeb for All: enhance, add CmdPathVersion and LastCmdPathVersion reports
• SQWareWeb for All: enhance, add report of path and version for ksh, rsync, openssl, ...
• SQWareWeb for PostgreSQL: enhance, modify check of PITR (full/incr/diff)

• • SQWareCentral for All: enhance, modify ref files generation
  • SQWareProduction for All: enhance, add kill all childs
  • SQWareProduction for All: enhance, add script sqwgen_KillAllChildsProcesses.ksh to kill all subprocesses from a parent PID
  • SQWareProduction for PostgreSQL: bugfix, bypass gather Citus information when instance is in recovery mode
  • SQWareProduction for PostgreSQL: bugfix, ignore error on gather alerlog path when RDS env
  • SQWareProduction for PostgreSQL: enhance, some adjust for EnterpriseDB Advanced/Extended
  • SQWareWeb for All: bugfix, correct api array for php 5.3

hange column name)

• SQWareCentral for All: enhance, add purge of tsqw_DetectDatasInstance, tsqw_DetectDatasObj1 and tsqw_DetectDatasObj2 (future module SQWarePredict)
• SQWareCentral for All: enhance, add purge of tsqw_PredictDatasInstance, tsqw_PredictDatasObj1 and tsqw_PredictDatasObj2 (future module SQWarePredict)
• SQWareProduction for All: bugfix, correction of duration compute
• SQWareProduction for MsSql: bugfix, rebuild script when mix partitionned/nonepartitionned indexes
• SQWareProduction for MySQL: bugfix, fix the issue on sqwmys_RestoreDatabase.ksh which generates "lfsqw_RestoreDatabase[235]: lfsqw_ExecRestoreDatabase[189]: 8: not found"
• SQWareProduction for MySQL: bugfix, for MariaDB 10.10 must stay 101 not 10010 ...
• SQWareProduction for MySQL: bugfix, suppress message "mysql: Deprecated program name." for MariDB >= 11.x
• SQWareProduction from MongoDB: enhance, get more parameters when gather indicators
• SQWareRepository for All: bugfix, increase token size for tsqw_TokenDynamic tsqw_TokenStatic tsqw_AuditToken tsqw_AuditConnectionsApi
• SQWareRepository for All: enhance, add comment column to tsqw_EndLife table for add if version is LTS or not
• SQWareRepository for All: enhance, add is_foradmin and is_forweb column on tsqw_AdminLogins and tsqw_AdminGroups to prepare SQWareAdmin (future module SQWareAdmin)
• SQWareRepository for All: enhance, add tables tsqw_DetectDatasInstance, tsqw_DetectDatasObj1 and tsqw_DetectDatasObj2 for detect of SQWarePredict module (future module SQWarePredict)
• SQWareRepository for All: enhance, add tables tsqw_PredictDatasInstance, tsqw_PredictDatasObj1 and tsqw_PredictDatasObj2 for predict of SQWarePredict module (future module SQWarePredict)
• SQWareRepository for All: enhance, add tadm_AccessLoginsCache for SQWareAdmin
• SQWareRepository for All: enhance, add viewes vadm_AdminAllTypesGroupsLoginsPrivs, vadm_AdminAllGroupsLoginsPrivs and vadm_AdminAllLoginsAccess to prepare SQWareAdmin (future module SQWareAdmin)
• SQWareRepository for All: enhance, modify viewes vsqw_AdminAllTypesGroupsLoginsPrivs, vsqw_AdminAllGroupsLoginsPrivs and vsqw_AdminAllLoginsAccess to prepare SQWareAdmin (future module SQWareAdmin)
• SQWareWeb for All: bugfix, empty message when deleting-updating Db Alias
• SQWareWeb for All: bugfix, empty results api key
• SQWareWeb for All: enhance, add access management to SQWareWeb and SQWareAdmin for groups and logins (future module SQWareAdmin)
• SQWareWeb for All: enhance, add tokens for SQWareWeb and SQWareAdmin (future module SQWareAdmin)
• SQWareWeb for All: enhance, create api for SQWareWeb and SQWareAdmin authentification (future module SQWareAdmin)
• SQWareWeb for All: enhance, modify EndLife reports for add if version is LTS or not

• SQWareCentral for All: bugfix, format mail when error on exec on demand job
• SQWareCentral for All: enhance, add examples for param variables gvsqw_RsyncProtocol_MyHost and gvsqw_RsyncPath_MyHost
• SQWareCentral for All: enhance, exec UpdateApiList when dbspatch
• SQWareCentral for All: enhance, modify vmsqwarebox by localhost in some example parfiles
• SQWareProduction for MongoDB: bugfix, modify modify gen databases list for version <= 3.2
• SQWareProduction for MongoDB: enhance, modify purge in DumpDatabase to avoid error when /var/tmp mounted in noexec mode
• SQWareProduction for MsSql: bugfix, correction of "Error, can't read gvsqw_MssqlPassFile='' !!!"
• SQWareProduction for MsSql: enhance, add detail for login if 'SQL_LOGIN' or 'WINDOWS_LOGIN'
• SQWareProduction for MsSql: enhance, detect (and print) if we are on RDS SQL
• SQWareProduction for MsSql: enhance, don't collect users if RDS SQL (can't execute "EXECUTE AS LOGIN = '$lvsqw_Login'")
• SQWareProduction for MsSql: enhance, for gather file and log size use 'sys.dm_db_file_space_usage' and 'sys.dm_db_log_space_usage' instead of 'DBCC showfilestats' and 'DBCC LOGINFO' for version>=2012
• SQWareProduction for MsSql: enhance, just warning when collect jobs info if RDS SQL (rights on msdb.dbo.sysjobs, msdb.dbo.sysjobsteps, msdb.dbo.sysjobhistory)
• SQWareProduction for MsSql: enhance, just warning when gather structures for version<=2000
• SQWareProduction for PostgreSQL: bugfix, add "datallowconn!='f'" where clause when generate db list
• SQWareWeb for All : enhance, add logs for update instance in Repository
• SQWareWeb for All : enhance, add mass update for Repository
• SQWareWeb for All : bugfix, change param in files of OnDemandJobs
• SQWareWeb for PostgreSQL: enhance, add IsInRecovery reports (unit and all)

• SQWareCentral for PostgreSQL: enhance, add purge of tsqwpg_CitusTables table
• SQWareCentral for PostgreSQL: enhance, add purge of tsqwpg_Extensions and tsqwpg_ExtensionsChanges tables
• SQWareProduction for All: bugfix, Global.lib exit code 22 (instead 0) when can't retrieve return code on script
• SQWareProduction for Oracle: bugfix, modify RMAN script for backup controlfiles on windows ...
• SQWareProduction for PostgreSQL: bugfix, modify PITR to support conf files with space like 'C:\Program Files\...'
• SQWareProduction for PostgreSQL: enhance, add collect extensions and extensions changes indicators
• SQWareProduction for PostgreSQL: enhance, add collect of citus tables indicators
• SQWareProduction for PostgreSQL: enhance, add collect of partitionned tables (before, only partitions report)
• SQWareProduction for PostgreSQL: enhance, modify CopyDump scripts to accept all formats p,t,c,d
• SQWareProduction for PostgreSQL: enhance, modify Dump scripts to accept all formats p,t,c,d
• SQWareRepository for All: bugfix drop index on tsqw_JobsOnDemandFollow (double)
• SQWareRepository for PostgreSQL: enhance, add tsqwpg_CitusTables table
• SQWareRepository for PostgreSQL: enhance, add tsqwpg_Extensions and tsqwpg_ExtensionsChanges tables
• SQWareWeb for PostgreSQL: enhance, add reports for citus tables indicators
• SQWareWeb for PostgreSQL: enhance, add reports for extensions and extensions changes in all and unit views

• SQWareProduction for Oracle: enhance, modify RMAN Clone for SBT_TAPE
• SQWareProduction for Oracle: enhance, modify "shutdown immediate" by "shutdown abort" in MenuRman
• SQWareProduction for Oracle: enhance, suppress "format" option when SBT_TAPE in RmanBackup script (for VEEAM lib usage for example)
• SQWareProduction for PostgreSQL: bugfix, add shebang for Debian that run sh for PITR script
• SQWareRepository for All: bugfix, maintain table list to update
• SQWareRepository for All: enhance, add GenerateCreateNewTableDbaliasDate script
• SQWareWeb for All: bugfix, maintain table list to update (dbalias)

• SQWareCentral for All: bugfix, escape of quotes for parameter tracing for sqwScheduler
• SQWareCentral for All: bugfix, modify reset var order in sqwScheduler
• SQWareCentral for All: bugfix, OnDemandJobKiller kill with 31 instead of 51 (pb with old Solaris version)
• SQWareCentral for All: enhance, global review of help (-h)
• SQWareCentral for All: enhance, global review of sample (-s)
• SQWareProduction for All: bugfix, Global lib, modify trap with 31 instead of 51 (pb with old Solaris version)
• SQWareProduction for All: bugfix, modify gfsqw_GiveTraceCounterAndFile in InsertIndicators lib (pb trap errors)
• SQWareProduction for All: enhance, augment verbosity of debug for Global lib
• SQWareProduction for All: enhance, augment verbosity of debug for InsertIndicators lib
• SQWareProduction for All: enhance, global review of help (-h)
• SQWareProduction for All: enhance, global review of sample (-s)
• SQWareProduction for PostgreSQL: enhance, add -Concurrently and -NoConcurrently options for ReindexAllDatabases and ReindexDatabase scripts
• SQWareProduction for PostgreSQL: enhance, add gvsqw_Concurrently=Enable variable to globaly activate CONCURRENTLY for ReindexDatabase script
• SQWareProduction for PostgreSQL: enhance, modify gvsqw_DropTmpIndexes=Disable to gvsqw_DropTmpIndexes=Enable
• SQWareRepository for All: bugfix, modify update demo for tsqw_GenHisto
• SQWareRepository for All: enhance, modify PK of tsqw_VolBackups to add bck_type

• 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"