Re: Feature codes

[Larry Bolhuis <lbolhuis@xxxxxxxxxx>]

Al,

 RE: The %DB Capability. I belive this is specifically intended for DSD
boxes where the amount of CPU available for DB2 is limited much the same
as interactive. Thus it is possible to have the %CPU Used at 20 but %DB
Capability at 100.  Interestingly I have observed %DB capability greater
than %CPU Used on NON-DSD boxes although not over long periods.

 - Larry

barsa@barsaconsulting.com wrote:
>

> To make matters worse, I expect that multiple levels of data base
> capability will be offered in a future release.  (I have no advanced
> knowledge of this that I have not derived by myself.)  In V5R1, take a look
> at assistance level 3 in WRK/DSPSYSSTS:
>
>                              Display System Status
> BARSA
>                                                              10/24/01
> 13:20:33
>  % CPU used . . . . . . . :       32.5    Auxiliary storage:
>  % DB capability  . . . . :         .0      System ASP . . . . . . :
> 36.50 G
>  Elapsed time . . . . . . :   00:11:02      % system ASP used  . . :
> 50.1795
>  Jobs in system . . . . . :       3348      Total  . . . . . . . . :
> 49.31 G
>  % perm addresses . . . . :       .009      Current unprotect used :
> 710 M
>  % temp addresses . . . . :       .009      Maximum unprotect  . . :
> 719 M
>  System    Pool    Reserved    Max   -----DB-----  ---Non-DB---
>   Pool   Size (M)  Size (M)  Active  Fault  Pages  Fault  Pages
>     1       60.26     34.69   +++++     .0     .0     .0     .0
>     2      163.88       .08      51     .0     .0     .0     .0
>     3        2.55       .00       5     .0     .0     .0     .0
>     4       29.28       .00      10     .0     .0    4.4    4.4
>