In current multiplex configurations, multiple nodes can write to the main store, which eliminates the need for local stores. iqlsunload is a command line utility that you can use to unload a 12.7 local store. iqlsunload is used only in 12.7 ESD #5 multiplex migrations.
iqlsunload [ options ] directory [ @data ]
data:[ environment variable | file ]
General Notes
On Windows, use double slashes as a file separator, not single slashes..
Run iqlsunload from the %IQDIR16%\lsunload directory to pick up updated libraries before resolving any IQ 12.7 libraries.
Unloaded Objects
Base tables
Global temporary tables
Indexes
Domains (user-defined data types)
Constraints (column check constraint, table constraint, primary key, foreign key, unique, default, IQ unique, not null)
Views
Stored procedures and functions
Messages
Remote servers and external logins
Events
Empty User Names
SAP Sybase IQ no longer allow users with empty user names. You cannot drop or migrate users with empty user names the 12.6 or 12.7 server. The schema reload operation warns that an empty user name has been encountered and that the user will not be re-created. The reload operation ignores such users and any associated objects.
Unloading Tables
If you extract table schema and data only, the legacy database collation must match the collation of the current database collation.
If you do not qualify table names with owner names, iqlsunload extracts table data from all tables with that table name.
Output Files
Script Name | Description |
---|---|
reload_schema.sql | Recreates schema for unloaded objects (either objects from local store or tables selected by the user.) This script is executed against a node that writes to the multiplex. This node can be either the existing writer node, or a writer or coordinator for the multiplex after migration, depending on where you plan to recreate the schema. |
extract_data.sql | Extracts table data for the unloaded tables from the local store. Execute this script in Interactive SQL while connected to the query node from which it was generated. When this script executes, it generates the data files into the directory data. |
reload_data.sql | Loads extracted table data. This script is executed on the node where you ran reload_schema.sql, and reloads the data extracted from the extract_data.sql file. |
DBA