Running Must-Gather scripts

You can run the Must-Gather script for IBM Storage Protect for Databases- Data Protection for SQL to collect diagnostic information required by IBM Support.

For more information about the script location, installation, and prerequisites, see Collecting diagnostic data using Must-Gather scripts.

Supported operating systems

  • Windows

How to run the Must-Gather script

  1. Open a terminal at the Must-Gather script directory.
  2. Run the following command. For example:
    perl mustgather.pl --product sp-client-sql --output-dir <target_path> --caseno <case_number> --adminid <id> [options]

Data Protection for SQL modules

Table 1. SQL modules
Module Description
config Collects IBM Storage Protect configuration files (dsm.opt, dsm.sys, dsminfo.txt).
logs Gathers client logs such as dsmj.log, dsminstr.log, dsmwebcl.log, dsmerror.log, and dsmsched.log.
performance Captures performance metrics and instrumentation logs (dsminstr.log).
sql Collects Data Protection for SQL configuration, logs, version details, registry data, and TDPSQL query outputs.

Output summary

At the end of execution, the script automatically creates a zip file:

mustgather_<case_number>_<product_name>_<timestamp>.zip

=== Must-Gather Collection Summary === 
Product              : sp-client-sql
Version              : Version 8, Release 2, Level 1.0 
Node Name            : TEST 
Server Name          : server1 
  
  Modules           : Status
-----------------------------
 1. config          : Success
 2. logs            : Success
 3. performance     : Success 
 4. network         : Success
 5. server          : Success
 6. sql             : Success
 7. system          : Success

Check script.log inside each module folder for detailed failures. 
Output : <output-dir>/mustgather_TS123456789_sp-client-sql_20260212_034652.zip
This file can be sent to IBM Support team for analysis.
The .zip file contains the diagnostic data for each module.