Search found 32 matches
- Tue Nov 22, 2011 3:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Character set conversion in DataStage job
- Replies: 3
- Views: 6935
Character set conversion in DataStage job
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 ...
- Mon Nov 14, 2011 8:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RT_LOG corrupt at 2GB
- Replies: 2
- Views: 2781
RT_LOG corrupt at 2GB
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...
- Tue Sep 13, 2011 7:23 am
- Forum: General
- Topic: NLS Error in DSExecute routine
- Replies: 3
- Views: 17391
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...
- Tue Sep 13, 2011 3:53 am
- Forum: General
- Topic: NLS Error in DSExecute routine
- Replies: 3
- Views: 17391
NLS Error in DSExecute routine
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...
- Thu Mar 24, 2011 2:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-12541: TNS: no listener
- Replies: 4
- Views: 10530
ORA-12541: TNS: no listener
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
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
- Thu Feb 03, 2011 4:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sql query as parameter
- Replies: 3
- Views: 3008
- Wed Feb 02, 2011 9:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sql query as parameter
- Replies: 3
- Views: 3008
Sql query as parameter
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...
- Wed Jan 26, 2011 8:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query on Runtime column propagation
- Replies: 2
- Views: 3949
Re: Query on Runtime column propagation
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
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
- Tue Jan 25, 2011 8:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query on Runtime column propagation
- Replies: 2
- Views: 3949
Query on Runtime column propagation
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...
- Thu Jan 20, 2011 10:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with dsjob command
- Replies: 0
- Views: 1648
Issue with dsjob command
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...
- Thu Dec 30, 2010 10:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query on Lookup job score
- Replies: 1
- Views: 2704
Query on Lookup job score
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...
- Thu Dec 30, 2010 6:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query on SAN filesystem
- Replies: 4
- Views: 3475
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...
- Wed Dec 29, 2010 4:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find if job is IO limited
- Replies: 4
- Views: 2649
- Wed Dec 29, 2010 4:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query on SAN filesystem
- Replies: 4
- Views: 3475
- Wed Dec 29, 2010 12:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query on SAN filesystem
- Replies: 4
- Views: 3475
Query on SAN filesystem
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...