Search dba-db2.com
*Use the Comments section for questions
Daily & Exclusive Content
Recent Posts
DB2 - truncate table
09 February,2010 by Tom Collins
A very useful approach to clearing down data from tables . This will truncate a specific table , without it being logged.
Use with caution!
ALTER TABLE schema.table_name activate not logged initially with empty table
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright
Posted by: |