| |
- Causa
- ROLLBACK TO SAVEPOINT CAUSED A NOT LOGGED TABLE SPACE TO BE PLACED IN THE LPL
An application issued a ROLLBACK, but uncommitted changes existed for a table space defined with the NOT LOGGED logging attribute.
Db2® cannot undo changes made to not logged table spaces because no log records were written due to the logging attribute of the table space.
The table space is placed in the LPL so that other concurrently running agents are not able to see the data that cannot be rolled back.
The table space is also marked recover pending because the table space has been modified.
- Ação do sistema
- The ROLLBACK TO SAVEPOINT was performed, however changes that were made to not logged table spaces have not been undone.
- Resposta ao Desenvolvedor
- Avoid making changes to a not logged table space within the span of a savepoint to which you intend to rollback.
To remove a table space from the LPL and reset recover pending, use one of the following options:
- REFRESH TABLE to repopulate a Materialized Query Table, but only if the Materialized Query Table is alone in its table space.
If the table, including Materialized Query Tables, is not alone in its table space, a utility must be used to reset the table space and remove
it from recover pending.
- RECOVER utility, to recover either to currency or to a prior image copy
- LOAD REPLACE utility or LOAD REPLACE PART utility:
- With an input data set to empty the table space and repopulate the table
- Without an input data set to empty the table space to prepare for one or more insert operations to repopulate the table
- Drop and re-create the table space and repopulate the table.
- DELETE without a WHERE clause to empty the table.
When the table space is a segmented (non-UTS) table space or universal table space, the table is alone in its table space and the table does not
have a VALIDPROC, referential constraints, delete Triggers, or a SECURITY LABEL column (or has this column, but multilevel security is not in effect).
- TRUNCATE TABLE to empty the table.
When the table space is segmented (non-UTS) table space or universal table space, the table is alone in its table space and the table does not
have a VALIDPROC, referential constraints, or a SECURITY LABEL column (or has this column, but multilevel security with row level granularity is
not in effect).
Important: If the table, materialized query table or not, is not alone in its table space, a utility must be used to
reset the table space and remove it from recover pending.
SQLSTATE: 01656
|
| |
