Collecting Data for Spectrum Protect for Databases

Collecting troubleshooting data early, even before opening the Case, helps IBM® Support quickly determine if:
Symptoms match known problems (rediscovery).
There is a non-defect problem that can be identified and resolved.
There is a defect that identifies a workaround to reduce severity.
Locating root cause can speed development of a code fix.

Collecting Data: Table of contents

	Gathering general information
	Manually Gathering Data Protection for MS SQL Information
	Manually Gathering Data Protection for Oracle Information
	Submitting Information to IBM Support
	Online Self-Help Resources
	Related Information

 

Gathering General Information

Entering general information into an electronically-opened Problem Case (previously called PMRs) eliminates waiting on the phone to provide general information to support. 

 

Manually Gathering Data Protection for MS SQL Information

Gather the following general data, typically found in the installation directory. The default installation path is: C:\Program Files\Tivoli\TSM\TDPSQL

• dsm.opt
• dsmerror.log (may be in the b/a client directory depending on the scheduler configuration)
• dsierror.log (or the file specified by the ERRORLOGNAME option in the dsm.opt file)
• dsmsched.log (may be in the b/a client directory depending on the scheduler configuration)
• The version and service pack of Windows
• Spectrum Protect Client specific version (ex: 8.1.4.1)
• The version of the Data Protection SQL client
• Output of 'reg query HKLM\software\ibm\adsm\currentversion /s'
• Data Protection for SQL log. By default, this is the tdpsql.log in the Data Protection for SQL install directory. It can also be specified by the /logfile option during command line processing.
• Data Protection for SQL config file. By default this is the tdpsql.cfg in the Data Protection for SQL install directory. It can also be specified by the /configfile option during command line processing.
• The output of TDPSQLC Q TSM
• The output of TDPSQLC Q TDP
• The output of TDPSQLC Q SQL

• From the DOS/Command prompt in the BAClient directory, gather the outputs from the command:
• dsmcutil list
  then for each item in this list run a query:
  dsmcutil query /name:"Name of service from list above"
• From the Spectrum Protect server, provide the output from the administrative commands:
  • QUERY PROXYNODE
    QUERY ADMIN
• To ensure that VSS is working properly, see Knowledgebase document:
  • http://www-01.ibm.com/support/docview.wss?uid=swg21403458

Note: If using MS SQL in a clustered environment, provide all of this data for each MSCS node

 

Manually Gathering Data Protection for Oracle Information

The default installation paths for the Data Protection Oracle client are:

• Windows: C:\Program Files\Tivoli\TSM\AgentOBA or C:\Program Files\Tivoli\TSM\AgentOBA64
  Linux, Solaris, HP-UX: /opt/tivoli/tsm/client/oracle/bin or /opt/tivoli/tsm/client/oracle/bin64
  AIX: /usr/tivoli/tsm/client/oracle/bin64

If this is an Oracle RAC Cluster, it is critical to gather the data from ALL the machines in the RAC environment.

Gather the following data:

• dsm.opt file specified in the tdpo.opt file for the variable DSMI_ORC_CONFIG
• dsm.sys (only specific to UNIX operating systems)
• dsmerror.log
• dsierror.log
• tdpoerror.log
• dsmsched.log
• details of operating system levels
• details of Oracle instance levels
• The full RMAN script being used for either the backup or restore
• The tdpo.opt file referenced in the RMAN script by the TDPO_OPTFILE parameter
• The output of the command 'tdpoconf showenv'
• The output from a 'set' command
• The RMAN msglog output

AIX only:

• Output of 'lslpp -L tivoli.tsm.* '
• The output of the command 'find / -name libobk* -exec ls -l {} \; 2>/dev/null'

Solaris only:

• Output of 'pkginfo -l TDPoracle32'
• Output of 'pkginfo -l TDPoracle64'
• Output of 'pkginfo -l TIVsmCapi'
• The output of the command 'find / -name libobk* -exec ls -l {} \; 2>/dev/null'

HP-UX only:

• Output of 'swlist -v TDPOracle32'
• Output of 'swlist -v TDPOracle64'
• Output of 'swlist -v TIVsmCapi'
• The output of the command 'find / -name libobk* -exec ls -l {} \; 2>/dev/null'

Linux only:

• Output of 'rpm -qai TIV* '
• Output of 'rpm -qai TDP* '
• The output of the command 'find / -name libobk* -exec ls -l {} \; 2>/dev/null'

Windows only:

• Output of 'reg query HKLM\software\ibm\adsm\currentversion /s'
• Output of 'dir /a /s /b c:\ | findstr orasbt.dll'

 

Submitting Information to IBM Support

After a Case is open, you can submit diagnostic troubleshooting data to IBM.

When data is uploaded to the Case, the status will be automatically be updated to acknowledge that data has been received. If you are still working with older Problem Management Records, you will want to update the PMR to indicate that you have sent the data.

 

Online Self-Help Resources

• Review up-to-date product information at the IBM Spectrum Protect page.

• Sign into your account on the Spectrum Protect Product page, to access additional resources or to open a Case with the Support team.

 

Related Information

• Exchanging information with IBM Technical Support
• Spectrum Protect for Databases – all requirement document