What files are modified/created while running pdm_publish?

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

What files are modified/created while running pdm_publish?

Environment

Release:
Component: ARGIS

Resolution

This process creates 5 files on the primary server under site/mods.

• wsp.mods gets created under Majic folder.
• Wsp_schema.sch and wsp_index.sch: contain all physical dbms changes that area created with wsp
• Wsp.altertbl file lists new tables in text format.
• Wsp.altercol is a text file listing new columns.

The changes are replicated to all the domsrvr using wsp.mods

To complete publishing, user must shutdown services.-> run pdm_publish script on primary server.

Pdm_publish runs a utility called schmerge to merge new schema with existing schema

It rebuilds service desk data dictionary. It also updates wsp_schema.log in site/mods. This file is a log file that lists all the tables and columns that are added. Pdm_publish reads it to figure out what tables and columns are already added so that it doesn't attempt to publish the published tables. Hence it is strongly recommended not to delete this file.