Search found 28 matches
- Tue Apr 19, 2011 12:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Doing Maximum of character column in an Aggregator
- Replies: 6
- Views: 8044
I faced the same issue. I was grouping on Column X,Y and Z and taking maximum of Column A which is CHAR(9). Data loaded in target was in exponential format something like this 12312e5+. After figuring out that in DS v8.1 Aggregator stage does not perform agg functions on varchar columns, I then adde...
- Mon Apr 04, 2011 4:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query in Oracle Connector Stage
- Replies: 7
- Views: 10222
I was facing same issue with my query where I was using INNER JOIN. SELECT count(*) FROM EPIMART.MUT_FUD_TRANS_FACT_0_V MFTF INNER JOIN EPIMART.SECURITIES_0_V SECURITIES ON MFTF.SECURITIES_KEY = SECURITIES.SECURITIES_KEY INNER JOIN EPIMART.SECURITIES_0_V TO_SECURITIES ON MFTF.TO_SECURITIES_KEY = TO_...
- Wed Jun 09, 2010 4:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What stage can acomplish splitting variable length recrods
- Replies: 5
- Views: 3082
- Thu May 06, 2010 10:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with datastage connectivity to SQL server
- Replies: 0
- Views: 2270
Issue with datastage connectivity to SQL server
I have a job that extracts data from SQL server and loads to a dataset. DSN has been created to connect to SQL server. I am using DRSPX stage to connect to SQL server and could view data with the given credentials. Database type used in DRSPX stage is "MSSQL Server" But when I run the job,...
- Fri Apr 16, 2010 12:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset write Failure
- Replies: 10
- Views: 10989
I faced same issue. Resolution was to delete datasets and create some space. Job then ran fine. tCopy,0: Write to dataset on [fd 8] failed (Success) on node node1, hostname mphewddes001 tCopy,0: Orchestrate was unable to write to any of the following files: tCopy,0: /node1/res/DS_C_MP_MSTR_PFL.ds.ds...
- Fri Apr 09, 2010 3:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Difference between $ENV and $PROJDEF
- Replies: 5
- Views: 5683
- Wed Mar 10, 2010 10:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Funnel did not consume all of the available data
- Replies: 1
- Views: 3656
Funnel did not consume all of the available data
I am facing an error which involves datasets, funnel stage and UDBLoadPX stage. The job design is simple. Data extracted from 5 dataset files is combined using a funnel. Funnel Type used is "Continous". Finally data is loaded into DB2 table using UDBLoad PX stage. Settings in UDBLoad PX st...
- Mon Apr 09, 2007 9:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: FAILED return code 255
- Replies: 3
- Views: 4983
FAILED return code 255
Hi, I am running a server job. Calling it through Tivoli Scheduler Tool. When I run this job from Datastage Director its running fine. But when called from Tivoli, its aborting with the following error. FAILED return code 255 The logs in Director is not giving sufficient information. Resetting stage...
- Mon Jul 31, 2006 11:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Status code = -10 DSJE_JOBLOCKED
- Replies: 7
- Views: 10205
- Mon Jul 31, 2006 10:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Status code = -10 DSJE_JOBLOCKED
- Replies: 7
- Views: 10205
Hi, I am facing the same issue with the following error log: -------------------------------------------------------------------- Status code = 0 ERROR: Failed to lock job Status code = -10 DSJE_JOBLOCKED Status code = 0 Error -4 getting log summary Status code = -4 DSJE_BADVALUE Error running job S...
- Mon Jul 03, 2006 1:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: unable to use job after abort
- Replies: 6
- Views: 4585
Hi, I am facing the same mutex issue in a server job. Error found. SBL_SMP_CR_SLX_Extract_HashData..TRN_SPLIT.HASH_note: ds_ipcgetnext() - timeout waiting for mutex The job is running state. I can always stop the process through Unix. But I would like to know the reason. I am using a Basic Transform...
- Sun Jul 02, 2006 11:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting - ds_ipcgetnext - timeout waiting for mutex
- Replies: 4
- Views: 3233
Need help
Hi,
Could you please share your experience with this issue, your understanding on the reason and what was the resolution.
I am facing the same issue.
Thanks in advance.
Anand
Could you please share your experience with this issue, your understanding on the reason and what was the resolution.
I am facing the same issue.
Thanks in advance.
Anand
- Thu Feb 23, 2006 8:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Processing Error found :Not enough space in /node1 directory
- Replies: 4
- Views: 2812
Hi Ananda, What Force option you selected in the Copy stage after Teradata stage? If Force=False make it Force=True then copy stage will work as a Optimiser. I think it will solve your problem. If your doing the above one already then think about Lookup, lookup reference file unable to store the hu...
- Thu Feb 23, 2006 3:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Processing Error found :Not enough space in /node1 directory
- Replies: 4
- Views: 2812
Processing Error found :Not enough space in /node1 directory
What is the volume of data your are gettting out of teradata. How much space is available in your server?... Hi Rasi, The server space does not seems to be an issue. bidev1:/etld/datastage/data/datasets/node01 >bdf . Filesystem kbytes used avail %used Mounted on /dev/vx/dsk/apps/appsdsadm 330301440...
- Wed Feb 22, 2006 6:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Processing Error found :Not enough space in /node1 directory
- Replies: 4
- Views: 2812
Processing Error found :Not enough space in /node1 directory
hi, I am running a parallel job where data is extracted from Teradata table and through copy stage is moved into lookup file and dataset files. This job had been running successfully for many cycles. It is now getting aborted with the following error logs in Director: -------------------------------...