Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: DB2 stored procedures filesystem full errors

    Hello gurus,

    We keep getting filesystem error full messages when we run several stored procedure transform jobs in DB2 UDB on AIX. We added space and expanded the size of the raw volume that the stored procedures use. If the stored procedures/transforms fail what else could be the cause and resolution of the problem? Thanks

    Scott

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 stored procedures filesystem full errors

    I would check the system logs to see which filesystem was full at that time and start from there .....

    Check the db2diag.log file also ...

    What is the stored procedure doing ? Any ideas ... If it is performing a complex query, it could be that TEMPSPACE is full ..

    Cheers

    Sathyaram

    Originally posted by mixxalot
    Hello gurus,

    We keep getting filesystem error full messages when we run several stored procedure transform jobs in DB2 UDB on AIX. We added space and expanded the size of the raw volume that the stored procedures use. If the stored procedures/transforms fail what else could be the cause and resolution of the problem? Thanks

    Scott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •