Collecting Data: Spectrum Protect for Enterprise Resource Planning

Collecting 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 SAP® General Information
	Manually Gathering Data Protection for SAP® DB2 Information
	Manually Gathering Data Protection for SAP® Oracle Information
	Submitting Information to IBM Support
	Online Self-Help Resources
	Related Information

 

Gathering General Information

Manually Gathering General Information

Gather the following information:

• The version of SAP® (R/3) and the SAP® BRTools®
• The version of Data Protection for SAP®
• SAP® backup configuration file (init<SID>.sap)
• Data Protection SAP® configuration file (init<SID>.utl)
• SAP® Tools log file of the operation in question (brbackup, brarchive, brrestore)
• If it worked before, also provide the change history of the system components

Manually Gathering Data Protection for SAP® for DB2 Information

The default installation path is:
AIX: /usr/tivoli/tsm/tdp_r3/db2 or /usr/tivoli/tsm/tdp_r3/db264
Solaris & Linux: /opt/tivoli/tsm/tdp_r3/ or /opt/tivoli/tsm/tdp_r3/db264
Windows: C:\Program Files\Tivoli\TSM\tdp_r3\db2 or C:\Program Files\Tivoli\TSM\tdp_r3\db264

Gather the following data:

• dsm.sys - contained in the DSMI_DIR directory (only specific to UNIX operating systems)
• dsmerror.log
• dsierror.log
• dsmsched.log
• the file specified by the ERRORLOGNAME in the dsm.sys (unix) or dsm.opt (windows)
• the dsm.sys (UNIX) in the /<opt or usr>/tivoli/tsm/client/api/<bin or bin64>/ directory
• the file specified by the DSMI_CONFIG
• for Windows systems: The {server}.opt file in the same directory that the DSMI_CONFIG is using
• details of operating system level
• details of DB2 instance levels
• vendor.env file specified by the DB2_VENDOR_INI variable defined in the DB2 cfg
• the init<SID>.utl file referenced by XINT_PROFILE in the vendor.env file
• location of init<SID>.utl file
• the output of the command 'db2 get db cfg'
• the output from a 'set' command
• the db2diag.log
• tdpdb2.<SID>.<NODE> log

AIX Only:

• Gather the Data Protection and Spectrum Protect API version output from the following command: 'lslpp -l tivoli.tsm*'

Solaris Only:

• Gather the Data Protection and Spectrum Protect API version output from the following command: 'pkginfo TIVsm*'

Linux Only:

• Gather the Data Protection and Spectrum Protect API version output from the following command: 'rpm -q TIVsm*'

Windows Only:

• The version of the Spectrum Protect API client
  • Look in the registry for the API entry:
  • HKEY_LOCAL_MACHINE->SOFTWARE->IBM->ADSM->CurrentVersion->Api
  • Look at the value for the Path
  • Right click on the tsmapi.dll in this directory and choose the version tab.
    • (default is c:\Program Files\Tivoli\TSM\api)
• The version of the Data Protection for SAP® client
  • At a DOS command prompt within the installation directory run:
    • backint
  • This will show the Version/Release/Modification/Level for the Data Protection client software

 

Manually Gathering Data Protection for SAP® Oracle Information

The default installation path is:
AIX: /usr/tivoli/tsm/tdp_r3/ora64 or /usr/tivoli/tsm/tdp_r3/ora
Solaris & Linux: /opt/tivoli/tsm/tdp_r3/ora64 or /opt/tivoli/tsm/tdp_r3/ora
Windows: C:\Program Files\Tivoli\TSM\tdp_r3\ora or C:\Program Files\Tivoli\TSM\tdp_r3\ora64

Gather the following data:

• dsm.sys - contained in the DSMI_DIR directory (only specific to UNIX operating systems)
• dsmerror.log
• dsierror.log
• dsmsched.log
• the file specified by the ERRORLOGNAME in the dsm.sys (unix) or dsm.opt (windows)
• the dsm.sys (UNIX) in the /<opt or usr>/tivoli/tsm/client/api/<bin or bin64>/ directory
• the file specified by the DSMI_CONFIG
• for Windows systems: The {server}.opt file in the same directory that the DSMI_CONFIG is using
• details of operating system level
• details of Oracle instance levels
• the init<SID>.sap file
• the init<SID>.utl file
• location of init<SID>.utl file
• location of the init<SID>.bki file
• the sbtio.log
• the backint log from the /oracle/<SID>/sapbackup or /oracle/<SID>/saparch directory


• (with the extension .anf, .aff, .anr, .svd, .rsb, etc)
• the output from a 'set' command
• the version of Oracle

AIX Only:

• output from the command 'find / -name "libtdp_r3*" -exec ls -al {\} \; 2> /dev/null'
• Get the Data Protection and Spectrum Protect API version output from the following command:
  • 'lslpp -l tivoli.tsm*'

Solaris Only:

• output from the command 'find / -name "libtdp_r3*" -exec ls -al {\} \; 2> /dev/null'
• Get the Data Protection and Spectrum Protect API version output from the following command:
  • 'pkginfo -x | grep "TIVsm"

HP-UX:

• output from the command 'find / -name "libtdp_r3*" -exec ls -al {\} \; 2> /dev/null'
• Get the Data Protection and Spectrum Protect API version output from the following command:
  • 'swlist TIVsm'

Linux Only:

• output from the command 'find / -name "libtdp_r3*" -exec ls -al {\} \; 2> /dev/null'
• Get the Data Protection and Spectrum Protect API version output from the following command:
  • 'rpm -qai TIV* TDP*'

Windows Only:

• Version and location of the orasbt.dll file
  • Right-click on the orasbt.dll, select properties and choose the version tab
• The version of the Spectrum Protect API client
  • Look in the registry for the API entry:
  • HKEY_LOCAL_MACHINE->SOFTWARE->IBM->ADSM->CurrentVersion->Api
  • Look at the value for the Path
  • Right click on the tsmapi.dll in this directory and choose the version tab.
    • (default is c:\Program Files\Tivoli\TSM\api)

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
• Data Protection for SAP® User's Guides v7.1
• Data Protection for SAP® User's Guides v8.1
• IBM Spectrum Protect for Enterprise Resource Planning All Requirements
• IBM Spectrum Protect for Enterprise Resource Planning APARs