What are the differences between dump transaction with truncate_only and dump transaction with no_log?
Neither dump transaction with truncate_only nor dump transaction with no_log make a copy of the log records. Both reduce the space used in syslogs whenever possible. The dump transaction command adds checkpoint records and log-deallocation records to the log even when just truncating the log, except when using the with no_log option. Use dump transaction with no_log only when dump transaction with truncate_only fails because syslogs lacks room for dump transaction’s checkpoint and deallocation records. See dump transaction in the Sybase Adaptive ServerTM Enterprise System Administration Guide.
Related Questions
- What are the differences between calling a program, transaction ‘with return’ and ‘without return’ and how can each be accomplished?
- Explain the similarities and differences between EJB CMT and the Spring Frameworks declarative transaction management ?
- What are the differences between dump transaction and dump transaction with no_truncate?
