DSXchange

The main bottleneck in the job would be doing a lookup directly to the database. For every row that passes through the job it has to go off and do a select on the database. This will have a big overhead. I suggest changing the DB2 API stages to hashed file stages as well as generating the surrogate ...

Ray, the site I am at has not only numerous machines but also several instances of DS on many of them. Although originally intended for temporary use during migration, they work out quite well. They are almost a 24x7 operation and "bouncing" a DS instance can take days to arrange, with mo...

I am interested in what scenario you would need two instances of the same Datastage Server version on the same box. Just out of curiosity

From memory you have to have lotus notes installed on the datastage server as well. There was a problem with a certain version that a site I was working on was using. Version 4.X something. When to version 5 and there was no problems. For the lotus notes database that I was connecting to I had to ha...

Happy to join the DataStagers team.

Will set up the software when I get home today.

You want the max of the sequence number for each of the rows you pass through?

Sasi: I believe the person was trying to find the client software installed on the server.

That is why they only see the datastage package installer.

If it is urgent then I suggest you contact the vendor from which you bought the product. You import the dsx from the datastage manager client. This imports the dsx onto the datastage server so that everyone can access and use what the dsx file contains. Under the tab Import select the datastage comp...

Off the top of my head I believe that the change you made will only affect new jobs created in that project.

The old jobs in your project would not have had their auto-purge changed.

Tim

If you have have alot of big text files you want to have sorted then I suggested having a look at syncsort.

We implemented it at the last datastage project I was working on. The time this program takes to sort large text files is amazing.

Naveen,

Glad you found the problem. :D

I am surprised that the error was saying that it was on line 306. I would have thought it would have been a couple of lines up.

Tim

Looking at the code you must have a rejected link defined in a transform stage? What is in the contraint for this link? * Column derivation code for pin DSLink4 Pin%%V0S1P2.Column%%4 = (Pin%%V0S1P1.Column%%4[1, 8]) Pin%%V0S1P2.REJECTED = @FALSE Are you trying to compare something on the input side t...

Looking up the number 6033 on google I found the error message

6033 "Number of bound columns exceeds the number of result columns."

Check the number of columns your query is returning and how many columns datastage thinks the query should be returning.

Tim

Hi Kish,

Yes you can upgrade from 5.2 to 7.5.

There has been a couple of posts just recently about the challenges, changes and things to look out for.

Do a search on upgrading datastage.

Tim

I think the original point was missed that he can't get access to the UNLOCK command.

Kame: I suspect your problem is that you have not been granted connect access.

Have a look at the link below.



viewtopic.php?t=81459&highlight=grant