AUDIT WORKSHEET WITH BALA

 

CREATE TABLE AUDIT (TIMESTAMP CHAR(26),CATEGORY CHAR(8),EVENT VARCHAR(32), CORRELATOR INTEGER,STATUS INTEGER, USERID VARCHAR(1024), AUTHID VARCHAR(128))


CREATE TABLE CHECKING (TIMESTAMP CHAR(26),CATEGORY CHAR(8),EVENT VARCHAR(32),CORRELATOR INTEGER,STATUS INTEGER,DATABASE CHAR(8),USERID VARCHAR(1024),AUTHID VARCHAR(128),NODENUM SMALLINT,COORDNUM SMALLINT,APPID VARCHAR(255),APPNAME VARCHAR(1024),PKGSCHEMA VARCHAR(128),PKGNAME VARCHAR(128),PKGSECNUM SMALLINT,OBJSCHEMA VARCHAR(128),OBJNAME VARCHAR(128),OBJTYPE VARCHAR(32),ACCESSAPP CHAR(18),ACCESSATT CHAR(18),PKGVER VARCHAR(64))




CREATE TABLE OBJMAINT (TIMESTAMP CHAR(26),CATEGORY CHAR(8),EVENT VARCHAR(32),CORRELATOR INTEGER,STATUS INTEGER,DATABASE CHAR(8),USERID VARCHAR(1024),AUTHID VARCHAR(128),NODENUM SMALLINT,COORDNUM SMALLINT,APPID VARCHAR(255),APPNAME VARCHAR(1024),PKGSCHEMA VARCHAR(128),PKGNAME VARCHAR(128),PKGSECNUM SMALLINT,OBJSCHEMA VARCHAR(128),OBJNAME VARCHAR(128),OBJTYPE VARCHAR(32),PACKVER VARCHAR(64))



CREATE TABLE SECMAINT (TIMESTAMP CHAR(26),CATEGORY CHAR(8),EVENT VARCHAR(32),CORRELATOR INTEGER,STATUS INTEGER,DATABASE CHAR(8),USERID VARCHAR(1024),AUTHID VARCHAR(128), NODENUM SMALLINT,COORDNUM SMALLINT,APPID VARCHAR(255),APPNAME VARCHAR(1024),PKGSCHEMA VARCHAR(128),PKGNAME VARCHAR(128),PKGSECNUM SMALLINT,OBJSCHEMA VARCHAR(128),OBJNAME VARCHAR(128),OBJTYPE VARCHAR(32),GRANTOR VARCHAR(128),GRANTEE VARCHAR(128),GRANTEETYPE VARCHAR(32),PRIVAUTH CHAR(18),PKGVER VARCHAR(64))


CREATE TABLE SYSADMIN (TIMESTAMP CHAR(26),CATEGORY CHAR(8),EVENT VARCHAR(32),CORRELATOR INTEGER,STATUS INTEGER,DATABASE CHAR(8),USERID VARCHAR(1024),AUTHID VARCHAR(128),NODENUM SMALLINT,COORDNUM SMALLINT,APPID VARCHAR(255),APPNAME VARCHAR(1024),PKGSCHEMA VARCHAR(128),PKGNAME VARCHAR(128),PKGSECNUM SMALLINT,PKGVER VARCHAR(64))


CREATE TABLE VALIDATE (TIMESTAMP CHAR(26), CATEGORY CHAR(8), EVENT VARCHAR(32), CORRELATOR INTEGER, STATUS INTEGER,DATABASE CHAR(8), USERID VARCHAR(1024),AUTHID VARCHAR(128),EXECID VARCHAR(1024),NODENUM SMALLINT,COORDNUM SMALLINT, APPID VARCHAR(255), APPNAME VARCHAR(1024), AUTHTYPE VARCHAR(32),PKGSCHEMA VARCHAR(128), PKGNAME VARCHAR(128),PKGSECNUM SMALLINT,PKGVER VARCHAR(64),PLUGINNAME VARCHAR(32))



CREATE TABLE CONTEXT (TIMESTAMP CHAR(26),CATEGORY CHAR(8),EVENT VARCHAR(32),CORRELATOR INTEGER,DATABASE CHAR(8),USERID VARCHAR(1024),AUTHID VARCHAR(128),NODENUM SMALLINT,COORDNUM SMALLINT,APPID VARCHAR(255),APPNAME VARCHAR(1024),PKGSCHEMA VARCHAR(128),PKGNAME VARCHAR(128),PKGSECNUM SMALLINT,STMTTEXT CLOB(2M),PKGVER VARCHAR(64))




LOAD FROM audit.del OF del MODIFIED BY CHARDEL0xff INSERT INTO MAHESH.AUDIT

LOAD FROM checking.del OF del MODIFIED BY CHARDEL0xff INSERT INTO MAHESH.CHECKING

LOAD FROM objmaint.del OF del MODIFIED BY CHARDEL0xff INSERT INTO MAHESH.OBJMAINT

LOAD FROM sysadmin.del OF del MODIFIED BY CHARDEL0xff INSERT INTO MAHESH.SYSADMIN

LOAD FROM validate.del OF del MODIFIED BY CHARDEL0xff INSERT INTO MAHESH.VALIDATE

LOAD FROM context.del OF del MODIFIED BY CHARDEL0xff INSERT INTO MAHESH.CONTEXT




db2 "select * from MAHESH.AUDIT"
db2 "select * from MAHESH.CHECKING"
db2 "select * from MAHESH.OBJMAINT"
db2 "select * from MAHESH.SYSADMIN"
db2 "select * from MAHESH.VALIDATE"
db2 "select * from MAHESH.CONTEXT"




<MAHESH>db2 " drop table audit"
DB20000I  The SQL command completed successfully.
<MAHESH>db2 "drop table validate"
DB20000I  The SQL command completed successfully.
<MAHESH>db2 drop table checking"
> "
DB20000I  The SQL command completed successfully.
<MAHESH>db2 "drop table OBJMAINT"
DB20000I  The SQL command completed successfully.
<MAHESH>db2 "drop table SYSADMIN"
DB20000I  The SQL command completed successfully.
<MAHESH>db2 "drop table VALIDATE1"
DB20000I  The SQL command completed successfully.
db2  "drop table




DELETE FROM MAHESH.AUDIT WHERE TIMESTAMP > TIMESTAMP('20080826130000')
DELETE FROM MAHESH.CHECKING WHERE TIMESTAMP > TIMESTAMP('20080826130000')
DELETE FROM MAHESH.OBJMAINT WHERE TIMESTAMP > TIMESTAMP('20080826130000')
DELETE FROM MAHESH.SYSADMIN WHERE TIMESTAMP > TIMESTAMP('20080826130000')
DELETE FROM MAHESH.VALIDATE WHERE TIMESTAMP > TIMESTAMP('20080826130000')
DELETE FROM MAHESH.CONTEXT WHERE TIMESTAMP > TIMESTAMP('20080826130000')