DSXchange

I use google reader, works very well for me and is accessable from any computer...

Great! I didn't realize this "hidden" property. I just focused on the format tab in the sf-stage.

By the way, do you know why the prefix only shows on records longer than 35 bytes and not on shorter?

Hi, I am trying to write a simple sequential file on unix using a sequential file stage through a parrallel job. The thing is that I can't get rid of a 1-byte record prefix in front of any record longer than 35 letters. All rows longer than that gets a 1-byte prefix. My schema is very simple; 1 colu...

When you add a job activity that is a multiple instance job to a job sequence, a field will appear where you give that activity an instance name. This field can be populated with a job parameter or any other activity control in your sequence.

if you cant write db2 connect to [databasename] user [user] using [password] from the unix prompt then you can't connect using datastage. Talk to your dba's and make them confirm your settings and when you've connected to the database via the prompt then you can proceed and try it through datastage.

SQL30061N The database alias or database name "DATVT000 " was not
found at the remote node. SQLSTATE=08004

This means that your db-connection is not set up (catalogued) in your db2 client utility. Correct and try again.

I am not sure that we did something really wrong, but we had a consultant which implemented transformations in parrallel jobs using a BASIC tarnsformer and we had problems with all those jobs every 3-5 run, where the job would fail due to broken pipes. I spent 4-6 month recoding every job into paral...

Ok, thanks ray!

So as soon as i have a reject link available in a db-stage i need to handle any possible sql insert or update error.... In this case i will built a over 1 record termination...

I don't think you can have non-recoverable true and cleanup on failure true set at the same time, however if your set cleanup on failure true and non-recoverable false and your operation aborts then the database will do a rollback.

Hi, I have a strange problem. We are using db2 v9.1 dpf plus range partitioning. I have a job with a db2ee-stage upsert, where i've used user-defined insert and update statements. I was trying to insert data outside the range partitions and got the following fatal error in the datastage logs! Primar...

Hi, there is a setting in the db2 enterprise stage called "cleanup on failure" set it to true and your table will be as it was prior to the load, however your job will end ok and that might not be what you wish for. Just, read about the available parameters carefully and understand the con...

Are you saying, that since there is only one APT_DB2INSTANCE_HOME per project I somewhat get lock to one target database instance per enterprise job? Did I understand it correctly when; Each stage has parameters populated by from job properties, and they are of course different, but that doesn't rea...

Sometimes when I have multiple db2 target databases which I want to load through the db2ee-stage I encounter a problem in one of the db2ee-target stages; Fatal message in director: db2LaddaStyrtabell: Currently connected to a different database: uvods3. I've tried the job using apt_disable_combinati...

Well, The db2 enterprise stage does 2 things while inserting ocr loading data. 1. It sends a SQL via db2 connect (or some client utility) to the db2 system cataloge to find out how the db is partitioned, when that process is completed. Data can be spread to the correct node for local processing. 2. ...

What settings have you specified in the enterprise stage?