The DB_VERSION procedure returns the version number of the database.
EXECUTE privilege on the DBMS_UTILITY module.
SET SERVEROUTPUT ON@
BEGIN
DECLARE v_version VARCHAR(80);
DECLARE v_compat VARCHAR(80);
CALL DBMS_UTILITY.DB_VERSION(v_version, v_compat);
CALL DBMS_OUTPUT.PUT_LINE('Version: ' || v_version);
CALL DBMS_OUTPUT.PUT_LINE('Compatibility: ' || v_compat);
END@
SET SERVEROUTPUT ON
DB20000I The SET SERVEROUTPUT command completed successfully.
BEGIN
DECLARE v_version VARCHAR(80);
DECLARE v_compat VARCHAR(80);
CALL DBMS_UTILITY.DB_VERSION(v_version, v_compat);
CALL DBMS_OUTPUT.PUT_LINE('Version: ' || v_version);
CALL DBMS_OUTPUT.PUT_LINE('Compatibility: ' || v_compat);
END
DB20000I The SQL command completed successfully.
Version: DB2 v9.7.0.0
Compatibility: DB2 v9.7.0.0