Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Log files in a Real Time (or close to) Environment
Go
New
Search
Notify
Tools
Reply
  
Log files in a Real Time (or close to) Environment
 Login/Join
 
Member
posted
Does anyone have a way to handle the log files when running the ETLs on a constant basis? We currently run ETLs to load our Data Warehouse at night on a scheduled basis and want to go to a more frequent basis throughout the day. Currently before our nightly ETL load of our tables to the Data Warehouse, the logs are backuped and cleared out.

Any suggestions on how to handle this is appreciated.

We are on version 7.6.10.
 
Posts: 9 | Location: St. Pete, FL | Registered: January 04, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Hi Deanna,

Can you please provide a little more details on what you are trying to do? For example, what exactly you mean by "handle the log file"? What is not currently being handled properly? What is the problem you are having?

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
Member
posted Hide Post
I was under the impressiong that the log files were limited to 2 GB, but I just now found that they can be increased to 16 GB by adding the XFOCUS file format to the master file.

I think that it is going to solve my concern. We currently have a process that runs nightly to recreate the logs before our nightly run loads. We are going to be updating our Data Warehouse on a more frequent basis and the concern was on how to prevent the log file from filling up during the day before it reaches the scheduled recreation.
 
Posts: 9 | Location: St. Pete, FL | Registered: January 04, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Log files in a Real Time (or close to) Environment

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.