Error during spooling

Shell Programming and Scripting
1

Hi,

I am extracting the records of a table from oracle into a csv file using spool command in unix script. I retrieve the error message as

msgcnt 18512 vxfs: mesg 001: vx_nospace - /dev/vg02/lvol12 file system full (1 block extent)

How to resolve it ?

2

The disk is full.

df -h

will show you which disk has the problem. You have to delete files from the disk before your code will run.

3

In case it's HP-UX:

df /dev/vg02/lvol12
df -k /dev/vg02/lvol12
bdf /dev/vg02/lvol12
4

Thank you

5

And you can always look at:

vgdisplay vg02

and look for the line :

Free PE                      XXXX

To see if you have some space left to extend you lvol...