I am getting DSNT408I SQLCODE = -204, ERROR: PTI.PTSQL_TEXT_115 IS AN UNDEFINED NAME, how do I address this error?

book

Article ID: 8428

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

User complains about receiving the following error message:

DSNT408I SQLCODE = -204, ERROR: PTI.PTSQL_TEXT_115 IS AN UNDEFINED NAME
DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOTL SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -500 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFE0C' X'00000000' X'00000000'
X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

Note we also previously ran the 0000, 0001, 0002 jobs (compare, create missing objects, binds) but no new objects were detected.

Environment

Release:
Component: GEN

Resolution

The PTI.PTSQL_TEXT_115 table would have been created in the ssid0001 job from the post-install process). This job takes as its input an ssidDDL member which is created by the previous job ssid0000. It is that ssidDDL member that should contain the CREATE for that table as well as any others that may be missing.  If the above doesn't help, then the following will be needed for more investigation:

1/ All the job outputs relating to runs done during post-install i.e. all outputs for ssid0000 and ssid0001 

2/ The ssidDDL member(s) that were created as a result of running ssid0000.