Unix command for Optim Database Administrator

[Database Administrator]

Hi,

I just upgraded our DB2 server to 9.7 from 8.2. But the Control Center
tools and the DAS have been deprecated in version 9.7. I'm wondering
how to access the new tool, Optim Database Administrator, in unix?

Thanks in advance.

[Database Administrator]

Tony wrote:
> Hi,
>
> I just upgraded our DB2 server to 9.7 from 8.2. But the Control Center
> tools and the DAS have been deprecated in version 9.7. I'm wondering
> how to access the new tool, Optim Database Administrator, in unix?
>
> Thanks in advance.
http://www.ibm.com/developerworks/sp...AGX01&S_CMP=LP

Larry Edelstein

[Database Administrator]

Thanks Larry. Does it become a separate product, not coming with the
DB2 ESE any more?

[Database Administrator]

Tony wrote:
> Thanks Larry. Does it become a separate product, not coming with the
> DB2 ESE any more?

You are looking for IBM Data Studio 2.2. It is the free product that
will replace Control Center.

Optim Database Administrator provides additional functionality (on top
of Data Studio), but it is a paid product.

[Database Administrator]

"Ian" wrote in message
news:GjXlm.135$nQ6.22@newsfe07.iad...
> You are looking for IBM Data Studio 2.2. It is the free product that
> will replace Control Center.
>
> Optim Database Administrator provides additional functionality (on top
> of Data Studio), but it is a paid product.

About $5K USD from what I can tell.

I would hang on to the CC for the Visual Explain if nothing else. The Visual
Explain in DS is not the same (don't know about Optim).

Even though CC and Admin Server are "deprecated" in 9.7, they are still
there and still should work. They might be completely removed in a future
release, but that has not happened yet.

[Database Administrator]

Ian wrote:

> Tony wrote:
>> Thanks Larry. Does it become a separate product, not coming with the
>> DB2 ESE any more?
>
> You are looking for IBM Data Studio 2.2. It is the free product that
> will replace Control Center.

Got a link to the download location? Time to take another look at it.

--
Will Honea

[Database Administrator]

"Will Honea" wrote in message
news:aR%lm.274365$E61.102484@newsfe09.iad...
> Got a link to the download location? Time to take another look at it.
>
> --
> Will Honea

There are two versions, the stand-alone, and the integrated development
(eclipse)
http://www.ibm.com/developerworks/sp...tim?pageid=649

Data Studio is free, but registration with IBM is required.

[Database Administrator]

Thanks guys! I've tried the Data Studio and I think it is useless
especially for a DBA. I'm so disappointed on the DB2 version 9.7 ......

[Database Administrator]

Tony wrote:
> Thanks guys! I've tried the Data Studio and I think it is useless
> especially for a DBA. I'm so disappointed on the DB2 version 9.7 ......
Just curious, why do you feel that way? It's designed for DBAs.

Larry Edelstein

[Database Administrator]

On Sep 2, 9:02*pm, Larry wrote:
> Tony wrote:
> > Thanks guys! I've tried the Data Studio and I think it is useless
> > especially for a DBA. I'm so disappointed on the DB2 version 9.7 ......
>
> Just curious, why do you feel that way? It's designed for DBAs.
>
> Larry Edelstein

I am curious also would like to hear DBAs opinions of using Data
Studio in 9.7 vs. CC.