Search found 60 matches
- Fri Jan 03, 2014 3:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error running any job with lookup stage
- Replies: 6
- Views: 5414
- Fri Dec 27, 2013 8:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error running any job with lookup stage
- Replies: 6
- Views: 5414
Data is about 100 rows from reference, we have about 800K records from the source. the sort is carried out in the query, so we don't have any sorts applied in data stage. disk space on scratch is about 20% and on the server it is 27%. swap memory utilization is 50% at any time, when the job was in w...
- Fri Dec 27, 2013 7:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error running any job with lookup stage
- Replies: 6
- Views: 5414
the queries are fine, remove lookup stage, dump both the main query, and lookup data to peek stages, the job is done in 30 seconds.
as soon as the process kicks off, it gets into a dormant state, it waits forever, till we logout the PIDs from director, attempting to release resources was unsuccessful
as soon as the process kicks off, it gets into a dormant state, it waits forever, till we logout the PIDs from director, attempting to release resources was unsuccessful
- Thu Dec 26, 2013 9:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error running any job with lookup stage
- Replies: 6
- Views: 5414
error running any job with lookup stage
Hi, i have few jobs, well any job with a lookup or a join stage getting hung in my testing environment All these jobs have a common flow We read from Oracle Database, use a lookup stage to lookup data from Oracle DB, and write data to a Dataset What we did to verify? we checked with the DBAs , there...
- Mon Dec 03, 2012 3:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows to single row
- Replies: 9
- Views: 5928
- Mon Dec 03, 2012 3:17 pm
- Forum: General
- Topic: DataStage Client Connection issue
- Replies: 11
- Views: 11152
- Mon Dec 03, 2012 11:34 am
- Forum: General
- Topic: DataStage Client Connection issue
- Replies: 11
- Views: 11152
Hi Ray All the services on all the tiers are working. Everyone else from the team is able to connect to this server without any issues The login issue from the client machine is not specific to a particular datastage server. This machine cannot connect to dev, sit, uat or prod using any login creden...
- Thu Nov 29, 2012 5:18 pm
- Forum: General
- Topic: DataStage Client Connection issue
- Replies: 11
- Views: 11152
- Thu Nov 29, 2012 1:56 pm
- Forum: General
- Topic: DataStage Client Connection issue
- Replies: 11
- Views: 11152
DataStage Client Connection issue
Hi All I am having trouble in setting up access for one of my team members. We keep running into the error message pasted below Also, below are the checks i have made 1. Uninstalled and re-installed the client after cleaning the registry entries 2. listed the IP address in Hosts file 3. ping and tel...
- Wed May 18, 2011 11:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Import DS Macro ?
- Replies: 9
- Views: 6981
- Thu Mar 31, 2011 8:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: getting error when compiling the Datastage job
- Replies: 12
- Views: 35406
uhho .. i am on the same boat, I have installed the Information server, as we still haven't got the licences for the C++ compiler (we were over excited to install the tool :oops: ) when we had a similar problem on 7.5 we changed the default path for parameter - APT_COMPILER to the local point where ...
- Wed May 19, 2010 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String Comparision fail
- Replies: 6
- Views: 4572
- Wed May 19, 2010 9:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String Comparision fail
- Replies: 6
- Views: 4572
- Wed May 19, 2010 9:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String Comparision fail
- Replies: 6
- Views: 4572
Sai Sample of the input data set i get 01,COS 02,chasidh,dasdasd,asdasdasd,wdfddwasd, 03,dsfds,dsasd,asdasd,asdasdas, 04,dfoprewo,qwqe,reteererqwe 01,MOS 02,chasidh,dasdasd,asdasdasd,wdfddwasd, 03,dsfds,dsasd,asdasd,asdasdas, 04,dfoprewo,qwqe,reteererqwe 01,FOS 02,chasidh,dasdasd,asdasdasd,wdfddwasd...
- Wed May 19, 2010 8:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String Comparision fail
- Replies: 6
- Views: 4572
String Comparision fail
Hi alll I have an issue while reading data from a comma delimited file. There is a simple if then else statement in a stage variable which does basic string comparison if Field(trim(Lnk_Src_Socn.Field002),",",1) ='COS' Then 'Type1' else if Field(trim(Lnk_Src_Socn.Field002),",",1)...