ADSM-L

DB performance and space

1997-04-23 06:15:59
Subject: DB performance and space
From: CC Masters <cmaster1 AT TUELECTRIC DOT COM>
Date: Wed, 23 Apr 1997 11:15:59 +0100
We are running ADSM MVS 2.1.10.  The database is apx 13GB.  Each of the
12 data base volume is allocated at 1172MB (1/2 of a 3390-3).

1.  Any thoughts on the pros and cons to allocating more, smaller DB
volumes compared to a few large DB volumes? (Database performance is the
goal here).  There is high I/O to the DASD where the DB volumes reside.
One of the ideas was to allow the smaller DB volumes to be managed by
SMS, thereby spreading the volumes across a general pool(and spreading
the I/O?).


2.  After splitting the workload to a second ADSM server I am left with
a DB that is under 50% utilized, shown below:

adsm> q db

Available Assigned   Maximum   Maximum    Page     Total      Used
%Util  Max.
    Space Capacity Extension Reduction    Size    Usable     Pages
%Util
     (MB)     (MB)      (MB)      (MB) (bytes)     Pages
--------- -------- --------- --------- ------- --------- --------- -----
-----
-----
   13,824   13,824         0         0   4,096 3,538,944 1,652,738
   13,824   13,824         0         0   4,096 3,538,944 1,652,738
46.7  46.7

How do I reclaim some of the unused space if "Maximum Reduction" is 0?
<Prev in Thread] Current Thread [Next in Thread>
  • DB performance and space, CC Masters <=