IBM Support

Deleting the Derby transaction log to silence errors will corrupt the database

Flashes (Alerts)


Abstract

Never delete or manipulate *ANY* files in a Derby database directory structure. Doing so will corrupt the database.

Content

The bottom line: Never delete or manipulate *ANY* files in a Derby database directory structure. Doing so will corrupt the database.

The problem: Some Derby users have discovered that deleting the files in the log subdirectory of the database will silence recovery errors and allow access the database. Removing the logfiles, even on a database that is not reporting problems, will corrupt the database. The data integrity and possibly the internal structure of the database will be irreparably damaged. Such corruptions are silent and could go unnoticed for long periods of time.

Please help: If you find any documents that recommend removing files from the Derby database folders please report them to the Derby Community (see below) or correct these reference.

Critical Best Practice: Make regular backups of your databases. Restoring the database from backup is the only way to recover a corrupt system.

Report problems or ask questions: Obtain assistance, post information or ask questions regarding Cloudscape or Derby via the Apache Derby maillists.

[{"Product":{"code":"SSCRVP","label":"Cloudscape"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"All (General)","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF014","label":"iOS"},{"code":"PF012","label":"IBM i"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"5;10","Edition":"All Editions","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
25 September 2022

UID

swg21261294