Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Utilities
  3. createdatamaps - Data Map Creation Utility
  4. DTLCCADW - Adabas PCAT Utility
  5. DTLCUIML - IMS Log Marker Utility
  6. DTLINFO - Release Information Utility
  7. DTLREXE - Remote Execution Utility
  8. DTLUAPPL - Restart Token Utility
  9. DTLUCBRG - Batch Registration Utility
  10. DTLUCDEP - CDEP Maintenance Utility
  11. DTLUCSR2 - IDMS SR2 and SR3 Records Utility
  12. DTLUCUDB - DB2 for Linux, UNIX, and Windows CDC Utility
  13. DTLULCAT and DTLULOGC - IDMS Log Catalog Utilities
  14. DTLURDMO - Data Map Utility
  15. DTLUTSK - Task Control Utility
  16. EDMLUCTR - Log Scan and Print Utility
  17. EDMXLUTL - Event Marker Utility
  18. HOSTENT - TCP/IP Address Reporter Utility
  19. PWXCATMY - MySQL Catalog Utility
  20. PWXUCCLPRT - Print Log Summary Utility
  21. PWXUCDCT - Logger for Linux, UNIX, and Windows Utility
  22. PWXUCREG - Capture Registration Suspend Utility
  23. PWXUCRGP - Capture Registrations Print Utility
  24. PWXUDMX - Data Maps Update Time ECSA Memory Utility
  25. PWXUGSK - SSL Reporting Utility for z/OS
  26. PWXUMAP - Map List Utility
  27. PWXUSSL - PowerExchange SSL Reporting Utility

DM_COPY Validate Example

DM_COPY Validate Example

The following example shows the validate mode report for a DTLURDMO DM_COPY statement:
DTLURDMO DM_COPY .\UpdateToLocal_ADA_V.ini ============================================ Source: Location SYSBUSRA1 User USRA1 EPWD=**** Target: Location LOCAL User USRA1 EPWD=**** Output I:\datamaps_SYSBUSRA1 Detail YES (Print a detailed report) Testmode NO Validate YES (Process maps/registrations but do not save them) Replace YES Number of DM_COPY items 2 Data map copy started =========================================================================== DM_COPY # 1 Exclude: Schema 'cpn301' Map 'sysbusra1' Select: Schema 'ada200' Access Method 'ADABAS' Rename: Schema 'ada200' to 'XXXada200' Rename: Table 'ADA_RECORD' to 'XXX_ADA_RECORD' Modify: AM=ADA DBID=9200 Modify: AM=ADA FILENO=9001 ========================================================================== DMY selection SQL 'DBLIST DMX,ada200,*,SYSBUSRA1' 1: Data map: Schema 'ada200' Map 'ada200f001' Access method 'ADABAS' ==================================================================== SCHEMA ada200 changed to XXXada200 TABLE ADA_RECORD changed to XXX_ADA_RECORD DBID 200 changed to 9200 FILENO 1 changed to 9001 Updated and renamed data map: Schema 'ada200' Map 'ada200f001' Changes 4 Tables: XXX_ADA_RECORD DBID = 9200, FILENO = 9001 Save of map skipped because of VALIDATE=Y 2: Data map: Schema 'ada200' Map 'save' Access method 'ADABAS' ============================================================== SCHEMA ada200 changed to XXXada200 TABLE ADA_RECORD changed to XXX_ADA_RECORD DBID 200 changed to 9200 FILENO 1 changed to 9001 Updated and renamed data map: Schema 'ada200' Map 'save' Changes 4 Tables: XXX_ADA_RECORD DBID = 9200, FILENO = 9001 Save of map skipped because of VALIDATE=Y Totals for DM_COPY #1 ===================== Data maps Excluded 0 Data maps Not Selected by name 0 Data maps Not Selected by access method 0 Data maps Selected 2 --------------------------------------------------------- Data maps Read 2 Data maps Updated with changes 2 Data maps Written 0 ============================================================================ DM_COPY # 2 Exclude: Schema 'cpn301' Map 'sysbusra1' Exclude: Schema 'ada200' Access Method 'ADABAS' Select: Access Method 'ADABAS' Rename: Table 'ADA_RECORD' to 'YYY_ADA_RECORD' ============================================================================ DMY selection SQL 'DBLIST DMX,*,*,SYSBUSRA1' Data map 'a.notfound' not selected because access method 'S' not in AM select list 1: Data map: Schema 'aaada1000' Map 'fdt50' Access method 'ADABAS' ================================================================== Copied data map: Schema 'aaada1000' Map 'fdt50' Tables: YYY_ADA_RECORD DBID = 1000, FILENO = 50 Save of map skipped because of VALIDATE=Y Data map 'ada200.ada200f001' excluded by mask Schema 'ada200' Map '' ... Data map 'testout.zoned' not selected because access method 'S' not in AM select list 2: Data map: Schema 'xxxada200' Map 'ada200f001' Access method 'ADABAS' ======================================================================= Copied data map: Schema 'xxxada200' Map 'ada200f001' Tables: XXX_ADA_RECORD DBID = 9200, FILENO = 9001 Save of map skipped because of VALIDATE=Y 3: Data map: Schema 'xxxada200' Map 'save' Access method 'ADABAS' ================================================================= Copied data map: Schema 'xxxada200' Map 'save' Tables: XXX_ADA_RECORD DBID = 9200, FILENO = 9001 Save of map skipped because of VALIDATE=Y Totals for DM_COPY #2 ===================== Data maps Excluded 3 Data maps Not Selected by name 0 Data maps Not Selected by access method 218 Data maps Selected 3 --------------------------------------------------------- Data maps Read 224 Data maps Copied without changes 3 Data maps Written 0 DTLURDMO DM_COPY Processing Totals ================================== Total data maps Excluded 3 Total data maps Not Selected by name 0 Total data maps Not Selected by access method 218 Total data maps Selected 5 --------------------------------------------------------- Total data maps Read 226 Total data maps Copied without changes 3 Total data maps Updated with changes 2 Total data maps Written 0 Totals for map / registration components changed ================================================ ADABAS DBID 2 ADABAS File number 2 Schema 2 Table 2 ------------------------ ----- Total components changed 8 DTLURDMO DM_COPY .\UpdateToLocal_ADA_V.ini ============================================ Source: Location SYSBUSRA1 User USRA1 EPWD=**** Target: Location LOCAL User USRA1 EPWD=**** Output I:\datamaps_SYSBUSRA1 Detail YES (Print a detailed report) Testmode NO Validate YES (Process maps/registrations but do not save them) Replace YES Number of DM_COPY items 2 Data map copy started =========================================================================== DM_COPY # 1 Exclude: Schema 'cpn301' Map 'sysbusra1' Select: Schema 'ada200' Access Method 'ADABAS' Rename: Schema 'ada200' to 'XXXada200' Rename: Table 'ADA_RECORD' to 'XXX_ADA_RECORD' Modify: AM=ADA DBID=9200 Modify: AM=ADA FILENO=9001 ========================================================================== DMY selection SQL 'DBLIST DMX,ada200,*,sysbusra1' 1: Data map: Schema 'ada200' Map 'ada200f001' Access method 'ADABAS' ==================================================================== SCHEMA ada200 changed to XXXada200 TABLE ADA_RECORD changed to XXX_ADA_RECORD DBID 200 changed to 9200 FILENO 1 changed to 9001 Updated and renamed data map: Schema 'ada200' Map 'ada200f001' Changes 4 Tables: XXX_ADA_RECORD DBID = 9200, FILENO = 9001 Save of map skipped because of VALIDATE=Y 2: Data map: Schema 'ada200' Map 'save' Access method 'ADABAS' ============================================================== SCHEMA ada200 changed to XXXada200 TABLE ADA_RECORD changed to XXX_ADA_RECORD DBID 200 changed to 9200 FILENO 1 changed to 9001 Updated and renamed data map: Schema 'ada200' Map 'save' Changes 4 Tables: XXX_ADA_RECORD DBID = 9200, FILENO = 9001 Save of map skipped because of VALIDATE=Y Totals for DM_COPY #1 ===================== Data maps Excluded 0 Data maps Not Selected by name 0 Data maps Not Selected by access method 0 Data maps Selected 2 --------------------------------------------------------- Data maps Read 2 Data maps Updated with changes 2 Data maps Written 0 ============================================================================ DM_COPY # 2 Exclude: Schema 'cpn301' Map 'sysbusra1' Exclude: Schema 'ada200' Access Method 'ADABAS' Select: Access Method 'ADABAS' Rename: Table 'ADA_RECORD' to 'YYY_ADA_RECORD' ============================================================================ DMY selection SQL 'DBLIST DMX,*,*,SYSBUSRA1' Data map 'a.notfound' not selected because access method 'S' not in AM select list 1: Data map: Schema 'aaada1000' Map 'fdt50' Access method 'ADABAS' ================================================================== Copied data map: Schema 'aaada1000' Map 'fdt50' Tables: YYY_ADA_RECORD DBID = 1000, FILENO = 50 Save of map skipped because of VALIDATE=Y Data map 'ada200.ada200f001' excluded by mask Schema 'ada200' Map '' ... Data map 'testout.zoned' not selected because access method 'S' not in AM select list 2: Data map: Schema 'xxxada200' Map 'ada200f001' Access method 'ADABAS' ======================================================================= Copied data map: Schema 'xxxada200' Map 'ada200f001' Tables: XXX_ADA_RECORD DBID = 9200, FILENO = 9001 Save of map skipped because of VALIDATE=Y 3: Data map: Schema 'xxxada200' Map 'save' Access method 'ADABAS' ================================================================= Copied data map: Schema 'xxxada200' Map 'save' Tables: XXX_ADA_RECORD DBID = 9200, FILENO = 9001 Save of map skipped because of VALIDATE=Y Totals for DM_COPY #2 ===================== Data maps Excluded 3 Data maps Not Selected by name 0 Data maps Not Selected by access method 218 Data maps Selected 3 --------------------------------------------------------- Data maps Read 224 Data maps Copied without changes 3 Data maps Written 0 DTLURDMO DM_COPY Processing Totals ================================== Total data maps Excluded 3 Total data maps Not Selected by name 0 Total data maps Not Selected by access method 218 Total data maps Selected 5 --------------------------------------------------------- Total data maps Read 226 Total data maps Copied without changes 3 Total data maps Updated with changes 2 Total data maps Written 0 Totals for map / registration components changed ================================================ ADABAS DBID 2 ADABAS File number 2 Schema 2 Table 2 ------------------------ ----- Total components changed 8

0 COMMENTS

We’d like to hear from you!