topic Re: Savings by compaction in Active IQ Unified Manager Discussions

Savings by compaction

matthias_beck — Wed, 22 Nov 2017 14:27:23 GMT

Hello,

Are the savings by compaction, which is based on the aggregate level, already available in the DWH?

Thank you

Re: Savings by compaction

ostiguy — Wed, 22 Nov 2017 14:36:56 GMT

Hey Matthias,

OCI 7.3.1 has an extensible schema capability. We have patches in OCI 7.3.1 that extend the storage pool object to have some attributes to store facts about compaction.

In OCI 7.3.1, within the DWH it is possible to perform point in time reporting on attributes brought into OCI via the extensible schema

Matt

Re: Savings by compaction

matthias_beck — Wed, 22 Nov 2017 14:49:37 GMT

Hey Matt,

Thank you for the information.

Currently we are running on 7.3.0 and at the Insight in Berlin I already saw 7.3.2. Is there already aplanned release time frame for it?

I don't want to do the update to 7.3.1 and a week later to 7.3.2.

Regards

Matthias

Re: Savings by compaction

ostiguy — Wed, 22 Nov 2017 14:56:32 GMT

OCI 7.3.2 is expected late in calendar Q1, 2018.

Re: Savings by compaction

matthias_beck — Fri, 01 Dec 2017 12:55:36 GMT

Hello Matt,

It seems that I'm blind 🙂

Can you give me a hint where I can find the scheme in the DWH?

Last week I have updated our OCI Environment to 7.3.1.

Thank you

Regards

Matthias

Re: Savings by compaction

ostiguy — Fri, 01 Dec 2017 13:49:41 GMT

Crikey, I need coffee.

We are talking compaction, not compression, so I am re-writing this answer.

Compaction was added to storage pools via the 7.3.1+ extensible schema. For now, the DWH only has point in time values in the DWH_inventory mart.

extended_data

is the table I believe you want to look at

Re: Savings by compaction

matthias_beck — Fri, 01 Dec 2017 14:56:44 GMT

Hey Matt,

no problem. 🙂

Currently I cannot see the extended_data in the Database.

How do I get this 7.3.1+ extensible schema?

I already got the link to the latest data source patches, but I think there it is not included.

Regards

Matthias

Re: Savings by compaction

ostiguy — Fri, 01 Dec 2017 15:55:31 GMT

Data source patches in 7.3.1+ can extend the schema.

Looking at your OCI ASUP data, it looks like you are running cDOT datasource code as it shipped with 7.3.1

It could be that 7.3.1 didn't ship out of the box with compaction support within cDOT.

It may also be, that the DWH dynamically creates that table as necessary, and perhaps you have no datasources deployed that extend the schema.

We are unfortunately behind, and haven't been able to ship a data source service pack for 7.3.1 yet, as had been expected.

Installing the latest cDOT patch may sort this out - on my laptop, compaction is additionally visible as part of the capacity as a time series feature

Matt