Troubleshooting
Problem
This document describes what to collect and how to collect information for problems with the SQL precompiler.
Resolving The Problem
For issues concerning the SQL precompiler this document includes the recommended data collection for debug.
This is by no means all inclusive. It is meant as a starting point for document collection.
Specific MustGather information for SQL precompiler issues
If you encounter a SQL precompiler issue, collect the following information as related to the issue:
Specific MustGather information for SQL precompiler issues
If you encounter a SQL precompiler issue, collect the following information as related to the issue:
| Manual Collection |
PTF information:
1.
IBM i level of system. (for example, IBM i 7.3, IBM i 7.4)2. Issue
WRKPTFGRP and press Enter. Press F6 to generate a QSYSPRT spooled file.3. Issue
DSPPTF OUTPUT(*PRINT)Data Collection:
1. Compile listing compiled with
OPTION(*XREF) OUTPUT(*PRINT) specified on the CRTSQLxxxNOTE: If the program compiles but there is a problem running it you should send both the precompiler and compiler listings.
2.
DSPFFD FILE(--your library--/--your file--) OUTPUT(*PRINT) for external files used to define variables.Note: Use applicable
Library and File name.** All spool files generated from above steps needs to be sent to IBM. **
[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHbAAM","label":"IBM i Db2->MustGather Database"},{"code":"a8m0z0000001i3HAAQ","label":"IBM i Db2->SQL Programming"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]
Historical Number
N1012146
Was this topic helpful?
Document Information
Modified date:
05 April 2022
UID
nas8N1012146