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:
- 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
- If the routine type is SQL PROCEDURE:
- 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
- If the routine type is SQL PROCEDURE:
Severity
12 (severe error)
