How can I Identify, what data available in Bufferpools and to which transaction that data is related?
1
Currently could see my DB2 10.5 is using 40 GB of available memory and all this memory was getting used by bufferpool of size 4K. can you please help in ways for identifying below requirement
- way to identify Hot Data available memory and
- to which transaction data available in memory and how much size of
memory that transaction used for processing query. - how frequent that data is getting accessed
- what transaction query is using more memory.
db2 db2-luw
edited Dec 30 '18 at 11:48
mao
3,7501316
asked Dec 30 '18 at 11:39
Behzad RahimiBehzad Rahimi
42
add a comment |
1
Currently could see my DB2 10.5 is using 40 GB of available memory and all this memory was getting used by bufferpool of size 4K. can you please help in ways for identifying below requirement
- way to identify Hot Data available memory and
- to which transaction data available in memory and how much size of
memory that transaction used for processing query. - how frequent that data is getting accessed
- what transaction query is using more memory.
db2 db2-luw
edited Dec 30 '18 at 11:48
mao
3,7501316
asked Dec 30 '18 at 11:39
Behzad RahimiBehzad Rahimi
42
1
While it might be possible to collect the information you want, you probably need to first articulate why you want it. What is it specifically that you are trying to achieve?
– mustaccio
Dec 30 '18 at 16:03
I wanna know which one of my tables are in the bufferpool and which one of them used the most memory resource
– Behzad Rahimi
Jan 9 at 9:20
You're just rephrasing your original question; instead, explain why you "wanna know which one of my tables are in the bufferpool".
– mustaccio
Jan 9 at 11:47
I want to tune that table and somehow optimise it in order to improve the performance
– Behzad Rahimi
Jan 9 at 12:09
Tables don't have "performance" and you can "tune" them. You need to identify SQL statements that don't perform according to your requirements and tune those.
– mustaccio
Jan 9 at 13:24
add a comment |
1
1
1
Currently could see my DB2 10.5 is using 40 GB of available memory and all this memory was getting used by bufferpool of size 4K. can you please help in ways for identifying below requirement
- way to identify Hot Data available memory and
- to which transaction data available in memory and how much size of
memory that transaction used for processing query. - how frequent that data is getting accessed
- what transaction query is using more memory.
db2 db2-luw
edited Dec 30 '18 at 11:48
mao
3,7501316
asked Dec 30 '18 at 11:39
Behzad RahimiBehzad Rahimi
42
Currently could see my DB2 10.5 is using 40 GB of available memory and all this memory was getting used by bufferpool of size 4K. can you please help in ways for identifying below requirement
- way to identify Hot Data available memory and
- to which transaction data available in memory and how much size of
memory that transaction used for processing query. - how frequent that data is getting accessed
- what transaction query is using more memory.
db2 db2-luw
db2 db2-luw
edited Dec 30 '18 at 11:48
mao
3,7501316
asked Dec 30 '18 at 11:39
Behzad RahimiBehzad Rahimi
42
edited Dec 30 '18 at 11:48
mao
3,7501316
asked Dec 30 '18 at 11:39
Behzad RahimiBehzad Rahimi
42
edited Dec 30 '18 at 11:48
mao
3,7501316
edited Dec 30 '18 at 11:48
mao
3,7501316
edited Dec 30 '18 at 11:48
mao
3,7501316
3,7501316
asked Dec 30 '18 at 11:39
Behzad RahimiBehzad Rahimi
42
asked Dec 30 '18 at 11:39
Behzad RahimiBehzad Rahimi
42
asked Dec 30 '18 at 11:39
Behzad RahimiBehzad Rahimi
42
42
1
While it might be possible to collect the information you want, you probably need to first articulate why you want it. What is it specifically that you are trying to achieve?
– mustaccio
Dec 30 '18 at 16:03
I wanna know which one of my tables are in the bufferpool and which one of them used the most memory resource
– Behzad Rahimi
Jan 9 at 9:20
You're just rephrasing your original question; instead, explain why you "wanna know which one of my tables are in the bufferpool".
– mustaccio
Jan 9 at 11:47
I want to tune that table and somehow optimise it in order to improve the performance
– Behzad Rahimi
Jan 9 at 12:09
Tables don't have "performance" and you can "tune" them. You need to identify SQL statements that don't perform according to your requirements and tune those.
– mustaccio
Jan 9 at 13:24
add a comment |
1
While it might be possible to collect the information you want, you probably need to first articulate why you want it. What is it specifically that you are trying to achieve?
– mustaccio
Dec 30 '18 at 16:03
I wanna know which one of my tables are in the bufferpool and which one of them used the most memory resource
– Behzad Rahimi
Jan 9 at 9:20
You're just rephrasing your original question; instead, explain why you "wanna know which one of my tables are in the bufferpool".
– mustaccio
Jan 9 at 11:47
I want to tune that table and somehow optimise it in order to improve the performance
– Behzad Rahimi
Jan 9 at 12:09
Tables don't have "performance" and you can "tune" them. You need to identify SQL statements that don't perform according to your requirements and tune those.
– mustaccio
Jan 9 at 13:24
1
1
While it might be possible to collect the information you want, you probably need to first articulate why you want it. What is it specifically that you are trying to achieve?
– mustaccio
Dec 30 '18 at 16:03
While it might be possible to collect the information you want, you probably need to first articulate why you want it. What is it specifically that you are trying to achieve?
– mustaccio
Dec 30 '18 at 16:03
I wanna know which one of my tables are in the bufferpool and which one of them used the most memory resource
– Behzad Rahimi
Jan 9 at 9:20
I wanna know which one of my tables are in the bufferpool and which one of them used the most memory resource
– Behzad Rahimi
Jan 9 at 9:20
You're just rephrasing your original question; instead, explain why you "wanna know which one of my tables are in the bufferpool".
– mustaccio
Jan 9 at 11:47
You're just rephrasing your original question; instead, explain why you "wanna know which one of my tables are in the bufferpool".
– mustaccio
Jan 9 at 11:47
I want to tune that table and somehow optimise it in order to improve the performance
– Behzad Rahimi
Jan 9 at 12:09
I want to tune that table and somehow optimise it in order to improve the performance
– Behzad Rahimi
Jan 9 at 12:09
Tables don't have "performance" and you can "tune" them. You need to identify SQL statements that don't perform according to your requirements and tune those.
– mustaccio
Jan 9 at 13:24
Tables don't have "performance" and you can "tune" them. You need to identify SQL statements that don't perform according to your requirements and tune those.
– mustaccio
Jan 9 at 13:24
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
});
}
});
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53977289%2fhow-can-i-identify-what-data-available-in-bufferpools-and-to-which-transaction%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f53977289%2fhow-can-i-identify-what-data-available-in-bufferpools-and-to-which-transaction%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
1
While it might be possible to collect the information you want, you probably need to first articulate why you want it. What is it specifically that you are trying to achieve?
– mustaccio
Dec 30 '18 at 16:03
I wanna know which one of my tables are in the bufferpool and which one of them used the most memory resource
– Behzad Rahimi
Jan 9 at 9:20
You're just rephrasing your original question; instead, explain why you "wanna know which one of my tables are in the bufferpool".
– mustaccio
Jan 9 at 11:47
I want to tune that table and somehow optimise it in order to improve the performance
– Behzad Rahimi
Jan 9 at 12:09
Tables don't have "performance" and you can "tune" them. You need to identify SQL statements that don't perform according to your requirements and tune those.
– mustaccio
Jan 9 at 13:24