table_import command options

You can use any of the following options with the table_import command. You must always supply the -password option.

-allreferencesallowed
Allows references to existing non-administrative rows in all operational tables.
This option only applies with the following command options:
  • -integritycheck
  • -integritycheckandload
This option corresponds to the Boolean parameter allowRefsToExistingNonAdminRows used by the integrity check methods of the TableImportAPI web service. Guidewire recommends that you use this option or the equivalent API parameter, set to true only if absolutely necessary.
This option can cause performance degradation during the check and load process, which would noticeably slow down the loading of staging table.
-batch
Runs the table_import command in a batch process. This option only applies with the following command options:
  • -deleteexcluded
  • -encryptstagingtbls
  • -integritycheck
  • -integritycheckandload
  • -populateexclusion
  • -updatedatabasestatistics
You can run table_import in a batch process from any node in a PolicyCenter cluster. However, table import batch processing must run physically on a server designated as a batch server. Therefore, in running the command, provide the URL of a batch server and also provide the user credentials for that batch server.
Note: The -batch option does not wait until the started process completes before returning. Instead, it returns immediately and prints the ID of the started process (PID). The process caller is responsible for waiting for the process to complete before taking further action.
-clearerror
Clears the error table.
-clearexclusion
Clears the exclusion table.
-clearstaging
Clears the staging tables. Requires the server to be at the MAINTENANCE run level.
-deleteexcluded
Deletes rows from staging tables based on contents of exclusion table.
-encryptstagingtbls
Do not use. While this command option is available, Guidewire does not support this command option in PolicyCenter.
-estimateorastats
Executes queries for row counts on production tables and sets the database statistics. If you do not use this option, the import command uses information in database statistics to report approximate row counts. Use the -estimateorastats option only to load production tables that are empty or have very few rows. Used with the -integritycheckandload command option.
This option only applies with the following command option:
  • -integritycheck
  • -integritycheckandload
This parameter corresponds to the Boolean parameter updateDBStatisticsWithEstimates used by the integrity check methods of the TableImportAPI web service.
This command option applies to Oracle databases only.
-filepath filepath
Path to target directory in which to download a report. Use with the -getLoadHistoryReport command option.
-getLoadHistoryReport reportID
Downloads a compressed Zip version of the load history report as specified by the value of reportID. Does not require the server to be at the MAINTENANCE run level. Use the -listLoadHistoryReports option to determine the ID to use. Use the optional -filepath parameter to specify the target directory for the download.
-integritycheck
Validates the contents of the staging tables. You can optionally specify:
  • -allreferencesallowed
  • -clearerror
  • -numthreadsintegritychecking
  • -populateexclusion
-integritycheckandload
Validates the contents of the staging tables and populate operational tables. You can optionally specify one of the following command options as well:
  • -allreferencesallowed
  • -clearerror
  • -estimateorastats
  • -numthreadsintegritychecking
  • -populateexclusion
  • -zonedataonly
-listLoadHistoryReports [numReports]
Lists the most recent load history reports. Optional parameter numReports is the number of reports to list:
  • If you supply a positive integer for numReports, then PolicyCenter lists that number of most recent reports.
  • If you do not supply a value for numReports, then PolicyCenter lists all available reports.
This option does not require the server to be at the MAINTENANCE run level.
-messagesinks sinks, ...
Deprecated. This option does nothing.
-numthreadsintegritychecking num
Specifies the number of threads that PolicyCenter is to use in running database table integrity checks. The value of num has the following meaning:
  • Not specified – PolicyCenter assumes the number of threads to be one, no multithreading.
  • 1 – No multithreading, the default.
  • 2 - 100 – PolicyCenter runs the database integrity checks with the number of specified threads.
  • > 100 – PolicyCenter throws an exception.
This option only applies with the following command options:
  • -integritycheck
  • -integritycheckandload
-password password
Password (password) to use to connect to the server. PolicyCenter requires the password.
-populateexclusion
Populate the exclusion table with rows to exclude.
-server url
Specifies the PolicyCenter host server URL. Include the port number and web application name, for example:
  • http://serverName:8180/pc
-updatedatabasestatistics
Updates the database statistics on the staging tables. Run the table import command with this option after populating the staging tables, but before using the -integritycheck or -integritycheckandload options.
-user user
Specifies the user to use to run this process.
-zonedataonly
Sets the import to load zone data only. Used with the -integritycheckandload command option.