DB002040 C-4M6003: Type mismatch Table:SYSCA.GET_DIAGNOSTICS

Document ID : KB000118575
Last Modified Date : 26/10/2018
Show Technical Document Details
Question:
After running the CONVERT CATALOG for release 19.0, attempt to run the VIEW19U and receive this:
ALTER PROCEDURE SYSCA.GET_DIAGNOSTICS
ADD (IDMS_ROWID_INSERT BINARY(8)) ;
Status = -4 SQLSTATE = 42000 Messages follow:
DB002040 C-4M6003: Type mismatch Table:SYSCA.GET_DIAGNOSTICS
 
What is causing this error?
 
Answer:
This error can occur if you have never run VIEW17U that adds the procedure SYSCA.GET_DIAGNOSTICS to the catalog. This job should be in your CAGJSAMP. You will need to run the VIEW17U first, then the VIEW19U.