Example of a Member-Scope Audit Detail Report and Trace (Type AUTHCNTL)

This section shows examples of a Member-Scope Audit Detail report and trace (Type AUTHCNTL).

Example of a Member-Scope Audit Detail Report (Type AUTHCNTL)

   LOCATION: OMPDB61                          OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)             PAGE: 1-1
      GROUP: N/P                                   AUDIT REPORT - DETAIL                        REQUESTED FROM: 03/23/15 12:03:12.80
     MEMBER: N/P                                   AUTHORIZATION CONTROL                                    TO: 03/23/15 12:03:16.48
  SUBSYSTEM: DB61                                ORDER: PRIMAUTH-PLANNAME                          ACTUAL FROM: 03/23/15 12:03:12.80
DB2 VERSION: V12                                       SCOPE: MEMBER                                        TO: 03/23/15 12:03:16.47
PRIMAUTH CORRNAME CONNTYPE
ORIGAUTH CORRNMBR INSTANCE
PLANNAME CONNECT                TIMESTAMP   TYPE                                   DETAIL
-------- -------- ------------ ----------- -------- --------------------------------------------------------------------------------
EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          USER
EDVA     ppli     CEB03BC01A53 12:03:12.80          PRIV CHECKED:       DROP                             OBJECT TYPE:       TAB/VIEW
DISTSERV SERVER                                     AUTHID:             EDVA
REQLOC  :::FFFF:9.157.1#1                           SOURCE OBJECT
ENDUSER :EDVA_End_User_#1                            QUALIFIER:         EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
WSNAME  :EDVA_Work_Statio#1                                             123456789G123456789H123456789I123456789J123456789A123456789B
TRANSACT:EDVA_Application_Information#1                                 12345END
TCONTEXT:EDVA_T#1                                    NAME:              EDVATABLE_AU_US4741_1234567890123456789012345678901234567890
ROLE    :EDVA_R#1                                                       123456789012345678901234567890123456789012345678901234567890
                                                                        1234567A
                                                    TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               DROP TABLE EDVATABLE_AU_US4741_12345678901234567890123456789
                                                                        012345678901234567890123456789012345678901234567890123456789
                                                                        012345678901234567A

EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          SYSADM
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       CREATE TABLE                     OBJECT TYPE:       DATABASE
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
TCONTEXT:EDVA_T#1                                                       123456789G123456789H123456789I123456789J123456789A123456789B
ROLE    :EDVA_R#1                                                       12345END
                                                     NAME:              EDVADB
                                                    TARGET OBJECT
                                                     QUALIFIER:         EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
                                                                        123456789G123456789H123456789I123456789J123456789A123456789B
                                                                        12345END
                                                     NAME:              EDVATABLE_AU_US4741_1234567890123456789012345678901234567890
                                                                        123456789012345678901234567890123456789012345678901234567890
                                                                        1234567A
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL

EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          SYSADM
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       USE                              OBJECT TYPE:       LOBTS
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         EDVADB
TCONTEXT:EDVA_T#1                                    NAME:              EDVATS
ROLE    :EDVA_R#1                                   TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL
   LOCATION: OMPDB61                          OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)             PAGE: 1-2
      GROUP: N/P                                   AUDIT REPORT - DETAIL                        REQUESTED FROM: 03/23/15 12:03:12.80
     MEMBER: N/P                                   AUTHORIZATION CONTROL                                    TO: 03/23/15 12:03:16.48
  SUBSYSTEM: DB61                                ORDER: PRIMAUTH-PLANNAME                          ACTUAL FROM: 03/23/15 12:03:12.80
DB2 VERSION: V12                                       SCOPE: MEMBER                                        TO: 03/23/15 12:03:16.47
PRIMAUTH CORRNAME CONNTYPE
ORIGAUTH CORRNMBR INSTANCE
PLANNAME CONNECT                TIMESTAMP   TYPE                                   DETAIL
-------- -------- ------------ ----------- -------- --------------------------------------------------------------------------------
EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          SYSADM
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       CREATE TABSPACE                  OBJECT TYPE:       DATABASE
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         EDVA
TCONTEXT:EDVA_T#1                                    NAME:              EDVADB
ROLE    :EDVA_R#1                                   TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL

EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          USER
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       USE                              OBJECT TYPE:       BUFFER
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         SYSIBM
TCONTEXT:EDVA_T#1                                    NAME:              BP16K0
ROLE    :EDVA_R#1                                   TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL

EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          SYSADM
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       USE                              OBJECT TYPE:       STOGROUP
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         SYSIBM
TCONTEXT:EDVA_T#1                                    NAME:              EDVASTGR
ROLE    :EDVA_R#1                                   TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL
   LOCATION: OMPDB61                          OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)             PAGE: 1-3
      GROUP: N/P                                   AUDIT REPORT - DETAIL                        REQUESTED FROM: 03/23/15 12:03:12.80
     MEMBER: N/P                                   AUTHORIZATION CONTROL                                    TO: 03/23/15 12:03:16.48
  SUBSYSTEM: DB61                                ORDER: PRIMAUTH-PLANNAME                          ACTUAL FROM: 03/23/15 12:03:12.80
DB2 VERSION: V12                                       SCOPE: MEMBER                                        TO: 03/23/15 12:03:16.47
PRIMAUTH CORRNAME CONNTYPE
ORIGAUTH CORRNMBR INSTANCE
PLANNAME CONNECT                TIMESTAMP   TYPE                                   DETAIL
-------- -------- ------------ ----------- -------- --------------------------------------------------------------------------------
EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          USER
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       USE                              OBJECT TYPE:       BUFFER
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         SYSIBM
TCONTEXT:EDVA_T#1                                    NAME:              BP1
ROLE    :EDVA_R#1                                   TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL

************************************************************************************************************************************
*                                                    LIST OF TRUNCATED VALUES                                                      *
* TRUNCATED VALUE                FULL VALUE                                                                                        *
* ------------------------------ ------------------------------------------------------------------------------------------------- *
* EDVA_Application_Information#1 EDVA_Application_Information_128_456789D123456789E123456789F123456789G123456789H123456789I1234567 *
*                                89J123456789K123456789L12345678                                                                   *
* EDVA_End_User_#1               EDVA_End_User_128_9B123456789C123456789D123456789E123456789F123456789G123456789H123456789I1234567 *
*                                89J123456789K123456789L12345678                                                                   *
* EDVA_R#1                       EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F123456789G123456789H123456789I1234567 *
*                                89J123456789A123456789B12345END                                                                   *
* EDVA_T#1                       EDVA_TRUSTED_CONTEXT_128_6789C123456789D123456789E123456789F123456789G123456789H123456789I1234567 *
*                                89J123456789A123456789B12345END                                                                   *
* EDVA_Work_Statio#1             EDVA_Work_Station_255_3456789C123456789D123456789E123456789F123456789G123456789H123456789I1234567 *
*                                89J123456789K123456789L123456789M123456789N123456789O123456789P123456789Q123456789R123456789S1234 *
*                                56789T123456789U123456789V123456789W123456789X123456789Y12345                                     *
************************************************************************************************************************************
AUDIT REPORT COMPLETE

Example of a Member-Scope Audit Trace (Type AUTHCNTL)

   LOCATION: OMPDB61                          OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)             PAGE: 1-1
      GROUP: N/P                                        AUDIT TRACE                             REQUESTED FROM: 03/23/15 12:03:12.80
     MEMBER: N/P                                                                                            TO: 03/23/15 12:03:16.48
  SUBSYSTEM: DB61                                                                                  ACTUAL FROM: 03/23/15 12:03:12.80
DB2 VERSION: V12                                       SCOPE: MEMBER                                 PAGE DATE: 03/23/15
PRIMAUTH CORRNAME CONNTYPE
ORIGAUTH CORRNMBR INSTANCE
PLANNAME CONNECT                TIMESTAMP   TYPE                                   DETAIL
-------- -------- ------------ ----------- -------- --------------------------------------------------------------------------------
EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          USER
EDVA     ppli     CEB03BC01A53 12:03:12.80          PRIV CHECKED:       DROP                             OBJECT TYPE:       TAB/VIEW
DISTSERV SERVER                                     AUTHID:             EDVA
REQLOC  :::FFFF:9.157.1#1                           SOURCE OBJECT
ENDUSER :EDVA_End_User_#1                            QUALIFIER:         EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
WSNAME  :EDVA_Work_Statio#1                                             123456789G123456789H123456789I123456789J123456789A123456789B
TRANSACT:EDVA_Application_Information#1                                 12345END
TCONTEXT:EDVA_T#1                                    NAME:              EDVATABLE_AU_US4741_1234567890123456789012345678901234567890
ROLE    :EDVA_R#1                                                       123456789012345678901234567890123456789012345678901234567890
                                                                        1234567A
                                                    TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               DROP TABLE EDVATABLE_AU_US4741_12345678901234567890123456789
                                                                        012345678901234567890123456789012345678901234567890123456789
                                                                        012345678901234567A

EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          SYSADM
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       CREATE TABLE                     OBJECT TYPE:       DATABASE
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
TCONTEXT:EDVA_T#1                                                       123456789G123456789H123456789I123456789J123456789A123456789B
ROLE    :EDVA_R#1                                                       12345END
                                                     NAME:              EDVADB
                                                    TARGET OBJECT
                                                     QUALIFIER:         EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
                                                                        123456789G123456789H123456789I123456789J123456789A123456789B
                                                                        12345END
                                                     NAME:              EDVATABLE_AU_US4741_1234567890123456789012345678901234567890
                                                                        123456789012345678901234567890123456789012345678901234567890
                                                                        1234567A
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL

EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          SYSADM
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       USE                              OBJECT TYPE:       LOBTS
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         EDVADB
TCONTEXT:EDVA_T#1                                    NAME:              EDVATS
ROLE    :EDVA_R#1                                   TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL
 
    LOCATION: OMPDB61                          OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)             PAGE: 1-2
      GROUP: N/P                                        AUDIT TRACE                             REQUESTED FROM: 03/23/15 12:03:12.80
     MEMBER: N/P                                                                                            TO: 03/23/15 12:03:16.48
  SUBSYSTEM: DB61                                                                                  ACTUAL FROM: 03/23/15 12:03:12.80
DB2 VERSION: V12                                       SCOPE: MEMBER                                 PAGE DATE: 03/23/15
PRIMAUTH CORRNAME CONNTYPE
ORIGAUTH CORRNMBR INSTANCE
PLANNAME CONNECT                TIMESTAMP   TYPE                                   DETAIL
-------- -------- ------------ ----------- -------- --------------------------------------------------------------------------------
EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          SYSADM
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       CREATE TABSPACE                  OBJECT TYPE:       DATABASE
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         EDVA
TCONTEXT:EDVA_T#1                                    NAME:              EDVADB
ROLE    :EDVA_R#1                                   TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL

EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          USER
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       USE                              OBJECT TYPE:       BUFFER
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         SYSIBM
TCONTEXT:EDVA_T#1                                    NAME:              BP16K0
ROLE    :EDVA_R#1                                   TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL

EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          SYSADM
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       USE                              OBJECT TYPE:       STOGROUP
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         SYSIBM
TCONTEXT:EDVA_T#1                                    NAME:              EDVASTGR
ROLE    :EDVA_R#1                                   TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL
    LOCATION: OMPDB61                          OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)             PAGE: 1-3
      GROUP: N/P                                        AUDIT TRACE                             REQUESTED FROM: 03/23/15 12:03:12.80
     MEMBER: N/P                                                                                            TO: 03/23/15 12:03:16.48
  SUBSYSTEM: DB61                                                                                  ACTUAL FROM: 03/23/15 12:03:12.80
DB2 VERSION: V12                                       SCOPE: MEMBER                                 PAGE DATE: 03/23/15
PRIMAUTH CORRNAME CONNTYPE
ORIGAUTH CORRNMBR INSTANCE
PLANNAME CONNECT                TIMESTAMP   TYPE                                   DETAIL
-------- -------- ------------ ----------- -------- --------------------------------------------------------------------------------
EDVA     db2jcc_a DRDA         03/23/15    AUTHCNTL AUTH TYPE:          USER
EDVA     ppli     CEB03BC412C3 12:03:16.47          PRIV CHECKED:       USE                              OBJECT TYPE:       BUFFER
DISTSERV SERVER                                     ROLE:               EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F
REQLOC  :::FFFF:9.157.1#1                                               123456789G123456789H123456789I123456789J123456789A123456789B
ENDUSER :EDVA_End_User_#1                                               12345END
WSNAME  :EDVA_Work_Statio#1                         SOURCE OBJECT
TRANSACT:EDVA_Application_Information#1              QUALIFIER:         SYSIBM
TCONTEXT:EDVA_T#1                                    NAME:              BP1
ROLE    :EDVA_R#1                                   TARGET OBJECT
                                                     QUALIFIER:         N/P
                                                     NAME:              N/P
                                                    OTHER  OBJECT
                                                     NAME:              N/P
                                                    TEXT:               CREATE TABLE EDVATABLE_AU_US4741_123456789012345678901234567
                                                                        890123456789012345678901234567890123456789012345678901234567
                                                                        89012345678901234567A(COL_0_789A123456789B123456789C XML, CO
                                                                        L_1_789A123456789B123456789C CHAR(10)) IN EDVADB.EDVATS AUDI
                                                                        T ALL

************************************************************************************************************************************
*                                                    LIST OF TRUNCATED VALUES                                                      *
* TRUNCATED VALUE                FULL VALUE                                                                                        *
* ------------------------------ ------------------------------------------------------------------------------------------------- *
* EDVA_Application_Information#1 EDVA_Application_Information_128_456789D123456789E123456789F123456789G123456789H123456789I1234567 *
*                                89J123456789K123456789L12345678                                                                   *
* EDVA_End_User_#1               EDVA_End_User_128_9B123456789C123456789D123456789E123456789F123456789G123456789H123456789I1234567 *
*                                89J123456789K123456789L12345678                                                                   *
* EDVA_R#1                       EDVA_ROLE_NAME_______128_6789C123456789D123456789E123456789F123456789G123456789H123456789I1234567 *
*                                89J123456789A123456789B12345END                                                                   *
* EDVA_T#1                       EDVA_TRUSTED_CONTEXT_128_6789C123456789D123456789E123456789F123456789G123456789H123456789I1234567 *
*                                89J123456789A123456789B12345END                                                                   *
* EDVA_Work_Statio#1             EDVA_Work_Station_255_3456789C123456789D123456789E123456789F123456789G123456789H123456789I1234567 *
*                                89J123456789K123456789L123456789M123456789N123456789O123456789P123456789Q123456789R123456789S1234 *
*                                56789T123456789U123456789V123456789W123456789X123456789Y12345                                     *
************************************************************************************************************************************
AUDIT TRACE COMPLETE