What files are modified/created while running pdm_publish?

Document ID : KB000054696
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

The Article below describes the steps pdm_publish

Solution

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.