DSXchange

My server has been up at 100% CPU all day. My theory (based on history) is that there is a job that has some poor code in it and is looping around and around, sucking up CPU. I will be rebooting when I have a window, but in the mean time, I'd like to figure out which job is out of control. Is there ...

Kenneth, thanks. That was my initial concern. By Enterprise scheduler, you mean a scheduler to incorporation both systems, not just the Data Stage server, right? One major complication to that is cost (of course). Trying to justify the purchase of such an application will be difficult knowing my org...

Our Data Stage ETL processes support a large data warehouse. In an effort to minimize lag between data entering our AS400 production box and the data entering our data warehouse my boss has asked me to investigate ways in which Data Stage jobs can be executed with external scripts. The work flow wou...

thanks!

I'm sorry. This is just needed to pass the correct table name. Its the table name that has the 'mmyy' at the end.

I have a job that extracts a monthly table. The table has the 2 digit month and year format at the end. this is what I've been using If ReportDate = 0 Then ReportDate = CONVERT("/","",OConv(@DATE - 7, "D/MY[Z,2]")) End It worked normally........until we rolled over to J...

thanks!

does anyone know the link to open a ticket with IBM?

thanks!

is there any stage that can do that?

can the pivot stage do the opposite. I have a query that returns 11 rows in one column. I'd like to split those up into 11 columns and one row.

There is a FAQ that may help. Here is the viewtopic.php?t=95371

thanks for all your help and I'm sure you're sick of looking at this thread by now. I've gone into the odbc stage, included the column owner, marked it as key. Included that column in the SQL statement and in the where clause select owner, sum(bytes) from dba_segments where owner = 'ACCT_HIST' group...

my apologies and thanks. I'll give that a try

Please note there are only 10 links as I deleted one fo them.





[/img]