determining the perm space .........!!!

UDA

determining the perm space .........!!!

i HAVE an create /insert SQL that creates the table and inserts the data into the tables ...............is there any calculation or capacity planning kind of thing before we assign the PERM SPACE while creating an user or a database ........../

if so please suggest how to determine the PERM SPACE ............
1 REPLY

Re: determining the perm space .........!!!

U can calculate by the following Sql.

SELECT Vproc
,CAST (TableName
AS FORMAT 'X(20)')
,CurrentPerm
,PeakPerm
FROM DBC.TableSize
WHERE DatabaseName = USER
ORDER BY TableName, Vproc ;

Note: replace USER by the database name.