Changing the logging attribute
You can use the ALTER TABLESPACE statement to set the logging attribute of a table space.
Before you begin
Important: Limit the use of the NOT
LOGGED attribute. Logging is not generally a performance bottleneck,
given that in an average environment logging accounts for less than
5% of the central processing unit (CPU) utilization. Therefore, you
should use the NOT LOGGED attribute only when data is being used by
a single task, where the table space can be recovered if errors occur.
Procedure
To change the logging attribute of a table space: