Verifying your data model using the cmdbdiag program
The cmdbdiag
program is a command-line tool, which is located in the cmdb\server64 directory of your BMC Atrium Core installation. This program allows you to check for any invalid data in BMC Atrium Configuration Management Database (BMC Atrium CMDB) and correct it.
Working with the Data Integrity Checker option
The Data Integrity Checker validates BMC Atrium CMDB for the various issues based on the menu option you choose. If the Data Integrity Checker finds invalid data, it creates a report that contains information about the invalid relationship instances and datasets.
To start the cmdbdiag program
When you launch cmdbdiag
, provide your BMC Remedy AR System logon credentials for the computer hosting BMC Atrium Core.
- Navigate to the appropriate location where you copied the
cmdbdiag
program and perform the following step:- On Windows, double-click
cmdbdiag.exe
. - On UNIX, type
cmdbdiag
.
- On Windows, double-click
- From the initial screen for the
cmdbdiag
program, log on to the AR System server. Thecmdbdiag
program Main Menu appears.
To troubleshoot invalid relationships
Check for invalid relationships — relationship instances that point to nonexistent Configuration Item (CI) instances or relationships that contain incorrect endpoint information, such as incorrect dataset ID or class ID.
- Start the
cmdbdiag
program. - At the Main Menu prompt, type 1.
- At the Data Integrity Checker prompt, type 1.
- At the All datasets [y, n] prompt, perform the appropriate action:
- To view invalid relationships for all datasets, type y.
- To view invalid relationships for a specific dataset, press Enter and provide a dataset ID.
- Enter a name for the output file, or press Enter to accept the default file name.
If you enter a file name manually, specify an absolute path for the file (for example, C:\DIC_Invalid_Relationships.txt). Otherwise, the program saves the report file in the same directory as thecmdbdiag
program.
To troubleshoot invalid dataset IDs
Check for invalid dataset IDs — Incorrect dataset IDs specified for CI and relationship instances. A dataset ID might be incorrect if it refers to:
- A nonexisting dataset
- Contains a value of 0 or NULL
- Start the
cmdbdiag
program. - At the Main Menu prompt, type 1.
- At the Data Integrity Checker prompt, type 2.
- Specify a name for the output file or press Enter to accept the default file name.
If you manually enter a name, you must specify an absolute path for the file (for example: C:\dataset_ids.txt ). Otherwise, the program saves the report file in the same directory as thecmdbdiag
program.
To troubleshoot invalid CI relationships
Check for relationship cardinality issues — invalid relationships that are caused by a violated relationship cardinality, which occurs when a relationship between CI classes does not fall into one of the following categories:
- One to one
- One to many
- Many to one
- Start the
cmdbdiag
program. - At the Data Integrity Checker prompt, type 3.
- At the All datasets [y, n] prompt, perform the appropriate action:
- To check for relationship cardinality issues for all datasets, type y.
- To check for relationship cardinality issues for a specific dataset, press Enter and provide a dataset ID.
- Specify a name for the output file or press Enter to accept the default file name, test_cardinality.txt.
If you manually enter a name, you must specify an absolute path for the file (for example: C:\DIC_Cardinality.txt ). Otherwise, the program saves the report file in the same directory as thecmdbdiag
program. - To exit the Data Integrity Checker option, type 4.
Comments
A nice tip in case folks run into it: While using UNIX directions, the Backspace key may not work correctly.
I find that if you use the Control-Backspace while navigating through the prompts it appears to properly perform the destructive-backspace.
Hi David,
Thank you for your suggestion!
Regards,
Maithili