Задание 4. Перемещение существующих данных в секции
Переместим существующие данные из исходных секций таблиц Customer и Order в их соответствующие split-target секции.
- Откройте командную строку Proenv и перейдите в каталог C:\OpenEdge\WRK\tablepartitioning.
- Переместите данные таблицы Customer в split-target секции:
proutil sportsco -C partitionmanage split table customer composite initial
Обратите внимание на то, что после завершения работы этой команды, в исходной композитной секции не останется ни одной записи.
Inserting V:\PROGRE~2\OpenEdge\bin to beginning of path and the current directory is V:\Progress120\WRK OpenEdge Release 12.0 as of Fri Feb 22 19:02:39 EST 2019 proenv>cd tablepartitioning proenv>proutil sportsco -C partitionmanage split table customer composite initial OpenEdge Release 12.0 as of Fri Feb 22 19:02:39 EST 2019 BEGIN: Split Operation For Table customer (17384) Source Partition initial[0] Target Partition Customer-1[1] Target Partition Customer-2[2] Target Partition Customer-3[3] Target Partition Customer-4[4] Target Partition Customer-5[5] Target Partition Customer-6[6] Target Partition Customer-7[7] Target Partition Customer-8[8] Target Partition Customer-9[9] Target Partition Customer-10[10] Target Partition Customer-11[11] Target Partition Customer-12[12] Target Partition Customer-13[13] Target Partition Customer-14[14] Target Partition Customer-15[15] Target Partition Customer-16[16] Target Partition Customer-17[17] Target Partition Customer-18[18] Target Partition Customer-19[19] Target Partition Customer-20[20] Target Partition Customer-21[21] Target Partition Customer-22[22] Target Partition Customer-23[23] Index CountrySalesrepLocalIdx has been identified as the scanning index (selected). A non-unique index has been selected as the useindex index. Additional locking is required with the use of this index CountrySalesrepLocalIdx. Number of Records per Transaction (recs): 100 Do you want to continue (y/n)? y Target partition: Customer-1[1], records moved: 1. Target partition: Customer-2[2], records moved: 3. Target partition: Customer-3[3], records moved: 28. Target partition: Customer-4[4], records moved: 5. Target partition: Customer-5[5], records moved: 1. Target partition: Customer-6[6], records moved: 1. Target partition: Customer-7[7], records moved: 1. Target partition: Customer-8[8], records moved: 1. Target partition: Customer-9[9], records moved: 3. Target partition: Customer-10[10], records moved: 2. Target partition: Customer-11[11], records moved: 2. Target partition: Customer-12[12], records moved: 1. Target partition: Customer-13[13], records moved: 1. Target partition: Customer-14[14], records moved: 7. Target partition: Customer-15[15], records moved: 123. Target partition: Customer-16[16], records moved: 129. Target partition: Customer-17[17], records moved: 137. Target partition: Customer-18[18], records moved: 146. Target partition: Customer-19[19], records moved: 146. Target partition: Customer-20[20], records moved: 125. Target partition: Customer-21[21], records moved: 9. Target partition: Customer-22[22], records moved: 118. Target partition: Customer-23[23], records moved: 127. Source partition: initial[0], contains no records. <---------------------- Total records processed: 1117.<------------------------------------------- END: Split Operation For Table customer[0] Split Operation finished successfully. (17359) proenv> - Переместите данные таблицы Order в split-target секции:
proutil sportsco -C partitionmanage split table order composite initial
Обратите внимание на то, что после завершения работы этой команды, в исходной композитной секции не останется ни одной записи.
proenv>proutil sportsco -C partitionmanage split table order composite initial OpenEdge Release 12.0 as of Fri Feb 22 19:02:39 EST 2019 BEGIN: Split Operation For Table order (17384) Source Partition initial[0] Target Partition Order-12[1] Target Partition Order-11[2] Target Partition Order-10[3] Target Partition Order-9[4] Target Partition Order-8[5] Target Partition Order-7[6] Target Partition Order-1[7] Target Partition Order-2[8] Target Partition Order-3[9] Target Partition Order-4[10] Target Partition Order-5[11] Target Partition Order-6[12] Index CarrierOrderDateLocalIdx has been identified as the scanning index (selected). A non-unique index has been selected as the useindex index. Additional locking is required with the use of this index CarrierOrderDateLocalIdx. Number of Records per Transaction (recs): 100 Do you want to continue (y/n)? y Target partition: Order-7[6], records moved: 233. Target partition: Order-1[7], records moved: 388. Target partition: Order-8[5], records moved: 243. Target partition: Order-2[8], records moved: 458. Target partition: Order-9[4], records moved: 220. Target partition: Order-3[9], records moved: 385. Target partition: Order-10[3], records moved: 235. Target partition: Order-4[10], records moved: 497. Target partition: Order-11[2], records moved: 246. Target partition: Order-5[11], records moved: 393. Target partition: Order-12[1], records moved: 228. Target partition: Order-6[12], records moved: 427. Source partition: initial[0], contains no records. Total records processed: 3953. END: Split Operation For Table order[0] Split Operation finished successfully. (17359) proenv>
Задание выполнено!
Подведение итогов урока
Теперь вы научились:
- Секционировать существующие таблицы с помощью инструментария Data Dictionary и Database Administration Console.
- Подготавливать секции к миграции данных с помощью Database Administration Console.
- Перемещать существующие данные в секции таблицы.
- Секционировать существующие таблицы с помощью OpenEdge SQL.
- Подготавливать секции к миграции данных с помощью OpenEdge SQL.
- Загружать новые данные в секции.