(Optional) Task 3: Copy Data to the joinnode Table

Starting with version 9.32, Service Manager uses the joinnode table to replace the mainframe, networkcomponents, storage, and computer tables. If you are upgrading from Service Manager 9.31 or earlier and want to migrate to the joinnode-based data mappings, you need to copy data to the joinnode table.

Note If you want to use the original tables instead of joinnode, this task is not needed. Instead, you need to modify the data mappings of your Service Manager adapter in UCMDB.

To copy your data to the joinnode table, follow these steps:

  1. Log in to Service Manager as a system administrator.
  2. Open Database Manager
  3. Enter cidatacopy in the Table field, and then click Search. The Copy CI Type Data form opens.
  4. Click Search. A list of records is displayed: joincomputer, joinmainframe, joinnetworkcomponents, and joinstorage.
  5. Select each record from the list, update or add source/target fields as needed, and click the Copy Data button. One of the following messages is displayed:
    • A message that resembles “<XXX> records were successfully copied, and <YYY> records were ignored within xxx ms”, where XXX and YYY represent the numbers of records copied and ignored, respectively.
    • “Configuration validation failed, and no records were copied. Please check your Source Fields/Target Fields settings and run Copy Data again.”
  6. If the error message is displayed, correct your Source Fields/Target Fields settings, and click Copy Data again until all of your records have been successfully processed.