Diagnostics
Use the Diagnostics property page to select the type of tracing to run on various components of Data Protection for Microsoft SQL Server.
When you encounter a problem, open the Diagnostics property page. Select the diagnostic mode that you want to use by clicking Normal, Complete, or Custom. Then, click Begin to start the trace. Close the property page. Re-create the problem, open the Diagnostics property page, and click End to stop the tracing and collect the data.
If you are using this property page from the Dashboard property sheet, you can run trace only for Microsoft Management Console (MMC).
Diagnostic modes
The following diagnostic
mode is available in the Diagnostics property
page from the Dashboard property sheet:
- MMC - use this mode to set tracing for only MMC.
The following diagnostic modes are available in the Diagnostics property page in the workload property sheets. The type of tracing that is enabled for each mode is listed in the table. Specific trace flags, and guidance on when to use each mode is also listed.
| Mode | Components traced along with trace flags used | When to use |
|---|---|---|
| Normal | MMC, DP (service), API (service,api_detail) | If using legacy operations, you can use this mode as it results in small output size |
| Complete | MMC, DP (service), API (service,api_detail), Agent (service) | Use for VSS operations, results in large output size |
| Custom | Any combination | Use if specific flags are needed |
- Normal
- Click Normal to collect trace and log files for legacy operations.
- Complete
- Click Complete to collect trace and log files for VSS operations.
- Custom
- Click Custom, then click the check mark
icon to select the trace and log files that you want to collect. Use
this mode only if specific trace flags are required.
- Enable snapin tracing
- Select this box to enable tracing of the Management Console. Click Review to view the trace file.
- Set Default Trace Flags
- ClickSet Default Trace Flags to set the most commonly requested trace flags.
- Enable Data Protection tracing
- Select this box to enable tracing of Data Protection for Microsoft SQL Server operations. Click Review to view the trace file. Add or update trace flags in the field.
- Enable DSM Agent tracing
- Select this box to enable tracing for the Tivoli® Storage Manager client node. You must restart the client acceptor service before you start the trace. Click Review to view the trace file. Add or update trace flags in the field.
- Enable API tracing
- Select this box to enable tracing for the Tivoli Storage Manager API. Click Review to view the trace file. Add or update trace flags in the field.
- Event log entries
- Click Event log entries to view Windows application event log for SQL Server, Exchange Server, or File System workloads. For SQL workloads, you can also click SQL Server Log file to view the SQL Server log.
- Select diagnostic files and click Email to send a diagnostic email to an IBM service representative with the selected files attached. You must configure your email information before you can send the data to an IBM service representative. To configure your email information, go to the Dashboard and click Properties. Then, click EMail to open the email property page.
- Screenshot
- This function is enabled after you click Begin. Click Screenshot to open the Diagnostic Screenshot Tool. This tool is a modeless dialog that remains open until you close it or click End or Cancel.
- Click Add New Screenshot to add a screen capture to the FlashCopyManager\ProblemDetermination folder. The screen capture can be selected with other diagnostic data.
Tracing details for each component
All trace
files are stored in the flashcopymanager folder,
which is C:\Program Files\Tivoli\flashcopymanager by
default. When you click End, these files are
automatically copied, compressed, and stored in the C:\Program
Files\Tivoli\flashcopymanager\problemdetermination folder
along with other information.
- MMC
- Options are stored in MMC user settings file. The following files
are created as a result of the diagnostic functions:
TraceFm.trc TraceUx.trc - Data Protection
- Tracing options are stored in MMC user settings file and passed
to the Data Protection component as part of the command. The following
file is generated:
TraceFileSql.trc - Agent
- Tracing options are stored in the VSS requestor dsm.opt file.
The following file is generated:
TraceFileAgent.trc - API
- Tracing options are stored in the respective Data Protection dsm.opt file.
The following file is generated:
TraceFileSqlAPI.trc