 CREATE OR REPLACE PROCEDURE ONE_TIME_SETUP()
  BEGIN
   CALL LOGGER.DEACTIVATE_CACHE();
+  CALL DB2UNIT.SET_AUTONOMOUS(FALSE);
  END @
 
 CREATE OR REPLACE PROCEDURE SETUP()


CREATE OR REPLACE PROCEDURE ONE_TIME_TEAR_DOWN()
 BEGIN
  CALL LOGADMIN.DELETE_LOGGERS();
 END @

-- Tests

  CALL LOGGER.LOG(LOGGER_ID, LVL_ID, 'Message test');
  SET AUTONOMOUS = DB2UNIT.GET_AUTONOMOUS();
  IF (AUTONOMOUS = TRUE) THEN
   SET EXPECTED_MSG = '    -';
  ELSE
   SET EXPECTED_MSG = '       -';
  END IF;
  SELECT MESSAGE INTO ACTUAL_MSG
    FROM LOGS
