Running UDB 7.2 on a RS6000 server

[kozlow]

Running UDB 7.2 on a RS6000 server running AIX4.3.3

df -k shows 46423068K free on /db2prod/data

ran

create tablespace DATA01 managed by database
using (file '/db2prod/data/data01.f01' 46423068K)

This brought the database to its knees. No one could log in and all the transactions where timing out. After about an hour... Received error message:
SQL0968C The File system is full. SQLSTATE=57011

It removed the data01.f01 file from /db2prod/data. Again showing 46423068K free.....

Does the database need more space then I allocated for overhead and how much. I read that it needs three extents for overhead, but I was assuming that was part of the 46423068K I assigned.

Also, why did the database hang on creating a new tablespace????

Thanks in advance....

 

[ChristopherD]

Hi -

If you are creating a DMS tablespace you need to be sure that you are using the 'whole' filesystem. Meaning your 46423068K should be ALL of the available pages in that file system. Also, you should not have any other data in that filesystem.

Hope this helps.

Christopher Devenny
c_devenny@yahoo.com