Dynamic database dump

摘要

Controlling a dump for a database by determining a state of a diagnosis flag associated with the structured query language (SQL) statement in response to a SQL statement being executed for the database. The diagnosis flag is used to indicate if a database dump should be performed. A database dump is performed for the SQL statement in response to determining that the diagnosis flag indicates that a dump is to be performed.

主权项

1. A method of controlling a dump for a database, comprising:
in response to a structured query language (SQL) statement being executed for the database, determining a state of a diagnosis flag associated with the SQL statement, the diagnosis flag indicating whether to perform a dump; performing, by a computer, a dump for the SQL statement in response to determining that the diagnosis flag indicates that a dump is to be performed; and for each of one or more processing steps for the SQL statement:
executing the processing step;determining the state of the diagnosis flag in response to executing the processing step;accessing dump configuration information associated with the processing step; andperforming the dump for the processing step based on the dump configuration information, in response to the dump configuration information indicating a dump is to be performed.