Technical Blog Post
Abstract
Why the storage group status is 0x0000000A
Body
Normally the storage group status is 0. The following is an example that the storage group status is set to 0x0000000A instead:
$ db2pd -d mydb -storagegroup
Database Member 0 -- Database MYDB -- Active Standby -- Up 11 days 18:50:57 -- Date 2018-02-20-11.08.11.478864
Storage Group Configuration:
Address SGID Default
0x00003FFD04642820 0 Yes 0 IBMSTOG
Storage Group Statistics:
Address SGID State
0x00003FFD04642820 0 0x0000000A 2 0
Storage Group Paths:
Address SGID PathID
0x00003FFD04666000 0 0 InUse /path1
0x00003FFD04668000 0 1 InUse /path2
The state 0x0000000A of storage group is a combination of the following two flags:
* 0x0000000000000002 - SQLB_STORAGEGROUP_SKIP_ALTERS
* 0x0000000000000008 - SQLB_STORAGEGROUP_REDEFINE_CON
Other possible values are documented at the following link:
https://www.ibm.com/support/kn
These flags may be turned on when you restore the database to set up HADR and storage group has been redefined
using "ON..."option or other ways that redefine the storage group.
UID
ibm11140202