DB2 database file System full solution

Error Case:

Create a tablespace with a size of 20G in the DB2 database of the AIX system, with the following specific SQL:

create REGULAR TABLESPACE HTDC_DATA PAGESIZE 8 K MANAGED BY DATABASE
USING ( FILE ’/db2_tag/TABLE_SPACES/HTDC_DATA/HTDC_DATA.dat’ 20G)
EXTENTSIZE 16 OVERHEAD 10.67 PREFETCHSIZE 16 TRANSFERRATE 0.04
BUFFERPOOL BPHTDC
dropPED TABLE RECOVERY OFF

Error code: SQLCODE 0968C

Error message: File System is full. (File system is full)

Problem reason: The maximum file size allowed for the current user ID is exceeded.

Workaround:

Login to Aix terminal

Telnet IPAddress

Access to the system

Root

PassWord

Switch user to Db2admin

Su-db2admin

PassWord

Change Fsize to 100G, (209715100 512byte)

Chuser fsize=209715100 Db2admin

Restart the computer

Shutdown-fr

Login system again and switch user to Db2admin

Su- db2admin
PassWord
db2start
db2
connect to HTDC user db2admin using ******
create REGULAR TABLESPACE HTDC_DATA PAGESIZE 8 K MANAGED BY DATABASE
USING ( FILE ’/db2_tag/TABLE_SPACES/HTDC_DATA/HTDC_DATA.dat’ 20G)
EXTENTSIZE 16 OVERHEAD 10.67 PREFETCHSIZE 16 TRANSFERRATE 0.04
BUFFERPOOL BPHTDC
dropPED TABLE RECOVERY OFF