Released: Nov 26, 2024

November 2024 での更新項目

機能

• New Features:
  • DBW – Bulk setting of SQL Worksheet authentications.
  • DBW – SQL Worksheet query timeout parameter.
  • DBW – AD integration now handles LDAP Signing.
  • DBW – CCC can now connect to non DC node.
  • DBW – FDL hash function.
  • DBW – FDL substring function.
  • DBW – FDL indexof function.
  • DBW – FDL length function.
  • PostgreSQL – Engine installation can now create dbWatch database.
• Improvements:
  • DBW – Web remote server access.
  • DBW – Heavy load stability improvements.
  • DBW – Job templates, use latest task version when resolving parameters.
  • DBW – Improved error reporting when file privileges prevent config save.
  • DBW – Node privilege changes now triggers certificate renewal.
  • DBW – CCC now handles absolute paths to scripts.
  • DBW – Can now uninstall no-engine jobs that are no longer compatible from Manage Jobs view.
  • DBW – AD integration now handles multiple AD servers.
  • DBW – Improved performance of FDL compare function.
  • DBW – Now cleans old system event messages.
  • MS SQL Server – job "DBCC CHECKDB", improved exception handling when main procedure terminates abnormally.
    • Added two new parameters "return status when terminated abnormally". This parameter defines the return status (ALARM – 2, WARNING – 1, or OK – 0) when the dbWatch main procedure terminates unexpectedly. An abnormal termination refers to errors with a severity level of 20 or higher, which can cause the entire procedure to terminate without entering the CATCH block. In such cases, the dbWatch job will only return information that it was terminated uncontrollably, without any details about the DBCC execution. Upon the next successful execution of the procedure, it will provide feedback on which database caused the issue.
    • The parameter "keep WARNING/ALARM status" controls the duration (in hours) for which the job will retain a WARNING or ALARM status following the occurrence of such an event.
  • MS SQL Server – job "Reorganize indexes", improved exception handling when main procedure terminates abnormally.
  • MS SQL Server – job "Rebuild indexes", improved exception handling when main procedure terminates abnormally.
  • MS SQL Server – job "MS SQL Server patch status", added patch information from Microsoft Update Catalog up to November 14, 2024.
  • MS SQL Server – Improved Farm views for Maintenance jobs.
  • MS SQL Server – job "AlwaysOn transaction log backup alert", the job provides improved feedback on last transaction log backups information when not all nodes in the AlwaysOn cluster are accessible.
  • MS SQL Server – job "AlwaysOn database backup alert", the job provides improved feedback on last full backups information when not all nodes in the AlwaysOn cluster are accessible.
  • Oracle – job "RMAN archivelog backup status", new parameter "return status when ARCHIVER STOPPED".

不具合の修正

• DBW – CCC service command more robust.
• DBW – New/moved instance refresh bug when using Cloud Router.
• DBW – Monitor status circle refresh bug.
• DBW – SQL Worksheet multi server query handling.
• DBW – SQL Worksheet multi statement result handling.
• MS SQL Server – job "Suspect pages", compilation error on 2005 platform.
• Oracle – job "RMAN backup status", block_change_tracking column, varchar to small.
• PostgreSQL – problems installing jobs "Vacuum tables", "Vacuum alert" and "Analyze tables" with dbWatch-no-engine monitoring.