dataextractloader

Takes the SQL, CSV, and recommendations output files from dataextractor, and uses those inputs to load recovered disk store data into a new GemFire XD system

Syntax

dataextractloader  recommended=<filename>
  [host=<hostname>]
  [port=<port-number>]
  [--string-delimiter="<delimiter>"]
See also Recovering Data from Disk Stores for limitations, requirements, and examples of using this utility.
Option Description
recommended=<filename> (Required.) The recommendations file that defines the full list of SQL and CSV data files to use for loading the recovered data into the GemFire XD system. This file is generated by dataextractor as part of the disk store recovery process.
host=<hostname> Specifies the hostname of a locator or GemFire XD server to use for connecting to the distributed system. Default is localhost.
port=<port-number> Specifies the port number of the locator or GemFire XD server to use for connecting to the distributed system. Default is 1527.
--string-delimiter="<delimiter>" Specifies a custom delimiter to use in generated CSV files. The default is a double quotation mark: "

Description

Ensure that you define the necessary server groups, heap configuration, and disk resources needed to host the recovered data. Refer to the DDL EXPORT INFORMATION portion of the Summary.txt file to determine which server groups are expected when recreating the schema.

See Recovering Data from Disk Stores for more information.

Replay DDL and load recovered disk store data into a GemFire XD distributed system using a locator at localhost:1527. All SQL and CSV files are defined in the indicated Recommendations.txt file:
$ dataextractloader host=localhost port=1527 recommended=./EXTRACTED_FILES/Recommended.txt 
Loading .sql file: /Users/yozie/recovery-directory/EXTRACTED_FILES/examplelocator1/exported_ddl.sql
Executing :CALL SYSCS_UTIL.IMPORT_TABLE_EX ('APP', 'FLIGHTS', '/Users/yozie/recovery-directory/EXTRACTED_FILES/exampleserver1/PR-APP-FLIGHTS-_B__APP_FLIGHTS_36-1400537865621.csv' , ',', '"', null, 0, 0, 6, 0, null, null)
Executing :CALL SYSCS_UTIL.IMPORT_TABLE_EX ('APP', 'FLIGHTS', '/Users/yozie/recovery-directory/EXTRACTED_FILES/exampleserver1/PR-APP-FLIGHTS-_B__APP_FLIGHTS_37-1400537866233.csv' , ',', '"', null, 0, 0, 6, 0, null, null)
Executing :CALL SYSCS_UTIL.IMPORT_TABLE_EX ('APP', 'FLIGHTS', '/Users/yozie/recovery-directory/EXTRACTED_FILES/exampleserver2/PR-APP-FLIGHTS-_B__APP_FLIGHTS_34-1400537866329.csv' , ',', '"', null, 0, 0, 6, 0, null, null)
Executing :CALL SYSCS_UTIL.IMPORT_TABLE_EX ('APP', 'FLIGHTS', '/Users/yozie/recovery-directory/EXTRACTED_FILES/exampleserver1/PR-APP-FLIGHTS-_B__APP_FLIGHTS_35-1400537865998.csv' , ',', '"', null, 0, 0, 6, 0, null, null)
Executing :CALL SYSCS_UTIL.IMPORT_TABLE_EX ('APP', 'FLIGHTS', '/Users/yozie/recovery-directory/EXTRACTED_FILES/exampleserver1/PR-APP-FLIGHTS-_B__APP_FLIGHTS_38-1400537866224.csv' , ',', '"', null, 0, 0, 6, 0, null, null)
[...]

See also Procedure for Loading Recovered Data into a New System.