DSXchange

Sadly, no, not without the right permissions.
You will likely need your administrator to obtain the log OR open a PMR (their choice )

Please look at the the log from the DataStage/QualityStage Director (or Operations Console, if you use that).

Open the project you run you Information Analyzer jobs in (the default is ANALYZERPROJCT).

Hi,

Some of these messages are normal (http://www-01.ibm.com/support/docview.w ... wg21584766).
However, the 'create' issue....is the IADB or the IADBSPACE full?
Can you please 'retain scripts' and show the entire log instead of just a piece?

Hi Todd, Go into the 'Web Console for Information Server' ([url]https://server:port/ibm/iis/console[/url]) and create a scheduling view (Schedule Monitoring > Views of Schedules > New Scheduling View) and select at least an 'Origin' of Information Analyzer. You should be able to work with the schedu...

Hi All! I've added some additional detail to the QualityStage Address Verification Interface Outputs document. Please see the post on IBM developerWorks at https://www.ibm.com/developerworks/community/forums/html/topic?id=b43debd9-ac17-4cac-8674-6f95041c0559 to get a copy of the pdf. As before, AVI ...

Hi Bob, It's database.schema.table.col, with anything able to be * "BANK.BANK2.TABLE1.*" means BANK database BANK2 schema TABLE1 table all columns Here is a simple one I used: <?xml version="1.0" encoding="UTF-8"?> <iaapi:Project xmlns:iaapi="http://www.ibm.com/inv...

Hi Roy,

Indeed - a PMR may be necessary.

What is the source of the data? -472844 is certainly not a smallint, so it looks like the declared datatype in the source metadata may be wrong (or you may have data corruption..)

First, you do not need to update dsenv or uvconfig.odbc. Second, there is still something wrong with your .odbc.ini file. Here is mine that works: [QSMATCHDriver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb200.so Description=QualityStage Match Designer Database AddStringToCreateTable= Alt...

Brazil is included, just not pre-loaded into the repository ( http://www-01.ibm.com/support/knowledgecenter/#!/SSZJPZ_11.5.0/com.ibm.swg.im.iis.qs.ug.doc/topics/c_qsrules.html ). On the client, go to C:\IBM\InformationServer\Clients\Classic\QSRules. You will see the Brazil rule set (read the 'readme...

The most frequent cause of bad match performance is (arguably) blocking fields that are too 'loose' (include too many candidate records). Do you know what pass is causing issues? (Blocking fields are per pass). The next thing you can look at is the job design. I would assume there is some sort of re...

Hi Bob,

Your 'Firstly' sounds like a bug. How are you exporting/importing the DRD?

You mention the Rules Stage in DataStage/QualityStage. Is that your entire use case, or just one use case? In other words, are you also executing the DRD's in Data Rules in Information Analyzer?

Take a look at your match specification. If you are using overrides for every column, then generating frequencies will not matter as the overrides can take priority.

Is the original question based on curiosity, or are you having quality issues in your matching?

Hi DJ, As you noted, the challenge is that when you look at an unhanded pattern (like @,@ for M0rgan,STEP4HAN), you have no idea if that pattern occurs once or many times. I want to spend my time fixing the things that are causing the most problems. So for me, the method I use is to create a process...

Hi DJ, 1) For ROBERT & ANGIE STEGMANN, you should see: FirstName: ROBERT PrimaryName: STEGMAN AdditionalName: ANGIE STEGMAN For ROBERT STEGMANN ANGLE STEGMAN you should see: UnhandledData: ROBERT STEGMANN ANGLE STEGMANN The above is 'out-of-the-box', so I suspect your rule sets have been overrid...