CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - Prob_Ctg

Document created by TMACUL Champion on Jun 24, 2015Last modified by TMACUL Champion on Apr 26, 2017
Version 4Show Document
  • View in full screen mode

Everthing about pdm_load for CA SDM Categories

 

Do you have some tip, please comment this DOC and we´ll improving our knowledge.

 

ITIL Definition: Category (v2, v3) Category (ITILv3): A named group of things that have something in common. Categories are used to group similar things together. For example Cost Types are used to group similar types of Cost. Incident Categories are used to group similar types of Incident.

 

 

 

Category (ITILv2):    Classification of a group of Configuration Items, e.g., hardware, Changes, Problems

 

 

 

1. 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.

 

2. pdm_load updates a CA SDM database using an input file you specify, up to a maximum of 112 attributes.

 

3. Syntax

This command has the following format:

pdm_load [-c] [-h] [-m] [-r] [-u] [-v] -f filename

 

4. File Format

 

The input file entries follow this format:

TABLE table_name fieldname1 fieldname2 . . . . fieldnameN { "value11", "value12", . . . "value1N" } { "value21", "value22", . . . "value2N" } . . . { "valueN1", "valueN2", . . . "valueNN" }

 

Do you need use accents? Save text file in UTF-8 format.

ERROR for accents: Invalid character encountered in input

 

5. BACKUP

 

 

BACKUP COMMAND
pdm_extract Prob_Category > Prob_Category.txt

 

 

 

 

6. Bulding our input file (Download Excel input file Schema)

 

6.1 Required Fields (SYM and SS_INCLUDE)

       SS_INCLUDE ::. ERROR: error 8 on update: Table Prob_Category is missing value for ss_include

      

TABLE Prob_Category

sym ss_include

{"category.type.item", "0"}

 

For each "." we´ll see a new level.

 

{"Software.Environment.DOS", "0"}

CASDM_20150624_pcat.jpg

 

Save your file, example: load_category.txt

 

7. Input command

 

pdm_load -i -f load_category.txt

 

What means i and f?

 

-i ==> Insert

 

-f  ==>  filename Specifies an input ASCII file.

 

8. Do you have tenants?

 

Use t parameter

 

-t ==> Specify your tenant name, for example: -t CA (pdm_load -i -f load_category.txt -t CA)

 

9. Structure table

bop_sinfo -dq pcat

Factory pcat < Prob_Category >

Attributes:

   id                   INTEGER UNIQUE

   producer_id          LOCAL STRING(20)

   persistent_id persid STRING(30)

   delete_flag del      SREL -> actbool.enum REQUIRED

   sym                  STRING(1000) REQUIRED SKEY

   last_mod_dt          DATE

   last_mod_by          SREL -> cnt.id TENANCY_UNRESTRICTED

   description          STRING(500)

   organization         SREL -> org.id

   assignee             SREL -> agt.id SERVICE_PROVIDER_ELIGIBLE

   group group_id       SREL -> grp.id SERVICE_PROVIDER_ELIGIBLE

   properties           BREL <- cr_prptpl.owning_area {owning_area = ?}

   survey               SREL -> svy_tpl.id

   auto_assign          INTEGER

   service_type         SREL -> sdsc.code

   category_urgency     SREL -> urg.enum

   owning_contract      SREL -> svc_contract.id

   cr_flag              INTEGER

   in_flag              INTEGER

   pr_flag              INTEGER

   suggest_knowledge    INTEGER

   assignable_ci_attr   STRING(60)

   service_grps         BREL <- lrel_svc_grps_svc_pcat.pcat (LREL cnt) {pcat = ?}

   service_locs         BREL <- lrel_svc_locs_svc_pcat.pcat (LREL loc) {pcat = ?}

   service_schedules    BREL <- lrel_svc_schedules_pcat_svc.pcat (LREL wrkshft) {pcat = ?}

   ss_include           SREL -> bool.enum REQUIRED

   ss_sym               STRING(128)

   flow_flag            INTEGER

   caextwf_start_id     SREL -> caextwf_sfrm.id

   cawf_defid           STRING(40)

   cawf_defname         LOCAL STRING(0)

   cawf_desc            LOCAL STRING(0)

   cawf_active          LOCAL STRING(0)

   cawf_effective       LOCAL INTEGER

   cawf_cache           LOCAL DATE

   ebr_doc_blc <>       STRING(0)

   ebr_serial_num <>    STRING(0)

   ebr_relevance <>     STRING(0)

   ebr_ks_teaser <>     STRING(0)

   ebr_ks_concepts <>   STRING(0)

   ebr_search_in <>     STRING(0)

   ebr_fuzziness <>     STRING(0)

   ebr_match_type <>    STRING(0)

   ebr_search_text <>   STRING(0)

   ebr_primary_order <> STRING(0)

   ebr_order_direction <> STRING(0)

   ebr_search_type <>   STRING(0)

   sap_prop             INTEGER

 

 

Structure load: pdm_extract pcat

TABLE Prob_Category

assignable_ci_attr assignee auto_assign caextwf_start_id category_urgency cawf_defid cr_flag del description flow_flag group_id id in_flag last_mod_by

last_mod_dt organization owning_contract persid pr_flag sap_prop schedule service_type ss_include ss_sym suggest_knowledge survey sym tcode tenant

 

 

CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - User view Prob_Ctg Category.xlsx

 

REFERENCES:

pdm_load 

https://support.ca.com/cadocs/0/CA%20Service%20Desk%20Manager%2012%207-ENU/Bookshelf_Files/HTML/CA_SDM_Admin_ENU/pdm_load_add_update_and_delete_database_records.html?intcmp=searchresultclick&resultnum=2492

 

 

http://www.itsmsolutions.com/newsletters/DITYvol6iss27.htm

 

http://www.knowledgetransfer.net/dictionary/ITIL/en/Category.htm

6 people found this helpful

Attachments

    Outcomes