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:
-
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.
- Capture a supervisor call (SVC) dump for your Db2 application
environment. Include all Db2 address
spaces in the JOBLIST of your DUMP command.
-
Unload your XML data by using the DSNTIAUL program.