Introducing DSNTPSMP level 1.15

During the course of any application development effort, errors inevitably occur for many reasons. These errors can range from programmer syntax errors on one end of the spectrum to tool set and process related failures on the other end. "BUILDS" using distributed function development presents additional challenges on the tool set side of the spectrum. DSNTPSMP has been updated via APAR PQ45854 to approach the difficulties of diagnosing build problems during SQL stored procedure development. Emphasis has been placed on detecting and handling the root causes of many types of problems that customers report to IBM Software Support. This solution gives the broadest coverage possible while also strengthening the integrity of the build process.

Certain problems are detected before they can cascade into larger, less distinct, and harder to diagnose issues. In these cases the Build stops before certain failure occurs and provides relevant messages about the error and, when appropriate, any recommended actions to take. This action prevents wasted time for both the user and the system. In cases where the DSNTPSMP can make corrections, they are made so a build can proceed with merely a warning.

The areas of error detection and handling addressed in DSNTPSMP 1.15 include the following situations:

• Incorrect or missing environment setup (WLM configuration)
• Incorrect, missing, or conflicting Build requests (Client input)
• Missing, hidden, or misrepresented feedback (Build step output)

• Define the C compiler that DSNTPSMP should use during the build process
• Establish defaults for selected bind package options to meet site guidelines
• Activate or disable DSNTPSMP tracing as needed for additional build diagnosis

• UQ72854 V6
• UQ72855 V7