Monitor delete statements on a specific table on DB2 LUWHow to revoke DBADM and clean up any related objects...
Critique vs nitpicking
Calculating the strength of an ionic bond that contains poly-atomic ions
How resistance converts voltage to current?
What can I do to encourage my players to use their consumables?
Players preemptively rolling, even though their rolls are useless or are checking the wrong skills
Does rolling friction increase speed of a wheel?
I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."
Why is "rm -r" unable to delete this folder?
How to deal with an underperforming subordinate?
Is there any danger of my neighbor having my wife's signature?
How bad is a Computer Science course that doesn't teach Design Patterns?
Was there a pre-determined arrangement for the division of Germany in case it surrendered before any Soviet forces entered its territory?
How can I prevent an oracle who can see into the past from knowing everything that has happened?
Is Screenshot Time-tracking Common?
What is an efficient way to digitize a family photo collection?
Would water spill from a bowl in a Bag of Holding?
Why might frozen potatoes require a hechsher?
How to put text above column in minipage?
Planting on shale filled patch with weed underlay
Boss asked me to sign a resignation paper without a date on it along with my new contract
Maybe pigeonhole problem?
What is the nature of, and syntactic distinction between, modifier and complement?
Writing dialogues for characters whose first language is not English
How can I automatically launch GPSD on startup?
Monitor delete statements on a specific table on DB2 LUW
How to revoke DBADM and clean up any related objects from DB2 LUWDB2: Cannot use RUNSTATS/REORG in trigger definitions?Problem deleting detached partition in DB2 LUW V9.7DB2 database -> does it continue to be platform-specific? (iSeries, LUW, z/OS)DB2 LUW Timestamp differences in versionsList of open (uncommitted transactions) in DB2 LUWWhere do I set the I/O size for DB2 9.7 LUW driver (AIX 6.1)?How to identify overflow rows in DB2 LUWSee parameters passed to query in DB2 LUW 10.5 (AIX or Windows)
Background
User is claiming that records are deleted from a specific table, but nobody knows why. They are not sure if it's an application error or done by a user.
Question
Is it possible to monitor / catch / trace delete statements executed against a specific table?
My first idea was to create an event monitor, but I can't limit it to a specific table or a specific kind of statement.
db2 db2-luw
asked Feb 18 at 9:41
CyberiderCyberider
293
add a comment |
Background
User is claiming that records are deleted from a specific table, but nobody knows why. They are not sure if it's an application error or done by a user.
Question
Is it possible to monitor / catch / trace delete statements executed against a specific table?
My first idea was to create an event monitor, but I can't limit it to a specific table or a specific kind of statement.
db2 db2-luw
asked Feb 18 at 9:41
CyberiderCyberider
293
add a comment |
Background
User is claiming that records are deleted from a specific table, but nobody knows why. They are not sure if it's an application error or done by a user.
Question
Is it possible to monitor / catch / trace delete statements executed against a specific table?
My first idea was to create an event monitor, but I can't limit it to a specific table or a specific kind of statement.
db2 db2-luw
asked Feb 18 at 9:41
CyberiderCyberider
293
Background
User is claiming that records are deleted from a specific table, but nobody knows why. They are not sure if it's an application error or done by a user.
Question
Is it possible to monitor / catch / trace delete statements executed against a specific table?
My first idea was to create an event monitor, but I can't limit it to a specific table or a specific kind of statement.
db2 db2-luw
db2 db2-luw
asked Feb 18 at 9:41
CyberiderCyberider
293
asked Feb 18 at 9:41
CyberiderCyberider
293
asked Feb 18 at 9:41
CyberiderCyberider
293
asked Feb 18 at 9:41
CyberiderCyberider
293
asked Feb 18 at 9:41
CyberiderCyberider
293
293
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Use the AUDIT TABLE statement on this table using an AUDIT POLICY with the EXECUTE category.
Or create an AFTER UPDATE trigger.
answered Feb 18 at 21:07
Mark BarinsteinMark Barinstein
1311
This is a good idea, but it as far as I see it's also not possible to limit the monitoring to delete statements only. Or do I miss something?
– Cyberider
2 days ago
If you mean auditing delete statements only, then yes, it's not possible.
– Mark Barinstein
2 days ago
add a comment |
Try a USAGE LIST
A usage list is a database object that records each DML statement section that references a particular table or index.
answered 11 mins ago
Paul VernonPaul Vernon
1835
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230028%2fmonitor-delete-statements-on-a-specific-table-on-db2-luw%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Use the AUDIT TABLE statement on this table using an AUDIT POLICY with the EXECUTE category.
Or create an AFTER UPDATE trigger.
answered Feb 18 at 21:07
Mark BarinsteinMark Barinstein
1311
This is a good idea, but it as far as I see it's also not possible to limit the monitoring to delete statements only. Or do I miss something?
– Cyberider
2 days ago
If you mean auditing delete statements only, then yes, it's not possible.
– Mark Barinstein
2 days ago
add a comment |
Use the AUDIT TABLE statement on this table using an AUDIT POLICY with the EXECUTE category.
Or create an AFTER UPDATE trigger.
answered Feb 18 at 21:07
Mark BarinsteinMark Barinstein
1311
This is a good idea, but it as far as I see it's also not possible to limit the monitoring to delete statements only. Or do I miss something?
– Cyberider
2 days ago
If you mean auditing delete statements only, then yes, it's not possible.
– Mark Barinstein
2 days ago
add a comment |
Use the AUDIT TABLE statement on this table using an AUDIT POLICY with the EXECUTE category.
Or create an AFTER UPDATE trigger.
answered Feb 18 at 21:07
Mark BarinsteinMark Barinstein
1311
Use the AUDIT TABLE statement on this table using an AUDIT POLICY with the EXECUTE category.
Or create an AFTER UPDATE trigger.
answered Feb 18 at 21:07
Mark BarinsteinMark Barinstein
1311
answered Feb 18 at 21:07
Mark BarinsteinMark Barinstein
1311
answered Feb 18 at 21:07
Mark BarinsteinMark Barinstein
1311
answered Feb 18 at 21:07
Mark BarinsteinMark Barinstein
1311
1311
This is a good idea, but it as far as I see it's also not possible to limit the monitoring to delete statements only. Or do I miss something?
– Cyberider
2 days ago
If you mean auditing delete statements only, then yes, it's not possible.
– Mark Barinstein
2 days ago
add a comment |
This is a good idea, but it as far as I see it's also not possible to limit the monitoring to delete statements only. Or do I miss something?
– Cyberider
2 days ago
If you mean auditing delete statements only, then yes, it's not possible.
– Mark Barinstein
2 days ago
This is a good idea, but it as far as I see it's also not possible to limit the monitoring to delete statements only. Or do I miss something?
– Cyberider
2 days ago
This is a good idea, but it as far as I see it's also not possible to limit the monitoring to delete statements only. Or do I miss something?
– Cyberider
2 days ago
If you mean auditing delete statements only, then yes, it's not possible.
– Mark Barinstein
2 days ago
If you mean auditing delete statements only, then yes, it's not possible.
– Mark Barinstein
2 days ago
add a comment |
Try a USAGE LIST
A usage list is a database object that records each DML statement section that references a particular table or index.
answered 11 mins ago
Paul VernonPaul Vernon
1835
add a comment |
Try a USAGE LIST
A usage list is a database object that records each DML statement section that references a particular table or index.
answered 11 mins ago
Paul VernonPaul Vernon
1835
add a comment |
Try a USAGE LIST
A usage list is a database object that records each DML statement section that references a particular table or index.
answered 11 mins ago
Paul VernonPaul Vernon
1835
Try a USAGE LIST
A usage list is a database object that records each DML statement section that references a particular table or index.
answered 11 mins ago
Paul VernonPaul Vernon
1835
answered 11 mins ago
Paul VernonPaul Vernon
1835
answered 11 mins ago
Paul VernonPaul Vernon
1835
answered 11 mins ago
Paul VernonPaul Vernon
1835
1835
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230028%2fmonitor-delete-statements-on-a-specific-table-on-db2-luw%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
