Configuring WLDF Diagnostic Archives

1.Use the following DDL definition for creating tables in SQL Server 2008

CREATE TABLE wls_events (
  RECORDID INTEGER IDENTITY(1,1) NOT NULL,
  TIMESTAMP BIGINT default NULL,
  CONTEXTID varchar(128) default NULL,
  TXID varchar(32) default NULL,
  USERID varchar(32) default NULL,
  TYPE varchar(64) default NULL,
  DOMAIN varchar(64) default NULL,
  SERVER varchar(64) default NULL,
  SCOPE varchar(64) default NULL,
  MODULE varchar(64) default NULL,
  MONITOR varchar(64) default NULL,
  FILENAME varchar(64) default NULL,
  LINENUM INTEGER default NULL,
  CLASSNAME varchar(250) default NULL,
  METHODNAME varchar(64) default NULL,
  METHODDSC varchar(4000) default NULL,
  ARGUMENTS VARCHAR(8000) default NULL,
  RETVAL varchar(4000) default NULL,
  PAYLOAD VARBINARY(8000),
  CTXPAYLOAD VARCHAR(4000),
  DYES NUMERIC default NULL,
  THREADNAME varchar(128) default NULL
);


CREATE TABLE wls_hvst (
  RECORDID INTEGER IDENTITY,
  TIMESTAMP NUMERIC default NULL,
  DOMAIN varchar(64) default NULL,
  SERVER varchar(64) default NULL,
  TYPE varchar(64) default NULL,
  NAME varchar(250) default NULL,
  ATTRNAME varchar(64) default NULL,
  ATTRTYPE INTEGER default NULL,
  ATTRVALUE VARCHAR(4000)
);


2. Create a jdbc data source in Oracle Weblogic Server and configure Diagnostics>Archives with this data source

3. Restart the weblogic server or just wait for some time and see the wls_hvst table getting populated with the diagnostic data.