Error: "object_name will not be reorganized because the Online Switch does not support it"
Object is not supported on online switch style.
RESOLUTION 1:
You can determine whether tables are supported for the online switch using the Find Tables Supported for the Online Switch package (quest_spc_reorg_type). This is automatically installed via the spc_pkg_reorg_support81.sql script. The script is located in the install subdirectory of the Space Manager client directory.
The Find Tables Supported for the Online Switch package includes the following:
- Inspect procedures: These allow you to populate the online switch table (QUEST_SPC_REORG_SUPPORT) with information on table eligibility for the online switch. You can use them to gather information for a certain table, a certain schema, or a certain tablespace.
- Online switch table: Called QUEST_SPC_REORG_SUPPORT. This contains information on table eligibility for the online switch. You can query this table to list tables that are supported for the online switch as well as tables that are not supported.
- Online switch view: Called QUEST_SPC_ONLINE_SUPPORTED. This shows which tables are supported for the online switch. You can query this view to list only tables that are supported for the online switch.
Populating the online switch table:
You can populate the online switch table (QUEST_SPC_REORG_SUPPORT) using inspect procedures.
To populate the table with information on a certain table, run this inspect procedure:
exec quest_spc_reorg_type.inspect_by_object ('OWNER_NAME','OBJECT_NAME') ;
To populate the table with information on tables in a certain schema, run this inspect procedure:
exec quest_spc_reorg_type.inspect_by_owner ('OWNER_NAME') ;
To populate the table with information on tables in a certain tablespace, run this inspect procedure:
exec quest_spc_reorg_type.inspect_by_tablespace ('TABLESPACE_NAME') ;
Querying the online switch table:
You can query the online switch table (QUEST_SPC_REORG_SUPPORT) to list tables that are supported for the online switch as well as tables that are not supported.
To query the table, run this select statement:
select * from quest_spc_reorg_support ;
Check the REORG_TYPE column to see whether a table is supported for the online switch. This column shows Online for tables that are supported. It shows No for tables that are not supported. To see why a table is not supported, check the DESCRIPTION column.
Querying the online switch view:
You can query the online switch view (QUEST_SPC_ONLINE_SUPPORTED ) to list only tables that are supported for the online switch.
To query the view, run this select statement:
select * from quest_spc_online_supported ;
RESOLUTION 2:
Space Manager's User Guide 6.0: Chapter 12-5 has a chart with "What's supported for Live reorganizations" on each method.
Also applies to QCO Space Management 5.6.8, 5.7.3, and Space Manager with Live Rear 6.0.1.
