DSNT058I DSNTRIN PROCESSING CANNOT BE CONTINUED BECAUSE routine-type routine-name IS DEFINED WITH AN UNEXPECTED VERSION, version-identifier. THE STATUS IS version-status.

Explanation

During preliminary processing, DSNTRIN detected a Db2-supplied native SQL procedure or compiled SQL scalar function that has an unexpected version. This situation usually indicates that a local version of the routine was created. However, Db2 supports only official versions of Db2-supplied routines so processing terminates.

routine-type
The type of routine, SQL PROCEDURE or SQL FUNCTION
routine-name
The schema and specific name of the routine
version-identifier
The version identifier of the unexpected version
version-status
The status of the unexpected version, ACTIVE or INACTIVE

System action

Processing is discontinued.

User response

Drop the indicated unexpected version of the routine and rerun DSNTRIN:

  1. If the unexpected version is the active version, use one of the following statements to activate the official version, V1:
    • If the routine type is SQL PROCEDURE: 
      ALTER PROCEDURE routine-name ACTIVATE VERSION V1
    • If the routine type is SQL FUNCTION: 
      ALTER SPECIFIC FUNCTION routine-name ACTIVATE VERSION V1
  2. Use one of the following statements to drop the unexpected version:
    • If the routine type is SQL PROCEDURE: 
      ALTER PROCEDURE routine-name DROP VERSION version-identifier
    • If the routine type is SQL FUNCTION:
      ALTER SPECIFIC FUNCTION routine-name DROP VERSION version-identifier

Severity

12 (severe error)