Log file correlation schemas

There are different types of log file correlations, depending on the correlation schemas that you select:

• Correlation by Time
• Correlation by URLs and Time
• Correlation by Application IDs and Time
• Correlation by URLs, Application IDs and Time
• Correlation by Host Name, Database Name, Application IDs and Time
• Correlation by PMI Request Metrics

Correlation by Time
Any of the log types can be displayed by time-based sequencing. When two records have the same timestamp, they will be correlated with each other.

Correlation by URLs and Time
This type of correlation can involve multiple access logs, error logs, and trace logs, and will correlate logs by sequence and those that are closest in time.

The following are examples of such correlation:

• IBM^(R) HTTP Server access log to IBM WebSphere^(R) Application Server trace log correlation
• IBM HTTP Server error log to IBM WebSphere Application Server trace log correlation
• Apache HTTP Server access log to IBM WebSphere Application Server trace log correlation
• Apache HTTP Server error log to IBM WebSphere Application Server trace log correlation

Correlation by Application IDs and Time
This type of correlation can involve multiple diagnostic logs and trace logs, and will correlate logs by application IDs and time.

The following are examples of such correlation:

• IBM DB2^(R) Universal Database^TM diagnostic log to IBM DB2 Universal Database diagnostic log correlation
• IBM DB2 Universal Database diagnostic log to IBM DB2 Universal Database JDBC trace log correlation
• IBM WebSphere Application Server trace log to IBM DB2 Universal Database diagnostic log correlation
• IBM WebSphere Application Server trace log to IBM DB2 Universal Database JDBC trace log correlation

Correlation by URLs, Application IDs and Time
This type of correlation can involve multiple access logs, error logs, diagnostic logs and trace logs, and will correlate logs by sequence and those that are closest in time and then by application IDs and time.

The following are examples of such correlation:

• Apache HTTP access log to IBM WebSphere Application Server trace log to IBM DB2 diagnostic log correlation
• Apache HTTP error log to IBM WebSphere Application Server trace log to IBM DB2 diagnostic log correlation
• Apache HTTP access log to IBM WebSphere Application Server trace log to IBM DB2 JDBC trace log correlation
• Apache HTTP error log to IBM WebSphere Application Server trace log to IBM DB2 JDBC trace log correlation
• IBM HTTP Server access log to IBM WebSphere Application Server trace log to IBM DB2 Universal Database diagnostic log correlation
• IBM HTTP Server error log to IBM WebSphere Application Server trace log to IBM DB2 Universal Database diagnostic log correlation
• IBM HTTP Server access log to IBM WebSphere Application Server trace log to IBM DB2 Universal Database JDBC trace log correlation
• IBM HTTP Server error log to IBM WebSphere Application Server trace log to IBM DB2 Universal Database JDBC trace log correlation

Correlation by Host Name, Database Name, Application IDs and Time
This type of correlation can involve multiple trace logs, and will correlate logs by application IDs, host name, database name and time.

The following are examples of such correlation:

• IBM DB2 Universal Database DRDA^(R) trace log to IBM DB2 Universal Database JCC trace log to IBM WebSphere Application Server trace log correlation
• IBM DB2 Universal Database DRDA trace log to IBM DB2 Universal Database JCC trace log correlation
• IBM DB2 Universal Database DRDA trace log to IBM WebSphere Application Server trace log correlation
• IBM DB2 Universal Database JCC trace log to IBM WebSphere Application Server trace log correlation

Correlation by PMI Request Metrics
This type of correlation can involve multiple trace logs, and will correlate logs by PMI Request Metrics.

The following are examples of such correlation:

• IBM WebSphere Application Server trace log correlation
• IBM WebSphere Application Server trace log to IBM WebSphere Application Server trace log correlation

Related concepts
Determining problems in distributed applications

Related tasks
Correlating log files
Viewing correlations in log interaction views
Providing correlations for log interaction views

(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.