Graphical tools using first occurrence data capture (FODC)

If you find you are required to investigate Data Warehouse Center, or Information Catalog Center problems, there are logs that contain information about the probable cause for the difficulties you may be experiencing.

Data Warehouse Center IWH2LOGC.log file
  • Operating system: All
  • Default location: Located in the directory that is specified by the VWS_LOGGING environment variable. The default path is the $DB2PATH\sqllib\logging directory on Windows and in the $HOME/sqllib/logging directory on Linux® and UNIX, where HOME is the instance owner's home directory
  • Created automatically by the Data Warehouse Center if the logger stops.
  • Contains messages written by the Data Warehouse Center and OLE server that could not be sent in the situation where the logger stops. This log may be viewed using the Log Viewer window in the Data Warehouse Center.
Data Warehouse Center IWH2LOG.log file
  • Operating system: All
  • Default location: Located in the directory that is specified by the VWS_LOGGING environment variable. The default path is the $DB2PATH\sqllib\logging directory on Windows and in the $HOME/sqllib/logging directory on Linux and UNIX, where HOME is the instance owner's home directory
  • Created automatically by the Data Warehouse Center when it cannot start itself or when a trace is activated.
  • Contains diagnostic information for situations when the Data Warehouse Center logger cannot start itself and cannot write to the Data Warehouse Center log (IWH2LOGC.log). This log may be viewed using the Log Viewer window in the Data Warehouse Center.
Data Warehouse Center IWH2SERV.log file
  • Operating system: All
  • Default location: Located in the directory that is specified by the VWS_LOGGING environment variable. The default path is the $DB2PATH\sqllib\logging directory on Windows and in the $HOME/sqllib/logging directory on Linux and UNIX, where HOME is the instance owner's home directory
  • Created automatically by the Data Warehouse Center server trace facility.
  • Contains Data Warehouse Center start up messages and logs messages created by the server trace facility. This log may be viewed using the Log Viewer window in the Data Warehouse Center.
Information Catalog Center tag file EXPORT log
  • Operating system: All
  • Default location: The exported tag file path and log file name are specified in the Options tab of the Export tool in the Information Catalog Center
  • Generated by the Export tool in the Information Catalog Center
  • Contains tag file export information, such as the times and dates when the export process started and stopped. It also includes any error messages that are encountered during the export operation.
Information Catalog Center tag file IMPORT log
  • Operating system: All
  • Default location: The imported tag file path and log file name are specified in the Import tool in the Information Catalog Center
  • Generated by the Import tool in the Information Catalog Center
  • Contains tag file import history information, such as the times and dates when the import process started and stopped. It also includes any error messages that are encountered during the import operation.