DSXchange

Hi, My job is reading data from Oracle DB in Western European character set and writes it to a flat file. Now in another job I want to read this file and write the data to another file through a transformer in between, but in UTF8 character set this time. I tried changing the NLS map to UTF8 in the ...

Hi All, RT_LOG for few jobs are exceeding 2GB limits causing the job to hang. Every time this happens we have to kill the hung job and clear the RT_LOG using CLEAR.FILE Autopurge is set to execute every 5 run of job, which we need to do any troubleshooting. Is there a way to control the log corrupti...

Hi Craig, Thanks for helping me out. I checked the NLS_LANG in both DS job log and DB and it is some i.e. NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1. And as you pointed, this is happening in other project too, not just the new one. Another thing is, OCI stage is running fine in both the projects. When I...

Hi, I'm using DSExecute routine in a batch job to run some sql in oracle DB. DSExecute calls a unix shell script which in turn connects to DB and execute a sql file with multiple sql statements. Job is running fine in old projects. We created a new project recently but the routine call is failing in...

Hi

I getting below error while running my PX job that connects to Oracle,

main_program: (aptoci.C:89). Message: ORA-12541: TNS:no listener

It was running fine sometime back. Not sure what caused this issue. Server jobs that connect to Oracle are running fine.

Please advice.

Thanks,

Shashank

Thanks Ray and Craig for clarification. I'm going ahead for now and will check with IBM on the Oracle stage limits.

Thanks,

Shashank

Hello All, In my job, I want to run multiple sql queries in oracle stage and pass the output to a sequential file using RCP. In parallel jobs, I can not provide sql in a file for oracle stage. This option is available with server jobs. This would have been first preference but looks like not possibl...

Hi James,

Thanks a lot, you saved my day. That was the issue, I was viewing from Dataset stage view data.

Really appreciate your help.

Thanks,

Shashank

Hi, I'm trying to use Runtime column propagation in DS8.1. Job: Oracle Ent ---> Copy ---> DataSet I have enabled RCP for project and checked the Runtime column propagation box in Oracle and Copy stage. I have defined metadata for 5 columns in Oracle and Copy stage but selecting 10 columns through us...

Hi, I'm trying to use the dsjob command to get some info about DS jobs from command line. Below command used to run fine in v7.5, but not working in 8.1. I added <-domain> as this was not there in v7.5 but still I get the same error "Unable to connect to project" dsjob -domain <server_name...

Hi, I was testing the lookup performance between a) when reference data is partitioned using Auto(which uses Entire) and stream data also Auto(may be round robin used here) b) when both data sets are sorted and hash partition is used. second option works faster as expected even with data skew. but I...

Hi Ray, Please find below a sample if/else I'm using in transformer. This is to check the data quality and provide an appropriate value and a message in case of issue. If IsNull(Lnk_SrcData.PATIENT_ACCOUNT_NO) Or Trim(Lnk_SrcData.PATIENT_ACCOUNT_NO)='' Then '~Mandatory Error - PATIENT_ACCOUNT_NO val...

Thanks Ray,

Really appreciate your help and patience.

Thanks,

Shashank

Thanks Ray,

Does the drastic drop in performance by adding more and more transformation to Transformer stage is the normal behavior of the stage or it indicates to some sort of resource crunch.

Thanks,

Shashank

Hi, We are on DS 8.1 on AIX server. The server is shared with few other applications as well. Some info on the system, 1) SMP system 2) 4 logical CPUs 3) 4GB Memory 4) SAN File system 5) Target DB on separate GRID We are not getting the desired performance even for simple jobs like OEE ---> Seq File...