Upgrade Standard and Extended Catalogs or Migrate OR Catalogs

This action migrates OpenROAD system catalogs that were created with 255 length limit (Microsoft SQL Server 6.5) on the varchar data type. That is, if "HELP ii_srcobj_encoded" reports a length of 255 for the "text_string" column, select this action to take advantage of larger field support by lifting the 255 maximum varchar restriction in older releases of the gateway and the Microsoft SQL Server DBMS.

Clicking Scan returns a list of all system and user tables conforming to the documented structure for a bitmap or string object table: picture_id or string_id, row_sequence, text_total, and text_value. The object type (IMAGE or STRING), table name, table owner, and the number of objects contained in the table are displayed. Scanning system and user tables is currently enabled for Microsoft SQL Server only. Clicking Execute action causes iigwcat to restring and preserve data for tables containing bitmaps and strings, which results in improved performance and disk savings because fewer rows are required to hold each object.

With this action, all standard and extended catalogs are upgraded and their data preserved. The displayed system and user tables of bitmap and string objects are automatically selected after the scan, and only user tables may be cleared. Data for selected tables is saved, upgraded, restrung, and restored. Unselected user tables are not touched.

Important! User tables used by OpenROAD for bitmap or string objects must not be cleared. All of these tables need to be reformatted and reloaded in a consistent way for OpenROAD to continue to work. Any inconsistency can cause OpenROAD applications to be inoperable. Since copying out and restoring data are handled in iigwcat (not iigwcatmss), bitmap, string objects, and the OpenROAD source code table, ii_srcobj_encoded, are not properly restored if these steps are bypassed.

The only user tables that should be cleared are those that are not used as bitmap and string objects—they just happen to have the same structure.

Note: The indexes of upgraded user tables need to be recreated manually after the upgrade. If there are any user tables containing bitmap or string objects, the person running iigwcat is prompted to enter each user's password. Selecting this action causes an -s flag to be passed to the standard gateway catalog build utility (iigwcatmss). However, running iigwcatmss with the -s flag directly from the command line is not recommended.