Transient journal can be avoided if using following method:
- Insert into an empty table (fastpath insert)
- Fastpath delete (using all)
- Avoid UPDATE on large skew tables with INSERT INTO .. SELECT
- Using ; before the second INSERT
As we have seen, space can become a performance issue if it is lacking, because processes are not able to complete. Other than DBC running out of space, there are a few more phenomena that can occur because of low disk space:
- Frequent cylinder migration
- Min-cylpacks
- De-fragmentation execution