Jane_d
Member
Hi,
We would like to clear out many tables, some very large files in a test environment and are looking for a DB2 alternative to the Oracle sql 'Truncate Table' Command.
It is important that the space is immediatly released after the table has been cleared.
There are several postings on the web about using the command
"ALTER TABLE YourTable ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE"
any thoughts? DOes any one use this command? Does this mean that the logging is disabled only for this alter table command? Any other considerations or thoughts about using this command?
your thoughts are appreciated
JDE 810 Tools 8.94
As400 V5R3
We would like to clear out many tables, some very large files in a test environment and are looking for a DB2 alternative to the Oracle sql 'Truncate Table' Command.
It is important that the space is immediatly released after the table has been cleared.
There are several postings on the web about using the command
"ALTER TABLE YourTable ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE"
any thoughts? DOes any one use this command? Does this mean that the logging is disabled only for this alter table command? Any other considerations or thoughts about using this command?
your thoughts are appreciated
JDE 810 Tools 8.94
As400 V5R3