DELETE DATABASE deletes the contents of one or more databases, including all objects except for journal tables.
To drop a journal table contents and structure, use the SQL statement MODIFY DATABASE with the DROP JOURNAL TABLE option. Refer to SQL Request and Transaction Processing (B035-1142) for more information.