IBM Support

DSNT408I SQLCODE -401 creating stored procedure CIUSNTSR after upgrading to DB2 11

Question & Answer


Question

Why would CIUSNTSR stored procedure creation fail with message DSNT408I and SQLCODE=-401? I am running CICS Interdependency Analyzer for z/OS (CICS IA) CIUDBCQ JCL when the failure occurs. This happened after I upgraded z/OS DB2 to V11.

Here are the messages I receive:

 DSNT408I SQLCODE = -401, ERROR:  THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE
 NOT COMPARABLE
 DSNT418I SQLSTATE  = 42818 SQLSTATE RETURN CODE
 DSNT415I SQLERRP   = DSNXOBFC SQL PROCEDURE DETECTING ERROR
 DSNT416I SQLERRD   = 930 0  1  -1  0  0 SQL DIAGNOSTIC INFORMATION
 DSNT416I SQLERRD   = X'000003A2' X'00000000' X'00000001' X'FFFFFFFF' X'00000000' X'00000000'
 SQL DIAGNOSTIC INFORMATION

Answer

Apply DB2 V11 PTF UI20622 for APAR PI19804. The -401 could occur when using CICS Interdependency Analyzer for z/OS (CICS IA) V5.1 or V5.2, and when using DB2 V11 in conversation mode (CM) or New-function mode (NFM) mode.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSPPUS","label":"CICS Interdependency Analyzer for z\/OS"},"Platform":[{"code":"PF035","label":"z\/OS"}],"Component":"","Version":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Product Synonym

CICSIA CICS IA

Document Information

Modified date:
09 February 2015

UID

dwa1174496