Search found 773 matches

by balajisr
Thu Mar 11, 2010 8:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fork() failed. Not enough space.
Replies: 4
Views: 5115

Check your OS Process limit configuration.
by balajisr
Thu Mar 11, 2010 8:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fork() failed. Not enough space.
Replies: 4
Views: 5115

Check your OS Process limit configuration.
by balajisr
Tue Dec 08, 2009 11:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Oracle Logs
Replies: 9
Views: 4948

chulett wrote:You can't, it's not a separate app like it is in PX. Why would you want to? :? ...
Thanks. Just wanted to know.
by balajisr
Tue Dec 08, 2009 9:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Oracle Logs
Replies: 9
Views: 4948

Craig,

Thanks for the reply.

How do we disable job monitor in server jobs?
by balajisr
Mon Dec 07, 2009 10:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Oracle Logs
Replies: 9
Views: 4948

chulett wrote:Yes. ...
I wrote a simple routine to fetch link row count using DSGetLinkInfo().

When I ran job with job monitor switched on, link row count is ok. But when i rerun the job with job monitor switched off i get link row count (using DSGetLinkInfo()) as 0. :cry:

Have i missed anything?
by balajisr
Mon Dec 07, 2009 6:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capturing Oracle Logs
Replies: 9
Views: 4948

Sainath.Srinivasan wrote:Yes. You can do a linkinfo.

If you have followed good naming conventions, you can make it reusable also. ...
Is it possible to retrieve these information if the job monitor is switched off? :roll:
by balajisr
Mon Dec 07, 2009 3:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Default formatting
Replies: 15
Views: 9325

Transformer date format is ISO 8601 standard (YYYY-MM-DD) regardless of project or job default date format.
by balajisr
Mon Dec 07, 2009 1:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Default formatting
Replies: 15
Views: 9325

Actually the problem is that we can't use the server job....(we have to develop only parallel jobs... Rolling Eyes ).... That's ridiculous. :shock: FYI: IsValid('Timestamp',StringToTimestamp(DSLink2.Col1,'%dd%mmm%yyyy %hh:%nn;%ss')) The above code with below data did not produce any warnings when i...
by balajisr
Mon Dec 07, 2009 1:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Default formatting
Replies: 15
Views: 9325

Why don't you try using Ray's IsValid() routine. You need to develop server jobs to use this.
by balajisr
Sun Dec 06, 2009 11:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Default formatting
Replies: 15
Views: 9325

I actually use the above function, the job is giving warning..as Ray has pointed.. for every records ,whose date fomat doesn' t matches with the desired date format.
Can you please post those records which gives warning?
by balajisr
Thu Dec 03, 2009 11:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Default formatting
Replies: 15
Views: 9325

Ray, My project default timestamp format is "%yyyy-%mm-%dd %hh:%nn:%ss" I have two input rows which has to be in format "%dd%mmm%yyyy %hh:%nn;%ss" 1.20Nov2009 14:10:10 2.Nov202009 14:10:10 In the transfomer i have the following code: IsValid('Timestamp',StringToTimestamp(DSLink2....
by balajisr
Thu Dec 03, 2009 4:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Default formatting
Replies: 15
Views: 9325

Convert to timestamp using function StringToTimestamp and then check for IsValid.
by balajisr
Wed Dec 02, 2009 4:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage px
Replies: 2
Views: 2343

Have you gone through datastage manuals or training?
by balajisr
Wed Dec 02, 2009 4:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage px
Replies: 3
Views: 2881

What is the workaround you are proposing?