User tried to compile a procedure with debug and got error below:
DSNTPSMP utility failure for SQL Procedure CBISPDA.GET_FWR_TEST, rc=8.
STEP: DSNTPSMP, FILE: CONSOLE, SEQN: 1, LINE: *** DB2 V8R1 SQL Procedure Processor DSNTPSMP 1.21 (PK59011 2008-04-04)
STEP: DSNTPSMP, FILE: CONSOLE, SEQN: 2, LINE: Language conversion warnings and/or errors, rc=-2168
STEP: DSNTPSMP, FILE: CONSOLE, SEQN: 3, LINE: Abend 878 occurred while running Precompile program DSNHPSM
STEP: DSNTPSMP, FILE: CONSOLE, SEQN: 4, LINE: PSM precompile is not successful, cannot continue
STEP: DSNTPSMP, FILE: Summary, SEQN: 1, LINE: Request: BUILD_DEBUG routine
On this case, the use of SYSPROC.DSNTPSMP is prohibited
Under the BUILD section of Compile SQL Procedure with Debug panel, the Schema name must be specified in order to use for DSNTPSMP. See attachment.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center