Cause: The table name or index must be fully qualified. The format is authid.name where authid must be 1 to 8 characters and name must be 1 to 18 characters (bytes in a MBCS environment).
The utility stops processing.
Action: Resubmit the command with a fully qualified name including the correct qualifier.
Cause: The table name is required. It must be fully qualified and in the format authid.name where authid is 1 to 8 characters and name is 1 to 18 characters (bytes in MBCS environments). The table name must be located at a valid application address.
The utility stops processing.
Action: Resubmit the command with the correct table name.
Cause: If an index is specified, it must be fully qualified and in the format authid.name where authid is 1 to 8 characters and name is 1 to 18 characters (bytes in MBCS environments). The index must be located at a valid application address.
The utility stops processing.
Action: Resubmit the command with a valid index name.
Cause: The specified index does not exist for the specified authid.table or authid.index.
DataJoiner users: this situation can be detected by DataJoiner or by the data source.
The utility or operation stops processing.
Action: Resubmit the command with a valid index.
Cause: The datafile parameter is not any of the values that indicate the default filepath. Also the datafile parameter is not a valid non-default value. One of the following may apply:
The utility stops processing.
Action: Resubmit the command with a valid datafile parameter.
Cause: The table space parameter does not contain a valid value. One of the following conditions may exist:
The utility stops processing.
Action: Resubmit the command with a valid table space parameter or do not use the table space name parameter. In the latter case, the Reorganize Table utility will use the table space(s) in which the table itself resides.
Cause: The table does not exist in the database. Either the table name or the authorization ID is incorrect.
The command cannot be processed.
Action: Resubmit the command with a valid table name.
Cause: The Reorganize Table utility cannot be run against a view.
The utility stops processing.
Action: Resubmit the command with a valid table name.
Cause: The Reorganize Table utility requires that any table space specified is a temporary table space. The table space name provided is not a table space defined to hold temporary tables.
The utility stops processing.
Action: Resubmit the command with the name of a temporary table space or do not use the table space name parameter. In the latter case, the Reorganize Table utility will use the table space(s) in which the table itself resides.
Cause: The user attempted to reorganize the specified table without the appropriate authorization (either SYSADM or DBADM authority or the CONTROL privilege on the table).
The utility stops processing.
Action: Logon as a user with the appropriate authority or privilege and resubmit the reorganize table utility command.
Cause: The user was already connected to the database specified in the Reorganize Table command. An error occurred while committing the previous work in progress for the database.
The utility stops processing with no attempt to roll back the work or break the database connection.
Action: Look at the SQLCODE (message number) in the message for more information. Make changes and resubmit the command.
Cause: An error occurred during the reorganization of a database table.
The utility stops processing.
Action: Look at the SQLCODE (message number) in the message for more information. Make changes and resubmit the command.
Cause: All table data (including LONG and/or LOB column data) must reside in a table space with the same pagesize as the pagesize of the temporary table space provided to the REORG utility. One of the following has violated this restriction:
Action: If the table being reorganized resides in a table space with a pagesize other than 4K and the table also includes LONG and/or LOB columns, then a temporary table space cannot be provided to the REORG utility. Reissue the REORG request without specifying a temporary table space.
If the table being reorganized does not have LONG and/or LOB columns (or it does but the table's data resides in a table space with a 4K pagesize), then reissue the REORG request specifying a temporary table space that has a pagesize that matches the table space containing the table data. Alternatively, reissue the REORG request without specifying a temporary table space.