AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.


#Power
 View Only

  • 1.  Disk space issues

    Posted Tue October 07, 2014 06:58 AM

    Originally posted by: mirfaanm


    Hi there,

    I am relatively new to AIX, and i am trying to run some sql command for db2 but i am getting the following error:

    SQL0968C  The file system is full.  SQLSTATE=57011
     

    I have tried deleting a lot of files mostly from /tmp but i still get the same error.

    Any guidance would be appreciated.

    Thanks,


    #AIX-Forum


  • 2.  Re: Disk space issues

    Posted Tue October 07, 2014 08:15 AM

    Originally posted by: stephnane


    First check which file system is full (df -g or errpt -a).

    Then, in /tmp, check for old files -ls -tl

    You can also extend /tmp

    1. lsvg rootvg and check for free PPs
    2. Hot-extend /tmp with "chfs -a size=+200M /tmp"  (fot extending 200 MB on this filesystem)

    You can also try to change the destination of datas in your SQL script.


    #AIX-Forum


  • 3.  Re: Disk space issues

    Posted Tue October 07, 2014 10:54 AM

    Originally posted by: mirfaanm


    Thanks for the reply....

    So i guess i was struggling to read the results of df...but i saw /home was 100% used.

    I then ran the chfs -a size=+200M /home".

    I tried running the sql query that failed earlier and it ran successfully now.

    Thanks for the advise :)...

     

    Regards,

     


    #AIX-Forum


Related Content