Notifications

54 views

Description


Since the introduction of a Version N-1 or N-2 Support Policy, all instances should now be using the Table-Per-Partition Extended Table method for the Configuration Management Database's (CMDB) underlying SQL database structure.

VersionApplication TablesSQL TablesExtended Table/Flattening Method
<= Fuji  cmdb_ci, and all extending tables cmdb_ci, cmdb_ci_hardware, cmdb_ci_computer, etc.Table-Per-Class
>= Geneva  cmdb, and all extending tables, including cmdb_ci
A 'cmdb' table was slotted in above 'cmdb_ci' to become the new parent table.
 cmdb, cmdb_ci, cmdb_ci_hardware, cmdb_ci_computer, etc.Table-Per-Class
>= Jakarta  Unchanged cmdb + cmdb$par1 [ + cmdb$par2 ]Table-Per-Partition

A lot of CMDB-related code in more recent versions expects this to have happened. Problems and data loss can in theory occur if this is not done. Please open an Incident with Customer Support if you notice this has not happened in your instance.

Procedure


Did Geneva Re-Parenting happen?

  1. Open a list for the 'cmdb_ci' table
    /cmdb_ci_list.do
  2. Open a list for the 'cmdb' table
    /cmdb_list.do
  3. If cmdb_ci lists lots of records, and cmdb lists none, or doesn't even load a list view, then Geneva Re-Parenting has not happened.

Did Jakarta TPP Migration happen?

  1. Open the Tables table list:
    /sys_db_object_list.do
  2. Search for a table in that list with name=cmdb$par1
  3. If cmdb$par1 is not listed then TPP Migration has not happened.

Applicable Versions


Post Geneva and/or Jakarta.

Article Information

Last Updated:2019-01-16 00:15:29
Published:2019-01-16