RELEASE NOTES

Versions Majeures 2026

SQWareManager for All: bugfix, revert to 'en' by default
SQWareWeb for All: bugfix, activate ldap_ad provider when profile exists
SQWareWeb for All: bugfix, revert to 'en' by default
SQWareWeb for All: bugfix, some reports with binds
SQWareWeb for All: enhance, add binds management
SQWareWeb for All: enhance, cleanup in dashbord reports
SQWareManager for Admin: improvement, improved object right manager interface
SQWareManager for Admin: bugfix, Rebuild backup instance exclusion unique key
SQWareManager for Admin: enhance, Reconstruction of the audit part
SQWareManager for Admin: enhance, Reconstruction of the explorer part
SQWareManager for Admin: enhance, Reconstruction of the SQWareWeb part
SQWareManager for Admin: functionality, Added the ability to log in as someone else
SQWareManager for Admin: functionality, Added the ability to manage the access of login accounts to the plateform

SQWareCentral for All: enhance, add gvsqw_AutomaticUpdateStatusFail to update status when checks fail
SQWareCentral for All: enhance, add gvsqw_AutomaticUpdateStatusSuccess to update status when GenDefConf_SQWareProduction success
SQWareCentral for All: enhance, add 'Normalizer' script to transform NFD (Normalization Form Decomposed) in NFC (Normalization Form Composed)
SQWareCentral for All: enhance, modify ExecAsynchronousFiles to exec 'Normalizer' when NFD detected (in gather structures for example)
SQWareCentral for All: enhance, modify ExecAsynchronousFiles to insert in utf8mb4 (peparing migration)
SQWareProduction for DB2: bugfix, modify reorg index script "REORG INDEXES ALL FOR TABLE xxx"
SQWareProduction for MsSql: enhance, add flag -AddFlagName for BackupDatabase and BackupAllDatabases scripts
SQWareProduction for MsSql: enhance, add flag -AddFlagName for RestoreDatabase and RestoreAllDatabases scripts
SQWareProduction for Oracle: bugfix, lack column TABLE_NAME when gather indexes structures !
SQWareProduction for Oracle: bugfix, major version 260 when 23.26.xxx ...
SQWareProduction for Oracle: enhance, add ExecUtlrp in tools
SQWareProduction for Oracle: enhance, add GatherIndicatorsRMAN script
SQWareProduction for PostgreSQL: bugfix, replace the "REPLACEMENT CHARACTER", UTF-8 = U+FFFD, by to o avoid errors like "Incorrect string value: '\xEF\xBF\xBDre ...' in indicators script
SQWareProduction for PostgreSQL: bugfix, replace the "REPLACEMENT CHARACTER", UTF-8 = U+FFFD, by to o avoid errors like "Incorrect string value: '\xEF\xBF\xBDre ...' in structure script
SQWareWeb for All: enhance, add binds management
SQWareWeb for All: enhance, add binds management and table secure
SQWareWeb for Oracle: bugfix, add unit of size in DatafilesInfo report
SQWareWeb for Oracle: enhance, add Archivelogs report for all instances on 7 days
SQWareWeb for Oracle: enhance, add instance edition in BlockChangeTracking report
SQWareWeb for Oracle: enhance, modify LastReportAsmDG to take into account standalone ASM (not only cluster)
SQWareManager for Admin: enhance, Rebuild Explorer SQL queries management
SQWareManager for Admin: enhance, Reconstruction of the authentification and access part
SQWareManager for Admin: enhance, Reconstruction of the user part
SQWareManager for Admin: enhance, Simplification of type management directly in groups
SQWareManager for Admin: functionality, Added types of table columns management
SQWareManager for Admin: functionality, Implementation of the recycle bin for users, connection strings and SQL queries

SQWareCentral for All: enhance, modify 'egrep' by 'grep -E' when supported
SQWareCentral for Informix: enhance, add check backups (ontape + onbar)
SQWareCentral for Informix: enhance, add onbar backup script
SQWareCentral for Informix: enhance, add ontape backup script
SQWareProduction for All: enhance, modify 'egrep' by 'grep -E' when supported
SQWareProduction for Informix: enhance, add check backups (ontape + onbar)
SQWareProduction for Informix: enhance, add onbar backup script
SQWareProduction for Informix: enhance, add ontape backup script
SQWareProduction for MongoDB: enhance, take into account .mongoshrc for mongodump
SQWareProduction for MySQL: bugfix, when call GenerateCreateInstance for recent MariaDB (write mariadb instead of mysql ...)
SQWareProduction for PostgreSQL: bugfix, when call -CustFunc option in DumpAllDatabases
SQWareProduction for Redis: functionnality, first support + indicators
SQWareRepository for Informix: enhance, add entries for ontape + onbar check (level 0 + level %)
SQWareRepository for Redis: functionnality, first support
SQWareWeb for All: enhance, add logos for Couchbase, MariaDB and Redis
SQWareWeb for All: enhance, modify global db connection to utf8mb4
SQWareWeb for All: enhance, set mysqli charset
SQWareWeb for Informix: enhance, add report to follow onbar+ontape backups
SQWareWeb for Redis: functionnality, first support

SQWareCentral for All: enhance, add app:kill when patch for kill web sessions
SQWareCentral for All: enhance, running long-running commands (such as indicators) using nohup to avoid network interruptions
SQWareCentral for MongoDB: enhance, add check backup for standby
SQWareCentral for Oracle: bugfix, modify RMAN query for indicators
SQWareCentral for Oracle: enhance, add the ability to exclude 'Data Guard lag' when check indicators
SQWareProduction for MongoDB: enhance, add gvsqw_MinSizeMbCollectionCompact to filter collections to compact
SQWareProduction for MongoDB: enhance, add gvsqw_MinSizeMbCollectionIndic to filter collections for indicators
SQWareProduction for MongoDB: enhance, add unit+all IsWritable reports
SQWareProduction for MsSql: bugfix, exclude indexes from rebuild when allow_page_locks is disable
SQWareRepository for All: enhance, add column bck_slaveonly on tsqw_VolBackupsThreshold
SQWareRepository for All: enhance, add column bck_slaveonly on tsqw_VolBackupsThresholdDef
SQWareRepository for All: enhance, add table tsqw_CheckExclude
SQWareManager for All: bugfix, Apply admin rights on repository and connection strings
SQWareManager for All: enhance, Added the ability to log in with proxy server for Okta and Keycloak

SQWareCentral for All: bugfix, false positive when db/sch named like ERROR%
SQWareCentral for All: bugfix, replace /var/tmp by $HOME/SqwOnDemandJob for OnDemandJob scripts
SQWareCentral for All: enhance, add alias web_reset to reload caches
SQWareProduction for All: enhance, update maj_version on tsqw_Repository and tadm_ExpCstrs when gather indicators (for SQWareManager)
SQWareProduction for MongoDB: enhance, adjust to take into acount ~/.mongorc.js or ~/.mongoshrc.js instead of connection function
SQWareProduction for MsSql: bugfix, when gather structure on vers>=2017 but compatibility_level<140
SQWareProduction for Oracle: bugfix, reserved keyword 'parallel' from MySQL 8.4 in query
SQWareRepository for All: enhance, add column maj_version on tsqw_Repository table (for SQWareManager)
SQWareRepository for Oracle: bugfix, reserved keyword 'parallel' from MySQL 8.4 in views
SQWareWeb for All: enhance, change of the module's general title
SQWareWeb for All: enhance, decaching
SQWareWeb for All: enhance, modification of license wording
SQWareWeb for Oracle: bugfix, reserved keyword 'parallel' from MySQL 8.4 in reports

SQWareCentral for All: enhance, add columns client and env for exclusion when check backups
SQWareCentral for All: enhance, detect if mysql or mariadb binary to call
SQWareCentral for All: enhance, taking into account blackout periods when check indicators ("lack indicators" only)
SQWareProduction for All: bugfix, sys info for AIX (RAM, swap, CPU)
SQWareProduction for MsSql: enhance, modify GatherStructure indexes for perf
SQWareProduction for MySQL: enhance, add -ZIP option for DumpAllDatabases script
SQWareProduction for MySQL: enhance, add zstd compressor for DumpAllDatabases, DumpDatabase script
SQWareProduction for MySQL: enhance, detect if mysql or mariadb binary to call
SQWareProduction for MySQL: enhance, detect if RDS, AZURE or GCP managed hosting
SQWareProduction for Oracle: bugfix, add gvsqw_ExpdpImpdpUser for workaround bug that prompt for password when interactive session. Ex BUG 29926041 patch 28707931 on 19.3
SQWareProduction for Oracle: enhance, add -CustFunc flag to put custom function name to exec after successful expdp (Expdp+ExpdpAllSchemas+ExpdpAllPDB)
SQWareProduction for PostgreSQL: enhance, add -CustFunc option on DumpAllDatabases, DumpDatabase and DumpGlobalsOnly script to exec function after successful dump
SQWareProduction for PostgreSQL: enhance, add zstd compressor for DumpAllDatabases, DumpDatabase and DumpGlobalsOnly script
SQWareProduction for Sybase: enhance, manage lock file to avoid 2 dump on same db in the same time
SQWareRepository for All: enhance, add columns client and env in tsqw_VolBackupsExclude
SQWareRepository for All: enhance, add tsqw_BlackoutPeriods table
SQWareWeb for All: bugfix, modify url path of Edit Profile
SQWareWeb for All: bugfix, when display "dashboard" report
SQWareWeb for All: enhance, add cache update on headband top
SQWareWeb for All: enhance, add columns client and env for exclusion in check backups reports
SQWareWeb for All: enhance, add home on headband top
SQWareWeb for All: enhance, no access to profile user for anonymous
SQWareWeb for All: enhance, replacing the action icons with those of SQWareAdmin
SQWareWeb for All: enhance, taking into account blackout periods when generating lists
SQWareManager for Admin: add cache update logo
SQWareManager for Admin: functionality, added Connection Strings management for Explorer
SQWareManager for Admin: functionality, added Shared Queries management for Explorer
SQWareManager for Admin: update home logo
SQWareManager for Admin: update providers logos
SQWareManager for All: enhance, Improve anonymous account management

SQWareProduction for Oracle: enhance, modify GatherStructure indexes for perf
SQWareProduction for PostgreSQL: bugfix, for PITR when /var/tmp mounted in noexec mode
SQWareProduction for PostgreSQL: enhance, add value 'never' to gvsqw_PitrAutoStartSqwArchmon for block exec of BackupArchiveXlog, BackupPitr + no start of sqwArchmon
SQWareRepository for All: bugfix, force "CHARACTER SET latin1" when load files
SQWareRepository for All: bugfix, some adjusts when rep is in MySQL (more restrictive than MariaDB)
SQWareRepository for All: bugfix, when install from scratch
SQWareWeb for All: bugfix, access to Admin and Explorer
SQWareWeb for All: bugfix, display JobOnDemandLog or JobOnDemandMail when not admin
SQWareWeb for All: bugfix, increase size to display logs/mails/diff
SQWareWeb for All: enhance, change css in menu 3
SQWareWeb for All: enhance, change css in profile
SQWareWeb for All: enhance, Explorer option in top banner
SQWareWeb for All: enhance, include new name of table of Preferences
SQWareWeb for All: enhance, removal of the pdf button in tables
SQWareManager for All: bugfix, force "CHARACTER SET latin1" when load files
SQWareManager for MyProfile: enhance, Reorganize my profile menu

SQWareCentral for All: enhance, add check nb_users in license
SQWareCentral for All: enhance, add -CustFilter option for ReportSupport
SQWareCentral for All: enhance, add -CustFilter option for ReportSupportOs
SQWareCentral for All: enhance, add insert TrackFiles
SQWareCentral for All: enhance, add sqwaremanager in sqwareweb.ini if not exists
SQWareCentral for All: enhance, add TrackFiles functionnality for global config
SQWareCentral for All: enhance, modify generate URL masking for API
SQWareCentral for Informix: functionnality, add support of Informix (IDS)
SQWareProduction for All: bugfix, modify logfilename for database with ( or ) in name
SQWareProduction for All: enhance, add TrackFiles functionnality
SQWareProduction for Informix: functionnality, add support of Informix (IDS)
SQWareProduction for MsSql: bugfix, modify Backup for database with ( or ) in name
SQWareProduction for MsSql: bugfix, take into account Developer Edition for backup compression
SQWareProduction for Oracle: enhance, add collect of DBA_REGISTRY_SQLPATCH
SQWareProduction for PostgreSQL: enhance, drop index command if exist index_name like '%ccnew%' or index_name like '%ccold%' also before reindex
SQWareProduction for Sybase: bugfix, take into account when sp_spaceused is in MB (ASE 16.1)
SQWareRepository for All: enhance, add tsqw_TrackFilesCurrent + tsqw_TrackFiles tables
SQWareRepository for All: enhance, drop column authentication_type in tsqw_AdminLogins (replaced by profiles)
SQWareRepository for All: enhance, drop table tsqw_AdminLoginsTypes
SQWareRepository for All: enhance, modify profile_id in tsqw_AdminLogins for API
SQWareRepository for All: enhance, suppress all links for admin menu (replaced by SQWareManager admin)
SQWareRepository for All: enhance, update end of support dates
SQWareRepository for Informix: functionnality, add support of Informix (IDS)
SQWareRepository for Oracle: enhance, add tsqwora_RegistrySqlpatch table
SQWareWeb for All: enhance, add Tracks files reports (current+diff)
SQWareWeb for All: enhance, add user profile in headband top
SQWareWeb for All: enhance, change column is_foradmin in is_forexplorer in admin table
SQWareWeb for All: enhance, change column is_forweb in is_forexplorer in admin table
SQWareWeb for All: enhance, change css in menu 3
SQWareWeb for All: enhance, change css in profile
SQWareWeb for All: enhance, change licence of user profile
SQWareWeb for All: enhance, change locale management
SQWareWeb for All: enhance, change management of length page in tables
SQWareWeb for All: enhance, change name of locale
SQWareWeb for All: enhance, change param of icone in jobs schedule
SQWareWeb for All: enhance, connection of SQWareWeb in SQWareManager
SQWareWeb for All: enhance, error handling in the new authentication management
SQWareWeb for All: enhance, Explorer option in top banner
SQWareWeb for All: enhance, include new name of table of Preferences
SQWareWeb for All: enhance, modify check authentication_type for API
SQWareWeb for All: enhance, removal of the pdf button in tables
SQWareWeb for All: enhance, reorganization of the templates flow so that there is no scroll
SQWareWeb for All: enhance, securing access to log files
SQWareWeb for All: enhance, suppress all links for admin menu (replaced by SQWareManager admin)
SQWareWeb for All: enhance, unify design and functionalities of Admin of SQWareManager and SQWareWeb
SQWareWeb for All: enhance, unify design for license between Admin of SQWareManager and SQWareWeb
SQWareWeb for All: enhance, reorganization of the templates flow so that there is no scroll
SQWareWeb for Informix: functionnality, add support of Informix (IDS)
SQWareWeb for MySQL: bugfix, removal of the parasitic character in LackBackupsDbJustified
SQWareWeb for Oracle: enhance, add report to view DBA_REGISTRY_SQLPATCH
SQWareManager for Admin: functionnality, creation of module
SQWareManager for All: enhance, Added auth user provider check when login
SQWareManager for All: enhance, Added charts in Admin dashboard
SQWareManager for All: enhance, Separation from the management of my profile
SQWareManager for All: functionality, Added choice portal for Admin, Explorer and SQWareWeb modules
SQWareManager for All: functionality, Added LDAP authentication with service account
SQWareManager for All: functionality, Added license verification middleware
SQWareManager for All: functionality, Added SQWareWeb consent management
SQWareManager for All: functionality, Added user password management
SQWareManager for All: functionality, Interconnection of the modules SQWareManager and SQWareWeb
SQWareManager for MyProfile: enhance, Reorganize my profile menu
SQWareManager for MyProfile: functionality, Added user preferences management from my profile

Versions Majeures 2025

SQWareCentral for All: enhance, add clean old versions of SQWareManager_Web and sqwConnectord when patch
SQWareProduction for MariaDB: bugfix, add gvsqw_ExcludeDatabaseFromIndicators To avoid errors like : ERROR 1146 (42S02) at line 24: Received error: 1146 : Remote table does not exist
SQWareProduction for Oracle: bugfix, Refresh schema expdp from PDB to PDB ...
SQWareWeb for All: bugfix, modifying the display of a column name in RepositoryNoSQL
SQWareWeb for All: enhance, change column name in admin table
SQWareWeb for All: enhance, delete column is_forweb in admin table

SQWareCentral for All: enhance, add SQWareManager users in check license
SQWareProduction for All: bugfix, add global var for grep "-a" "-av" "-ac" to suppress "-a" when not supported by the OS (global lib)
SQWareProduction for All: bugfix, suppress 'openssl: not found' when openssl not installed
SQWareProduction for MySQL: bugfix, modify grep "-a" "-av" "-ac" to suppress "-a" when not supported by the OS (restore script)
SQWareProduction for Oracle: bugfix, modify grep "-a" "-av" "-ac" to suppress "-a" when not supported by the OS (expdp/impdp scripts)
SQWareProduction for Oracle: enhance, add collect of tz_version
SQWareProduction for PostgreSQL: bugfix, when retrieve backup size when repo not disk
SQWareProduction for PostgreSQL: enhance, add -StanzaName and -RepoName options on sqwpg_PgBackrest.ksh script
SQWareReport for Oracle: enhance, add tz_version in tsqwora_GenInfos
SQWareRepository for All: enhance, add anonymous in tsqw_AdminLogins to prepare anonymous access
SQWareRepository for All: enhance, update EOL dates for DBMS
SQWareRepository for MariaDB: enhance, ignore parameter change on gtid_slave_pos
SQWareWeb for All: enhance, add report TopTables volumetry for the DBMS
SQWareWeb for All: enhance, add SupportAllInOne (DBMS+OS) report
SQWareWeb for Oracle: enhance, add tz_version in all/unit GeneralInfos report

SQWareCentral for All: enhance, add aliases "repcheck_xx" like repind_xx" (lacks + warning)
SQWareCentral for All: enhance, add alias "repcheck" to retry indicators lacks + warning on all DBMS of all status
SQWareCentral for All: enhance, add alias "repind" to retry indicators on all DBMS of all status
SQWareCentral for All: enhance, add centralisation of RawFiles
SQWareCentral for All: enhance, add insert dbalias with warning in tsqw_RepositoryLastestWarning
SQWareCentral for All: enhance, add -Repcheck option on sqwctl_GatherIndicators.ksh script
SQWareCentral for All: enhance, create "Repcheck" like "Repind" generate list scripts
SQWareProduction for MongoDB: bugfix, users informations collect
SQWareProduction for Oracle: enhance, add -PAR option on sqwora_Impdp.ksh script
SQWareProduction for PostgreSQL: enhance, add pgbackrest scripts (Local/Central - Unit/All)
SQWareProduction for PostgreSQL: enhance, add support of AZURE PostgreSQL env
SQWareRepository for All: enhance, add table tsqw_RawFiles
SQWareRepository for All: enhance, add table tsqw_RepositoryLastestWarning
SQWareRepository for All: enhance, update tsqw_VolBackupsThresholdDef with XtraBackupFull and XtraBackupInc
SQWareRepository for MySQL: enhance, split MySQL/MariaDB in vadm_AdminAllLoginsAccess view + add maj_version and ProductEdition
SQWareWeb for All: bugfix, correction of loss of column names in show/hide columns
SQWareWeb for All: bugfix, force values for NbMonth and NbDays when missing
SQWareWeb for All: enhance, add report RawFiles in unit/storage

SQWareCentral for MySQL: enhance, add purge of tsqwmys_RepliSlave and tsqwmys_RepliMaster
SQWareCentral for PostgreSQL: enhance, add purge of tsqwmys_RepliSlave and tsqwmys_RepliMaster
SQWareCentral for All: enhance, add call of ManageAllDaemons 'restart' script when patch
SQWareCentral for All: enhance, add run of ManageAllDaemons 'startifnot' script all 5 minutes in CrontabRef
SQWareCentral for All: enhance, create ManageAllDemons script
SQWareCentral for All: enhance, create ManageSqwWebqueue script
SQWareCentral for All: enhance, rename all central deamons in sqwDemond (and manage corresponding script + aliases) ...
SQWareProduction for MySQL: enhance, add collect of repli status in tsqwmys_RepliSlave and tsqwmys_RepliMaster
SQWareProduction for MySQL: enhance, add -MinDataFree option for OptimizeDatabase and OptimizeAllDatabases to overwrite $gvsqw_OptimizeMinDataFree
SQWareProduction for MySQL: enhance, add -MinFragRatio option for OptimizeDatabase and OptimizeAllDatabases to overwrite $gvsqw_OptimizeMinFragRatio
SQWareProduction for Oracle: bugfix, modify connection function when Pdb for expdp and impdp scripts
SQWareProduction for Oracle: bugfix, modify imp parfile when // (introduce in v2025.07)
SQWareProduction for Oracle: enhance, add drop jobs and LOGON/LOGOFF triggers when schema refresh
SQWareProduction for Oracle: enhance, replace call of gfsqw_ValidatePdbConnection by gfsqw_ValidatePdbDirectConnection in all scripts
SQWareProduction for PostgreSQL: enhance, add collect of repli status in tsqwmys_RepliSlave and tsqwmys_RepliMaster
SQWareRepository for MySQL: enhance, add table tsqwmys_RepliSlave and tsqwmys_RepliMaster
SQWareRepository for PostgreSQL: enhance, add table tsqwmys_RepliSlave and tsqwmys_RepliMaster
SQWareWeb for MsSql: enhance, add RepliSlave and RepliMaster all reports (various new section menu2)
SQWareWeb for MsSql: enhance, add RepliSlave and RepliMaster unit reports (various new section menu2)
SQWareWeb for MySQL: enhance, add RepliSlave and RepliMaster all reports (various new section menu2)
SQWareWeb for MySQL: enhance, add RepliSlave and RepliMaster unit reports (various new section menu2)
SQWareWeb for PostgreSQL: enhance, add RepliSlave and RepliMaster all reports (various new section menu2)
SQWareWeb for PostgreSQL: enhance, add RepliSlave and RepliMaster unit reports (various new section menu2)

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
SQWareWeb for All: bugfix, modify check backup report (change column name)

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"

RELEASE NOTES

Versions Majeures 2026

Versions Majeures 2025

Versions Majeures 2024

Liens utiles

Démo SQWareWeb

Wiki

Wiki Fr

Blog

En savoir +

Une équipe qualifiée

Un club utilisateurs actif

Un réseau de partenaires

Des clients satisfaits

Contact