Script Name 

tclsh healing_before_migration.tcl

Function 

hl_H0343.sql. 

Deletes PIs and branches that do not have PIVs. 
Additionally this script deletes library objects 
(LOs), which do not have LOVs. This addresses a 
previously known issue with the Pro/INTRALINK 
delete function. 

hl_day1.sql 

Creates table columns that exist in 
Pro/INTRALINK Data Dictionary but do not exist 
in Oracle schema. 

hl_sequences.sql 

This script creates missing oracle sequences and 
drops any unnecessary oracle sequence that it 
encounters. 

hl_pivclass.sql 

Fixes the PDM_PRODUCTITEMVERSION.PIVCLASS 
file, which identifies specific PIVs as being a family 
table generic or instance. This addresses a 
previously known issue with Pro/INTRALINK. 

hl_populateudas.sql 

Drops UDA tables not registered in data dictionary. 
Additionally, this script populates all primary keys 
in UDA tables. 

hl_views.sql 

This script upgrades portions or the replication 
registry. The script works in conjunction with 
hl_updreplreg.sql. 

hl_checkOQLs.sql 

Deletes all predefined OQLs and recreates them. 

hl_updreplreg.sql 

This script upgrades the replication registry to 
ensure that the all replicated data is in sync with 
other Pro/INTRALINK databases. 

hl_unique_pivbrver.sql 

This script creates a unique index pdm_Br_BrVer 
on pdm_ProductItemVersion and checks the 
constraint CHK_pdm_ProductItemVersion 

hl_del_unused_pivtxns.sql 

This script deletes primary and secondary 
transaction IDs if the PIVs in those transactions 
are not used by any other PIVs 

hl_report_broken_mapname.sql 

This script checks if any file's mapnames were 
potentially reused by 3.3 upgrade 

hl_famtab.sql 

This script checks consistency of Family Tables in 
Pro/INTRALINK database, also checks for PIs with 
no PIVs. 
