A - Errors

A.1

MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
          DIA8312C Disk was full.
DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
0x0FFFFFFFFFFE3AA0 : 0000 0013 0000 0000                        ........
DATA #2 : unsigned integer, 8 bytes
131072
DATA #3 : signed integer, 8 bytes
2975858688
DATA #4 : unsigned integer, 8 bytes
0
DATA #5 : Hex integer, 4 bytes
0x00000000

A.2

MESSAGE : ADM6017E  The table space "SYSCATSPACE" (ID "0") is full.
	  Detected on container "/db2data/db2inst1/DB/db2inst1/NODE0000/
	  SQL00001/SQLT0000.0"(ID"0").The underlying file system is full or
	  the maximum allowed space usage for the file system has been 
	  reached. It is also possible that there are user limits in place
	  with respect to maximum file size and these limits have been
	  reached.

B- Possible Causes

B1 - Containers are full

All containers assigned to the tablespace are full.

B2 - Filesystem is full

The specific filesystem of the correspondent container is full

C - Investigating

First, check if the Tablespaces are full

db2 list tablespaces show detail

Check all containers for this tablespace

db2 list tablespace containers for <Tablespace ID> show detail

Check the space usage of all containers
Exemple:

df -g /db2data/db2inst1/DB/DBINST1.DBF

D - Resoluting

If the specific filesystem for this container is full, and you can't extend the tablespace, you must find out if there are space on the disk, to increase this filesystem.


First type:

'lsvg'

This gives you the list of VG's. You must find out the specific VG of the filesystem.
Type:

lsvg -l <vgname>

Now, you should find out how much free space is. You will see something like this:

FREE PPs:       237 (7584 megabytes)

Now, Be Careful. If you do not have permission, call the OS support to increase the filesystem. If you have permission, you must increase, for exemple, here we have 7.5 GB free. I will increase only 7.0 GB. Type:

chfs -a size=+7G <Filesystem path>

The chfs command changes the attributes of a file system. The options: -a size, specifies the size of the Journaled File System in 512-byte blocks. If Value begins with a + it is interpreted as a request to increase the file system size by the specified amount.

Now, you should check the filesystem again:

df -g <Filesystem path>

Now, you can extend the tablespace.
Got it ?