Search found 12 matches

by Brett
Wed Jul 06, 2011 10:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with install C++ compiler v8.5; xfm compile error
Replies: 3
Views: 4464

As I understand it for Datastage, it is only jobs that have a Transformer that require the C++ compiler and that it needs to be installed before you install the datastage software so it can detect and set up the correct options to use your compiler. For windows the compiler option should not be G++....
by Brett
Wed Jun 29, 2011 7:39 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IADB IADBSPACE tablespace size
Replies: 2
Views: 3212

The DB2 install that IA does by default I believe leaves the tablespaces / containers size as small and can be converted to large to enable the IADB to grow further. Apologies that I can not be more technical in the solution, but that is what our DB2 DBA verbally told me was the problem when he corr...
by Brett
Thu Jun 09, 2011 9:45 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA column analysis error in IIS 8.5 Fix Pack 1
Replies: 12
Views: 13968

The patch for this issue is ready - I suffered from a similar inability to run profiles - should be available from your local IBM support - I tested it this morning and it does appear to correct the problem.
by Brett
Sun May 29, 2011 6:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to Open Source file - Job Aborts
Replies: 4
Views: 5364

For what its worth - last time i had this and spent ages looking - turned out to be a leading space in the filename parameter that was incredibly hard to spot in the input area.
by Brett
Wed May 11, 2011 6:59 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Complex Data Rules in IA
Replies: 5
Views: 5538

To clarify - These views are not built inside IA - As I have an offline environment and full control of the database - I am able to build and construct subsets of data, to drive areas of the rule base I create - such as current address quality for an active client. This way I can build the views, ru...
by Brett
Mon May 09, 2011 9:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copy Stage is it needed
Replies: 3
Views: 2574

Thanks for the feedback - i was just curious.

Sorry for the post to the wrong forum as well :)

Brett.
by Brett
Mon May 09, 2011 7:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copy Stage is it needed
Replies: 3
Views: 2574

Copy Stage is it needed

In a job I can take a sequential flat file and connect it straight to a DB load stage or it has been suggested I can/should place a copy stage between them. Is there any benefit to this ? . Both methods work and the straight connection seems fine ?

Asking out of interest

Thanks Brett.
by Brett
Sun May 08, 2011 10:45 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Complex Data Rules in IA
Replies: 5
Views: 5538

I have had similar problems and have currently resorted to creating table views designed for testing some of the more complex business rules. My environment is discrete from the main system and I have the authority to do this. You can create simple join conditions in the rules editor, there is also ...
by Brett
Sun May 08, 2011 5:47 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Maintaining IADB
Replies: 5
Views: 4391

Would you be thinking of the table management functions under the investigate category for the IA tool ?.
by Brett
Sun May 08, 2011 5:45 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Maintaining IADB
Replies: 5
Views: 4391

Would you be thinking of the table management functions under the investigate category for the IA tool ?.
by Brett
Sun May 08, 2011 5:40 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA column analysis error in IIS 8.5 Fix Pack 1
Replies: 12
Views: 13968

I also broke the ability to submit profile jobs after applying FP1 and is currently with IBM for a fix.

However you can still run profiles etc using the IAJOB command line option.
by Brett
Wed Nov 10, 2010 9:47 pm
Forum: Enhancement Wish List
Topic: Profile functions selectable
Replies: 1
Views: 15181

Profile functions selectable

For Information Analyzer - I would really like to be able to limit profiling actions by column - in the simple example of maybe only wanting length and null-ability for a free text string and wishing to omit processing this column for frequency or pattern analysis. I understand that columns can be e...