Search found 85 matches

by Magesh_bala
Fri Dec 11, 2009 5:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unusable Index Issue
Replies: 12
Views: 4990

I have got the same error, But after enabling the options its working fine. But now Job takes almost 24 hrs to complete early it takes only 8 hrs. Can any one tell me the right options to use?
by Magesh_bala
Mon May 25, 2009 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mail
Replies: 6
Views: 1892

I have supplied the required parameters, But still Its not sending an email.
My server is in UNIX box, Please let me know what kind of configuration i have to do?
by Magesh_bala
Thu May 21, 2009 6:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Mail
Replies: 6
Views: 1892

Mail

Executed command: /opt/Ascential/Ascential/DataStage/Projects/AIS_MIG_PROJ/sendmail_Mail.sh *** No output from command *** The following parameters in the call to DSSendMail were not mentioned in the file 'dssendmail_template.txt': server I am getting the above error, can some please help me???
by Magesh_bala
Fri Dec 12, 2008 4:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regd An Error Calling a Routine
Replies: 7
Views: 2271

Routine Activity

I have a one sequence in which i am calling some Job routines and One Routine activity. When i check the option Automatically Handle Activities that Fails, My jobs is aborting in Routine activity, But still the Routine is executed and aborted. When i uncheck the option its running fine, Someone can ...
by Magesh_bala
Fri Dec 12, 2008 1:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regd An Error Calling a Routine
Replies: 7
Views: 2271

ray.wurlod wrote:Hint: your routine CalculateDate does not return 0. ...
Hi All,

I am facing the same kind of error, someone can help me.
by Magesh_bala
Fri Oct 17, 2008 1:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Carriage Return
Replies: 3
Views: 1082

ArndW wrote:This was asked yesterday, check this thread. ...
HI, I beleive its different problem, I want to check for the entire file, Is there any option to check the file?

Thanks and Regrads
N.Magesh
by Magesh_bala
Fri Oct 17, 2008 1:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Embedded Carriage Returns
Replies: 10
Views: 5941

ray.wurlod wrote:No.

But you can write a script to do that and invoke the script from DataStage. ...
Can you please help me in writing the script?
by Magesh_bala
Thu Oct 16, 2008 8:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Embedded Carriage Returns
Replies: 10
Views: 5941

Hi All, I have the same problem, I used to create the sequential file form the DB2 database, But some times when i create the file it is created with CR/LF, SO when i try to read the file, The datastage job is aborted. I have to check the entire file before i read it, Is there any option to check th...
by Magesh_bala
Thu Oct 16, 2008 8:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Embedded Carriage Returns
Replies: 10
Views: 5941

Hi All, I have the same problem, I used to create the sequential file form the DB2 database, But some times when i create the file it is created with CR/LF, SO when i try to read the file, The datastage job is aborted. I have to check the entire file before i read it, Is there any option to check th...
by Magesh_bala
Wed Oct 15, 2008 9:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Carriage Return
Replies: 3
Views: 1082

Carriage Return

Hi All, I have a job which reads files and write it to the hash file. very simple job (Fixed width). But in my Source file sometimes i will get a carriage reture. Can someone help me to find the carriage return column in my datastage log or ignore the record. Thanks and Regards N.Magesh
by Magesh_bala
Tue Oct 14, 2008 7:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Job 174 Phantom 4400
Replies: 2
Views: 1862

You have a corrupted hashed file. It may be one that the job is using, or it may be one that is part of the repository database. Is there another warning message, perhaps when you reset the job, tha ... Hi Ray, Thanks for reply, I am not using any Hash file or any database in the job. Only files i ...
by Magesh_bala
Mon Oct 13, 2008 11:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Job 174 Phantom 4400
Replies: 2
Views: 1862

DataStage Job 174 Phantom 4400

Hi All, I am getting the following error, Can someone please help me to come out of the error. DataStage Job 174 Phantom 4400 Found buffer on freechain that is marked as in use. Possible file corruption can be fixed with RESIZE. Attempting to Cleanup after ABORT raised in stage CkeckNumberRegsKMGFR1...
by Magesh_bala
Tue Sep 23, 2008 3:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job need to run every 6 hours
Replies: 6
Views: 1797

Hi, I belive we dont have an option in scheduler to run every six hours.
by Magesh_bala
Tue Sep 23, 2008 3:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: job need to run every 6 hours
Replies: 6
Views: 1797

Hi, I belive we dont have an option in scheduler to run every six hours.