Support Article
DSNT408I applys generated DDL when importing RAP on Db2 z/OS
SA-50820
Summary
Unable to apply the generated DDL from an RAP import on Db2 for z/OS environment. This occurs when using the same Auxiliary table name in multiple Create Aux Table statements.
Error Messages
DSNT408I SQLCODE = -601, ERROR: THE NAME (VERSION OR VOLUME SERIAL NUMBER) OF
THE OBJECT TO BE DEFINED OR THE TARGET OF A RENAME STATEMENT IS
IDENTICAL TO THE EXISTING NAME (VERSION OR VOLUME SERIAL NUMBER)
PEGASNDO.AUX_BLOB_PLOB0230 OF THE OBJECT TYPE TABLE
DSNT418I SQLSTATE = 42710 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXISB1 SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 345 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000159' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
Steps to Reproduce
- Import Healthcare Industry Foundation (HCIF) RAP file.
- Download the generated DDL.
Root Cause
A defect in Pegasystems’ code or rules. The NameSpace used for auxiliary tables on a single schema deployment was not managed correctly.
Resolution
Apply HFix-41129.
Published February 19, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.