Active IQ Unified Manager Discussions

WFA QSM Table for Storage Scheme

RoiBeci
4,292 Views

Hi All,

 

I've been trying to work with the "QSM" table in the WFA DB, but it seems to be missing there, although we have a Dictionary type called "QSM".

 

Can someone please point out what am I missing?

 

 

Thanks,

 

Roi Becidan.

1 ACCEPTED SOLUTION

rkiran
4,178 Views

Hi,

 

Looks like QSM information is available in OCUM server in dfm database 'snapmirrorStatus' table, but I didnt find any schedule information for QSM from dfm database.

 

The attributes available in the table are:

 

snapmirrorId","snapmirrorDstId","snapmirrorSrcId","snapmirrorSrcName","snapmirrorConnId","snapmirrorDstHostId","snapmirrorDstVolId","snapmirrorDstQtreeId","snapmirrorSrcHostId","snapmirrorSrcVolId","snapmirrorSrcQtreeId","snapmirrorFlags","snapmirrorState","snapmirrorStatus","snapmirrorTotalTransMBs","snapmirrorTotalTransTimeSeconds","snapmirrorTransMBs","snapmirrorTransTimeSeconds","snapmirrorSyncToAsync","snapmirrorDiscoverTimestamp","snapmirrorTimestamp","snapmirrorUpdateTimestamp","snapmirrorRplPlcyId","snapmirrorFalvrPlcyId","snapmirrorLastDataset"

 


Here are the steps to cache the data from WFA:

 

Clone the certified 'QSM' Dictionary Entry:
- enable to be cached property for 'dest_interface', 'src_interface', 'src_qtree' and 'dest_qtree' attributes
- disble can be null property for 'src_qtree' and 'dest_qtree' attributes
- enable natural key property for 'src_qtree' and 'dest_qtree' attributes


Add a new cache query for the cloned dictionary entry to acquire the data. You can try to use the following cache query:

 

SELECT
snapmirrorStatus.snapmirrorId AS id,
destInterface.objName as dest_interface,
srcInterface.objName as src_interface,
snapmirrorStatus.snapmirrorSrcQtreeId AS src_qtree_id,
snapmirrorStatus.snapmirrorDstQtreeId AS dest_qtree_id
FROM
dfm.snapmirrorstatus snapmirrorStatus
JOIN
dfm.objects srcInterface
ON snapmirrorStatus.snapmirrorSrcHostId = srcInterface.objId
JOIN
dfm.objects destInterface
ON snapmirrorStatus.snapmirrorDstHostId = destInterface.objId
AND snapmirrorStatus.snapmirrorSrcQtreeId IS NOT NULL
AND snapmirrorStatus.snapmirrorDstQtreeId IS NOT NULL


Note: I have not tested this with real qtree QSM data.

View solution in original post

6 REPLIES 6

shailaja
4,269 Views

Hi,

 

QSM dictionary entry is not applicable for acquisition as there are no cache queries written for it.

Please refer to this previous community thread on this:

http://community.netapp.com/t5/OnCommand-Storage-Management-Software-Discussions/Find-QSMs-in-a-volume-Finder/m-p/80900/highlight/true#M16826

 

Thanks,
Shailaja

RoiBeci
4,260 Views

Hi,

 

Maybe do you know how can I create a cache query for the "qsm" object? any reason why it was not written?

 

I'm not familiar with the DFM DB structure, maybe some guides that can help me cache that?

 

Thanks,

 

Roi

abhit
4,213 Views

Which version of Oncommand Unified manager are you using?

 

Regards

Abhi

RoiBeci
4,205 Views

It is OCUM 5.2 

rkiran
4,179 Views

Hi,

 

Looks like QSM information is available in OCUM server in dfm database 'snapmirrorStatus' table, but I didnt find any schedule information for QSM from dfm database.

 

The attributes available in the table are:

 

snapmirrorId","snapmirrorDstId","snapmirrorSrcId","snapmirrorSrcName","snapmirrorConnId","snapmirrorDstHostId","snapmirrorDstVolId","snapmirrorDstQtreeId","snapmirrorSrcHostId","snapmirrorSrcVolId","snapmirrorSrcQtreeId","snapmirrorFlags","snapmirrorState","snapmirrorStatus","snapmirrorTotalTransMBs","snapmirrorTotalTransTimeSeconds","snapmirrorTransMBs","snapmirrorTransTimeSeconds","snapmirrorSyncToAsync","snapmirrorDiscoverTimestamp","snapmirrorTimestamp","snapmirrorUpdateTimestamp","snapmirrorRplPlcyId","snapmirrorFalvrPlcyId","snapmirrorLastDataset"

 


Here are the steps to cache the data from WFA:

 

Clone the certified 'QSM' Dictionary Entry:
- enable to be cached property for 'dest_interface', 'src_interface', 'src_qtree' and 'dest_qtree' attributes
- disble can be null property for 'src_qtree' and 'dest_qtree' attributes
- enable natural key property for 'src_qtree' and 'dest_qtree' attributes


Add a new cache query for the cloned dictionary entry to acquire the data. You can try to use the following cache query:

 

SELECT
snapmirrorStatus.snapmirrorId AS id,
destInterface.objName as dest_interface,
srcInterface.objName as src_interface,
snapmirrorStatus.snapmirrorSrcQtreeId AS src_qtree_id,
snapmirrorStatus.snapmirrorDstQtreeId AS dest_qtree_id
FROM
dfm.snapmirrorstatus snapmirrorStatus
JOIN
dfm.objects srcInterface
ON snapmirrorStatus.snapmirrorSrcHostId = srcInterface.objId
JOIN
dfm.objects destInterface
ON snapmirrorStatus.snapmirrorDstHostId = destInterface.objId
AND snapmirrorStatus.snapmirrorSrcQtreeId IS NOT NULL
AND snapmirrorStatus.snapmirrorDstQtreeId IS NOT NULL


Note: I have not tested this with real qtree QSM data.

RoiBeci
4,159 Views

seems like now my cloned qsm table has valid data inside.

 

thanks 🙂

Public