Currentperm more than Maxperm on one AMP for database

Database
Teradata Employee

Currentperm more than Maxperm on one AMP for database

Hi All,

We are facing an issue regarding some skew.

When we assign space to a database then this space get divide even to the all AMPs. So any amp has limited space for database. Ex. If database d1 has 10 GB space and we have 10 Amps than each amp will have 1 GB space for database d1 and table size cannot occupy space more than 1 GB in any amp for database d1.

Issue : but here we are using MLOAD and currentperm of database on one amp is more than the maxperm. How its possible? 

when we run mload a work table size  created with uneven distribution  that make database currentperm more than it maxperm.

We are not able to create a table in this database even we have enough space in this database

Please help for the same.

Vproc

(Sum(CurrentPerm)/1.00000000000000E009)

(Sum(MaxPerm)/1.00000000000000E009)

29

0.24

0.07

0

0.01

0.07

4

0.01

0.07

24

0.01

0.07

2 REPLIES
Teradata Employee

Re: Currentperm more than Maxperm on one AMP for database

Vpro  CurrentPerm MaxPerm
29  0.24  0.07
0  0.01  0.07
4  0.01  0.07
24  0.01  0.07

Teradata Employee

Re: Currentperm more than Maxperm on one AMP for database

Hello Sandeep,

Possibly, the below link can help you:

https://forums.teradata.com/forum/database/sumcurrentperm-summaxperm-for-one-of-the-vprocs

Thanks,

Smarak