DSXchange

Hi Experts,

I am working on a development environment which is extremely slow on Designer. The jobs take ages to open. I suspect something wrong with the XMETA repository. How do I check if the repository is running out of space? Where can I find the XMETA connection parameters?

Thanks,
Varun

Thanks Ray, I havnt set it at a project level. This message handler is set only at a job level. A different message handler is in use at project level

Hi, I had created a message handler to suppress some warning and I was using that as the default handler for some of my jobs (From job properties set the default handler to this one). My problem now is that the messages are getting suppressed even after I removed the handler from job properties and ...

I used a terminator activity flowing to a user variable stage on to the notification stage. This works fine.. No need for a routine

Hi AndrW, I checked the db2diag file in the DB server.. Could find something like the below.. I enabled tracing in the director.. Didnt find anything in that.. What other logs should I check? 2012-10-27-09.46.28.453596+330 I10266850A450 LEVEL: Event PID : 16711862 TID : 1 PROC : db2stmm (P3D2_SIT) 0...

Hi Experts, I am facing a very strange issue with ODBC stage. I am using RCP in my ODBC stage and passing the query as parameter to it. The job works fine for many queries.. But in one big query it extracts very few records and "COMPLETES EXTRACTION WITHOUT ANY ISSUES IN THE LOG". I would ...

Hi, I have created my DS jobs without any partitioning and on a single node configuration. If I change these jobs to run on a multi node environment , is there any chance of duplicates getting generated in data? I remember I had faced such an issue some time back in another project. Please advice Th...

Hi ArndW,

Tried that but didnt help. There are no special column types in the table.

Thanks,
Varun

Hi ArndW, This is a write stage with UPSERT.. No custom SQL is used. The data volume is only in the 100s .. No big columns also. So the data size is less. The job barely takes 10 secs to execute. I had tried removing the SCD and doing a direct insert into the table. This works fine. The SCD /upsert ...

Hi,

I have a DB2 table which is having around 30 columns. I am using SCD staging in DS 8.1 to do SCD on this job. But the job aborts with the below error
[IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver]Out Of Memory

Any help is highly appreciated

Thanks,
Varun