Hi Eric,
Thank you so much! It has drastically improved performance! I was just
wondering if you would happen to know about the show memu S command and if
MaxQuickFree is supposed to be greater than Freeheld bytes? I know there's
a set command to increase the maxquickfree bytes, but I couldn't find any
documentation on it... Thanks again!
MAX initial storage 536870912 (512.0 MB)
Freeheld bytes 17377241 (16.6 MB)
MaxQuickFree bytes 10737418 (10.2 MB)
0 Page buffers of 13107 : 65 buffers of 1638.
10 Large buffers of 819 : 61 XLarge buffers of 102.
7106 buffers free: 68677 hiAlloc buffers: 54030 current buffers.
33689 units of 264 bytes hiAlloc: 33688 units of 264 bytes hiCur.
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
"Loon, E.J. van -
SPLXM"
<Eric-van.Loon@KL To
M.COM> ADSM-L AT VM.MARIST DOT EDU
Sent by: "ADSM: cc
Dist Stor
Manager" Subject
<[email protected] Re: Server Performance decreasing
.EDU> rapidly: help!
01/27/2005 09:48
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[email protected]
.EDU>
Hi Joni!
I noticed that your database is quite large (more than 100 Gb.) and you are
running with a very small database buffer. I would expect an ever lower
cache hit pct! You should use the setopt command to raise your bufpoolsize.
It's now 135 Mb, I would at least double it.
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-----Original Message-----
From: Joni Moyer [mailto:joni.moyer AT HIGHMARK DOT COM]
Sent: Thursday, January 27, 2005 15:34
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Server Performance decreasing rapidly: help!
Hey!
The performance on our TSM server is going down rapidly. It is on os/390
at level 5.2.2.5.
I have the following settings:
Server Option Option Setting Server Option Option Setting
----------------- -------------------- -----------------
--------------------
CommTimeOut 600 IdleTimeOut 90
BufPoolSize 135168 LogPoolSize 4096
DateFormat 1 (mm/dd/yyyy) TimeFormat 1 (hh:mm:ss)
NumberFormat 1 (1,000.00) MessageFormat 1
Language AMENG Alias Halt HALT
MaxSessions 300 ExpInterval 0
ExpQuiet No EventServer Yes
MirrorRead DB Normal MirrorRead LOG Normal
MirrorWrite DB Sequential MirrorWrite LOG Parallel
VolumeHistory 'SYS1.TSM.B1.VOLHIS- VolumeHistory
'SYS1.TSM.A1.VOLHIS-
T' T'
Devconfig 'SYS1.TSM.B1.DEVCON- Devconfig
'SYS1.TSM.A1.DEVCON-
F' F'
TxnGroupMax 256 MoveBatchSize 1000
MoveSizeThresh 2048 StatusMsgCnt 10
RestoreInterval 1,440 UseLargeBuffers Yes
DisableScheds No NOBUFPREfetch No
AuditStorage Yes REQSYSauthoutfile Yes
SELFTUNEBUFpools- Yes SELFTUNETXNsize No
ize
DBPAGEShadow No DBPAGESHADOWFile dbpgshdw.bdt
MsgStackTrace On QueryAuth None
LogWarnFullPerCe- 90 ThroughPutDataTh- 0
nt reshold
ThroughPutTimeTh- 0 NOPREEMPT ( No )
reshold
Resource Timeout 60 TEC UTF8 Events No
CommOpenTimeOut 20 TcpPort 1500
TcpAdminport 1500 TcpName TCPIP2
HttpTcpPort 1580 TECHost
TECPort 0 UNIQUETECevents No
UNIQUETDPTECeven- No IcsPort 1500
ts
ICSAdminport 1500 IcsSname *NONE*
PDMPort 1580 PDMName *NONE*
PDMConnect PDM TAPEIOBufs 1
UserExit FileExit
FileTextExit HttpIcsPort 1580
DeletionExit ARCTVEXT MsgSuppress *NONE*
LuName *NONE* Iucv *NONE*
RouteCode 11 MsgHilight *NONE*
MPThreading No TCPBufsize 32,768
HPDTenable Yes HPDTstorage ECSA
HPDTbuffer# 6 HPDTexpand# 2
NOLONG ( No )
The q db f=d is showing me that the cache hit% just keeps going down.
Available Space (MB): 116,320
Assigned Capacity (MB): 108,456
Maximum Extension (MB): 7,864
Maximum Reduction (MB): 16,804
Page Size (bytes): 4,096
Total Usable Pages: 27,764,736
Used Pages: 23,466,774
Pct Util: 84.5
Max. Pct Util: 84.5
Physical Volumes: 50
Buffer Pool Pages: 33,792
Total Buffer Requests: 50,768,552
Cache Hit Pct.: 97.63
Cache Wait Pct.: 0.00
And the Log Pool Pct. Util is greater than 0.
Available Space (MB): 11,636
Assigned Capacity (MB): 7,576
Maximum Extension (MB): 4,060
Maximum Reduction (MB): 7,244
Page Size (bytes): 4,096
Total Usable Pages: 1,938,944
Used Pages: 84,073
Pct Util: 4.3
Max. Pct Util: 5.7
Physical Volumes: 5
Log Pool Pages: 1,024
Log Pool Pct. Util: 0.57
What am I doing wrong? Any ideas? I am at a loss. Thank you in advance!
********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************
**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential
and privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment
may be disclosed, copied or distributed, and that any other action related
to this e-mail or attachment is strictly prohibited, and may be unlawful.
If you have received this e-mail by error, please notify the sender
immediately by return e-mail, and delete this message. Koninklijke
Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees
shall not be liable for the incorrect or incomplete transmission of this
e-mail or any attachments, nor responsible for any delay in receipt.
**********************************************************************
|