SUM(CurrentPerm) > SUM(MaxPerm) for one of the VPROCS

Database
Enthusiast

SUM(CurrentPerm) > SUM(MaxPerm) for one of the VPROCS

Hi,

Just wanted to know if thats possible since I observed that for one of my databases when I queried DBC.DISKSPACE

SUM(CurrentPerm) was greater than SUM(MaxPerm) for one of the vprocs (vproc = 0 in my case)

Please suggest.

Thanks

Manik

2 REPLIES
Enthusiast

Re: SUM(CurrentPerm) > SUM(MaxPerm) for one of the VPROCS

Yes, that is possible.  There are several possible scenarios that could produce that result, and there are good reasons why we allow it to happen. The most common case seems to be when a database is restored to a new hardware configuration.  Another case I've seen is when a MultiLoad job aborts because of a maxperm violation.  Since the job can't roll back, the disk space usage persists.  Rerunning the MultiLoad job repeatedly without increasing maxperm for the target database may widen the discrepancy.

Enthusiast

Re: SUM(CurrentPerm) > SUM(MaxPerm) for one of the VPROCS

Hey Jim,

Thanks a lot for the response.

Appreciated

Thanks

Manik