Search found 5168 matches

by kumar_s
Fri Feb 16, 2007 4:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer stage is not working in parallel jobs
Replies: 2
Views: 758

Hi Phani,

Welcome Aboard :D !!!

Can you give use more details about your job design?
The full error message that you get?
If you search for the code that you have posted, you get many hits from this site. Check if that helps, else get back to us with more details.
by kumar_s
Fri Feb 16, 2007 4:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference between killing the job and unlock the job
Replies: 3
Views: 1181

This terms are generally used in following scenario. If a job is running forever, or for any extreme case like restarting the engine, the running jobs need to be stopped. Some times, the stop option available in the director might take a long to stop the job. So the PID of the corresponding Job will...
by kumar_s
Fri Feb 16, 2007 4:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: difference between killing the job and unlock the job
Replies: 3
Views: 1181

This terms are generally used in following scenario. If a job is running forever, or for any extreme case like restarting the engine, the running jobs need to be stopped. Some times, the stop option available in the director might take a long to stop the job. So the PID of the corresponding Job will...
by kumar_s
Fri Feb 16, 2007 3:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem to convert the amount field from currency to decimal
Replies: 11
Views: 5683

Yes, Covnert will remove all the existing "$" symbol. If you additionally need to remove the comma "," or some other special character, you can add it next to the "$" in the given expression.
by kumar_s
Fri Feb 16, 2007 3:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Hanging
Replies: 3
Views: 911

What is the job design? What is the parameter that been passed?
If you look at the log, what is the stage at which the jobs is showing as it is been hanging?
by kumar_s
Fri Feb 16, 2007 3:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while scheduling a job in datastage
Replies: 11
Views: 4420

ray.wurlod wrote:So is Director just a client component. They share some DLLs.

Yeah true. It could be a case. But the same error in some previous case, where they could not schedule from command prompt either.
Lets wait till OP to revert.
by kumar_s
Fri Feb 16, 2007 12:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: capturing reject records in transformer stage
Replies: 6
Views: 1991

Capturing reject is possible both in Server as well as PX, constraints plays the key role for that.
by kumar_s
Fri Feb 16, 2007 12:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting input data into files
Replies: 2
Views: 559

Not based on size but can be done based on records in DS level.
Or you can use Split command in OS level and use DS to convert it into XML.
by kumar_s
Fri Feb 16, 2007 12:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while scheduling a job in datastage
Replies: 11
Views: 4420

Ray, do you think MCM will affect Scheduling. MCM is just a client component isn't?
by kumar_s
Thu Feb 15, 2007 8:47 pm
Forum: Site/Forum
Topic: Ray hits 18K !!!
Replies: 19
Views: 8973

Oh..Oh.... The value can be stored only as LOBs.
10! Points can be Ray's immediate target.
by kumar_s
Thu Feb 15, 2007 8:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error while scheduling a job in datastage
Replies: 11
Views: 4420

Is the Windows for English or for different language? Have you check the same AT command from command prompt? "AT 16:35 vmdsr_sched.exe e:\Ascential\DataStage\Projects\SMDM_dev HF_AVG_SELLING_DAY 0/50/1/0/0 3" Try with different value, it that works. If nothing works, try to schedule some thing else...
by kumar_s
Thu Feb 15, 2007 8:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row Count
Replies: 5
Views: 3492

Alternatively you can use the OS command option.

Code: Select all

dsjob -linkinfo $Project $Job $Stage $Link | grep 'Link Row Count' | awk '{print $5}'`
by kumar_s
Thu Feb 15, 2007 6:27 pm
Forum: Site/Forum
Topic: Ray hits 18K !!!
Replies: 19
Views: 8973

I just thought of finding the value of 18!!!. But for 18!!, windows calculator warning me that it will take very long time to calculate. :lol:
by kumar_s
Thu Feb 15, 2007 6:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: random errors SIGSEGV, SIGKILL, SIGBUS
Replies: 17
Views: 5314

Set APT_NO_JOBMON to True, to see if you get some major difference. Dont expect to get rid completely. If you find the difference, you can fiddle with the value in SIZE and TIME parameter.
by kumar_s
Thu Feb 15, 2007 6:08 pm
Forum: Site/Forum
Topic: Ray hits 18K !!!
Replies: 19
Views: 8973

Ray hits 18K !!!

Ray hits 18K in his usual pace.
Still maintaining ~ 2*Craig's post.
Thanks for your time.