Page tree

Unsupported content

 

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Skip to end of metadata
Go to start of metadata

Because the BMC _CORE_BMC_BASERELATIONSHIP table used by BMC Atrium CMDB to store CI relationship data is not suitable for the reporting requirements of BMC Analytics for BSM, a new table is created during installation that prepares the operational data for use in the reports.

The installation utility populates the table using the PC_DENORMALIZE_BSM_RELATIONSHIPS procedure that retrieves BMC Business Service Class CI data from the BMC _CORE_BMC_BASERELATIONSHIP table and recursively traverses the table following the relationships that identify a service model, then stores the CI, Relationship and other denormalized data in the DENORMALIZE_BSM_RELATIONSHIPS table.

You should update the table whenever relationships are updated in BMC Atrium CMDB. See Updating the DENORMALIZE_BSM_RELATIONSHIPS table for more information.

The following table shows the detailed structure of the DENORMALIZE_BSM_RELATIONSHIPS table.

Structure of the DENORMALIZE_BSM_RELATIONSHIPS table

Column name

Type

Description

NODEID

VARCHAR2(38 BYTE)/VARCHAR(38)

Stores the reconciliation ID of the CI in the business service model that is representing the current row

LEVELNUMBER

NUMBER

Stores the level number for each CI in the tree as part of the root/ultimate Provider (Parent) or Consumer (Child). For example, it stores 1 for root-level parent and 2 for the immediate child when traversing from top to bottom in a tree.

NODEORDER

NUMBER

Stores the node-order number for each CI in the tree as part of root/ultimate Provider (Parent) or Consumer (Child). For example, it stores 1 for root-level parent, 2 for immediate child, and 3 for another immediate child of root-level parent when traversing from bottom to top in a tree.

RELATIONTYPE

VARCHAR2 (254 Byte) / VARCHAR(254)

Captures the relationship type between the CIs involved in a relationship; for example, DEPENDENCY, COMPONENT and MEMBEROFCOLLECTION

UNODE

VARCHAR2 (254 Byte) / VARCHAR(254)

Stores the reconciliation identity of the root-level parent when traversing from top to bottom in a tree or root-level child when traversing from bottom to top in a tree

REQUESTID

VARCHAR2 (38 Byte) / VARCHAR(38)

Stores the request ID of the row which belongs to the CI in the baserelationship table

INSTANCEID

VARCHAR2 (38 Byte) / VARCHAR(38)

Stores the instance ID of the row which belongs to the CI in the baserelationship table

UNODENAME

VARCHAR2 (254 Byte) / VARCHAR(254)

Stores the name of the root-level parent when traversing from top to bottom in a tree or root-level child when traversing from bottom to top in a tree

INODE

VARCHAR2 (38 Byte) / VARCHAR(38)

Stores the Reconciliation identity of the immediate provider for a given CI (Consumer)

INODENAME

VARCHAR2 (254 Byte) / VARCHAR(254)

Stores the name of immediate provider for a given CI (Consumer)

RELATIONSHIPNAME

VARCHAR2(254 BYTE)

The name of the relationship, like "member of," "hosts," or "hosted by," that the current CI forms with the CI at the next level

UPARENT

VARCHAR2(254 BYTE)

The reconciliation ID of the Business Service CI at the root of the business service model

RELATIONSHIP

VARCHAR2 (4000 Byte) / VARCHAR(4000)

Captures the relationship type between the CIs involved in a relationship along with the Immediate Provider Name

NODENAME

VARCHAR2(254BYTE)/ VARCHAR(254)

Stores the name of the Consumer

NODEDISPLAY

VARCHAR2 (4000 Byte) / VARCHAR(4000)

Stores the name of the Consumer with -- (hyphens) based on the order which falls in the tree

DATASETID

VARCHAR2(254BYTE)

Stores the dataset ID of the root-level provider/consumer

SHOW_RELATION

VARCHAR2 (38 Byte) / VARCHAR(38)

Stores the relation of Ultimate Provider/Consumer with dependent CIs. It stores PARENT when traversing from top to bottom in a tree or CHILD when traversing from bottom to top in a tree.

RELATION_CODE

NUMBER/INT

Stores the numeric value 0 for the parent and 1 for the children. This column is required for data translation.

SOURCE_CLASSID

VARCHAR2(254 BYTE) / VARCHAR(254)

Stores the class ID of the Provider/Parent/Source (source class ID)

DESTINATION_CLASSID VARCHAR2(254 BYTE)

VARCHAR2(254 BYTE) / VARCHAR(254)

Stores the class ID of the Provider/Parent/Destination (destination class ID)