Search found 43 matches

by Hema.k
Wed Jan 30, 2013 5:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to pass file path as parameter in xml output stage
Replies: 5
Views: 3496

Hi ray,

We have give the parameters with "#" .for eg#$evRMSRootPath# filename.xml
But in the director log it shows error like
NOTLIKELYDISCAPIOP_$evRMSRootPath

Regards,
Hema K
by Hema.k
Tue Jan 29, 2013 3:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to pass file path as parameter in xml output stage
Replies: 5
Views: 3496

Hi Prasson, Thanks for your reply. The job is working fine after giving the job parameters. Initially I have specified environmental variable for file path and it is not working. Could you please let us know why it is not accepting environmental variable.what should be done If i want to use environm...
by Hema.k
Tue Jan 29, 2013 1:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to pass file path as parameter in xml output stage
Replies: 5
Views: 3496

How to pass file path as parameter in xml output stage

Hi, We are generating the xml files using xml output stage.If we hard code the filepath , it is generating the files. If we pass the file path as parameter , xml files are not getting generated, but the job sucessfully runs without any warning. Please let us know how to generate the files by giving ...
by Hema.k
Wed Apr 04, 2012 1:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: no of process running on the DS at a particular time
Replies: 4
Views: 2084

no of process running on the DS at a particular time

Hi All,

We are facing the error code -14 frequently.
When I checked in the forum, i understood that it is due to DS server overloaded.
Is there any way to check the no of process running on the DS at a particular time when the job got aborted.

Thanks in advance,

Regards,
Hema K
by Hema.k
Thu Mar 08, 2012 11:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find memory/resource utilisation by a job
Replies: 8
Views: 3583

Hi All,

Thanks for your suggestions.
I will check the same.

Regards,
Hema K
by Hema.k
Wed Mar 07, 2012 11:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find memory/resource utilisation by a job
Replies: 8
Views: 3583

How to find memory/resource utilisation by a job

Hi All, We are facing some performance issues. Initially we had some jobs in PROD envt due to the performance issue we moved some jobs (say 4) to UAT envt. There was no issues in UAT before moving the jobs from PROB. After we migrated the jobs , we are facing some performance issues in UAT. Could an...
by Hema.k
Thu Jan 19, 2012 5:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Decode stage
Replies: 1
Views: 2006

Problem has been resolved once
I removed the input data definition which is not required for decode stage
by Hema.k
Thu Jan 19, 2012 4:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Decode stage
Replies: 1
Views: 2006

Issue with Decode stage

Hi All, We are trying to decode a dataset but not able to do the same. Step 1: We first converted a sequential file to dataset which is encoded using encode stage in parallel job. Command line used : gzip Seq file has 2 columns a,b Schema definition for dataset : record ( t: tagged {preservePartitio...
by Hema.k
Thu Jan 19, 2012 12:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to run job --14
Replies: 1
Views: 2189

Unable to run job --14

Hi All, I have designed a simple parallel job and design is as below: dataset ----->Transformer----->dataset. Job completes with out any issues most of the time but it is aborting with the following error Xfm,2 :Unable to run job --14 this error is occurring for different jobs in same project. Could...
by Hema.k
Fri Jan 13, 2012 2:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job got stuck- process completed but still in running status
Replies: 3
Views: 2122

Thanks for the reponse ...

@Ray: There are some datatype conversion warnings.
Below is the last message obtained after which the job got stuck.

main_program: Step execution finished with status = OK.


@Pandeesh: There were no active sessions available in the db.


Regards,
Hema K
by Hema.k
Fri Jan 13, 2012 12:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job got stuck- process completed but still in running status
Replies: 3
Views: 2122

Job got stuck- process completed but still in running status

Hi Everyone, We have below design as below in a single job. oracle ---> odbc oracle ---> odbc oracle ---> odbc It is running fine but at sometime it got stuck. i.e job extraction & Loading process completed but then it is in running status. while monitoring the job it shows finished in all stage...
by Hema.k
Sun Dec 25, 2011 9:37 pm
Forum: General
Topic: How to avoid Code -2 Error
Replies: 3
Views: 1791

How to avoid Code -2 Error

Hi All, We have some 6 jobs in the sequence job and in every job activity the option "Reset if required ,then run" has been enabled. We are facing the Code - -2 Unable to run the job(Compiled,not running) if the job has aborted in the previous run. If we compile and run the job again, its ...
by Hema.k
Wed Dec 14, 2011 5:46 am
Forum: General
Topic: Copy the result obtained using DS Command in Admin client
Replies: 1
Views: 1184

Copy the result obtained using DS Command in Admin client

Hi ,

Can anyone let me know how to copy the result obtained by executing the DS Command in Administrator Client.

Thanks in advance.

Regards,
Hema K
by Hema.k
Thu Nov 17, 2011 9:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job process
Replies: 3
Views: 1795

I have a single job and the design of the job is as follows:

Odbc---->Transformer---->Netezza (Insertion)
Row Generator ------> Odbc (Updation)


Regards,
Hema K
by Hema.k
Thu Nov 17, 2011 12:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job process
Replies: 3
Views: 1795

Parallel job process

Hi, I have developed a parallel job which has two different design,one is for insertion of records and another one to Update the records. Both Insertion & Updation is on same table and the job is running fine. Can anyone explain how the job is processed while running i.e. which one will happen f...