1 ETQ201 Entering upgrade-phase "MAIN_SWITCH/SUBMOD_MIG_SWITCH_ORG/EU_CLONE_MIG_DT_CP2SHD_PRP" ("20200722223224")
4 ETQ380 computing toolpath for request "TP_DEFAULT".
2 ETQ367 Connect variables are set for standard instance access.
4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000'
1 ETQ206 Executing pre-phase DB specific actions 0/1.
1 ETQ200 Executing actual phase 'MAIN_SWITCH/SUBMOD_MIG_SWITCH_ORG/EU_CLONE_MIG_DT_CP2SHD_PRP'.
1 ETQ399 Phase arguments:
2 ETQ399 Arg[ControlName]    = 'EUCLONEDEFS.LST'
2 ETQ399 Arg[CloneSelection] = 'MIGRATE_DOWNTIME_CP2SHD'
2 ETQ399 Arg[MigrationDir]   = 'migrate_dt_cp2shd'
2 ETQ399 Arg[Options]        = 'PREPARE_ONLY;DEST_LOAD_ONLY;DESTSECONDDB;CLONETIME=UPTIME;USECONTREQFIELD;USE_EXISTING_SPLITS'
1 ETQ399 Using error summary log 'EUMIGRATEDTCP2SHDPRP.ELG'.
2 ETQ399 Actions to perform: clone: PRP
1 ETQ399 Import into different database recognized for prepare.
1 ETQ399 Adding ROW/COLUMN properties.
1 ETQ399 Using existing naming convention for destination indexes.
1 ETQ399 Getting all tables/views supposed to be cloned.
1 ETQ399 Enabling table declustering flag.
4 ETQ399 Mapping SCR class 'MIGRATE_DOWNTIME_CP2SHD' to actual condition.
3 ETQ399 Selecting from 'PUTTB_SHD' with condition '( ( CLONE == "S" and FLAGTRIG == "X" ) or TABNAME == "PUTTB_SHD" )'.
3 ETQ399 1 entries matched.
3 ETQ399 Generating clone list with flags: CLONETIME=UPTIME CHK4NAMETABS CHECKMOVECORR DECLUSTER ADDLOGICAL
2 ETQ399 Read 44/0 entries from 'D:\usr\sap\EHI\SUM\abap\control\EUCLONEDEFS.LST'.
1 ETQ000 ==================================================
2 ETQ399 List of cloned objects:
4 ETQ166 Clone PUTTB_SHD                      to PUTTB_SHD                      flags: altnametab
2 ETQ399 Statistics of different clone types:
3 ETQ399      1 x 'altnametab'.
3 ETQ399      1   TOTAL
1 ETQ000 ==================================================
2 ETQ399 Loading row store after column store tables with sync for target DB 'HDB'.
1 ETQ000 ==================================================
1 ETQ399 ACTION: Preparing clone 'L' buckets in directory 'load\migrate_dt_cp2shd' command file 'MIGRATE_DT_CP2SHD.BUC'.
3 ETQ399 Export DB type is 'MSSQL', suffix '~', ntsuffixSTD '', ntsuffixALT '~'.
3 ETQ399 Import DB type is 'HDB', suffix '~', ntsuffixSTD '~', ntsuffixALT ''.
2 ETQ399 Using pipe based export/import method.
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20200722223224  
2 ETQ399 Checking 1 source tables for existance.
4 ETQ290 Starting database operation "TABLE-EXISTANCE-TEST"
2 ETQ399 Requested task ID is 'CHECK_TABLEEXISTS', to be executed in parallel.
3WETQ399 Statement has selections, parallel execution disabled.
3 ETQ399 'LIST': Distributed 1 statements.
3 ETQ399 Generated TQL file 'EU_CLONE_MIG_DT_CP2SHD_PRP.XQL' with 1 SQL statements, log file 'EU_CLONE_MIG_DT_CP2SHD_PRP.XUT'.
2 ETQ399 Distributed 1 statements, 1 actual ones are written to TQL files.
4 ETQ276 Executing SQL-script "EU_CLONE_MIG_DT_CP2SHD_PRP.XQL"
3 ETQ120 20200722223224: PID 5900 execute '~\bin\SAPuptool execdb ..\var\EU_CLONE_MIG_DT_CP2SHD_PRP.XQL', output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.OUT'.
3 ETQ123 20200722223224: PID 5900 exited with status 0 'EU_CLONE_MIG_DT_CP2SHD_PRP.XQL' (time:    0.00 real)
3 ETQ399 Reading selections from 'EU_CLONE_MIG_DT_CP2SHD_PRP.XUT'.
4 ETQ399 Read 1 entries for table 'EXTABLES'.
4 ETQ291 Database operation "TABLE-EXISTANCE-TEST" completed successfully
2 ETQ399 Default to no separator for index extension for table names length 16.
2 ETQ399 Requested task ID is 'INDTEST'.
3 ETQ399 Generated TQL file 'INDTEST.TQL' with 2 SQL statements, log file 'INDTEST.LOG'.
2 ETQ399 Distributed 0 statements, 2 actual ones are written to TQL files.
4 ETQ276 Executing SQL-script "INDTEST.TQL"
3 ETQ120 20200722223224: PID 3348 execute '~\bin\SAPuptool execdb ..\var\INDTEST.TQL', output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.OUT'.
3 ETQ123 20200722223225: PID 3348 exited with status 0 'INDTEST.TQL' (time:    0.00 real)
3 ETQ399 Reading selections from 'INDTEST.LOG'.
4 ETQ399 Read 55621 entries for table 'TABINDDBS'.
3 ETQ120 20200722223226: PID 3460 execute '~\bin\R3ldctl -p ~\load\migrate_dt_cp2shd -template MSS HDB', output written to 'D:\usr\sap\EHI\SUM\abap\log\R3LDCALLCHK.LOG'.
3 ETQ123 20200722223226: PID 3460 exited with status 0 '' (time:    0.00 real)
2 ETQ399 Working directory is 'D:\usr\sap\EHI\SUM\abap\load\migrate_dt_cp2shd'.
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20200722223226  
1 ETQ399 Setting table sizes and estimated durations using average duration rate 1.00 MB/sec
1 ETQ399 Original total size of tables/views is 1.7 MB with estimated runtime 2 secs (without durations file).
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20200722223226  
1 ETQ399 Total size of tables/views is 1.7 MB with estimated runtime of 2 secs.
2 ETQ399 Decreasing bucket size from 10240 to 256 MB to make use of 40 processes.
2 ETQ399 Decreasing number of tables per bucket from 500 to 1 to make use of 40 processes.
3 ETQ399 Split segment sizes are from interval [0.025,0.5].
3 ETQ399 Adding rowstore properties to tasks.
2 ETQ399 Requested task ID is 'SEL_ROWCOLSTORE_SHD'.
3 ETQ399 Generated TQL file 'SELROWCOLSTORE.TQL' with 1 SQL statements, log file 'SELROWCOLSTORE.OUT'.
2 ETQ399 Distributed 0 statements, 1 actual ones are written to TQL files.
4 ETQ276 Executing SQL-script "SELROWCOLSTORE.TQL"
3 ETQ120 20200722223226: PID 3980 execute '~\bin\SAPuptool execdb ..\var\SELROWCOLSTORE.TQL', output written to 'D:\usr\sap\EHI\SUM\abap\log\SQLSTMTSTD.OUT'.
3 ETQ123 20200722223226: PID 3980 exited with status 0 'SELROWCOLSTORE.TQL' (time:    0.00 real)
3 ETQ399 Reading selections from 'SELROWCOLSTORE.OUT'.
4 ETQ399 Read 25226 entries for table 'LIST'.
3 ETQ399 Flagged 1 for column and 0 for row store, 0 tables kept.
3 ETQ399 Putting 300 entries per work package for table clone preparation.
3 ETQ399 Generated 1 input files, now creating STR files for them.
2 ETQ000 ==================================================
2 ETQ100 Executing 1 processes in total - will run 40 in parallel.
3 ETQ121 20200722223226 #1 (1): PID 4040 execute '~\bin\R3ldctl -p ~\load\migrate_dt_cp2shd -input ~\load\migrate_dt_cp2shd\MIGRATE_DT_CP2SHD_PRP00001_IN.LST -output ~\load\migrate_dt_cp2shd\MIGRATE_DT_CP2SHD_PRP00001_GEN.STR -table_suffix ~ -nametab DDNTT~ DDNTF~' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\R3LDCALLPRP.001'.
3 ETQ123 20200722223228 (0): PID 4040 exited with status 0 'MIGRATE_DT_CP2SHD_PRP00001_IN.LST' (time:    0.00 real)
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20200722223228  
2 ETQ102 Finished execution of 1 process(es).
3 ETQ128 Interval: 20200722223226-20200722223228, time     2.0 real
2 ETQ108 Analyzing logs for errors.
4 ETQ399 Existing index 'PUTTB_SHD~0' for table 'PUTTB_SHD' has standard separator, using it.
4 ETQ399 Existing index 'PUTTB_SHD~0' for table 'PUTTB_SHD' has standard separator, using it.
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20200722223228  
1 ETQ399 Adapting template file 'D:\usr\sap\EHI\SUM\abap\load\migrate_dt_cp2shd\DDLHDB_LRG.TPL' with 20 lines.
4 ETQ399 Determined 'fullindexname' as 0 from target release 750
4 ETQ399 Setting 'svers' to '750' in template.
1 ETQ000 ==================================================
1 ETQ399 Sorting 1 tasks for descending estimated durations.
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20200722223228  
3 ETQ399 Splitting: Looking for explicit requests.
2 ETQ399 Splitting: Analyzing tail to determine tables.
1 ETQ000 ==================================================
2 ETQ399 Minimum estimated duration of table to consider splitting: 169 sec.
1 ETQ000 ==================================================
1 ETQ399 Determining nametabs suitable for splitting for 40 processes and setting table category for bucket distribution.
2 ETQ399 No tables found to consider for splitting - skip splitting.
1 ETQ000 ==================================================
1 ETQ399 Determining non-nametabs and non-rowstore tables suitable for splitting for 40 processes and setting table category for bucket distribution.
2 ETQ399 Optimal tail runtime 0 sec and max table runtime 2 sec are smaller than minimal runtime 30.0 sec - skip splitting.
1 ETQ000 ==================================================
1 ETQ399 Determining row store tables suitable for splitting for 40 processes and setting table category for bucket distribution.
2 ETQ399 No tables found to consider for splitting - skip splitting.
1 ETQ000 ==================================================
3 ETQ399 Result of table splitting:
3 ETQ399 No large tables to split found!
1 ETQ000 ==================================================
1 ETQ399 Writing table sequence to 'D:\usr\sap\EHI\SUM\abap\doc\analysis\MIGRATE_DT_CP2SHD_TABSEQUENCE.CSV'.
1 ETQ000 ==================================================
3 ETQ399 Generating task files for each STR file.
2 ETQ000 ==================================================
2 ETQ100 Executing 2 processes in total - will run 40 in parallel.
3 ETQ121 20200722223229 #1 (1): PID 5792 execute '~\bin\R3load -ctf E ~\load\migrate_dt_cp2shd\MIGRATE_DT_CP2SHD_PRP00001_EXP.STR ~\load\migrate_dt_cp2shd\DDLMSS_LRG.TPL ~\load\migrate_dt_cp2shd\MIGRATE_DT_CP2SHD_PRP00001_EXP.TSK MSS -l ~\load\migrate_dt_cp2shd\MIGRATE_DT_CP2SHD_PRP00001_EXP.LOG' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\R3LDCALLPRP.001'.
3 ETQ121 20200722223229 #2 (2): PID 3580 execute '~\bin\R3load -ctf I ~\load\migrate_dt_cp2shd\MIGRATE_DT_CP2SHD_PRP00001_IMP.STR ~\load\migrate_dt_cp2shd\DDLHDB_LRG.TPL ~\load\migrate_dt_cp2shd\MIGRATE_DT_CP2SHD_PRP00001_IMP.TSK HDB -l ~\load\migrate_dt_cp2shd\MIGRATE_DT_CP2SHD_PRP00001_IMP.LOG' in background, output written to 'D:\usr\sap\EHI\SUM\abap\log\R3LDCALLPRP.002'.
3 ETQ123 20200722223229 (1): PID 5792 exited with status 0 'MIGRATE_DT_CP2SHD_PRP00001_EXP.TSK' (time:    0.00 real)
3 ETQ123 20200722223231 (0): PID 3580 exited with status 0 'MIGRATE_DT_CP2SHD_PRP00001_IMP.TSK' (time:    0.00 real)
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20200722223231  
2 ETQ102 Finished execution of 2 process(es).
3 ETQ128 Interval: 20200722223228-20200722223231, time     3.0 real
2 ETQ108 Analyzing logs for errors.
1 ETQ124 Scanned file 'load\migrate_dt_cp2shd\MIGRATE_DT_CP2SHD_PRP00001_EXP.LOG' from offset 114 to 1513 for errors.
1 ETQ124 Scanned file 'load\migrate_dt_cp2shd\MIGRATE_DT_CP2SHD_PRP00001_IMP.LOG' from offset 114 to 1513 for errors.
3 ETQ114 Analyzed 2 log files.
2 ETQ399 Checking that all tables with content have required tasks.
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20200722223231  
3 ETQ399 Put 0 rowstore tables into separate buckets.
3 ETQ399 Will finish loading column store before loading row store.
1 ETQ399 Distributing table tasks into buckets of size 256 MB and 256 sec.
1 ETQ399 Sorting for task types.
2 ETQ399 Generating export+import bucket '00001_PUTTB_SHD' with    1 table(s) and size     1.68 MB
1 ETQ399 Command file 'MIGRATE_DT_CP2SHD.BUC': 1 tables in 1 tasks, size 1.7 MB (estimated duration 1.7 sec).
1 ETQ000 ==================================================
4 ETQ010 Date & Time: 20200722223231  
4 ETQ399 Cleaning up intermediate files..
1 ETQ207 Executing post-phase DB specific actions 0/1.
4 ETQ010 Date & Time: 20200722223231  
1 ETQ202 Upgrade phase "EU_CLONE_MIG_DT_CP2SHD_PRP" completed successfully ("20200722223231")