The Article below describes the steps pdm_publish
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.