DSXchange

Someone wrote to do a search on DS_AUDIT. I did ... That's the reason I posted this ...

Please provide helpful information.

Newbie question ... I'm trying to create a clean report (rtf, html, comma-delimited) that will provide the following information: JOB_NAME Date of Last Modification Changes Made *** I realize that the changes made is wishful thinking ... Wondering how others are managing version control as well ... ...

They are still HASH files ... I believe we are on 8.1 for SUSE

Actually, sometimes the obvious bites you on the butt!!! After spending countless hours and not sleeping for three days, I took a wild stab and change the prune setting on the log files to 1 day. Then, I cleaned the log files ... Started my cycles ... Run Times for my environments went from 30 - 40 ...

Help!!! So ... We have been tracking the times that the jobs run themselves ... The jobs fly ... In and out in seconds ... The issue appears (but not certain) in Datastage ... We have approximately 80 jobs that all run sequentially ... All of the jobs were being checkpointed ... We removed 80% of th...

That cleaned out the phantom files ...

Unfortunately. no improvement ...

We are thinking about updating the statistics on the xmetadb to see if that would help.

We are also removing our temporary hash files that we use in the process to see if that helps ...

Got the command ...

We'll see how it goes now ...

Thanks!

Craig,

Not to sound stupid ... Should I bring down DS? or simply stopping running the jobs????


Thanks!! Very Helpful Info!

Fair enough ... We have been monitoring through Director ... It is unfortunate that we cannot repeat the same "lag" between jobs / job sequences. For example, the Master Job Sequence will start, then a minute later the first job in the Sequence will start. It will run for 10 seconds, then ...

OK ... Here are more specifics: Same data volume. Same exact data set ... I run the Master Job Sequence that calls a set of job sequences SEQUENTIALLY. 1st Run - 12 minutes Empty the staging tables, and Data mart tables. 2nd Run - 12 minutes Empty the staging tables, and Data mart tables. 3rd Run - ...

We are running fiber channel to our SAN ... We have been monitoring activity on the network and the SAN. There are no spikes in either when this inconsistency occurs. It's not a bandwidth issue. We are 2 GIG-E fiber ... That's not the problem ... And the network has limited sharing. We have noticed ...

I'm getting inconsistent performance times with Datastage on a recurring basis for the same volume of data being processed. Brief Description: 1 Project - Multiple sequences executing SEQUENTIALLY. The first run completed in 12 minutes (overall data processed 200 MB). The second run in 12 minutes. T...

I really think it's a DB2 thing ... My experience with Teradata, Oracle, Ingres, and SQL Server using other ETL tools (e.g. Ab Initio, Informatica) have never had this issue ....

[quote="chulett"]Sometimes known as an "O-with-dots", the dots are a diacritic mark known as an [url=http://en.wikipedia.org/wiki/%C3%96]umlaut[/url] or diaeresis or trema as well, it seems. So "O-umlaut". :wink: Is your install "NLS enabled"? Assuming yes, bu...

I'm running into a strange issue ... I'm running Datastage Server v8, DB2 9.5 on SUSE Linux. Here's the deal: I have a person's name that contains the O with two dots on top (sorry don't know the name of that character). I can insert the name with no issue. I can substring out the first character in...