473,842 Members | 1,891 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Moving STMMLOG to another location

Folks -

DB2 V9.2 on SUSE 9

Is there a way other than moving the entire /sqllib/db2dump/ (Default
database path (DFTDBPATH) = /home/db2inst1 to move just STMMLOG out
of there to another location away from where it is?

I'd like to either 1). Move STMMLOG without moving db2diag 2).
Prohibit the making of the stmm.1.log file(s).

Thanks,

-B

Mar 27 '07 #1
7 4181
Ian
bw********@gmai l.com wrote:
Folks -

DB2 V9.2 on SUSE 9

Is there a way other than moving the entire /sqllib/db2dump/ (Default
database path (DFTDBPATH) = /home/db2inst1 to move just STMMLOG out
of there to another location away from where it is?

I'd like to either 1). Move STMMLOG without moving db2diag 2).
Prohibit the making of the stmm.1.log file(s).
Not sure why you'd want to move the stmm log only (as opposed to all of
the db2dump information), but, you could do it with a soft link:

cd /home/db2inst1/sqllib/db2dump
mv stmm /new/location
ln -s /new/location/stmm
Mar 28 '07 #2
Ian wrote:
bw********@gmai l.com wrote:
>Folks -

DB2 V9.2 on SUSE 9

Is there a way other than moving the entire /sqllib/db2dump/ (Default
database path (DFTDBPATH) = /home/db2inst1 to move just STMMLOG out
of there to another location away from where it is?

I'd like to either 1). Move STMMLOG without moving db2diag 2).
Prohibit the making of the stmm.1.log file(s).

Not sure why you'd want to move the stmm log only (as opposed to all of
the db2dump information), but, you could do it with a soft link:

cd /home/db2inst1/sqllib/db2dump
mv stmm /new/location
ln -s /new/location/stmm
I wouldn't do that with links. Just set the DIAGPATH configuration
parameter of the DBM config.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Mar 28 '07 #3
On Mar 28, 2:12 am, Knut Stolze <sto...@de.ibm. comwrote:
Ian wrote:
bwmille...@gmai l.com wrote:
Folks -
DB2 V9.2 on SUSE 9
Is there a way other than moving the entire /sqllib/db2dump/ (Default
database path (DFTDBPATH) = /home/db2inst1 to move just STMMLOG out
of there to another location away from where it is?
I'd like to either 1). Move STMMLOG without moving db2diag 2).
Prohibit the making of the stmm.1.log file(s).
Not sure why you'd want to move the stmm log only (as opposed to all of
OK, Thanks.

Well, from just after 2:00pm through nearly 8:00pm
I had 277,709 lines of output in 10mb...then a second
log was created taking-up 9mb and 277,709 lines.

stmm.1.log

2007-03-27-14.10.59.653462-360
2007-03-27-21.52.10.713117-360

302,148 lines...10,486, 375 bytes

stmm.2.log

2007-03-27-21.52.10.714093-360
2007-03-28-07.58.23.948920-360
277,709 lines...9,657,4 90 bytes

At this point I'm just going to modify my daily
cron job that maintains the db2diag.log file to
have it blow-away the stmm.n.log files.

Mar 28 '07 #4
On Mar 28, 10:02 am, bwmille...@gmai l.com wrote:
On Mar 28, 2:12 am, Knut Stolze <sto...@de.ibm. comwrote:
Ian wrote:
bwmille...@gmai l.com wrote:
>Folks -
>DB2 V9.2 on SUSE 9
>Is there a way other than moving the entire /sqllib/db2dump/ (Default
>database path (DFTDBPATH) = /home/db2inst1 to move just STMMLOG out
>of there to another location away from where it is?
>I'd like to either 1). Move STMMLOG without moving db2diag 2).
>Prohibit the making of the stmm.1.log file(s).
Not sure why you'd want to move the stmm log only (as opposed to all of

OK, Thanks.

Well, from just after 2:00pm through nearly 8:00pm
I had 277,709 lines of output in 10mb...then a second
log was created taking-up 9mb and 277,709 lines.

stmm.1.log

2007-03-27-14.10.59.653462-360
2007-03-27-21.52.10.713117-360

302,148 lines...10,486, 375 bytes

stmm.2.log

2007-03-27-21.52.10.714093-360
2007-03-28-07.58.23.948920-360
277,709 lines...9,657,4 90 bytes

At this point I'm just going to modify my daily
cron job that maintains the db2diag.log file to
have it blow-away the stmm.n.log files.
Just FYI - these STMM log files are circular - you should see at most
5 of these files, after which time STMM will start re-using the old
log files (unlike the db2diag.log, which is always appended to). So,
the STMM log files should consume at most 50MB of total disk space.

Cheers,
Liam.

Mar 28 '07 #5
Ian
Liam Finnie wrote:
Just FYI - these STMM log files are circular - you should see at most
5 of these files, after which time STMM will start re-using the old
log files (unlike the db2diag.log, which is always appended to). So,
the STMM log files should consume at most 50MB of total disk space.

Cheers,
Liam.
Liam,

Just out of curiosity: Why are the STMM log files separated out of the
db2diag.log? The stmm logs are in the same format, and can be queried
with the db2diag tool, so... ?

Thanks,
Mar 28 '07 #6
On Mar 28, 4:33 pm, Ian <ianb...@mobile audio.comwrote:
Liam Finnie wrote:
Just FYI - these STMM log files are circular - you should see at most
5 of these files, after which time STMM will start re-using the old
log files (unlike the db2diag.log, which is always appended to). So,
the STMM log files should consume at most 50MB of total disk space.
Cheers,
Liam.

Liam,

Just out of curiosity: Why are the STMM log files separated out of the
db2diag.log? The stmm logs are in the same format, and can be queried
with the db2diag tool, so... ?

Thanks,
Hi Ian,

If I remember correctly, the main reason is that we didn't want STMM
to flood the db2diag.log with information that is not typically that
important. Whenever STMM does make a tuning decision (increase the
size of a bufferpool, decrease the package cache size, etc), that
change will be reflected in the db2diag.log. What shows up in the
STMM log is more along the lines of internal metrics that led STMM to
conclude it should increase or decrease any particular memory
consumer.

So, the only time you should need to look in the STMM log (or likely,
that customer support would want to see the STMM log) is if we suspect
STMM is not making the right decisions for some reason. And, in those
cases, we're only usually concerned with recent tuning metrics (which
is why old STMM logs are re-used). So, logging all those metrics to
the db2diag.log would consume a lot of disk space, and it might cause
so much noise that other, more urgent, db2diag.log entries are missed.

Cheers,
Liam.

Mar 29 '07 #7
On Mar 29, 7:07 am, "Liam Finnie" <lfin...@ca.ibm .comwrote:
On Mar 28, 4:33 pm, Ian <ianb...@mobile audio.comwrote:
Liam Finnie wrote:
Just FYI - these STMM log files are circular - you should see at most
5 of these files, after which time STMM will start re-using the old
log files (unlike the db2diag.log, which is always appended to). So,
the STMM log files should consume at most 50MB of total disk space.
Cheers,
Liam.
Liam,
Just out of curiosity: Why are the STMM log files separated out of the
db2diag.log? The stmm logs are in the same format, and can be queried
with the db2diag tool, so... ?
Thanks,

Hi Ian,

If I remember correctly, the main reason is that we didn't want STMM
to flood the db2diag.log with information that is not typically that
important. Whenever STMM does make a tuning decision (increase the
size of a bufferpool, decrease the package cache size, etc), that
change will be reflected in the db2diag.log. What shows up in the
STMM log is more along the lines of internal metrics that led STMM to
conclude it should increase or decrease any particular memory
consumer.

So, the only time you should need to look in the STMM log (or likely,
that customer support would want to see the STMM log) is if we suspect
STMM is not making the right decisions for some reason. And, in those
cases, we're only usually concerned with recent tuning metrics (which
is why old STMM logs are re-used). So, logging all those metrics to
the db2diag.log would consume a lot of disk space, and it might cause
so much noise that other, more urgent, db2diag.log entries are missed.

Cheers,
Liam.
Liam -

I appreciate your thoughtful answer to this question...and FYI from my
experience the STMM manager is working really well....we enjoy
watching it make memory changes on the fly as the needs change.

I say Congrats to IBM and you folks for a nice implementation.

-B

Mar 29 '07 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1937
by: HeroOfSpielburg | last post by:
hi, I know this is a much-travelled subject, but I was wondering what people's thoughts were on the bare minimum (and conversely the grand scheme) for augmenting standard memory references to handle moving objects around in memory (as is needed in compaction algorithms associated with 'moving collection' aka 'copy collection'). There are a number of ways to handle this without affecting the overarching structure of one's program (albeit...
1
2554
by: GuyInTn | last post by:
Hi all, I have been given the task of moving an sql database from one server to another. These servers are not on the same network. I know I can detach the database, copy it to a new location, then FTP it to the new server and re-attach it. My question is, is this the best way to do this? Or is there another way? I have access to both servers through Enterprise Manager.
6
8935
by: Hemant Shah | last post by:
Folks, I need to move HOME directory of an instance to another directory. What is the best way of doing it? Is changing password file enough? or dies DB2 store this info in it's own config? I am running UDB 8.2 on Linux and AIX. Thanks.
7
1615
by: jcrouse | last post by:
I use the following three subs to click on a label and reposition it at runtime: Private Sub lblP1JoyUp_MouseDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles lblP1JoyUp.MouseDown myMouseDown = True mouseX = Cursor.Position.X - Me.Location.X - (lblP1JoyUp.Width / 2)
2
3117
by: Carl Gilbert | last post by:
Hi I have a math kinda problem where I'm trying to split some lines when two or more lines connect two shapes. The reason I am doing this is to make it clear that there are multiple lines connecting the two shapes. http://www.blackwaterbadgers.co.uk/image1.bmp Image 1 shows how if you have a line between two shapes, the line is straight. if you have more than one line, the lines will start overlapping
4
9286
by: fripper | last post by:
I am a real novice when it comes to the graphics class in VB 2005. I have a windows app with a large picture box control with a black background ... except for a small rectangle that has an image in it. A timer fires every second or so and when it does I want to move the small rectangle within the picture box to another location within the picture box. I don't want to copy the rectangle ... I want to move it and have the vacated...
14
2013
by: bwadley | last post by:
Hi, Im fairly new to VB.NET and am hoping someone can help me with what is probably a simple problem. I have an MDI app, when I open a child form, I want it centered to the parent. So I put some code in the FormLoad procedure which works out the centre of the screen and moves the child appropraitely. This is pretty much the code I have:
12
1932
by: =?Utf-8?B?TWFyaw==?= | last post by:
I modified a C# application from Bob Powell that moves graphics primitives around on the screen into a Vb.NET 2005 application. I want to modify this application so along with moving regular geometric shapes, I can also move the alphanumeric characters as well. For example I place the character "A" on the screen and when I point to it with the mouse the character will be outlined and while holding down the left mouse button move the "A"...
15
2456
by: mcjason | last post by:
I saw something interesting about a grid pair puzzle problem that it looks like a machine when you find each that work out the way it does and say with all the others that work out the way they do together overlapping common pieces but say connected each working out as connected, but together as connected it's connected with the others connected. a whole machine where connected together is a condition of the machine together as...
0
9865
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10609
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10668
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9446
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7853
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5694
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5882
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4498
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3140
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.