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
Was this topic helpful?
Document Information
Modified date:
09 February 2015
UID
dwa1174496