Viewpoint

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

05-10-2018
09:27 AM

05-10-2018
09:27 AM

Can someone provide SQL to calculate Current Perm Max %? I guess I don't understand the concept of 'current perm max', it seems it should just be the amount of perm space assigned to a database. The Viewpoint User Guide provides this calculation:

Current Perm Max=((% Current Perm Max * Number of Vprocs)/ Max Perm)

I recently reduced the amount of perm space assigned to a database that I have an alert set up for in Viewpoint. When I run this query:

SyntaxEditor Code Snippet

SELECT Databasename (format 'X(12)') ,SUM(maxperm),SUM(CurrentPerm),SUM(PeakPerm),((SUM(currentperm))/ NULLIFZERO (SUM(maxperm)) * 100) (FORMAT 'zz9.99%', TITLE 'Percent // Used')FROM DBC.DiskSpaceV where databasename in ('XXXXX')GROUP BY 1 ORDER BY 3 DESC WITH SUM (currentperm), SUM(maxperm);

I get the following results:

DatabaseName=XXXXX

Sum(MaxPerm)=1,588,058,280

Sum(CurrentPerm)=1,146,953,728

Sum(PeakPerm)=1,148,467,712

Percent used=72.22

I have a Database Space alert set up in Viewpoint that sends an email when the Current Perm Max threshold is > 90%. I have been receiving alerts ever since I reduced the amount of perm space (it was about 9 GB). I don't understand that my database is 72% full but I'm getting an alert saying:

Space Used Percentage=72.223656

Max Space Used Percentage=95.1047

Can someone help me understand?

4 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

05-10-2018
10:53 AM

05-10-2018
10:53 AM

Your database is skewed, this *(% Current Perm Max * Number of Vprocs)* calculation in Viewpoint translates to

max(CurrentPerm) * (HashAMP() +1) -- max used space across all AMPS * number of AMPs in your system

Highlighted
##
##### Re: Current Perm Max % Viewpoint alert: how is this calculated?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

05-10-2018
01:39 PM

05-10-2018
01:39 PM

Thank you very much, Dieter, this is very helpful. I had a feeling skew was the issue. Could you walk me through an example of calculating these values so I know how to size the database properly? Current Perm Max % = ((Current Perm Max * Number of Vprocs)/ Max Perm)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

05-10-2018
02:24 PM

05-10-2018
02:24 PM

max(CurrentPerm) * (HashAMP() +1) / sum(MaxPerm) as "Current Perm Max %"

:-)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

05-14-2018
01:07 PM

05-14-2018
01:07 PM

Thanks again, Dieter!!