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: [email protected] 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 [EMAIL PROTECTED] ******************************** ********************************************************************** 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. **********************************************************************
