Extend a DMS tablespace

[kozlow]

Ran the following command:
db2 -v "ALTER TABLESPACE INDEX01 EXTEND ( FILE '/db2prod/index/index01.f01' 5772991 )"

Received error:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0968C The file system is full. SQLSTATE=57011

Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/db2_index_lv 88735744 44016572 51% 18 1% /db2prod/index

The database ID has unlimited as far as File size....

Is there a UDB limit to the max size of a container?

running on Unix - UDB 7.2

Thanks.....

 

[gregsimpson]

Kozlow,

as your on UNIX could it be ulimit, this can restrict the maximum file size and gives this error.

I believe on AIX, you have the option to increase the size of the db file system, which is usually in the /home file system.

Cheers
Greg

 

[kozlow]

Checked the ID and the ulimit is set to -1 (unlimited). The increase should have been under the 64Gig limit of a tablespace too.

The filesystem I am trying to increase the DMS area has plenty of room. I will check and see if there is a file size limit. I have created the filesystem with large file enabled....

 

[kozlow]

My fault... The File size limit is the 64 Gig, matching the Tablespace size limit, Like I thought... Except I failed to read the fine print, the File size limit is really 64Gig Minus 128 Meg..... RTFM.... And I was blaming UDB.