Search found 42189 matches

by chulett
Mon Jul 09, 2012 4:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage 8.5 XML Stage Startup Time Issue
Replies: 12
Views: 6854

Same here.

And there is a 'Views' count outside in the forum listing, I could see that it had been viewed 55 times before I popped in here to add this, one of which was me reading it and not having anything to add. :(
by chulett
Mon Jul 09, 2012 4:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Random Function
Replies: 3
Views: 1355

So, as you've seen, those random numbers are not truly random since the pattern repeats each time based on the "seed" or the intial starting value. I believe the term is 'psuedo-random', hang on.... yup: Pseudorandom Number Generator wiki entry. As noted though, you have ways to "rand...
by chulett
Mon Jul 09, 2012 1:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: StringtoDecimal for Negative Decimal value
Replies: 4
Views: 3927

That is something else entirely where the last letter indicates both the last digit and the sign:

A = +1
B = +2
...
J = -1
K = -2

etc.
by chulett
Mon Jul 09, 2012 1:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Improve loading into SQL server
Replies: 15
Views: 9440

Post your job design and the abort you are getting.
by chulett
Mon Jul 09, 2012 11:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: StringtoDecimal for Negative Decimal value
Replies: 4
Views: 3927

The StringToDecimal function may want a leading sign, don't know off the top of my head and can't check. If that is the case, you could convert everything except the last character and then if the last character is a "-", multiply the decimal result by -1.
by chulett
Mon Jul 09, 2012 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Startup time high in jobs having a DB operation
Replies: 11
Views: 4583

If you haven't done so already, add $APT_STARTUP_STATUS and $APT_PM_PLAYER_TIMING to your job set to True in both environments. Compare and contrast.
by chulett
Mon Jul 09, 2012 7:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Startup time high in jobs having a DB operation
Replies: 11
Views: 4583

OK, good to know. Cross that one off your list. :wink:
by chulett
Mon Jul 09, 2012 7:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset warning-expecting 2 segments, read 3 segments.
Replies: 2
Views: 1781

Don't run them in parallel. Never mind the fact that it doesn't make any sense to do that since one job is creating the source data the other job needs.
by chulett
Mon Jul 09, 2012 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Startup time high in jobs having a DB operation
Replies: 11
Views: 4583

Actually we are using the same load which is used in the Dev.No change absolutely in the load. If by "load" you mean the data you are loading, that's not what I meant. I meant the amount of data in the target database, in other words the amount of data it needed to cache before the main p...
by chulett
Mon Jul 09, 2012 7:00 am
Forum: General
Topic: User connection issue with 8.7
Replies: 14
Views: 5681

ArndW wrote:Since datamine has opened as a new thread *here* we'll close this one and continue on the new thread.
Nope, sorry. Don't want to encourage that behaviour so I deleted it. Continue on here please. :wink:

Another option - Google Docs.
by chulett
Sun Jul 08, 2012 9:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Connect to sap hr
Replies: 3
Views: 1531

Does SAP have its own proprietary database? I thought it sat on top of Oracle or whatever RDBMS that you'd like. :?
by chulett
Sat Jul 07, 2012 10:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Parallel Routine
Replies: 4
Views: 4470

I don't really "do" C anymore so this could be a little off, although I have in the past and I've dealt with other things requiring a linker. Basically it means that the executable code is referencing a "symbol" (a variable) and the definition of that symbol / variable could not ...
by chulett
Fri Jul 06, 2012 11:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Startup time high in jobs having a DB operation
Replies: 11
Views: 4583

Re: Startup time high in jobs having a DB operation

I read the posts here,and came across &PH& directory cleanup.There were around 1600 files which we cleared. This did not result in any change on the start up time. It wouldn't affect the "start up time" of the lookups. The same jobs on the development database takes very little st...
by chulett
Fri Jul 06, 2012 8:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer loop, cache or anything else
Replies: 9
Views: 5552

Transformer looping was introduced in 8.5, was it not?