SQWareCentral for MsSql: enhance, add purge of tsqwmsq_DbOptions
SQWareCentral for MsSql: enhance, add purge of tsqwmsq_DbOptionsChanges
SQWareCentral for Oracle: bugfix, add filter on status for TBS and FRA check space
SQWareProduction for All: bugfix, loop on search parent process when Solaris zone because PID=PPID
SQWareProduction for All: bugfix, quote replaced by underscore _ in file name for database with quote in name
SQWareProduction for All: enhance, add 'chmod 600 EncryptedFile ClearFile SslPassFile' when generate files
SQWareProduction for All: enhance, add default options '-pbkdf2 -iter 100000' when encript file with openssl >= v3
SQWareProduction for All: enhance, add gfsqw_ConvertPathToCygwin function in generic lib to convert "D:/xxx" to "/cygdrive/d/xxx"
SQWareProduction for All: enhance, add var gvsqw_HostFullname to put "full hostname" instead of "short name"
SQWareProduction for MongoDB: bugfix, syntax error on restore script
SQWareProduction for MongoDB: enhance, add option -IgnoreVersion for GenerateCreateInstance script
SQWareProduction for MongoDB: enhance, modify SetEnv to source profile when Dist mode
SQWareProduction for MsSql: bugfix, add 'set quoted_identifier on' for rebuild when not set to OFF on db
SQWareProduction for MsSql: bugfix, modify connection function when encript file
SQWareProduction for MsSql: enhance, add collect of db options in tsqwmsq_DbOptions
SQWareProduction for MsSql: enhance, add collect of db options in tsqwmsq_DbOptionsChanges
SQWareProduction for MsSql: enhance, ignore "failed because the following SET options have incorrect settings: 'ANSI_NULLS, ..." messages when rebuild
SQWareProduction for Oracle: bugfix, modify SchemaRefreshExpdp Impdp GenericRefresh Expdp and CopyDmpdp libs to take into account upper case files names on Windows
SQWareProduction for Oracle: enhance, add csqwora_SetEnv_profile.ksh for example
SQWareProduction for PostgreSQL: bugfix, modify all scripts to accept database with quote or space in name
SQWareProduction for PostgreSQL: bugfix, modify libs to take into account db with ' or space in name 🙁
SQWareRepository for MsSql: enhance, add table tsqwmsq_DbOptions
SQWareRepository for MsSql: enhance, add table tsqwmsq_DbOptionsChanges
SQWareWeb for All: bugfix, correction change password in preferences
SQWareWeb for All: bugfix, correction of loss of column names in show/hide columns
SQWareWeb for All: security, delete access to test.php phpinfo.php
SQWareWeb for MsSql: enhance, add DbOptionsChanges and DbOptions all reports
SQWareWeb for MsSql: enhance, add DbOptionsChanges and DbOptions unit reports
SQWareCentral for All: enhance, adjust JobsParam and JobsParamPrivs because of changes in JobsParam tables (new standard)
SQWareProduction for MongoDB: bugfix, fail to restore when 'no tar' backup
SQWareRepository for All: bugfix, correct migrations before rename columns created_by and updated_by
SQWareRepository for All: bugfix, some adjust after rename columns in 2025.06
SQWareWeb for All: enhance,adjust GeneralInfos and Daybook because of changes in Management tables
SQWareWeb for All: bugfix, correct dbalias update action
SQWareWeb for All: bugfix, correct sql queries for lack backups db justified
SQWareWeb for All: bugfix, correct sql queries for lack backups justified
SQWareCentral for All: enhance, add load of SQWareAdmin param when dbspatch
SQWareCentral for MsSql: enhance, add purge of tsqwmsq_AuditLogon
SQWareCentral for Oracle: enhance, add purge of tsqwora_AuditLogon
SQWarePredict for MsSql: bugfix, add 'sort' when check files to restore because of bad sort of 'dir' command when NFS mount ...
SQWareProduction for Add: enhance, add generic function gfsqw_DisplayAllParentsProcesses for display parents processes in log+mail
SQWareProduction for MongoDB: bugfix, fail to search file to restore
SQWareProduction for MsSql: enhance, add collect/purge of tsqw_audit_logon
SQWareProduction for MsSql: enhance, add CreateAuditLogon to create table tsqw_audit_logon and trigger trgsqw_audit_logon
SQWareProduction for MySQL: bugfix, fix -Consistent option
SQWareProduction for MySQL: enhance, add collect of data_free for tables, databases and instance
SQWareProduction for MySQL: enhance, modify optimize to filter on $gvsqw_OptimizeMinDataFree and $gvsqw_OptimizeMinFragRatio
SQWareProduction for Oracle: enhance, add collect/purge of TSQW_AUDIT_LOGON
SQWareProduction for Oracle: enhance, add CreateAuditLogon to create table TSQW_AUDIT_LOGON and triggers TRGSQW_AUDIT_LOGON+TRGSQW_AUDIT_LOGOFF
SQWareRepository for All: enhance, add created_at on tsqw_RepositoryVersion
SQWareRepository for MsSql: enhance, add table tsqwmsq_AuditLogon
SQWareRepository for MySQL: enhance, add column data_free on tsqwmys_VolDb
SQWareRepository for MySQL: enhance, add column data_free on tsqwmys_VolTables
SQWareRepository for Oracle: enhance, add table tsqwora_AuditLogon
SQWareWeb for All: enhance, add created_at in SQWareRepositoryVersions report
SQWareWeb for All: enhance, add criticality in repository
SQWareWeb for All: enhance, add TargetsRdbmsHisto reports
SQWareWeb for All: enhance, add TargetsTotalHisto and TargetsRdbmsHisto reports
SQWareWeb for All: enhance, API modification of the admin part of SQWareWeb for merge with SQWareAdmin
SQWareWeb for All: enhance, modification of the admin part of SQWareWeb for merge with SQWareAdmin
SQWareWeb for MsSql: enhance, add AuditConnection report
SQWareWeb for MySQL: enhance, add data_free on reports for tables and databases
SQWareWeb for Oracle: enhance, add AuditConnection report
SQWareCentral for All: enhance, add "DBMS list" when check indicators with filter
SQWareCentral for All: enhance, add insert in tsqw_TargetsDetailHisto when check indicators
SQWareCentral for All: enhance, add ReportSupportOs to send mail with support date
SQWareProduction for All: bugfix, modify for Solaris collect of version
SQWareProduction for DB2: bufix, suppress bad location of 'db2 terminate' in reorg script
SQWareProduction for MsSql: bugfix, call tsql instead of fisql to avoid issue when collect tables size (for ex, tablename with japan chars)
SQWareProduction for MySQL: bugfix, mail format when error on MariaBackup or XtraBackup
SQWareProduction for Oracle: bugfix, double call of userid when impdp
SQWareProduction for Oracle: enhance, add collect of spfile parameters
SQWareRepository for All: enhance, add criticality_id on tsqw_Repository and tsqw_RepositoryApplication
SQWareRepository for All: enhance, add insert histo datas in tsqw_TargetsDetailHisto
SQWareRepository for All: enhance, add tables tsqw_RepoParam and tsqw_RepoParamTranslate
SQWareRepository for All: enhance, add table tsqw_TargetsDetailHisto
SQWareRepository for All: enhance, add tsqw_TargetsDetailHisto
SQWareRepository for Oracle: enhance, add table tsqwora_SpParameters
SQWareWeb for All: enhance, add criticality for instance and/or applications on all links reports
SQWareWeb for All: enhance, add criticality for instance in inventory report
SQWareWeb for All: enhance, add ReportSupport and ReportSupportOs once a month in CrontabRef example
SQWareWeb for All: enhance, modify Support and SupportOs reports to take into account only "active" status
SQWareWeb for Oracle: enhance, spfile parameters reports unit + all
SQWareCentral for All: bugfix, modify ExecOnDemandJob because follow issue on Solaris
SQWareCentral for All: enhance, add ConnectTimeout for all ssh/rsync commands
SQWareCentral for All: enhance, add example to manage HISTFILE for each client
SQWareCentral for All: enhance, add "pfu" alias
SQWareCentral for All: enhance, add ReportSupport to send mail with support date
SQWareCentral for All: enhance, make log and mail more verbose for TrtAuto when timeout (and KillAllChilds)
SQWareCentral for All: enhance, search if client is mysql or mariadb command
SQWareCentral for MsSql: bugfix, add 'LINUX' status for gen checks
SQWareProduction for All: bugfix, modify RunJob to accept '>' in exec command
SQWareProduction for All: enhance, add ConnectTimeout for all ssh/rsync commands
SQWareProduction for All: enhance, add KillAllChilds for kill process and all this childs
SQWareProduction for All: enhance, add "pfu" alias
SQWareProduction for All: enhance, add var gvsqw_SshConnectTimeout to manage ConnectTimeout ssh/rsync
SQWareProduction for All: enhance, modify Gobal.lib to gather HostTypeFamily, HostEdition, HostVersion and HostVersionMaj
SQWareProduction for MsSql: bugfix, 'set ansi_defaults, concat_null_yields_null on', don't rebuild small tables correctly
SQWareProduction for MsSql: enhance, modify Gobal.lib to gather ProductEdition and ProductAddInfos
SQWareProduction for MySQL: enhance, modify Gobal.lib to gather ProductEdition and ProductAddInfos
SQWareProduction for Orale: enhance, modify Gobal.lib to gather ProductEdition and ProductAddInfos
SQWareProduction for PostgreSQL: enhance, modify Gobal.lib to gather ProductEdition and ProductAddInfos
SQWareProduction for Sybase: bugfix, modify Global lib to avoid "... delimited by end-of-file (wanted `EOFSQL')" appear in bash
SQWareProduction for Sybase: enhance, modify Gobal.lib to gather ProductEdition and ProductAddInfos
SQWareRepository for Adabas: enhance, add EOL dates
SQWareRepository for All: enhance, add HostTypeFamily, HostEdition, HostVersion and HostVersionMaj on tsqw_GenHostInfos
SQWareRepository for All: enhance, add ProductEdition and ProductAddInfos on tsqw_GenInstance
SQWareWeb for All: enhance, add HostTypeFamily, HostEdition, HostVersion and HostVersionMaj in LastGenHostInfos report
SQWareWeb for All: enhance, add InventoryOverview report
SQWareWeb for All: enhance, add ProductEdition and ProductAddInfos in HostInfos report
SQWareWeb for All: enhance, add SupportOs and SupportOsDates reports
SQWareWeb for All: enhance, add table tsqw_EndLifeOs
SQWareWeb for All: enhance, add wiki, wikifr and support links on footer
SQWareProduction for All: enhance, add -AddMail and -SendReport options for sqwgen_RunJob script
SQWareProduction for All: enhance, add gvsqw_SendMailOnError=Disable variable to globaly deactivate sendmail on error
SQWareProduction for All: enhance, add -SendMailOnError and -NoSendMailOnError options for sqwgen_RunJob script
SQWareProduction for Central: bugfix, for set .profile_confort when connected
SQWareProduction for MsSql: bugfix, bash only accep interger when test (in rebuild script)
SQWareProduction for Oracle: bugfix, add 'eval' when echo ~$lvsqw_UserUnixSource (work in ksh but not in bash)
SQWareProduction for Oracle: bugfix, adjust BackupPasswd
SQWareProduction for Oracle: bugfix, for refresh imp.par not reset
SQWareProduction for Oracle: bugfix, 'grep -a' not supported on old Solaris (ExpdpAll* + GatherStructures)
SQWareProduction for Oracle: enhance, add gvsqw_NoASM to disable ASM indicators
SQWareProduction for PostgreSQL: bugfix, error message when archive (introduce in v2025.01)
SQWareProduction for PostgreSQL: bugfix, modify delete in DumpGlobalsOnly (for noexec on /var/tmp)
SQWareProduction for PostgreSQL: enhance, add -Analyze and -NoAnalyze options for VacuumAllDatabases and VacuumDatabase scripts
SQWareProduction for PostgreSQL: enhance, add example for dump with opt
SQWareProduction for PostgreSQL: enhance, add gvsqw_VacuumAnalyze=Disable variable to globaly deactivate ANALYZE for VacuumDatabase script
SQWareProduction for Sybase: bugfix, add 'eval' when echo ~$lvsqw_UserUnixSource (work in ksh but not in bash)
SQWareProduction for Teradata: bugfix, add *.0 to avoid round in compute
SQWareCentral for All: functionality, add sqwPredictMon deamon to async update Predict/Detect
SQWareProduction for All: bugfix, test $SHELLOPTS before "set +H" to prevent fail
SQWareProduction for All: enhance, add gvsqw_TraceJobDb=disable to disable trace job
SQWareProduction for All: enhance, add gvsqw_TraceSqlDb=disable to disable load sql
SQWareProduction for All: enhance, add var for prompt BlackWhite2LinesLong + alias : p_b2l
SQWareProduction for All: enhance, add var for prompt BlackWhite2LinesShort + alias : p_b2s
SQWareProduction for All: enhance, add var for prompt BlackWhiteMultiLinesLong + alias : p_bml
SQWareProduction for All: enhance, add var for prompt BlackWhiteMultiLinesShort + alias : p_bms
SQWareProduction for All: enhance, add var for prompt BlackWhiteOneLineLong + alias : p_bol
SQWareProduction for All: enhance, add var for prompt BlackWhiteOneLineShort + alias : p_bos
SQWareProduction for All: enhance, add var for prompt Color2LinesLong + alias : p_c2l
SQWareProduction for All: enhance, add var for prompt Color2LinesShort + alias : p_c2s
SQWareProduction for All: enhance, add var for prompt ColorMultiLinesLong + alias : p_cml
SQWareProduction for All: enhance, add var for prompt ColorMultiLinesShort + alias : p_cms
SQWareProduction for All: enhance, add var for prompt ColorOneLineLong + alias : p_col
SQWareProduction for All: enhance, add var for prompt ColorOneLineShort + alias : p_cos
SQWareRepository for All: enhance, add tsqw_CommandPathVersion + tsqw_LibsVersion in maintenance scripts
SQWareRepository for All: enhance, update end of support dates
SQWareRepository for PostgreSQL: enhance, add tsqwpg_CitusTables + tsqwpg_CitusTablesShards in maintenance scripts
SQWareRepository for PostgreSQL: enhance, add tsqwpg_Extensions + tsqwpg_ExtensionsChanges in maintenance scripts
SQWareWeb for All: enhance, add tsqw_CommandPathVersion + tsqw_LibsVersion in update dbalias scripts
SQWareWeb for PostgreSQL: enhance, add tsqwpg_CitusTables + tsqwpg_CitusTablesShards in update dbalias scripts
SQWareWeb for PostgreSQL: enhance, add tsqwpg_Extensions + tsqwpg_ExtensionsChanges in update dbalias scripts
/!\ Migration du ksh au bash !
SQWareCentral for SQWareAdmin: enhance, add ManageConnector
SQWareCentral for All: enhance, add -CustFilter option for check indicators
SQWareCentral for All: enhance, add gvsqw_RunSQWarePredict to globaly enable/disable Predect/Detect
SQWareCentral for All: enhance, dbspatch wil mv all scripts, cfg and cron on sqwarebox from ksh to bash
SQWareCentral for All: enhance, mv all scripts from ksh to bash
SQWareCentral for All: enhance, add sqwctl_PredictUpdate.ksh
SQWarePredict for All: enhance, add genric param (instance + FS)
SQWarePredict for All: enhance, add param FSGrowth_used.ini
SQWarePredict for All: functionnality, init
SQWarePredict for MsSql: enhance, add param for databases
SQWarePredict for MsSql: enhance, add param DatabaseGrowth_size.ini
SQWarePredict for MsSql: enhance, add param DatabaseGrowth_used.ini
SQWarePredict for MySQL: enhance, add param for databases
SQWarePredict for Oracle: enhance, add param for schemas + tablespaces
SQWarePredict for Oracle: enhance, add param SchemaGrowth_size.ini
SQWarePredict for PostgreSQL: enhance, add param for databases
SQWarePredict for PostgreSQL: enhance, add param DatabaseGrowth_size.ini
SQWarePredict for Sybase: enhance, add param for databases
SQWarePredict for Sybase: functionnality, add DatabaseGrowth_used.ini
SQWareProduction for All: enhance, add global purge of Predect/Detect when GatherIndicators
SQWareProduction for All: enhance, add sqwgen_MvToBash.ksh to mv all scripts, cfg and cron on local env from ksh to bash
SQWareProduction for All: enhance, mv all scripts from ksh to bash
SQWareProduction for MsSql: enhance, ignore deadlocks when rebuild or update stats
SQWareProduction for Oracle: bugfix, put 'gunzip -f' to prevent errors when file exists
SQWareProduction for Oracle: bugfix, put credentials from command line instead of parfile
SQWareProduction for PostgreSQL: bugfix, modif DumpAllDatabases to take options for DumpGlobalsOnly
SQWareWeb for All: enhance, add Predict report for FS
SQWareWeb for All: enhance, add Predict report for Instances
SQWareWeb for All: enhance, migration from c3js/d3js to Billboard
SQWareWeb for All: enhance, upgrade DataTables version from v1.10 to v2.2
SQWareWeb for All: bugfix, display action buttons when repository is empty
SQWareWeb for Central: enhance, add CmdPathVersion GenHostInfos GenHostInfosChanges and GenPathInfos reports
SQWareWeb for Central: enhance, add GenDbsVersionLast and GenDbsVersionAll reports
SQWareWeb for MsSql: enhance, add Predict report for Databases
SQWareWeb for MySQL: enhance, add Predict report for Databases
SQWareWeb for Oracle: enhance, add Predict report for Schemas + Tablespaces
SQWareWeb for PostgreSQL: enhance, add Predict report for Databases
SQWareWeb for Sybase: enhance, add Predict report for Databases
Versions Majeures 2024
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"
Versions Majeures 2023
SQWareProduction for All: bugfix, modify test in .profile_confort to avoid return code 1
SQWareProduction for All: enhance, add somme future reports for perf (Monitor*)
SQWareProduction for All: functionality, add script sqwgen_FailWithoutMail
SQWareProduction for MsSql: enhance, add trace backup footprint
SQWareProduction for Oracle: bugfix, about ExpdpAllSchemas script (for sysdba connection and CDB env)
SQWareProduction for Oracle: enhance, add script ExpdpAllPDB script to datapump all PDB in //
SQWareProduction for Oracle: enhance, add traces in SQWareRepository for all types of dmpdp
SQWareProduction for PostgreSQL: bugfix, add double quotes when generate drop commands
SQWareProduction for PostgreSQL: bugfix, supp mail 'no clean' when PgIsInRecovery='true' for PITR
SQWareProduction for PostgreSQL: enhance, add -DropTmpIndexes option to drop if exist index_name like '%ccnew%' or index_name like '%ccold%' (reorg script)
SQWareProduction for PostgreSQL: enhance, add gvsqw_DropTmpIndexes variable to force to drop or not if exist index_name like '%ccnew%' or index_name like '%ccold%' (reorg script)
SQWareProduction for PostgreSQL: enhance, add -NoDropTmpIndexes option to disable drop if exist index_name like '%ccnew%' or index_name like '%ccold%' (reorg script)
SQWareProduction for Sybase: bugfix, modify test MajorVersion in GatherStructure
SQWareWeb for All: bugfix, allow modification of a user's password by an admin external_ad
SQWareWeb for All: bugfix, modify rights on GlobalGrowth and ReportFS reports
SQWareWeb for All: enhance, allow entering '$' and '#' in Administration
SQWareWeb for All: enhance, code optimization for actions and languages in Administration
SQWareCentral for All: enhance, add ability to force protocol for rsync ex "export gvsqw_RsyncPath_=--rsync-path=/usr/local/bin/rsync"
SQWareCentral for All: enhance, add ability to force protocol for rsync ex "export gvsqw_RsyncProtocol_MyHost=--protocol=26"
SQWareProduction for All: bugfix, structure changes not work since 2023.03 ...
SQWareProduction for Oracle, bugfix: about ExpdpAllSchemas script
SQWareProduction for Oracle: bugfix, indicators when datafile name contain \n \r or is missing
SQWareProduction for Oracle: bugfix, modify purge of dmpdp files because Oracle put files in upper case on windows
SQWareProduction for Sybase: enhance, add -LtmIgnore option to execute "dbcc settrunc (ltm,ignore)" after load
SQWareRepository for Oracle: bugfix, modify clone RMAN script when RMAN directory is a symbolic link (for find command)
SQWareRepository for PostgreSQL: bugfix, modify generation of backup_label file in PITR script (wall file apear when start by an upper letter, ex : FD/23000028)
SQWareWeb for All: bugfix, init NbDays in SQWareCentral after timeout
SQWareWeb for All: bugfix, modify reports AllIndexesChanges, AllStructuresChanges and AllTablesChanges
SQWareWeb for All: enhance, add AllSchemes reports in "all" category
SQWareWeb for All: enhance, add AllSchemes reports in "unit" category
SQWareWeb for All: enhance, add AllStructuresLastStatusAsync reports in "all" category
SQWareWeb for All: enhance, add AllStructuresStatusAsync reports in "all" category
SQWareWeb for All: enhance, add AllStructuresStatusAsync reports in "unit" category
SQWareWeb for All: enhance, add detail in compare structure reports
SQWareWeb for All: enhance, add traces in apiOut
SQWareCentral for All: enhance, add purge of tsqw_GenPathInfos
SQWareProduction for Adabas: enhance, add PathInfos reports
SQWareProduction for Adabas: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
SQWareProduction for All: enhance, add gfsqw_GatherPathInfos to follow var, logical path and physical path
SQWareProduction for All: enhance, add PathInfos reports
SQWareProduction for DB2: enhance, add PathInfos reports
SQWareProduction for DB2: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
SQWareProduction for MongoDB: enhance, add PathInfos reports
SQWareProduction for MongoDB: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
SQWareProduction for MongoDB: enhance, modify CopyDump script to not delete files included in copy list and use rsync
SQWareProduction for MsSql: bugfix, modify retrieve method for hostname in gather indicators
SQWareProduction for MySQL: enhance, add CopyMariaBackup script
SQWareProduction for MySQL: enhance, add CopyXtraBackup script
SQWareProduction for MySQL: enhance, add PathInfos reports
SQWareProduction for MySQL: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
SQWareProduction for MySQL: enhance, modify CopyDump script to not delete files included in copy list and use rsync
SQWareProduction for MySQL: enhance, modify purge in DumpDatabase to avoid error when /var/tmp mounted in noexec mode
SQWareProduction for MySQL: enhance, -OptionsBeforeMySQL in restore scripts to put additional options before mysql command (by default, $gvsqw_OptionsBeforeMySQL)
SQWareProduction for MySQL: enhance, -OptionsMySQL in restore scripts to put additional options during mysql command (by default, $gvsqw_OptionsMySQL)
SQWareProduction for Oracle: bugfix, source env in sqwora_RmanClone for source
SQWareProduction for Oracle: enhance, add PathInfos reports
SQWareProduction for Oracle: enhance, add script ExpdpAllSc^Cmas to datpump all schemas one by one in //
SQWareProduction for Oracle: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
SQWareProduction for PostgreSQL: enhance, add PathInfos reports
SQWareProduction for PostgreSQL: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
SQWareProduction for PostgreSQL: enhance, modify CopyDump script to not delete files included in copy list and use rsync
SQWareProduction for PostgreSQL: enhance, modify purge in DumpDatabase to avoid error when /var/tmp mounted in noexec mode
SQWareProduction for Sybase: enhance, add PathInfos reports
SQWareProduction for Sybase: enhance, add TestInstConnection script
SQWareProduction for Sybase: enhance, add var gvsqw_PathList and call of gfsqw_GatherPathInfos in GatherIndicators
SQWareProduction for Sybase: enhance, modify CopyDump script to not delete files included in copy list and use rsync
SQWareRepository for All: enhance, add table tsqw_GenPathInfos to insert var, logical path and physical path
SQWareCentral for PostgreSQL: enhance, modify check backup for standby when not required
SQWareProduction for All: bugfix, add touch to not rmdir ...
SQWareProduction for All: enhance, add traces to debug (export gvsqw_Debug=true to use it)
SQWareProduction for All: enhance, collect CPU number, type ... for Solaris
SQWareProduction for DB2: bugfix, add "db2 connect ..." in Reorganize because lost connection due to "tee" for log
SQWareProduction for DB2: bugfix, add "db2 connect ..." in RunStats because lost connection due to "tee" for log
SQWareProduction for MsSql: bugfix, lfsqw_BackupPath in sqwmsq_TestInstConnection.ksh
SQWareProduction for MsSql: bugfix, modify AlterDatabaseModifyLogGrowth to exclude offline and snapshot databases
SQWareProduction for MsSql: bugfix, modify AlterDatabaseRecoverySimple to exclude offline and snapshot databases
SQWareProduction for MsSql: bugfix, modify AlterDatabaseShrinkLogs to exclude offline and snapshot databases
SQWareProduction for MsSql: enhance, add -AllFull option to BackupAllDatabases script to select all databases with RECOVERY=FULL (for backup log)
SQWareProduction for MySQL: bugfix, take into account flag -F in restore script
SQWareProduction for Oracle: bugfix, modify query when collect indicators on offline datafiles in multi-tenant architecture
SQWareProduction for Oracle: bugfix, suppress "JOIN" in query for collect indexes infos when version <= 8i
SQWareProduction for PostgreSQL: enhance, add -ForceDump option to force dump when cluster is in recovery
SQWareProduction for PostgreSQL: enhance, add -ForcePitr option to force PITR when cluster is in recovery
SQWareProduction for PostgreSQL: enhance, add gvsqw_ForceDump variable to force dump when cluster is in recovery
SQWareProduction for PostgreSQL: enhance, add gvsqw_ForcePitr variable to force PITR when cluster is in recovery
SQWareProduction for PostgreSQL: enhance, add -NoForceDump option to disable force dump when cluster is in recovery
SQWareProduction for PostgreSQL: enhance, add -NoForcePitr option to disable force PITR when cluster is in recovery
SQWareProduction for PostgreSQL: enhance, add xlog/wal replay pause when PITR standby
SQWareRepository for All: enhance, add column BckSlave to tsqw_VolBackupsThresholdDef and tsqw_VolBackupsThreshold to ask or not check on standby
SQWareRepository for All: enhance, add table tsqw_VolBackupsExcludeAuto to exclude standby for backup check when not required
SQWareRepository for PostgreSQL: enhance, add tsqwpg_IsInRecoveryHisto and tsqwpg_IsInRecovery to trace if PG is in recovery mode
SQWareWeb for All: enhance, add management of BckSlave on VolBackupsThresholdDef and VolBackupsThreshold menu to ask or not check on standby
SQWareWeb for All: enhance, add new column (Backup Standby) in CheckBackups
SQWareCentral for All: enhance, add ReportSupport script to send support dates of DBMS
SQWareCentral for Oracle: enhance, add check 'expdp full' in morning check
SQWareProduction for All: bugfix, modify gather OS indicators
SQWareProduction for MongoDB: enhance, add support for v6.0 1/4: run mongosh instead of mongo command
SQWareProduction for MongoDB: enhance, add support for v6.0 2/4: add (prompt = ""; ) to suppress prompt display
SQWareProduction for MongoDB: enhance, add support for v6.0 3/4: call 'setReadPref("primaryPreferred")' instead of setSecondaryOk() because deprecated
SQWareProduction for MongoDB: enhance, add support for v6.0 4/4: output contain now ' instead of "
SQWareProduction for MsSql: bugfix, add 'where bck.is_snapshot=0 and bck.is_copy_only=0' when collect backup traces
SQWareProduction for MySQL: bugfix, suppress options before $gvsqw_ConnectString to accept "--defaults-file" in GatherIndicators
SQWareProduction for Oracle: bugfix, add alter "session set NLS_NUMERIC_CHARACTERS='.,'" because NLS_NUMERIC_CHARACTERS var don't work in all cases ...
SQWareProduction for Oracle: bugfix, modify gather PDB and TBS indicators for DG in multi-tenant
SQWareProduction for Oracle: enhance, add trace of 'expdp full' (for check backups)
SQWareProduction for PostgreSQL: bugfix, check if pg_is_in_recovery
SQWareProduction for PostgreSQL: bugfix, "fast => TRUE" for PITR (>=15)
SQWareProduction for Sybase: bugfix, modify search of dump to load with flag
SQWareRepository for All: bugfix, extend fields in tsqw_GenHostInfos
SQWareRepository for All: bugfix, modify size of HostRelease col in tsqw_GenHostInfos
SQWareRepository for All: bugfix, put binary mode on database_name and username fields on tsqw_UsersDb
SQWareRepository for All: bugfix, put database_name and username cols case sensitive in tsqw_UsersDb
SQWareWeb for All: enhance, add support PHP 8.2
SQWareWeb for All: enhance, load log and mail files for apiAudit jobs
SQWareWeb for Oracle: enhance, add check 'expdp full'
SQWareCentral for All: enhance, add banner
SQWareCentral for Oracle: bugfix, add "echo" to avoid error when no instance on host for StartedInstances
SQWareProduction for All: bugfix, return underlying code of executed command instead of 12 in RunJob script
SQWareProduction for Cassandra: bugfix, modify Global.lib to trap version (to ignore for example "Picked up JAVA_TOOL_OPTIONS ...")
SQWareProduction for MsSql: bugfix, add "PARTITION=$lvsqw_IndexPartitionNumber" when IndexPartitionNumber > 1 in RebuildIndex script
SQWareProduction for MsSql: bugfix, exclude objects with special caracters [ or ] in RebuildIndex script
SQWareProduction for MsSql: enhance, add -SizeMaxIndex option and gvsqw_SizeMaxIndexRebuild variable to take into account indexes <= $gvsqw_SizeMaxIndexRebuild Mb
SQWareProduction for MsSql: enhance, add -SizeMinIndex option and gvsqw_SizeMinIndexRebuild variable to take into account indexes >= $gvsqw_SizeMinIndexRebuild Mb
SQWareProduction for MySQL: bugfix, passwd masking in log messages
SQWareProduction for Oracle: bugfix, add "exit" when collect DBMS_STATS datas to avoid blocking sqlplus
SQWareProduction for PostgreSQL: bugfix, use pg_backup_start and pg_backup_stop (instead of pg_start_backup and pg_stop_backup) in PITR script for version >= 15
SQWareProduction for PostgreSQL: enhance, use the non-exclusive backup (pg_start_backup/pg_backup_start) in PITR script for version >= 9.6
SQWareRepository for All: enhance, add column rdbmstype to tsqw_LinkDbApplication
SQWareRepository for Oracle: enhance, modify PK on tsqwora_DbmsStats (param_name not null)
SQWareWeb for All: enhance, add free field for dbalias in linkDbApplication
SQWareWeb for All: enhance, add support PHP 8.1
SQWareWeb for All: enhance, modify strict join by like join on dbalias in reports LinksDbApplication, LinksDbApplicationStrict, LinksDbApplicationCompact (all and unit)
SQWareWeb for MsSql: bugfix, display for LackBackupsJustified
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
SQWareCentral for MongoDB: bugfix, modify sqwmng_GenLstUniqueNew.sql
SQWareProduction for All: bugfix, modify call to gfsqw_EndMailError when tee
SQWareProduction for All: bugfix, modify gfsqw_EndTrt + gfsqw_ExitTrt because tee prevents variable retrieval (suddenly, the script always exits in code 0)
SQWareProduction for All: enhance, add lfsqw_ArchivingParameters fonction to exclude parameters from change tracking
SQWareProduction for DB2: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
SQWareProduction for MongoDB: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
SQWareProduction for MsSql: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
SQWareProduction for MySQL: bugfix, trap "no version information available" message when check version
SQWareProduction for MySQL: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
SQWareProduction for Oracle: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
SQWareProduction for PostgreSQL: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
SQWareProduction for Sybase: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
SQWareProduction for SybRs: enhance, add call of lfsqw_ArchivingParameters to exclude parameters from change tracking
SQWareRepository for All: enhance, add table tsqw_ParametersChangesExclude (to exclude parameters from change tracking)
SQWareRepository for All: enhance, add table tsqw_UsersDbAddInfos (to add user information in reports)
SQWareWeb for All: enhance, add 'ChangementsParametresExclusion' tab in Jobs
SQWareWeb for All: enhance, add 'UserAjoutInfos' tab in Jobs
SQWareWeb for All: enhance, add distribution report dbms/Customer
SQWareWeb for All: enhance, add distribution report dbms/env
SQWareWeb for All: enhance, add management of ParametersChangesExclude (to exclude parameters from change tracking)
SQWareWeb for All: enhance, add management of UserAddInfos (to add user information in reports)
SQWareWeb for All: enhance, modify reports InventoryUsers and InventoryUsersFiltered to add user informations contained in tsqw_UsersDbAddInfos
SQWareCentral for All: enhance, add tee and suppress tail for log management in all scripts (big change, need adapt your custom scripts!)
SQWareProduction for All: enhance, add tee and suppress tail for log management in all scripts (big change, need adapt your custom scripts!)
SQWareProduction for All: enhance, change log name for RunJob to ${lvsqw_Action}_${gvsqw_DateFullIso}_${gvsqw_GlobalPid}.log
SQWareProduction for MsSql: enhance, Management of a lock file to avoid two backups of the same type at the same time
SQWareProduction for MySQL : bugfix, modif gather indicator global vol, don't work in MariaDB 10.6, bug ?
SQWareProduction for PostgreSQL: enhance, add CopyDumpAllDatabases to run CopyDumpDatabase in //
SQWareProduction for PostgreSQL: enhance, add CopyDumpDatabase script to copy dump between to host (get and put methods)
SQWareProduction for PostgreSQL: enhance, add RestoreAllDatabases to run RestoreDatabase in //
SQWareProduction for PostgreSQL: enhance, add RestoreDatabase script to restore database dump made by pg_dump
SQWareProduction for PostgreSQL: enhance, BackupArchiveXlog use pigz if installed instead of gzip (use "export gvsqw_ArchiveXlogPigzMaxProc=x" to limit the number of processes to x)
SQWareProduction for PostgreSQL: enhance, BackupPitr use pigz if installed instead of gzip (use "export gvsqw_PitrPigzMaxProc=x" to limit the number of processes to x)
SQWareProduction for PostgreSQL: enhance, disable Analyze, Reindex, Vacuum, BackupPitr jobs when pg_is_in_recovery=true
SQWareProduction for PostgreSQL: enhance, DumpAllDatabases use pigz if installed instead of gzip (use "export gvsqw_DumpPigzMaxProc=x" to limit the number of processes to x)
SQWareRepository for All: bugfix, alter tsqw_LinkDbApplication to make database_name case sensitive
SQWareWeb for All: bugfix, sql error for audit changes in tsqwRepository with mysql
SQWareWeb for All: bugfix, translation 3 labels for repository
Versions Majeures 2022
SQWareProduction for DB2: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
SQWareProduction for Ingres: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
SQWareProduction for MongoDB: bugfix, suppress info message for gather indicators tables
SQWareProduction for MongoDB: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
SQWareProduction for Oracle: enhance, add gvsqw_RmanMkdirOption to control create backup RMAN directory
SQWareWeb for Adabas: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for Adabas: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
SQWareWeb for DB2: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for DB2: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
SQWareWeb for Ingres: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for Ingres: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
SQWareWeb for MongoDB: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for MongoDB: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
SQWareWeb for MsSql: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for MsSql: enhance, add reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for MySQL: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for MySQL: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
SQWareWeb for Oracle: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for Oracle: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
SQWareWeb for PostgreSQL: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for PostgreSQL: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
SQWareWeb for Sybase: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for Sybase: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
SQWareWeb for SybRs: enhance, add compare unit reports for system infos (IPs, memory, CPU, ...)
SQWareWeb for SybRs: enhance, add reports all/unit for system infos (IPs, memory, CPU, ...)
SQWareProduction for Adabas: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
SQWareProduction for DB2: enhance, add support of gather indicators for DB2i (AS400) with unixODBC
SQWareProduction for MySQL: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
SQWareProduction for Oracle: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
SQWareProduction for PostgreSQL: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
SQWareProduction for Sybase: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
SQWareProduction for SybRs: enhance, add gather system infos in indicators (IPs, memory, CPU, ...)
SQWareRepository for All: enhance, add tsqw_GenHostInfos table to store system infos
SQWareWeb for All: enhance, add create icon
SQWareWeb for All: enhance, API Update for JobsFollow
SQWareCentral for All: enhance, add version + volumetry in RefInstance file
SQWareCentral for All: enhance, add version in RefInst file
SQWareProduction for MySQL : enhance, add options for sqwmys_MysqlAdmin.ksh and add script sqwmys_GaleraAdmin.ksh
SQWareProduction for Oracle: bugfix, gather structures in multitenant architecture (bad exit)
SQWareProduction for Oracle: enhance, add GetAlertFile tools + alt alisas
SQWareProduction for Oracle: enhance, add option for "mkdir -p" on backup RMAN script
SQWareProduction for PostgreSQL: bugfix, multiple corrections for PG 8.3... (-w option for psql and datcollate, datctype fields in pg_database)
SQWareProduction for Sybase: enhance, suppress mail when "dump tran" fail but "dump inc" success
SQWareProduction for Sybase: functionnality, add sqwsyb_UpdtStatsParallelDatabase.ksh for calculate statistics in // mode on tables
SQWareRepository for All: bugfix, add ins_date column for tracking schema changes on empty tables
SQWareRepository for All: enhance, add tables tsqw_AdminTokenDynamic, tsqw_AdminTokenStatic, tsqw_AuditToken, tsqw_AuditConnectionsApi
SQWareWeb for All: access, add TokenStatic
SQWareWeb for All: enhance, API Update (tsqw_Repository management)
SQWareWeb for All: enhance, API indicators, trace backups
SQWareWeb for All: enhance, API indicators, trace VolFS
SQWareWeb for All: enhance, Audit tsqw_Repository UPDATE and DELETE methods
SQWareProduction for All: bugfix, remove spurious messages
SQWareProduction for MongoDB: bugfix, exclude 'local' from dump scripts
SQWareProduction for MongoDB: enhance, modify dump script to accept not authenticated mongodump
SQWareProduction for MongoDB: enhance, modify dump script to add traces when tar command fail
SQWareProduction for MongoDB: enhance, modify dump script to choose tar or not after mongodump
SQWareProduction for Sybase: enhance, add flag -TryCum for dump script (try cumulative when dump tran fail)
SQWareWeb for All: bugfix, multi_bar php5.3
SQWareWeb for All: enhance, external connection management (like AD)
SQWareCentral for All: enhance, modif check FS to view only 1 alert by host and mount
SQWareProduction for Oracle: bugfix, gather structures in multitenant architecture (bad exit)
SQWareProduction for Oracle: bugfix, modify when overload "xxx as sysdba"
SQWareProduction for Oracle: enhance, add open/close PDB$SEED to avoid backup purge when perform a full backup in multitenant architecture
SQWareProduction for Oracle: functionnality, add sqwora_MonitorWithAwrLastStat.ksh script to generate csv of latests ratios
SQWareProduction for PostgreSQL: bugfix, add 'always' when check archive_mode before PITR
SQWareProduction for PostgreSQL: bugfix, add 'always' when check archive_mode before run sqwArchmon
SQWareProduction for PostgreSQL: enhance, add info2=dbo in tsqw_UsersDb when user is "Owner"
SQWareProduction for Sybase: enhance, add ddlgen devices + ddlgen databases + conf file when backup all
SQWareProduction for Sybase: functionnality, add sqwsyb_UpdtStatsParallelDatabase.ksh for calculate statistics in // mode on tables
SQWareRepository for All: enhance, add column interactive in tsqw_AdminLoginsTypes table
SQWareRepository for All: enhance, add external_ad and internal_api_update authentication_type
SQWareRepository for All: enhance, add tables tsqw_AuditRepository and tsqw_AuditConnections
SQWareRepository for All: enhance, extend size of virt_host_name and host_name fields in tsqw_Repository
SQWareRepository for All: enhance, modify size_limit, threshold_c and threshold_w in decimal on tsqw_VolThresholdDef and tsqw_VolThreshold tables
SQWareWeb for All: enhance, add decimal for threshold in Admin
SQWareWeb for All: enhance, field length enlargement : host in Admin
SQWareWeb for All: enhance, functions to get clients infos
SQWareWeb for All: enhance, internal authentication
SQWareProduction for All: enhance, add variable gvsqw_MailSubjetForceCase to force a case for mail subject, put UpperCase or LowerCase or NoCase, to avoid quarantine (like rule ODD_CASE of spamassassin)
SQWareProduction for Cassandra: enhance, Maj supported versions in help (4.0)
SQWareProduction for MongoDB: enhance, Maj supported versions in help (5.1)
SQWareProduction for MySQL: bugfix, replace 'ps -edf' by 'ps -ef' for cygwin env
SQWareProduction for MySQL: bugfix, some replace of '\r' in cygwin env
SQWareProduction for Oracle: bugfix, modify "with admin option" by "with grant option" in createdb.sql
SQWareProduction for Oracle: bugfix, replace 'ps -edf' by 'ps -ef' for cygwin env
SQWareProduction for Oracle: bugfix, some replace of '\r' in cygwin env
SQWareProduction for Oracle: bugfix, trap warning message expdp scripts like "ORA-39173: Encrypted data has been stored unencrypted in dump file set."
SQWareProduction for Oracle: bugfix, trap warning message expdp scripts like "ORA-39327: Oracle Database Vault data is being stored unencrypted in dump file set."
SQWareProduction for Oracle: enhance, Maj supported versions in help (21c)
SQWareProduction for PostgreSQL: bugfix, replace 'ps -edf' by 'ps -ef' for cygwin env
SQWareProduction for PostgreSQL: bugfix, some replace of '\r' in cygwin env
SQWareProduction for Sybase: enhance, add flag -AddFlagName for CopyDumpDatabase and CopyDumpAllDatabases scripts
SQWareProduction for Sybase: enhance, add flag -AddFlagName for DumpDatabase and DumpAllDatabases scripts
SQWareProduction for Sybase: enhance, add flag -AddFlagName for LoadDatabase and LoadAllDatabases scripts
SQWareProduction for Teradata: enhance, Maj supported versions in help (15.x, 16.x, 17.x)
SQWareRepository for Cassandra: enhance, Maj support dates (4.0)
SQWareRepository for MongoDB: enhance, Maj support dates (5.1)
SQWareRepository for Oracle: enhance, Maj support dates (21c)
SQWareRepository for Teradata: enhance, Maj support dates (15.x, 16.x, 17.x)
SQWareWeb for All : bugfix, allow . in url for Admin
SQWareWeb for All: bugfix, get parameter NbDays for Central
SQWareWeb for All: bugfix, Modify support dates display (were not displayed when no data)
SQWareWeb for All: bugfix, Put footer links in https mode
SQWareWeb for All: enhance, add option of percent in pie
SQWareWeb for All: enhance, put MonthlyGrowthAll.chart in bar format
SQWareWeb for Cassandra: enhance, Maj supported versions in help (4.0)
SQWareWeb for MongoDB: enhance, Maj supported versions in help (5.1)
SQWareWeb for Oracle: enhance, Maj supported versions in help (21c)
SQWareWeb for Teradata: enhance, Maj supported versions in help (15.x, 16.x, 17.x)
Versions Majeures 2021
SQWareCentral for MongoDB: enhance, modify to take into account "basic env" (no repli, no authent, ...)
SQWareProduction for All: bugfix, modify compute of FS rate in indicators to be equal with "df"
SQWareProduction for DB2: bugfix, modify gather alert log file
SQWareProduction for MongoDB: enhance, add check connection script
SQWareProduction for MongoDB: enhance, add user access to databases collect
SQWareProduction for MongoDB: enhance, modify to take into account "basic env" (no repli, no authent, ...)
SQWareProduction for MongoDB: enhance, take into account "no authent mode"
SQWareProduction for MsSql: enhance, add filter on snapshot db (for backup, rebuild, ... "All"
SQWareProduction for MsSql: enhance, add user access to databases collect
SQWareProduction for MySQL: enhance, add collect of user/db to store in tsqw_UsersDb
SQWareProduction for MySQL: enhance, add user access to databases collect
SQWareProduction for Oracle: bugfix, some correction for windows+cygwin (place of tempfiles, name without :, ...)
SQWareProduction for Oracle: enhance, add more detail when collect table, partition, subpartitions, ...
SQWareProduction for Oracle: enhance, add more detail when select FS list
SQWareProduction for Oracle: enhance, add more FS in indicators
SQWareProduction for Oracle: enhance, add user access to databases collect
SQWareProduction for PostgreSQL: enhance, add user access to databases collect
SQWareProduction for PostgreSQL: enhance, take into account PG 14
SQWareProduction for Sybase: enhance, add more FS in indicators
SQWareProduction for Sybase: enhance, add user access to databases collect
SQWareRepository for All: enhance, add tsqw_UsersDb table
SQWareRepository for MsSql: bugfix, suppress "typeset -u" when retrieve instance arg
SQWareRepository for Oracle: enhance, add tsqwora_Tab, tsqwora_TabPart,tsqwora_TabSubPart,tsqwora_Ind,tsqwora_IndCol,tsqwora_IndPart,tsqwora_IndSubPart tables
SQWareWeb for All: bugfix, % on input for Admin
SQWareWeb for All: enhance, add Oracle Cluster
SQWareWeb for All: enhance, add userExclusion in Admin
SQWareWeb for All: enhance, add userInclusion in Admin
SQWareWeb for MongoDB: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
SQWareWeb for MsSql: enhance, add more detail in all databases report
SQWareWeb for MsSql: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
SQWareWeb for MySQL: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
SQWareWeb for Oracle: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
SQWareWeb for PostgreSQL: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
SQWareWeb for Sybase: enhance, add more detail in all databases report
SQWareWeb for Sybase: enhance, add report 'user access to databases' and 'user access to databases filtered' + API (only for admin)
SQWareCentral for All: bugfix, add check source profile to avoid error when non-interactive shell not source profile ! (cygwin for example)
SQWareCentral for All: bugfix, modify gfsqw_ComputeDuration to take into account negative duration
SQWareProduction for All: enhance, Add ability to mute sending mail with $HOME/sqwConfig/Mute.cfg
SQWareProduction for All: enhance, Search 100% compatibility with ksh, bash and cygwin in sqwgen_Global.lib
SQWareProduction for Cassandra: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
SQWareProduction for Generic: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
SQWareProduction for Ingres: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
SQWareProduction for MsSql: bugfix, modify rebuild and update stat script to support tables with simple quote or space in their name
SQWareProduction for MsSql: enhance, modify gvsqw_RebuildType to 'index' by default for rebuild
SQWareProduction for MsSql: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
SQWareProduction for MsSql: functionality, add "tools" AlterDatabaseModifyLogGrowth to modify logs growth in Mb instead of %
SQWareProduction for MsSql: functionality, add "tools" AlterDatabaseRecoverySimple to alter databases to "RECOVERY SIMPLE"
SQWareProduction for MsSql: functionality, add "tools" AlterDatabaseShrinkLogs to shrink all logs
SQWareProduction for MySQL: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
SQWareProduction for Oracle: enhance, add set env example files for RAC/ASM or standalone oratab
SQWareProduction for Oracle: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
SQWareProduction for PostgreSQL: enhance, add postgresql.conf files for 9.4, 9.5, 9.6, 10, 11, 12, 13
SQWareProduction for PostgreSQL: enhance, modify "GenCreateInstance" to create directories and generate postgres.conf ...
SQWareProduction for PostgreSQL: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
SQWareProduction for Sybase: enhance, Search 100% compatibility with ksh, bash and cygwin in all scripts/libs
SQWareRepository for All: bugfix, extend duration column in tsqw_VolBackups, tsqw_JobsFollow and tsqw_VolTapeBackups
SQWareRepository for MsSql: enhance, add support for database_name with spaces ! (replace spaces by underscores in filenames)
SQWareWeb for All: bugfix, case of one curve on multi-curves
SQWareWeb for All: bugfix, special case of one curve (multi-curves)
SQWareWeb for All: enhance, add bar chart
SQWareWeb for MsSql: bugfix, modify syntax for rebuild COLUMNSTORE indexes (suppress sort_in_tempdb option)
SQWareProduction for DB2: bugfix, modify delete backups
SQWareProduction for MsSql: enhance, add "BackupLog" in default generated sqwmsq_Jobs.cfg
SQWareWeb for All: bugfix, case of one curve on multi-curves
SQWareWeb for All: enhance, add choice between name and id of application in Admin_Links
SQWareWeb for All: enhance, add the updating of user's rights
SQWareWeb for All: enhance, add updating cache
SQWareWeb for All: enhance, add updating rights in MenuManagement
SQWareWeb for All: enhance, block entry of spaces in Admin
SQWareWeb for All: enhance, button customization in Admin
SQWareWeb for Cassandra: bugfix, modify bad link for InventoryNodes
SQWareCentral for Adabas: enhance, add containers usage in the morning check
SQWareCentral for All: enhance, add Async and Awr file volumetry follow
SQWareProduction for All: enhance, add follow of repo changes (patch, upgrade, add) in tsqw_FollowRepoChanges
SQWareProduction for MsSql: enhance, add collect of MsSql jobs from msdb
SQWareProduction for MsSql: enhance, add collect of MsSql jobs stats exec per day and month
SQWareProduction for Oracle: enhance, RAC mode for Awr monitor and generation
SQWareProduction for Oracle: enhance, test if not connected to CDB in indicators script
SQWareRepository for All: enhance, add table tsqw_SqlFollow
SQWareRepository for All: enhance, add tsqw_AwrFollow and tsqw_AsyncFollow tables
SQWareRepository for All: enhance, add tsqw_FollowRepoChanges table
SQWareRepository for MsSql: enhance, add tsqwmsq_JobHistoryStats and tsqwmsq_JobHistoryStatsMonth tables
SQWareRepository for MsSql: enhance, add tsqwmsq_Jobs, tsqwmsq_JobSteps and tsqwmsq_JobHistory tables
SQWareRepository for Oracle: enhance, add instance_number in tsqwora_Awr% tables and views
SQWareWeb for Adabas: enhance, add warning on containers usage
SQWareWeb for All: bugfix, Admin Fields size
SQWareWeb for All: bugfix, Right groups management
SQWareWeb for All: enhance, add Sql insert report for unit
SQWareWeb for All: enhance, add SqlErr report for all DBMS
SQWareWeb for All: enhance, add SqlErr report for unit
SQWareWeb for All: enhance, add the follow of Repo changes (status OFF and delete repo)
SQWareWeb for All: enhance, Authentication Type
SQWareWeb for All: enhance, Traduction
SQWareWeb for MsSql: enhance, add reports on MsSql jobs setting and execution
SQWareWeb for MsSql: enhance, add reports on MsSql jobs stats exec per day and month
SQWareWeb for Oracle: enhance, RAC mode for Awr reports
SQWareCentral for All: enhance, add UpdateApiList script
SQWareProduction for MsSql: enhance, use 'wmic volume get name' instead of xp_fixeddrives to get mount point
SQWareProduction for Oracle: enhance, add BlockChangeTracking collect
SQWareProduction for Oracle: enhance, add EncryptedTablespaces collect
SQWareRepository for Oracle: enhance, add tsqwora_BlockChangeTracking table
SQWareRepository for Oracle: enhance, add tsqwora_EncryptedTablespaces table
SQWareWeb for All: bugfix, modify query for adminCheckBackupDefaultNbDays
SQWareWeb for All: bugfix, modify query for adminCheckBackupSpecificNbDays
SQWareWeb for All: enhance, add API list report (in management view, admin only)
SQWareWeb for All: enhance, add Daybook for Management (admin only)
SQWareWeb for Oracle: enhance, add BlockChangeTracking reports (all + unit)
SQWareWeb for Oracle: enhance, add EncryptedTablespaces reports (all + unit)
SQWareCentral for MsSql: enhance, add var to manage timeout+textsize in freetds.conf generation
SQWareProduction for All: enhance, modify eval global var to keep " in content
SQWareProduction for MongoDB: bugfix, one ajustement in indicators script
SQWareProduction for MsSql: enhance, add TestInstConnection script to test instance connection
SQWareProduction for MySQL: enhance, add TestInstConnection script to test instance connection (local+dist)
SQWareProduction for Oracle: bugfix, modify RMAN backup for Standby
SQWareProduction for Oracle: enhance, add TestInstConnection script to test instance connection (local+dist)
SQWareProduction for Oracle: enhance, 'show all' connected with catalog when available
SQWareProduction for PostgreSQL: enhance, add TestInstConnection script to test instance connection (local+dist)
SQWareRepository for All: enhance, add GeneralInfos and Daybook tables
SQWareRepository for All: enhance, add table AdminLoginsTypes to manage type of user
SQWareRepository for Oracle: enhance, add table tsqwora_RepositoryClusters to manage ASM clusters
SQWareWeb for All: enhance, add ins_date in Admin
SQWareWeb for All: enhance, add help for Table and Chart
SQWareWeb for All: enhance, add GeneralInfos for Management (admin only)
SQWareWeb for All: enhance, add management in menu2 (all and unit)
SQWareWeb for All: enhance, add online help for tables and charts
SQWareWeb for MsSql: bugfix, modify LackBackupsDb.table and LackBackupsDbJustified.table
SQWareWeb for Oracle: enhance, add InventoryPdb in all/various
SQWareWeb for Oracle: enhance, add reports on ASM DG (unit and all)
SQWareWeb for Oracle: enhance, move *DbaFeature* *DbaRegistry* *DbLinks* *MaxLog* *DgStatus* *RegistryHistory* from all/overview to all/various
SQWareCentral for All: enhance, add trace of dbSQWare version on DBMS level
SQWareCentral for All: enhance, some adjusts in HTML format mails
SQWareProduction for All: enhance, add trace of dbSQWare version on DBMS level
SQWareProduction for Oracle: bugfix, modify connect string in RMAN Clone (wallet)
SQWareProduction for Oracle: bugfix, modify some indicators for Oracle 8i ...
SQWareRepository for All: bugfix, modify url masking for avoid "Illegal mix of collations for operation 'concat'"
SQWareWeb for All: enhance, add API REST engine (more than 1400 reports available)
SQWareWeb for All: enhance, change css checkbox (right access)
SQWareWeb for All: enhance, add custom2 and custom3 in menu2 (all and unit)
SQWareWeb for Oracle: enhance, add reports in unit/growth OraInstanceInfos, OraDatabaseInfos (like all)
SQWareWeb for Oracle: enhance, add reports in unit/tablespaces TablespacesInfo, DatafilesInfo (like all)
SQWareWeb for Oracle: enhance, add reports in unit/various ArchivelogsNb, ArchivelogsNbDetail, ArchivelogsNbHourly, ArchivelogsNbHourlyDetail (in Nb)
dbSQWare, ce n’est pas seulement un logiciel, c’est aussi la société qui l’édite, fondée par des experts DBA, passionnés par leur métier.
