DA Morgan wrote:
> DA Morgan wrote:
>> Fernando Nunes wrote:
>>> DA Morgan wrote:
>>>> Fernando Nunes wrote:
>>>>
>>>>> 4- In this link you can see prices for various IDS licenses:
>>>>> http://www-950.ibm.com/ecatalog/Deta...06034N08119V60
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Thanks ... appreciate the link.
>>>>
>>>> I guess they sell it for what they can get for it. <g> Sorry.
>>>
>>> This could be interpreted as you finally saying IDS is cheaper than
>>> Oracle...
>>
>> I've no doubt IDS is cheaper than Oracle EE and no doubt it is far more
>> expensive than Oracle XE. One must compare with a version with
>> comparable features if such a beast exists.
>
> Not trying to beat a dead dog here but can someone explain this to me?
>
> http://publib.boulder.ibm.com/infoce...oc/esqlc02.htm
>
>
> The header on the frame says:
> "IBM Informix Dynamic Server, Version 10 IBM Client SDK, Version 2.9"
>
> and the contents says:
>
> "Some members of the DB2® family of servers do not support fragmenting
> by range, and attaching and detaching fragments."
>
> Is Informix now considered to be part of the DB2 family?

Not really --- long story.... When Janet Perna was general manager,
DB2 was the brand name. That led to a lot of confusion. For instance
IMS was under the DB2 brand ( really silly ). The brand name has been
changed, but unfortunately web pages have a life of their own.

IDS had supported range fragmentation, fragmentation attach, detach for
many years now.

BTW -

Madison Pruet wrote:
> DA Morgan wrote:
>> DA Morgan wrote:
>>> Fernando Nunes wrote:
>>>> DA Morgan wrote:
>>>>> Fernando Nunes wrote:
>>>>>
>>>>>> 4- In this link you can see prices for various IDS licenses:
>>>>>> http://www-950.ibm.com/ecatalog/Deta...06034N08119V60
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Thanks ... appreciate the link.
>>>>>
>>>>> I guess they sell it for what they can get for it. <g> Sorry.
>>>>
>>>> This could be interpreted as you finally saying IDS is cheaper than
>>>> Oracle...
>>>
>>> I've no doubt IDS is cheaper than Oracle EE and no doubt it is far more
>>> expensive than Oracle XE. One must compare with a version with
>>> comparable features if such a beast exists.
>>
>> Not trying to beat a dead dog here but can someone explain this to me?
>>
>> http://publib.boulder.ibm.com/infoce...oc/esqlc02.htm
>>
>>
>> The header on the frame says:
>> "IBM Informix Dynamic Server, Version 10 IBM Client SDK, Version 2.9"
>>
>> and the contents says:
>>
>> "Some members of the DB2® family of servers do not support fragmenting
>> by range, and attaching and detaching fragments."
>>
>> Is Informix now considered to be part of the DB2 family?
>
> Not really --- long story....

Thanks for the clarification.

> IDS had supported range fragmentation, fragmentation attach, detach for
> many years now.
>
> BTW -

I know that. I was trying to determine whether composite partitioning
had made it in yet.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)

DA Morgan wrote:
> I know that. I was trying to determine whether composite partitioning
> had made it in yet.
Daniel, can you clarify what the business value of these combinations is?
Many features make it into products because "some" customer/view with
enough $$ got their will, and not because they are truly useful.
To add some color to it. I have never ever received a request from a DB2
customer for nested tables, even when they were familiar with the
concept from Oracle.
Oracle ISVs wanting to port to IDS or DB2 will OF COURSE demand the
features because they just want to run their Oracle apps unchanged
without paying Oracle an arm and a leg in the process.
You are listing a lot of "features" that appear to be solutions to
Oracle unique problems. It's like asking for traction control for an
airplane...

Cheers
Serge

PS: How do you define "native"? Let's not even talk of XML, but just the
spatial type. What makes them "native" vs. an IDS geospatial datablade?


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Serge Rielau wrote:
> DA Morgan wrote:
>> I know that. I was trying to determine whether composite partitioning
>> had made it in yet.
> Daniel, can you clarify what the business value of these combinations is?

Extremely important to be able to range partition, for example by date,
and then partition by hash within it. At least if you are working with
large data sets.

> PS: How do you define "native"? Let's not even talk of XML, but just the
> spatial type. What makes them "native" vs. an IDS geospatial datablade?

The same thing that makes a DATE data type "native" versus storing a
string in it that represents a date. I can put zeros and ones into a
CHAR(1) or INT but that doesn't make it Boolean.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

DA Morgan wrote:
>> PS: How do you define "native"? Let's not even talk of XML, but just
>> the spatial type. What makes them "native" vs. an IDS geospatial
>> datablade?
> The same thing that makes a DATE data type "native" versus storing a
> string in it that represents a date. I can put zeros and ones into a
> CHAR(1) or INT but that doesn't make it Boolean.
Daniel, I am starting to believe I may know Oracle better than you do ;-)
Oracle classifies spatial types under "Oracle supplied types"
There even is a distinct list of "built-in types" you can find by
searching the relevant websites which does most definitely not contain
any spatial types.


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Serge Rielau wrote:
> DA Morgan wrote:
>>> PS: How do you define "native"? Let's not even talk of XML, but just
>>> the spatial type. What makes them "native" vs. an IDS geospatial
>>> datablade?
>> The same thing that makes a DATE data type "native" versus storing a
>> string in it that represents a date. I can put zeros and ones into a
>> CHAR(1) or INT but that doesn't make it Boolean.
> Daniel, I am starting to believe I may know Oracle better than you do ;-)
> Oracle classifies spatial types under "Oracle supplied types"
> There even is a distinct list of "built-in types" you can find by
> searching the relevant websites which does most definitely not contain
> any spatial types.

I made no reference to spatial ... are you reading what I wrote or
commenting on the "IDS geospatial datablade" comment from someone else?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org