db2 => TRUNCATE TABLE S9.ACT IGNORE DELETE TRIGGERS DROP STORAGE IMMEDIATE
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "68". SQLSTATE=40001
db2 => ALTER TABLE S9.ACT ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1477N For table "S9.ACT" an object "831" in table space
"1" cannot be accessed. SQLSTATE=55019
db2 => TRUNCATE TABLE S9.ACT IGNORE DELETE TRIGGERS DROP STORAGE IMMEDIATE
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "68". SQLSTATE=40001
db2 => ALTER TABLE S9.ACT ACTIVATE NOT LOGGED INITIALLY
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1477N For table "S9.ACT" an object "831" in table space
"1" cannot be accessed. SQLSTATE=55019
db2 => delete from S9.ACT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1477N For table "S9.ACT" an object "831" in table space
"1" cannot be accessed. SQLSTATE=55019
db2 => drop table S9.ACT
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "68". SQLSTATE=40001
db2 => select count(*) from S9.ACT

1
-----------
SQL1477N For table "S9.ACT" an object "831" in table space
"1" cannot be accessed. SQLSTATE=55019
db2 => reorg table S9.ACT
SQL2216N SQL error "-911" occurred while reorganizing a database table or its
indexes.
db2 => SET INTEGRITY FOR S9.ACT IMMEDIATE CHECKED
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0911N The current transaction has been rolled back because of a deadlock
or timeout. Reason code "68". SQLSTATE=40001
db2 => ALTER TABLE S9.ACT ACTIVATE NOT LOGGED INITIALLY
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1477N For table "S9.ACT" an object "831" in table space
"1" cannot be accessed. SQLSTATE=55019