Hi!
I have found that all the queries to my database consume too much CPU. Specially ADMIN_CENTER queries are too CPU intensive.
I have TSM server in a z/OS environment and by database characteristics are:
QUERY DB f=D
Available Space (MB): 99.292
Assigned Capacity (MB): 99.292
Maximum Extension (MB): 0
Maximum Reduction (MB): 952
Page Size (bytes): 4.096
Total Usable Pages: 25.418.752
Used Pages: 24.878.771
Pct Util: 97,9
Max. Pct Util: 97,9
Physical Volumes: 40
Buffer Pool Pages: 38.400
Total Buffer Requests: 8.082.700
Cache Hit Pct.: 99,97
Cache Wait Pct.: 0,00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 2
Changed Since Last Backup (MB): 267,09
Percentage Changed: 0,27
Last Complete Backup Date/Time: 02-04-2008
04:40:50
Estimate of Recoverable Space (MB): 21.496
Last Estimate of Recoverable Space (MB): 13-08-2007
18:39:28
Does anyone find anything wrong? I mean, is the database too big? Do I have to add another server?
Any suggestion?
Thanks in advance
I have found that all the queries to my database consume too much CPU. Specially ADMIN_CENTER queries are too CPU intensive.
I have TSM server in a z/OS environment and by database characteristics are:
QUERY DB f=D
Available Space (MB): 99.292
Assigned Capacity (MB): 99.292
Maximum Extension (MB): 0
Maximum Reduction (MB): 952
Page Size (bytes): 4.096
Total Usable Pages: 25.418.752
Used Pages: 24.878.771
Pct Util: 97,9
Max. Pct Util: 97,9
Physical Volumes: 40
Buffer Pool Pages: 38.400
Total Buffer Requests: 8.082.700
Cache Hit Pct.: 99,97
Cache Wait Pct.: 0,00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 2
Changed Since Last Backup (MB): 267,09
Percentage Changed: 0,27
Last Complete Backup Date/Time: 02-04-2008
04:40:50
Estimate of Recoverable Space (MB): 21.496
Last Estimate of Recoverable Space (MB): 13-08-2007
18:39:28
Does anyone find anything wrong? I mean, is the database too big? Do I have to add another server?
Any suggestion?
Thanks in advance