Collecting data for XML problems

If you encounter problems with Db2 XML data, collect some initial diagnostic information about your environment.

Before you begin

To diagnose Db2 XML data problems, you must have the appropriate authorization to collect data from different z/OS® components.

Procedure

To collect diagnostic data for Db2 XML data problems:

  1. Collect a copy of the SQL statement, related SQL data manipulation statements and catalog statistics, and the EXPLAIN output to diagnose incorrect output from an SQL statement, as described in Collecting service SQL documentation.
  2. Capture a supervisor call (SVC) dump for your Db2 application environment. Include all Db2 address spaces in the JOBLIST of your DUMP command.
  3. Unload your XML data by using the DSNTIAUL program.