Basic questions un-answered by storage scope?

Hi,

I have another question regarding storagescope and running queries...

I need to be able to report on host storage capacity but the problem I have is that we have the same LUNS assigned to move than one storage group (on CLR)...

How can I run report to extract what capacity is allocated without doing a duplicate count on the LUNS...

Hopefully this makes sense what I'm asking...if not let me know and I'll try and explain better...

Thanks and regards

David

There are several ways you can get the host storage report without counting the luns multiple times:

1.View host allocated capacity from array side

In query builder, create custom query from object Arrays and bring in columns:

Array Name

Raw Host Allocated

Host Allocated

The query shows you Total Allocated Capacity to hosts for each array. The luns are only counted once even though they are allocated to multiple hosts. All capacities under Array object are not double counted.

2. View host allocated capacity from host side

- Create user defined group from ECC console and put those hosts Lun allocated to in the same group.

- Run ETL.

- Create custom query by select object Groups under host category and bring in allocated capacities

The query shows you total allocated capacity for each group without double counting.

Thanks.

Sarah

Hi David,

From generated SQL, it seems you did not select the right objects. There is no need to select Host Array Path and Switch objects. The report you want to see is to get host allocated capacity per host from each array.  The object that gives the information is Host Arrays:

1. Select Hosts, Host Arrays, Arrays

2. Select columns:

Arrays.Array Names

Hosts.Host Names

Host Arrays.Allocated

3. Save and Run the query

This query will give you allocated capacity for host from each array.

If you have luns shared by multiple hosts, the lun capacity is included for each host. For example, if 10GB lun is allocated to host A and B. Both host A and B get allocated capacity of 10GB. However if you look at Array report, the total allocated capacity from array is still 10GB. The lun capacity is not counted twice.

You mentioned that you also want Primary capacity, clone capacity and DR capacity.

StorageScope does not support clone at this time. Primary capacity can be found in both host and array tables. What is DR cpacity?

Thanks.

Sarah

Hi Sarah,

Thanks for the feedback on this...but this is exactly my problem...

I can obtain the information from an array point of view but I need to see this from the host side...without counting the LUNS twice...or on some occasions three times for the different SG's (this is on CLR)...

DR refers to disaster recovery - which means storage allocated on the disaster recovery side...

Our set-up is as follows:

Sybase environment and we have 1 writer node and 4 query nodes...

LUNS are shared between the writer node and the 4 x query nodes...

The writer node and query node also have what we call their own Primary storage which is why each node is in its own SG on the CLR's...

For all the Primary storage we have 2 x Clones

The clones are cycled and are source LUNS for San Copy (which is used to replicate the data to the DR side)

On the DR side we have the SAN Copy target LUNS and

A clone copy or gold copy that is taken off the SAN Copy target LUNS

And

All this spans multiple CLR's - in total 8 x CLR's...

So we have the following:

Primary: 1 x Primary set of LUNS

2 x Clones

SAN Copy to DR - Source LUNS of SAN Copy are Clone LUNS...

DR-Site: 1 x SAN Copy target LUNs

2 x Clones

So as you can see to extract what is allocated where is quite a headache in terms of reporting...

And this is only one of the environments...

Any idea when Clones and MirrorView etc will be supported for reporting purposes?

Thanks and regards

David

When you say you need the capacity from host side without double counting, I am assuming you are doing sum up for all the hosts, right? Because for each individual host, there is no double counting involved. If 10GB lun is assigned to 2 hosts, each host does see 2 GB capacity and host allocated capacity for those two hosts is 2GB. However if you do subtotal or total from query builder, you will see 4 GB because query builder does straightly summation for the data.

For UB8, we are planning to add shared storage support to help solve the issue. Chargeable capacity will be introduced. Customer can choose either to Dirstribute the capacity to all hosts or Assign all capacity to one host.

For example, a 10 GB lun is assigned to 2 hosts A and B. The allocated capacity for each host is 10 GB. The chargeable allocated capacity for hosts will be 5 GB if you choose to distribute among all hosts. Or if you choose to Assign to single host, Chargeable capacity for host A will be 10 GB and Host B will be 0. In query builder when doing subtotal, the chargeable allocated capacity for both hosts will still be 10 GB without any double or multiple counting.

Thanks once again for the update Sarah...much appreciated.

This is exactly what I'm looking for...

Any date as to when UB8 will be available or release notes out as yet so I can see what all is coming in UB8?

Thanks, that would be great.

We be nice to get a set of the release notes as well so we can see what all is planned for UB8, unless this is what is planned for in the demo?

As if you need another person to say "I am in this boat too", I will throw in my 2 cents - just for the sake of me believing my scenario is still FAIRLY unique. We are allocating our DMX storage to 3 large areas, all of which are completely black holes to either ECC and StorageScope. I have a Unisys Mainframe, Recoverpoint and my Storage Virtualization Appliances that are not the same faceplate as the DMX . We have always been *this close* to using ECC for all sorts of great things. But we can't. At least, not out of the box. Currently, we have an active project going with our friends in Hopkinton that will attempt to set up a system to overcome the lack of intelligent communication between ECC and the environments my DMXs serve. It is also being designed with the lofty goal of overcoming the uselessness of the engineering-minded numbers produced by ECC & STS. We will be taking Raid into account. We will not accept double reporting of volumes that are mapped to both the Mainframe and Recoverpoint. We will not accept double reporting of volumes we can swing between our Test Mainframe and our Production Mainframe. This custom reporting proposal is an additional product to ECC called Enterprise Data Gateway. There are parts of it we will need to feed from the systems we are trying to report on, but we won't sign off on the product unless we can easily feed it and the reports make sense. Not to me...to my director. So, cheers to you nfwtnit, and if EDG does great things for our reporting challenges, I will be shouting from the rooftop. If it wastes our time, I'll bring an extra megaphone.

PS, note to EMC - Just because I allocate boatloads of my best RAID10 DMX disk to Recoverpoint, doesn't mean I didn't have to pay for it. This disk is not invisible to management and it's the top tier of what we have...it would have been nice to at least been able to report on the EMC based product!

I never use Storage Scope or ECC to get this. The method I take is a bit of labor but sure gives you a definitive answer.

For a DMX. I run symdev -sid **** list -noport -raid5 >> ****.txt (In case we have all raid-5 devs in that SYMM)

open it using XL and # of columns multiplied by the size of your disk is the amount of disk left.

This saved a lot of time for me instead of fooling with storage scope.

OR ECC tells you the # of unmapped luns out there also so we can calculate using that if case you dont want to mess with CLI.

If you want to know what is uncarved try to preview a dev create config change to see how many you can.

Well said.  Sadly, EMC has done nothing to help the engineer deal with management.  Try to generate this report in StorageScope...Good Luck.