Re: Server Performance decreasing rapidly: help!
Joni Moyer wrote >>I was just wondering how my bufpoolsize> region size? My region size is >>512MB and my bufpoolsize is 270336KB which equals out to 264MB. Is that an >>incorrect statement? I'm still trying to find the command to increase my >>maxquickfree bytes. Does anyone know this command? As you can see, I'm in >>need of increasing it... Thanks! >>MAX initial storage 536870912 (512.0 MB) >>Freeheld bytes 13592207 (13.0 MB) >>MaxQuickFree bytes 10737418 (10.2 MB) >>0 Page buffers of 13107 : 84 buffers of 1638. >>12 Large buffers of 819 : 69 XLarge buffers of 102. >> 2375 buffers free: 71682 hiAlloc buffers: 51214 current buffers. >> 33689 units of 264 bytes hiAlloc: 33685 units of 264 bytes hiCur. Sorry Joni I am used to thinking of buffer pool in 4 kb pages, so I stupidly took your query opt value x 4 By the way according to your opt the value is 134 mb not 268 mb. Anyway having said that your bufferpool size is large compared to your region size. OS390 is arguably not the best place for your size of database, as unless you have a dedicated lpar you are likely to be sharing memory and cpu with competing applications as I have to, so your performance will never match what you can get out of a dedicated unix box. You or your performance person need to look at RMF or similar tool to see how much real memory your TSM address space is using and whether it is having to page frequently. As Bill Kelly said earlier increasing your region size will increase MaxQuickFree bytes. At 768mb as mine is you get 15mb of MaxQuickFree bytes However the undocumented and hemce unsupported show memu command certainly does work under z/OS so it ought to work under os390. If you can't get it to work from the os390 command line, try it from the admin web browser. The command to double your MaxQuickFree bytes is :- show memu set maxquick 21474836 Can't remember whether it is case sensitive or not, so if it doesn't work lower case try upper. cheers, John ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy Group. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Unless specifically stated otherwise, this email (or any attachments to it) is not an offer capable of acceptance or acceptance of an offer and it does not form part of a binding contractual agreement. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **
Re: Server Performance decreasing rapidly: help!
Hi Joni! Sorry, I can't help you with that one. It has been 10 years since we ran ADSM 2.1 on MVS, so I have no experience with z/OS. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Joni Moyer [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 16:31 To: ADSM-L@VM.MARIST.EDU Subject: Re: Server Performance decreasing rapidly: help! 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 [EMAIL PROTECTED] "Loon, E.J. van - SPLXM" <[EMAIL PROTECTED] To M.COM>ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 15:34 To: ADSM-L@VM.MARIST.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 SettingServer Option Option Setting - - CommTimeOut600 IdleTimeOut90 BufPoolSize135168LogPoolSize4096 DateFormat 1 (mm/dd/)TimeFormat 1 (hh:mm:ss) NumberFormat 1 (1,000.00) MessageFormat 1 Language AMENG Alias Halt HALT MaxSessions300 ExpInterval0 ExpQuiet NoEventServerYes MirrorRead DB NormalMirrorRead LOG Normal MirrorWrite DB SequentialMirrorWrite LOGParallel VolumeHistory 'SYS1.TSM.B1.VOLHIS- VolumeHistory 'SYS1.TSM.A1.VOLHIS- T' T' Devconfig 'SYS1.TSM.B1.DEVCON- Devconfig 'SYS1.TSM.A1.DEVCON- F' F' TxnGroupMax256 MoveBatchSize 1000 MoveSizeThresh 2048 StatusMsgCnt 10 RestoreInterval1,440 UseLargeBuffersYes DisableScheds NoNOBUFPREfetch No AuditStorage Yes REQSYSauthoutfile Yes SELFTUNEBUFpools- Yes SELFTUNETXNsizeNo ize DBPAGEShadow NoDBPAGESHADOWFile dbpgshdw.bdt MsgStackTrace OnQueryAuth None LogWarnFullPerCe- 90ThroughPutDataTh- 0 nt reshold ThroughPutTimeTh- 0 NOPREEMPT ( No ) reshold Resource Timeout 60TEC UTF8 EventsNo CommOpenTimeOut20TcpPort1500 TcpAdminport 1500 TcpNameTCPIP2 HttpTcpPort1580 TECHost TECPort0 UNIQUETECeventsNo UNIQUETDPTECeven- NoIcsPort1500 ts ICSAdminport 1500 IcsSname *NONE* PDMPort1580 PDMName*NONE* PDMC
Re: Server Performance decreasing rapidly: help!
Hi John!
I was just wondering how my bufpoolsize> region size? My region size is
512MB and my bufpoolsize is 270336KB which equals out to 264MB. Is that an
incorrect statement? I'm still trying to find the command to increase my
maxquickfree bytes. Does anyone know this command? As you can see, I'm in
need of increasing it... Thanks!
MAX initial storage 536870912 (512.0 MB)
Freeheld bytes 13592207 (13.0 MB)
MaxQuickFree bytes 10737418 (10.2 MB)
0 Page buffers of 13107 : 84 buffers of 1638.
12 Large buffers of 819 : 69 XLarge buffers of 102.
2375 buffers free: 71682 hiAlloc buffers: 51214 current buffers.
33689 units of 264 bytes hiAlloc: 33685 units of 264 bytes hiCur.
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]
"John Naylor"
<[EMAIL PROTECTED]
TISH-SOUTHERN.CO. To
UK> ADSM-L@VM.MARIST.EDU
Sent by: "ADSM:cc
Dist Stor
Manager" Subject
<[EMAIL PROTECTED] Re: Server Performance decreasing
.EDU> rapidly: help!
01/27/2005 11:00
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
Joni,
Your bufferpool size is set higher than your region size, I did not know
you could do that
I would certainly look at increasing your region size, but you need to
check how much real memory is available in your lpar, and how much TSM is
actually using.
FWIW I am using a region size of 768 mb and BufPoolSize49152
My database is however only one third as big as yours
Another thing not connected with cace hit is that you have CommTimeOut
600
Do you not get a lot of sessions failing with this value, mine is set at
3600
regards,
John
Joni Moyer <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
27/01/2005 15:43
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@vm.marist.edu
cc
Subject
Re: Server Performance decreasing rapidly: help!
The REGION is set to 512MB within the startup JCL. I didn't know what the
max. is for the region size, so I didn't change that. I will have to look
into increasing that as well. Thanks!
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]
"Joe Howell"
<[EMAIL PROTECTED]
NSURANCE.COM> To
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU> Re: Server Performance decreasing
rapidly: help!
01/27/2005 10:23
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
What's your REGION set to on the startup jcl? We're using 768M, but then
we appear to be a smaller implementation than you based on your database
size.
###
Joe Howell
Shelter Insurance Companies
(573)-214-6534
[EMAIL PROTECTED]
Joni Moyer <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
01/27/2005 08:34 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
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 SettingServer Option Option Setting
- -
CommTimeOut600 IdleTimeOut90
BufPoolSize135168LogPoolSize4096
DateFormat 1 (mm/dd/)TimeFormat 1 (hh:mm:ss)
NumberFormat 1 (1,000.00) MessageFormat 1
Language AMENG Alias Halt HALT
MaxSessions300 ExpInterval0
ExpQuiet NoEventServerYes
MirrorRead DB NormalMirrorRead LOG Normal
MirrorWrite DB SequentialMirrorWrite LOGParallel
VolumeHistory 'SYS1.TSM.B1.VOLHIS- VolumeH
Re: Server Performance decreasing rapidly: help!
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 [EMAIL PROTECTED] "Loon, E.J. van - SPLXM" <[EMAIL PROTECTED] To M.COM>ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 15:34 To: ADSM-L@VM.MARIST.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 SettingServer Option Option Setting - - CommTimeOut600 IdleTimeOut90 BufPoolSize135168LogPoolSize4096 DateFormat 1 (mm/dd/)TimeFormat 1 (hh:mm:ss) NumberFormat 1 (1,000.00) MessageFormat 1 Language AMENG Alias Halt HALT MaxSessions300 ExpInterval0 ExpQuiet NoEventServerYes MirrorRead DB NormalMirrorRead LOG Normal MirrorWrite DB SequentialMirrorWrite LOGParallel VolumeHistory 'SYS1.TSM.B1.VOLHIS- VolumeHistory 'SYS1.TSM.A1.VOLHIS- T' T' Devconfig 'SYS1.TSM.B1.DEVCON- Devconfig 'SYS1.TSM.A1.DEVCON- F' F' TxnGroupMax256 MoveBatchSize 1000 MoveSizeThresh 2048 StatusMsgCnt 10 RestoreInterval1,440 UseLargeBuffersYes DisableScheds NoNOBUFPREfetch No AuditStorage Yes REQSYSauthoutfile Yes SELFTUNEBUFpools- Yes SELFTUNETXNsizeNo ize DBPAGEShadow NoDBPAGESHADOWFile dbpgshdw.bdt MsgStackTrace OnQueryAuth None LogWarnFullPerCe- 90ThroughPutDataTh- 0 nt reshold ThroughPutTimeTh- 0 NOPREEMPT ( No ) reshold Resource Timeout 60TEC UTF8 EventsNo CommOpenTimeOut20TcpPort1500 TcpAdminport 1500 TcpNameTCPIP2 HttpTcpPort1580 TECHost TECPort0 UNIQUETECeventsNo UNIQUETDPTECeven- NoIcsPort1500 ts ICSAdminport 1500 IcsSname *NONE* PDMPort1580 PDMName*NONE* PDMConnect PDM TAPEIOBufs 1 UserExit FileExit FileTextExit HttpIcsPort1580 DeletionExit ARCTVEXT MsgSuppress*NONE* LuName *NONE*Iucv *NONE* RouteCode 11MsgHilight
Re: Server Performance decreasing rapidly: help!
Joni,
Your bufferpool size is set higher than your region size, I did not know
you could do that
I would certainly look at increasing your region size, but you need to
check how much real memory is available in your lpar, and how much TSM is
actually using.
FWIW I am using a region size of 768 mb and BufPoolSize49152
My database is however only one third as big as yours
Another thing not connected with cace hit is that you have CommTimeOut
600
Do you not get a lot of sessions failing with this value, mine is set at
3600
regards,
John
Joni Moyer <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
27/01/2005 15:43
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@vm.marist.edu
cc
Subject
Re: Server Performance decreasing rapidly: help!
The REGION is set to 512MB within the startup JCL. I didn't know what the
max. is for the region size, so I didn't change that. I will have to look
into increasing that as well. Thanks!
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]
"Joe Howell"
<[EMAIL PROTECTED]
NSURANCE.COM> To
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU> Re: Server Performance decreasing
rapidly: help!
01/27/2005 10:23
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
What's your REGION set to on the startup jcl? We're using 768M, but then
we appear to be a smaller implementation than you based on your database
size.
###
Joe Howell
Shelter Insurance Companies
(573)-214-6534
[EMAIL PROTECTED]
Joni Moyer <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
01/27/2005 08:34 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
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 SettingServer Option Option Setting
- -
CommTimeOut600 IdleTimeOut90
BufPoolSize135168LogPoolSize4096
DateFormat 1 (mm/dd/)TimeFormat 1 (hh:mm:ss)
NumberFormat 1 (1,000.00) MessageFormat 1
Language AMENG Alias Halt HALT
MaxSessions300 ExpInterval0
ExpQuiet NoEventServerYes
MirrorRead DB NormalMirrorRead LOG Normal
MirrorWrite DB SequentialMirrorWrite LOGParallel
VolumeHistory 'SYS1.TSM.B1.VOLHIS- VolumeHistory
'SYS1.TSM.A1.VOLHIS-
T' T'
Devconfig 'SYS1.TSM.B1.DEVCON- Devconfig
'SYS1.TSM.A1.DEVCON-
F' F'
TxnGroupMax256 MoveBatchSize 1000
MoveSizeThresh 2048 StatusMsgCnt 10
RestoreInterval1,440 UseLargeBuffersYes
DisableScheds NoNOBUFPREfetch No
AuditStorage Yes REQSYSauthoutfile Yes
SELFTUNEBUFpools- Yes SELFTUNETXNsizeNo
ize
DBPAGEShadow NoDBPAGESHADOWFile dbpgshdw.bdt
MsgStackTrace OnQueryAuth None
LogWarnFullPerCe- 90ThroughPutDataTh- 0
nt reshold
ThroughPutTimeTh- 0 NOPREEMPT ( No )
reshold
Resource Timeout 60TEC UTF8 EventsNo
CommOpenTimeOut20TcpPort1500
TcpAdminport 1500 TcpNameTCPIP2
HttpTcpPort1580 TECHost
TECPort0 UNIQUETECeventsNo
UNIQUETDPTECeven- NoIcsPort1500
ts
ICSAdminport 1500 IcsSname *NONE*
PDMPort1580 PDMName*NONE*
PDMConnect PDM TAPEIOBufs 1
UserExit FileExit
FileTextExit
Re: Server Performance decreasing rapidly: help!
I'm using region=896m, you might want to check with your performance group
to see if you have enough storage to run this high.
Joni Moyer <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
01/27/2005 10:43 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
Subject
Re: Server Performance decreasing rapidly: help!
The REGION is set to 512MB within the startup JCL. I didn't know what the
max. is for the region size, so I didn't change that. I will have to look
into increasing that as well. Thanks!
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]
"Joe Howell"
<[EMAIL PROTECTED]
NSURANCE.COM> To
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU> Re: Server Performance decreasing
rapidly: help!
01/27/2005 10:23
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
What's your REGION set to on the startup jcl? We're using 768M, but then
we appear to be a smaller implementation than you based on your database
size.
###
Joe Howell
Shelter Insurance Companies
(573)-214-6534
[EMAIL PROTECTED]
Joni Moyer <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
01/27/2005 08:34 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
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 SettingServer Option Option Setting
- -
CommTimeOut600 IdleTimeOut90
BufPoolSize135168LogPoolSize4096
DateFormat 1 (mm/dd/)TimeFormat 1 (hh:mm:ss)
NumberFormat 1 (1,000.00) MessageFormat 1
Language AMENG Alias Halt HALT
MaxSessions300 ExpInterval0
ExpQuiet NoEventServerYes
MirrorRead DB NormalMirrorRead LOG Normal
MirrorWrite DB SequentialMirrorWrite LOGParallel
VolumeHistory 'SYS1.TSM.B1.VOLHIS- VolumeHistory
'SYS1.TSM.A1.VOLHIS-
T' T'
Devconfig 'SYS1.TSM.B1.DEVCON- Devconfig
'SYS1.TSM.A1.DEVCON-
F' F'
TxnGroupMax256 MoveBatchSize 1000
MoveSizeThresh 2048 StatusMsgCnt 10
RestoreInterval1,440 UseLargeBuffersYes
DisableScheds NoNOBUFPREfetch No
AuditStorage Yes REQSYSauthoutfile Yes
SELFTUNEBUFpools- Yes SELFTUNETXNsizeNo
ize
DBPAGEShadow NoDBPAGESHADOWFile dbpgshdw.bdt
MsgStackTrace OnQueryAuth None
LogWarnFullPerCe- 90ThroughPutDataTh- 0
nt reshold
ThroughPutTimeTh- 0 NOPREEMPT ( No )
reshold
Resource Timeout 60TEC UTF8 EventsNo
CommOpenTimeOut20TcpPort1500
TcpAdminport 1500 TcpNameTCPIP2
HttpTcpPort1580 TECHost
TECPort0 UNIQUETECeventsNo
UNIQUETDPTECeven- NoIcsPort1500
ts
ICSAdminport 1500 IcsSname *NONE*
PDMPort1580 PDMName*NONE*
PDMConnect PDM TAPEIOBufs 1
UserExit FileExit
FileTextExit HttpIcsPort1580
DeletionExit ARCTVEXT MsgSuppress*NONE*
LuName *NONE*Iucv *NONE*
RouteCode 11MsgHilight *NONE*
MPThreadingNoTCPBufsize 32,768
HPDTenable Yes HPDTstorageECSA
HPDTbuffer#6
Re: Server Performance decreasing rapidly: help!
The REGION is set to 512MB within the startup JCL. I didn't know what the
max. is for the region size, so I didn't change that. I will have to look
into increasing that as well. Thanks!
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]
"Joe Howell"
<[EMAIL PROTECTED]
NSURANCE.COM> To
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU> Re: Server Performance decreasing
rapidly: help!
01/27/2005 10:23
AM
Please respond to
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
What's your REGION set to on the startup jcl? We're using 768M, but then
we appear to be a smaller implementation than you based on your database
size.
###
Joe Howell
Shelter Insurance Companies
(573)-214-6534
[EMAIL PROTECTED]
Joni Moyer <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager"
01/27/2005 08:34 AM
Please respond to
"ADSM: Dist Stor Manager"
To
ADSM-L@VM.MARIST.EDU
cc
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 SettingServer Option Option Setting
- -
CommTimeOut600 IdleTimeOut90
BufPoolSize135168LogPoolSize4096
DateFormat 1 (mm/dd/)TimeFormat 1 (hh:mm:ss)
NumberFormat 1 (1,000.00) MessageFormat 1
Language AMENG Alias Halt HALT
MaxSessions300 ExpInterval0
ExpQuiet NoEventServerYes
MirrorRead DB NormalMirrorRead LOG Normal
MirrorWrite DB SequentialMirrorWrite LOGParallel
VolumeHistory 'SYS1.TSM.B1.VOLHIS- VolumeHistory
'SYS1.TSM.A1.VOLHIS-
T' T'
Devconfig 'SYS1.TSM.B1.DEVCON- Devconfig
'SYS1.TSM.A1.DEVCON-
F' F'
TxnGroupMax256 MoveBatchSize 1000
MoveSizeThresh 2048 StatusMsgCnt 10
RestoreInterval1,440 UseLargeBuffersYes
DisableScheds NoNOBUFPREfetch No
AuditStorage Yes REQSYSauthoutfile Yes
SELFTUNEBUFpools- Yes SELFTUNETXNsizeNo
ize
DBPAGEShadow NoDBPAGESHADOWFile dbpgshdw.bdt
MsgStackTrace OnQueryAuth None
LogWarnFullPerCe- 90ThroughPutDataTh- 0
nt reshold
ThroughPutTimeTh- 0 NOPREEMPT ( No )
reshold
Resource Timeout 60TEC UTF8 EventsNo
CommOpenTimeOut20TcpPort1500
TcpAdminport 1500 TcpNameTCPIP2
HttpTcpPort1580 TECHost
TECPort0 UNIQUETECeventsNo
UNIQUETDPTECeven- NoIcsPort1500
ts
ICSAdminport 1500 IcsSname *NONE*
PDMPort1580 PDMName*NONE*
PDMConnect PDM TAPEIOBufs 1
UserExit FileExit
FileTextExit HttpIcsPort1580
DeletionExit ARCTVEXT MsgSuppress*NONE*
LuName *NONE*Iucv *NONE*
RouteCode 11MsgHilight *NONE*
MPThreadingNoTCPBufsize 32,768
HPDTenable Yes HPDTstorageECSA
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
Re: Server Performance decreasing rapidly: help!
What's your REGION set to on the startup jcl? We're using 768M, but then we appear to be a smaller implementation than you based on your database size. ### Joe Howell Shelter Insurance Companies (573)-214-6534 [EMAIL PROTECTED] Joni Moyer <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 01/27/2005 08:34 AM Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc 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 SettingServer Option Option Setting - - CommTimeOut600 IdleTimeOut90 BufPoolSize135168LogPoolSize4096 DateFormat 1 (mm/dd/)TimeFormat 1 (hh:mm:ss) NumberFormat 1 (1,000.00) MessageFormat 1 Language AMENG Alias Halt HALT MaxSessions300 ExpInterval0 ExpQuiet NoEventServerYes MirrorRead DB NormalMirrorRead LOG Normal MirrorWrite DB SequentialMirrorWrite LOGParallel VolumeHistory 'SYS1.TSM.B1.VOLHIS- VolumeHistory 'SYS1.TSM.A1.VOLHIS- T' T' Devconfig 'SYS1.TSM.B1.DEVCON- Devconfig 'SYS1.TSM.A1.DEVCON- F' F' TxnGroupMax256 MoveBatchSize 1000 MoveSizeThresh 2048 StatusMsgCnt 10 RestoreInterval1,440 UseLargeBuffersYes DisableScheds NoNOBUFPREfetch No AuditStorage Yes REQSYSauthoutfile Yes SELFTUNEBUFpools- Yes SELFTUNETXNsizeNo ize DBPAGEShadow NoDBPAGESHADOWFile dbpgshdw.bdt MsgStackTrace OnQueryAuth None LogWarnFullPerCe- 90ThroughPutDataTh- 0 nt reshold ThroughPutTimeTh- 0 NOPREEMPT ( No ) reshold Resource Timeout 60TEC UTF8 EventsNo CommOpenTimeOut20TcpPort1500 TcpAdminport 1500 TcpNameTCPIP2 HttpTcpPort1580 TECHost TECPort0 UNIQUETECeventsNo UNIQUETDPTECeven- NoIcsPort1500 ts ICSAdminport 1500 IcsSname *NONE* PDMPort1580 PDMName*NONE* PDMConnect PDM TAPEIOBufs 1 UserExit FileExit FileTextExit HttpIcsPort1580 DeletionExit ARCTVEXT MsgSuppress*NONE* LuName *NONE*Iucv *NONE* RouteCode 11MsgHilight *NONE* MPThreadingNoTCPBufsize 32,768 HPDTenable Yes HPDTstorageECSA 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 [EMAIL PROTECTED] === This e-mail is intended only for its addressee and may contain informat
Re: Server Performance decreasing rapidly: help!
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:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 15:34 To: ADSM-L@VM.MARIST.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 SettingServer Option Option Setting - - CommTimeOut600 IdleTimeOut90 BufPoolSize135168LogPoolSize4096 DateFormat 1 (mm/dd/)TimeFormat 1 (hh:mm:ss) NumberFormat 1 (1,000.00) MessageFormat 1 Language AMENG Alias Halt HALT MaxSessions300 ExpInterval0 ExpQuiet NoEventServerYes MirrorRead DB NormalMirrorRead LOG Normal MirrorWrite DB SequentialMirrorWrite LOGParallel VolumeHistory 'SYS1.TSM.B1.VOLHIS- VolumeHistory 'SYS1.TSM.A1.VOLHIS- T' T' Devconfig 'SYS1.TSM.B1.DEVCON- Devconfig 'SYS1.TSM.A1.DEVCON- F' F' TxnGroupMax256 MoveBatchSize 1000 MoveSizeThresh 2048 StatusMsgCnt 10 RestoreInterval1,440 UseLargeBuffersYes DisableScheds NoNOBUFPREfetch No AuditStorage Yes REQSYSauthoutfile Yes SELFTUNEBUFpools- Yes SELFTUNETXNsizeNo ize DBPAGEShadow NoDBPAGESHADOWFile dbpgshdw.bdt MsgStackTrace OnQueryAuth None LogWarnFullPerCe- 90ThroughPutDataTh- 0 nt reshold ThroughPutTimeTh- 0 NOPREEMPT ( No ) reshold Resource Timeout 60TEC UTF8 EventsNo CommOpenTimeOut20TcpPort1500 TcpAdminport 1500 TcpNameTCPIP2 HttpTcpPort1580 TECHost TECPort0 UNIQUETECeventsNo UNIQUETDPTECeven- NoIcsPort1500 ts ICSAdminport 1500 IcsSname *NONE* PDMPort1580 PDMName*NONE* PDMConnect PDM TAPEIOBufs 1 UserExit FileExit FileTextExit HttpIcsPort1580 DeletionExit ARCTVEXT MsgSuppress*NONE* LuName *NONE*Iucv *NONE* RouteCode 11MsgHilight *NONE* MPThreadingNoTCPBufsize 32,768 HPDTenable Yes HPDTstorageECSA 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 [EMAIL PROTECTED] ** For information, services
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 SettingServer Option Option Setting - - CommTimeOut600 IdleTimeOut90 BufPoolSize135168LogPoolSize4096 DateFormat 1 (mm/dd/)TimeFormat 1 (hh:mm:ss) NumberFormat 1 (1,000.00) MessageFormat 1 Language AMENG Alias Halt HALT MaxSessions300 ExpInterval0 ExpQuiet NoEventServerYes MirrorRead DB NormalMirrorRead LOG Normal MirrorWrite DB SequentialMirrorWrite LOGParallel VolumeHistory 'SYS1.TSM.B1.VOLHIS- VolumeHistory 'SYS1.TSM.A1.VOLHIS- T' T' Devconfig 'SYS1.TSM.B1.DEVCON- Devconfig 'SYS1.TSM.A1.DEVCON- F' F' TxnGroupMax256 MoveBatchSize 1000 MoveSizeThresh 2048 StatusMsgCnt 10 RestoreInterval1,440 UseLargeBuffersYes DisableScheds NoNOBUFPREfetch No AuditStorage Yes REQSYSauthoutfile Yes SELFTUNEBUFpools- Yes SELFTUNETXNsizeNo ize DBPAGEShadow NoDBPAGESHADOWFile dbpgshdw.bdt MsgStackTrace OnQueryAuth None LogWarnFullPerCe- 90ThroughPutDataTh- 0 nt reshold ThroughPutTimeTh- 0 NOPREEMPT ( No ) reshold Resource Timeout 60TEC UTF8 EventsNo CommOpenTimeOut20TcpPort1500 TcpAdminport 1500 TcpNameTCPIP2 HttpTcpPort1580 TECHost TECPort0 UNIQUETECeventsNo UNIQUETDPTECeven- NoIcsPort1500 ts ICSAdminport 1500 IcsSname *NONE* PDMPort1580 PDMName*NONE* PDMConnect PDM TAPEIOBufs 1 UserExit FileExit FileTextExit HttpIcsPort1580 DeletionExit ARCTVEXT MsgSuppress*NONE* LuName *NONE*Iucv *NONE* RouteCode 11MsgHilight *NONE* MPThreadingNoTCPBufsize 32,768 HPDTenable Yes HPDTstorageECSA 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 [EMAIL PROTECTED]
