Search found 111 matches

by bollinenik
Tue Jun 29, 2010 5:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: capturing full duplicates in to a sequential file
Replies: 13
Views: 5287

It would be great if you can give more details about.
what are you going to do with duplicate rcords, are you going to delete or.
you might be doing some thing right.

and what else doing at same time, are you just try to findout only duplicates with that data, else are you some other process.

If you can give that info, you will get more optimal solutions for your requirement.
by bollinenik
Mon Feb 01, 2010 12:37 pm
Forum: General
Topic: time conversion
Replies: 17
Views: 10581

Hi,
Please post exact error message and database type, length as well

what was other format records, which was successfully inserted into that column.
by bollinenik
Tue Dec 15, 2009 5:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Stage Erroe
Replies: 10
Views: 6614

why don't you try first normal lookup if it works fine then you can range lookup.
I guess normal lookup will tell you exact error where it's going wrong, if it's related to Input schema or some thing else.
basically it might be due to column names are not defined properly, Try with some sample column names and create a new job.
If you can debug in this way and post your error if any.
by bollinenik
Tue Oct 27, 2009 2:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT _CONFIG file Warning
Replies: 6
Views: 2326

sorry, what is this?
Magic 8 Ball says... <shake,shake,shake>...
by bollinenik
Tue Oct 27, 2009 2:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in dev_rfc.trc
Replies: 2
Views: 2545

try triggering IDOC program first in SAP GUI, if it's working fine then it's problem with datastage, else SAP RFC settings needs to be configurd for datastage.
by bollinenik
Tue Oct 27, 2009 2:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle insert slow
Replies: 7
Views: 2273

try by selecting 'insert arry size' option and provide value as 1000

I think this will help you deffinetly.
by bollinenik
Tue Oct 27, 2009 2:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT _CONFIG file Warning
Replies: 6
Views: 2326

put your config file here and paste warning as it is then, that would make it easy to comment any thing.
by bollinenik
Fri Oct 16, 2009 12:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple jobs compile error
Replies: 3
Views: 2011

when I click on that option it's throwing error.

but I am able to solve it.

thanks.
by bollinenik
Wed Oct 14, 2009 12:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple jobs compile error
Replies: 3
Views: 2011

Multiple jobs compile error

Hi,
I am using datatstage 8.0.1 version and trying to use multiple jobs compile opetin from datatstage designer tools option, it's throughing below error, any help is appriciated.

DSRepos.SetParamsFromStr: Internal error - Error accessing file containing commandline. ()
by bollinenik
Wed Sep 30, 2009 3:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Number conversion
Replies: 5
Views: 2083

That would add '+' where ever it finds space, even if found more then one space then it will add many '+' symbols so, the best way is.

in derivation, If Coulmn>=0 then '+':StringToDecimal(Columnname,000000000D00), Datatype should be Varchar.

If you are extracting data from Database and writing into a file then use
To_Char(Columnname,'00000000D00') in SELECT query and Add '+' by concating in transformer so that it will give expected result.
by bollinenik
Tue Aug 11, 2009 12:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Status 99
Replies: 18
Views: 7470

Hi Mike,
can you explore little bit about changing settings of autopurge,
I have done the same changing it to 2 days, but it didn't work for me.
what is the process exact setting being changed to solve this issue.
by bollinenik
Mon Aug 10, 2009 8:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Status 99
Replies: 18
Views: 7470

Hi Mike,
Did you hear any good news from Tech support, please share thsoe details if you have any thing about this probelm.
by bollinenik
Mon Aug 10, 2009 8:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Status 99
Replies: 18
Views: 7470

Hi Mike,
Did you hear any good news from Tech support, please share thsoe details if you have any thing about this probelm.
by bollinenik
Mon Aug 10, 2009 8:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance with Datastage 8
Replies: 15
Views: 8735

Hi ray,
thanks for your response,
do you have any idea why it's taking lot of time even for staright mapping,
b.coz of not having GRID environment, It should not process <2000/sec right..!
Can you suggest me how to reslve this problem, there is difference between GRID and NON-GRID but,
bc.oz of not having GRID processing <2000 records/sec, is not acceptable.

please help me in solving this problem.
by bollinenik
Mon Aug 10, 2009 2:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multi Instance job status issue
Replies: 3
Views: 1585

Multi Instance job status issue

Hi,
Multi instance job is not showing proper status in director in websphere datastage v8.
Actually we are triggering multiinstance job for 5 times some tiems it's going fine, some time it's not.
example take one run:
If go to job clear LOG there, status is job finished today, but at the same time come to view status in director it's shows not triggered at all, means showing old run status.
is it known probelm in Datastage 8 or, it's some thing new.
is there any way to solve this.

Appriciate your response.