Load Data
Early Adoption Program—EAP
You can load data into your database with the
copydb or
unloaddb commands using rbash. For more information, see
Use of the Restricted Bash Shell (rbash).
Be aware of the following before doing the reload:
• Make sure your client system has the required setting for date_alias, II_DATE_FORMAT, II_TIMEZONE_NAME
• An Actian database only allows the default locations (e.g. ii_database). If you use other locations the include the ions the include the -no_loc flag on copydb / unloaddb
• If you have not enabled other page sizes by including your own config.dat during the database instance creation, make sure only page sizes 2048 and 8192 are being used.
After the initial load you can run optimizedb via the vnode from your local system, or use CREATE STATISTICS sql statement.
Last modified date: 12/12/2024