DSXchange

Best to pre-qualify your work with a lookup so you don't tell it to update or delete non-existent records. This is DB2, is it not?

There's no such thing as far as I know, it doesn't seem to maintain a log like that. I believe you can create a file called "errorlog" in the DSEngine directory and it will log certain problems there but it doesn't track the kind of 'activities' you are looking for from what I remember.

Is the user it executes under different between the manual and scheduled runs?

Or that.

Thanks Phil, I'll have to give that a go later on a spare dsx I have hanging around.

Or some sort of bulk load process, unless that is what the DB2 API stage is already doing for you.

"You" assigned a metadata repository database when the product was installed, typically Oracle or DB2. The actual XMETA database tables are not published and the only "correct way" of accessing this information is via the client tools that ship with the product.

ps. DRS stage <> speed up the process.

You have to start from either $DSHOME or a Project directory to avoid that question... which should always be answered 'NO' by the way.

You need to see if those "modules" it couldn't load actually still exist and where they are and then ensure your paths in the $DSHOME/dsenv file are still correct.

Probably. A search would reveal other possibilities.

Exactly. Take it to your DBA.

Right, I understand you have a workaround and I'll wager this 'ETL solution' you inherited is way more complex than it really needs to be. Problem is without seeing the big picture or having access to all that code it would be difficult for anyone on this side of the glass to really pinpoint the iss...

Can you describe your server hardware and setup / architecture plus where all of the 8.x components are installed? Co-located or separate servers? I'm thinking hardware or network related.

No, but you can add new fields in the transformer to carry the column names and populate them 'manually' since you know what they are at design time.

Chuck Smith publishes a free 'tool' on his website that would help with this. A search here for OLETYPE might turn up a query you could modify to do this as well.