CA Service Management

Mar 24, 2017 04:56 PM

TMACUL

The first thing what you need know: VERY Important! Using pdm_load can be destructive so always back up your database before you perform a pdm_load, and use pdm_userload unless instructed to use pdm_load.

Important! Make a backup copy of the database before running pdm_load with this option. After old database records are removed, you must restore the CA SDM database with this backup copy if you want to recover any deleted records, use pdm_extract for this procedure.

1. BACKUP

BACKUP COMMAND
pdm_extract Priority > priority.txt

2. Structure table

bop_sinfo -dq pri
Factory pri < Priority > Attributes: id INTEGER UNIQUE producer_id LOCAL STRING(20) persistent_id LOCAL STRING(60) sym STRING(60) REQUIRED SKEY UNIQUE enum INTEGER REQUIRED service_type SREL -> no_contract_sdsc.code delete_flag del SREL -> actbool.enum REQUIRED description desc<nx_desc> STRING(255) last_mod_dt DATE last_mod_by SREL -> cnt.id TENANCY_UNRESTRICTED

bop_sinfo -dq pri

Factory pri < Priority >
Attributes:
id INTEGER UNIQUE
producer_id LOCAL STRING(20)
persistent_id LOCAL STRING(60)
sym STRING(60) REQUIRED SKEY UNIQUE
enum INTEGER REQUIRED
service_type SREL -> no_contract_sdsc.code
delete_flag del SREL -> actbool.enum REQUIRED
description desc<nx_desc> STRING(255)
last_mod_dt DATE
last_mod_by SREL -> cnt.id TENANCY_UNRESTRICTED

The original content

Structure load: pdm_extract Priority
TABLE Priority del desc enum id last_mod_by last_mod_dt service_type sym { "0" ,"LOW Priority" ,"1" ,"500" ,"171E5C822F5AA4409145FC5220142A50","11/25/2016 14:34:38" ,"sdsc:5406" ,"5" } { "0" ,"MEDIUM-LOW Priority" ,"2" ,"501","171E5C822F5AA4409145FC5220142A50" ,"11/25/2016 14:34:22" ,"sdsc:5405" ,"4" } { "0" ,"MEDIUM Priority" ,"3" ,"502" ,"171E5C822F5AA4409145FC5220142A50","11/25/2016 14:34:01" ,"sdsc:5407" ,"3" } { "0" ,"MEDIUM-HIGH Priority" ,"4" ,"503","171E5C822F5AA4409145FC5220142A50" ,"11/25/2016 14:30:59" ,"sdsc:5404" ,"2" } { "0" ,"HIGH Priority" ,"5" ,"504" ,"" ,"" ,"sdsc:5403" ,"1" } { "0" ,"Priority unassigned" ,"0" ,"505" ,"" ,"" ,"" ,"None" }

Structure load: pdm_extract Priority

TABLE Priority
del desc enum id last_mod_by last_mod_dt service_type sym
{ "0" ,"LOW Priority" ,"1" ,"500" ,"171E5C822F5AA4409145FC5220142A50","11/25/2016 14:34:38" ,"sdsc:5406" ,"5" }
{ "0" ,"MEDIUM-LOW Priority" ,"2" ,"501","171E5C822F5AA4409145FC5220142A50" ,"11/25/2016 14:34:22" ,"sdsc:5405" ,"4" }
{ "0" ,"MEDIUM Priority" ,"3" ,"502" ,"171E5C822F5AA4409145FC5220142A50","11/25/2016 14:34:01" ,"sdsc:5407" ,"3" }
{ "0" ,"MEDIUM-HIGH Priority" ,"4" ,"503","171E5C822F5AA4409145FC5220142A50" ,"11/25/2016 14:30:59" ,"sdsc:5404" ,"2" }
{ "0" ,"HIGH Priority" ,"5" ,"504" ,"" ,"" ,"sdsc:5403" ,"1" }
{ "0" ,"Priority unassigned" ,"0" ,"505" ,"" ,"" ,"" ,"None" }

id	enum	sym	nx_desc	service_type
500	1	5	LOW Priority	sdsc:5406
501	2	4	MEDIUM-LOW Priority	sdsc:5405
502	3	3	MEDIUM Priority	sdsc:5407
503	4	2	MEDIUM-HIGH Priority	sdsc:5404
504	5	1	HIGH Priority	sdsc:5403
505	0	None	Priority unassigned	NULL

select * 
from pri

CA SDM Loading contacts pdm_load

DEREF - pdm_deref - Everthing do you need know

CA SDM Load department using pdm_load - dept - ca_resource_department

Was useful, please leave your feedback!

CA SDM::. loading priority - pri

Related Entries and Links