DSXchange

Sure, thanks for your time ogmios. Really appreciate it. The error message i posted in my previous post, is this due to the fact that i have different servers for DS and UDB, or this error is because of some property that i failed to specify correctly :?: Thanks once again for all your help guys Gu...

djdinjan wrote:Hi Ray, thanks for the information. Looks like you have forgotten to mention the command you wanted me to run.

Thanks,
Dinesh

UVFIXFILE DS_RESENU (or fixtool in newer versions).

A little bit off-topic but what I would do for the original problem would be to load all files to a database table and then use aggregation via SQL on the database using a DB2/Oracle stage. The aggregator stage doesn't work well with large input sets.

Ogmios

Right now without DataStage access... will try to look it up tomorrow. The "problem" with the DataStage DB2 Load stage is that the control file it generates is not very flexible and that it uses a kind of spool directory, and this requires the same directory to exist on the remote db2 serv...

I always put array size to 1. We've got bitten once that when a error occurred in a job using array size > 1 all rows in the same "array" got the same treatment and not only the row causing it (in our case all were rolled back). This behaviour changed between Datastage versions, so we just...

From personal experience, the DB2 load stage is much slower then if you would write your own UNIX load statement via a shell script. So although the stage is nicer to use, we use shellscripts to load data for the raw speed. Also if the DB2 database you want to load to is on a different server than t...

Oracle only locks rows on updates, never on reading. So if you can make sure that for writing/updating DataStage only uses 1 Oracle "connection/session" you don't have a problem. But it may require some creative rewriting of the DataStage job. Use a link collector and you should be fine (i...

The original solution works for as long as you don't exhaust transaction log space (because it's a single transaction), this depends on the database settings and width of a single row. Usually this works for upto +- 400.000 rows, not for millions. Solution is to have actual input on the left hand si...

If you would replace your sequence job with a true BASIC job you can do what you want (but it's a little bit more work). With sequences, not that I aware of.

Ogmios

I would first make sure the script works outside of DataStage running under the user that would execute the DataStage job. If you can get it to work like that the problem you're having with DataStage is an "integration" problem. So can you already make it work outside of DataStage? If it d...

Hi frens, I do have the 10,000 rows of data and the job get aborted while loading into warehouse after loading 5000 rows. How to hadle this situation to load it from 5001 record... There's nothing automatic in DataStage for that. You have to make your own restarting. Some options: - put the load in...

Answer is easy, had it already a few times... in Oracle whatever you read within 1 query is the data that existed at the moment the query was started.

Ogmios

On the machine where the DataStage server is installed you will need to install a DB2 client. Configure the DB2 client and configure DataStage to use the DB2 local instance.

Ogmios

If you just want to test DataStage/Informatica, Ascential/IBM offers time limited trial licenses via their sales people (charged per month), not sure about Informatica.

At a price both are willing to come on site and help you on your specific project as consulting services.

Lately I would also consider "Doing It Yourself"... for DataStage/Informatica you don't pay once... you pay the initial fee, yearly maintenance fee and you're stuck with upgrading in the timeframe the tool-company dictates (unless you want end up using unsupported software) and you're very...