DB2 - unnecessary second Stripe Set?

[marke_]

Hi,
we have the following situation after upgrading system, dont know why...


This is for every tablespace. There are 4 SAN volumes, but only 3 of them are added to a second stripe set.
Why was there a second stripe set created automatically with just 3 of 4 volumes??

So one negative effect, there is NO equal distribution on the volumes.

AUTOMATIC storage was always activated. Current version is v11.1.
Disabling automatic storage is not possible as I know... so do you know how to 'clean' that (deleting second stripe set including the container, for example)?

I think one possibilty should be a redirect restore.

Thanks for any response.

[marke_]

Sorry screenshot was not inserted:

[Frank-Martin]

Hi Mark,

difficult to tell why this unbalanced new stripe set has been created. Is it possible that your storage paths became temporarily full? This may for example happen when data and index tablespaces share the same storage paths with temporary tablespaces. We recommend to use seperate storage paths for them.

Yes, redirected restore is one option to solve the problem.

Depending on the tablespace size it may also possible to create a new tablespace and empty the old tablespace by moving the content over with DB6CONV.

Waiting for better answers from the BACKUP/RESTORE experts.

Regards Frank

[marke_]

Hi Alexander

thank you, but you mentioned the storage group.

But in my case there are four paths, all in that one storage group IBMSTOGROUP.

My problem belongs to the stripe sets. For every tablespace there is an additional stripe set ("1") with just 3 of 4 paths.

But I can not add or delete the path to that stripe set, because Automatic Storage ist activated.

Regrads

[alexander_bertram]

Hi,

the database manager added containers as needed.

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c00...

Effect is also described here:

https://www.ibm.com/support/knowledgecenter/pt/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/r00...

Solution here:

https://www.ibm.com/support/knowledgecenter/pt/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/r00...

So basically you would have to:

<code>ALTER STOGROUP sg DROP '/path2'

as far as i understand this topic.

Maybe also check the rebalance command.

To be honest i never experienced the effect on our systems so be cautious about working on this.

Best,

Alex