4. EXCEPTIONS › 4.3 Exception Descriptions › 10053 Drop Data Base Statement

Previous Topic: 10052 Drop Tablespace Statement

Next Topic: 10054 Allocate Requests A Nonexistent Plan

10053 Drop Data Base Statement


FILE:  DB2 Data Base Activity File
SAS FILE NAME:  DETAIL.DB2DSD01
SOURCE LOCATION:  sharedprefix.MICS.SOURCE(DB2DYEXC)

SEVERITY:  Warning              (Severity='W')
MANAGEMENT AREA:  Performance   (MGMTAREA='Performance')

PURPOSE:    This exception notes that a Drop Data Base
statement was executed.

RATIONALE:  Dropping a Data Base will delete all the tables
contained within the space.

DEFINITION:   This exception is noted when the DSDDRPDB flag
is non-zero.

EXCEPTION STATEMENTS:    The SAS statements identifying the
exception situation and describing the condition are stored
in the source member named in SOURCE LOCATION and are
described below:


/* ***************************************** */
/* EXCEPTION NUMBER:  10053                  */
/* TITLE:  DROP DATA BASE STATEMENT          */
/* FILE:  DB2DSD01                           */
/* ***************************************** */

IF DSDDRPDB GT 0 THEN DO;
  EXCCODE='10053';
  SEVERITY='W';
  MGMTAREA='PERFORMANCE';
  EXCDESC1='DROP DATA BASE STATEMENT';
  EXCDESC2='COUNT = '                  ||
            PUT(DSDDRPDB,6.)
            ;
  LINK HIT;
  END;