DSXchange

can only agree with the 'dont just forklift' the database comments - to be honest it probably will work if you dont spend much time tuning - but will be wasting a lot of expensive clock cycles. Have been through a db2 ---> teradata migation a few years back (~3000 jobs) and a few points bar the fork...

I believe this is down to assess of the sync table (presuming syncronisation is on in the connector stage) My understanding is there is a table (specified by TPT_TERASYNC env variable) which is used by datastage to co-ordainate and check point Teradata connector processes. As teradata queues access ...

I havent got Datastage infront of me at the moment - but another approach would be to use parameters to specify the names of the rpt files You can use an activity variable stage in a sequencer to pass in the name of the file (or even just an extention) based on a timestamp As I say I havent got data...

Actually as Ray et al have said it could be a problem with having single user license - though should point out I had a simalar problem with our compiler - and was actually just down to not being registered correctly. We had concurrent license but hadnt been set up correctly - so the compiler toddle...

Hullo, I suspect the final error (3807) is down to the previous error concerning the error tables 03:56:17 UTY1008 RDBMS failure: 3807, Object 'EDW_STAGE.STATUS_S_WE411_ET' does not exist. Basically when the multiload starts it attempts to drop any error tables first, though these will only get left...

sorry should have said

insert from a Dataset using Teradata connector in immediate mode (delegates to Teradata Call Level Interface API)

Hi - anyone seen this before - using the TDconnector stage on a job to do an insert into table - only about 20 or so fields And get the following error - however looking at the documentation it suggest that the limit is about 1mb for the sql statement and nowhere near that Just wondered if a bug - a...

It was simply a case sensitive problem ...

ParamVal = DSGetParamInfo(JobHandle, pCLEANSEDFILE, DSJ.PARAMVALUE)

Am trying to extract a parameter value from the last time a server job was ran using .... JobHandle = DSAttachJob(JobName,DSJ.ERRNONE) ParamVal = DSGetParamInfo(JobHandle, pCLEANSEDFILE, DSJ.ParamValue) I then output both the job name and parameter value (for param pCLEANSEDFILE) but whereas I get t...

hi - you dont seem to have the orchdb2 operator installed - are u sure db2 was specified when u did the install (I am looking at a v7.5 install so may be different on V8) You also need to watch out as I believe DSV8 can talk to both V8 and V9 of DB2 - however if you dont specifiy db2 version at inst...

possibly not related - but have experienced a simalar problem on AIX - though not to the extent you are seeing. Our issue was that the vacpp compile wasnt licensed correctly - (legally yes - tecnically not) So what was happening each time we kicked off a compile - it would sit there for several minu...

Just wondering where the default for the sync timeout property is set on the teradata connector stage. We want to change is project wide - I was kind of expecting to find an enviornment variable for it but none there through Admin However wondering if one existss that can be added (dont believe all ...

We have a handful of demoted messages on our v7.5. implementation via a project level message handler. However the message IDs are different on Version 8 (partly coz prefixed with IIS - but even taking that into account - doesnt seem to be 1-1 corrolation) Is there anyway of mapping v7.5. messages t...

not sure if the last suggestion helped - I hit this problem a while ago with routines and transforms and the basic response from IBM was 'dont import readonly objects' Ok they may have said please I personally think this is a major problem as it is easy to do when migrating from a v7 enviornment to ...

never got a solution - logged with IBM but the solution was - 'Dont import readonly objects' Sorry just popping out as a hear a stable door banging in the wind. The issue is that it is quite easy to do this and although I believe the behaviour is correct (i.e. dont delete a readonly object) as you c...