Skipping Table Analysis

seanc217 · Post by **seanc217** » Tue Mar 07, 2006 2:00 pm

Here's my quesiton,

In the manual it says...

"As an alternative, Table Analysis may be skipped, in which case the results are based on previously defined primary keys instate of aggregate dependencies."

Does anyone know what I have to set to accomplish this?

Thanks in advance.

seanc217 · Post by **seanc217** » Tue Mar 07, 2006 2:50 pm

I think I answered my own question, Where the analysis server is there is a check box that says copy existing keys, but I still have to run table analysis before I can run primary key analysis.

Is this true?

Thanks again,

Sean

roy · Post by **roy** » Tue Mar 07, 2006 4:25 pm

Hi,
As far as my memory serves me.
You must do every step and check the reviewed step in order to continue to the next step.

Normaly in cases that you don't need to get a recomended DB scheme you skip the primary key definition step.

In my humble opinion the table analysis is not something you want to skip.

If there are more conciderations you left out please post them and you might get additional info.

IHTH,

seanc217 · Post by **seanc217** » Wed Mar 08, 2006 10:19 am

The weird thing that happens though is that when I do the table analysis, and then go to do the primary key analysis, and I check the copy existing keys check box, I get a message that I cannot use the key because table analysis has been run.

I have a case open with IBM on this issue, I will let you know the results.

HenryHouet · Post by **HenryHouet** » Thu Jun 29, 2006 3:48 am

Hi,
I just ran across the same problem as you quoted where I get the same error reported when I try to choose the function 'Copy Existing Tools'.
I saw in your message that you had opened an issue with IBM regarding this problem and that you would supply a post when the issue has been resolved. I was just wondering if there has been a solution yet?