ReportCaster Repository Creation Tracing

To create the ReportCaster Repository tables, the create utility (createUtil.exe) is run from /ibi/WebFOCUS77/ReportCaster/bin. The create utility uses the connection and log on information that you provided during the ReportCaster Distribution Server installation to create and re-initialize the repository tables. When you run this utility, the /ibi/WebFOCUS77/ReportCaster/bin/broker.out file is created.

Reference: broker.out

The following is an excerpt from a broker.out trace file. The first three lines will always appear when you run the create utility for the first time. The rest of the trace file shows the creation of the ReportCaster Repository tables. This excerpt shows the BOTPARMS table being created.

Tue Feb 18 13:16:38 EST 2003: Exception caught while reading 
configuration (xmls):
Tue Feb 18 13:16:39 EST 2003: java.io.IOException: Configuration data 
missing
Tue Feb 18 13:16:39 EST 2003: Try to use ini file to create Repository 
Database
Tue Feb 18 13:16:39 EST 2003:   REPOSITORY:
Tue Feb 18 13:16:39 EST 2003:        [DATABASE TYPE]: SQL
Tue Feb 18 13:16:39 EST 2003:        [JDBC CLASS]: 
COM.ibm.db2.jdbc.app.DB2Driver
Tue Feb 18 13:16:39 EST 2003:        [JDBC URL]: jdbc:db2:rc77
Tue Feb 18 13:16:39 EST 2003:        [DATABASE OWNER]: db2admin
Tue Feb 18 13:16:39 EST 2003:        [REPORT BROKER ADMIN]: db2admin
Tue Feb 18 13:16:39 EST 2003: 
Tue Feb 18 13:16:39 EST 2003: Begin to Add DataServer Repository to 
DataServer Manager
Tue Feb 18 13:16:39 EST 2003: Added DataServer to DataServer Manager 
successfully.
Tue Feb 18 13:16:39 EST 2003: Begin to locate, load and link the class 
COM.ibm.db2.jdbc.app.DB2Driver
Tue Feb 18 13:16:41 EST 2003: Located, loaded and linked the class 
successfully.
Tue Feb 18 13:16:42 EST 2003: Begin to register JDBC driver 
COM.ibm.db2.jdbc.app.DB2Driver for Repository
Tue Feb 18 13:16:42 EST 2003: Registered JDBC driver successfully.
Tue Feb 18 13:16:42 EST 2003: Begin to Get the ConnectionManager for 
DataServer Repository
Tue Feb 18 13:16:42 EST 2003: Got ConnectionManager successfully.
Tue Feb 18 13:16:42 EST 2003: Begin to create a new connection in 
Repository
Tue Feb 18 13:16:42 EST 2003:    [URL]: jdbc:db2:rc77
Tue Feb 18 13:16:42 EST 2003:    [User]: db2admin
Tue Feb 18 13:16:42 EST 2003:    [Password]: ********
Tue Feb 18 13:16:49 EST 2003: Created the connection successfully.
Tue Feb 18 13:16:49 EST 2003:

Connection.getMetaData.getDatabaseProductName: DB2
Tue Feb 18 13:16:50 EST 2003:   Start dropping...
Tue Feb 18 13:16:54 EST 2003:         DROP TABLE BOTPARMS .... Success
Tue Feb 18 13:16:54 EST 2003:         DROP TABLE BOTSCHED .... Success
Tue Feb 18 13:16:54 EST 2003:     End
Tue Feb 18 13:16:54 EST 2003:   Start creating...
Tue Feb 18 13:16:57 EST 2003: SQL: CREATE TABLE BOTPARMS (
SCHEDULEID           VARCHAR(12)                            NOT NULL ,
TASKID               VARCHAR(12)                            NOT NULL ,
PARAM_NAME           VARCHAR(64)                            NOT NULL ,
PARAM_VALUE          VARCHAR(255)                                    ,
PARAM_TYPE           VARCHAR(12)         DEFAULT 'String'   NOT NULL ,
PARAM_XTYPE          VARCHAR(12)                                     ,
PARAM_INDEX          CHAR(2)             DEFAULT '00'       NOT NULL ,
PRIMARY KEY (SCHEDULEID,TASKID,PARAM_NAME,PARAM_INDEX))
Tue Feb 18 13:16:57 EST 2003:         CREATE TABLE BOTPARMS .... Success
Tue Feb 18 13:16:57 EST 2003:     End

Tue Feb 18 13:16:42 EST 2003:    [URL]: jdbc:db2:rc77
Tue Feb 18 13:16:42 EST 2003:    [User]: db2admin
Tue Feb 18 13:16:42 EST 2003:    [Password]: ********
Tue Feb 18 13:16:49 EST 2003: Created the connection successfully.

Tue Feb 18 13:16:49 EST 2003: 
Connection.getMetaData.getDatabaseProductName: DB2
Tue Feb 18 13:16:50 EST 2003:   Start dropping...
Tue Feb 18 13:16:54 EST 2003:         DROP TABLE BOTPARMS .... Success
Tue Feb 18 13:16:54 EST 2003:         DROP TABLE BOTSCHED .... Success
Tue Feb 18 13:16:54 EST 2003:     End
Tue Feb 18 13:16:54 EST 2003:   Start creating...
Tue Feb 18 13:16:57 EST 2003: SQL: CREATE TABLE BOTPARMS (
SCHEDULEID           VARCHAR(12)                            NOT NULL ,
TASKID               VARCHAR(12)                            NOT NULL ,
PARAM_NAME           VARCHAR(64)                            NOT NULL ,
PARAM_VALUE          VARCHAR(255)                                    ,
PARAM_TYPE           VARCHAR(12)         DEFAULT 'String'   NOT NULL ,
PARAM_XTYPE          VARCHAR(12)                                     ,
PARAM_INDEX          CHAR(2)             DEFAULT '00'       NOT NULL ,
PRIMARY KEY (SCHEDULEID,TASKID,PARAM_NAME,PARAM_INDEX))
Tue Feb 18 13:16:57 EST 2003:         CREATE TABLE BOTPARMS .... Success
Tue Feb 18 13:16:57 EST 2003:     End