We have a JFS filesystem on AIX that has reached its defined limit (64GB) and i was wondering what would be the best option, here is what our AIX admin laid out for us:

Option 1. Create a new filesystem (either JFS or JFS2) of another SMS container and make DB2 to use new one as a expansion.

Option 2. Create a JFS2 filesystem and migrate all data over to new one.

Option 3. Create a new JFS filesystem with larger nbpi parameter and migrate all data.


Option 2&3 are easy based on my knowledge of DB2 and the amount I work on it but option 1 seems like a good option but I am not sure how to go about it.

If anyone has any ideas or suggestions that would be great

Mark

DB2 8.1 on AIX 5.2

I would do option 1 (add a new container to the existing tablespace). See the SQL Reference for ALTER TABLESPACE.

I'm not sure you can actually add containers to an SMS tablespace, except when creating a new database partition. You would have to do a redirected restore.