DSXchange

Yes if you cpu is saturated you will have degragation. Just a thought. I did a little testing once. I have a 4core machine. So I set up four config.apt one node two node three node four nodes. I then ran a batch with some jobs in it on a one node and got my time. I then ran on two nodes , the time w...

The problem is that there is no index on the where clause columns, and keep in mind the order of the columns makes a difference. By that I mean that the order of the columns in the index needs to match the order of the columns in the where clause. What happens is that a job when trying to update wil...

Why not write a routine that reads the file and puts the value into an argument of the routine. You can then use the routine stage in the sequence to get the value and direct the flow.

I do it and it works fine.

Nutcracker is part of the MKS package which is installed when datastage is installed. It is what manages all the osh processes through a wrapper.

Currently we have 4-Node configuration and am thinking of recreating with 8-Node configuration? So what gains do you think you will get by doing this. do you have 8 controllers? do you have at least 4 cores. Increasing your config will increase the amount of sectionleaders (osh) processes to eight a...

I had the same issue on SQL server
I added the option maxdup = 0
this option limited the sql to a single process instead of 10
maybe there is a sim option in DB2

You might check for a function in the database you are sourcing the data from and convert the data in the select statement.

Are you referring to the right side of the decimal? I did this and got that create table gregg( myfloat float, myfloat2 float ) Insert into gregg values( 000004876274.70, 0006.0300) select * from gregg myfloat myfloat2 4876274.7 6.03 I defined both numbers as char(putting quotes around them) same re...

create a job with just that stage in it.
Then run the job
the output will be in the director log in one of the messages as I showed earlier.

You have to run it there is no show data option.

yes Surrogate_Key_Generator I built a server process which uses routines and a comma delimited list as a parameter. The list contains a list of all the tables, Dims. The routine contains a case statement which contains all the tables and what their key column name is. my job takes the table name fro...

I am still pondering the reason you would want to do that.
I would think you would want the max number already being used in production.

I am assuming you have watched this job run from director and are not receiving a warning message for each row processed.

Have you confirmed that the records are actually going in the tables.
600000 rows to a DB2 should be less then 5 min. It is on my system anyway

Also you don't need a peek stage to see the contents of a state file. Just a generator and set the View stet file property to yes. and you will get this message Surrogate_Key_Generator_0,0: Content of state file D:\DW_PROJECTS\1_DSProjectDataFiles\PROJ_CORP_DataWareHouse\SurrogateKeys\201\201_tDim_B...

Well the first question I would ask is. Are both config.apt file identical as far as how many nodes are defined. If test has 2 nodes and Prod has 4 nodes your results are not going to be what you expect. and you will get duplicate keys when you run it in prod. Heres why if you are running on two nod...

As I wrote in my earlier post I have 8.01 installed on server1 I have 8.5 32bit server installed on server2 I have 8.5 64bit server installed on server 3 I have the client tools for 8.0 and 8.5 installed on a VM server (vertual Machine) I can access all three servers from the one VM server using the...