Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    57

    Unanswered: "SQL2059W A device full" ...but ...

    Hello all!

    I have problem making a backup of db (DB" v7.2). It should have 110 GB (counting all tablespaces). I'm tring to place backup on the same computer in a directory that has 170GB free place. On AIX (v.4) I have enabled large file system, user has enough authorities, "ulimit -a" shows "file - unlimited".
    But, after 1h and 30 minutes it just stops with an message
    "SQL2059W A device full warning was encountered on device /backup'. Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t)".
    But backup directory is only 40 % full.
    It stops when completes 68 589 453 312 B.
    /backup directory is 174 214 610 944 B.

    I can't see anything to avoid the problem.

    Any advice I appreciate.
    Thank you,
    NNicole

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    The following thread has details
    http://www.dbforums.com/t1000341.html

    But, since you are on V4, you can apply the following technique :

    db2 backup database sample to /dbbackup,/dbbackup,/dbbackup

    will write the backup into three different files ... For 110, I'll use atleast 3 and preferably 4 ... Hence, you are unlikely to hit the 64 Gig limit

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by NNicole
    Hello all!

    I have problem making a backup of db (DB" v7.2). It should have 110 GB (counting all tablespaces). I'm tring to place backup on the same computer in a directory that has 170GB free place. On AIX (v.4) I have enabled large file system, user has enough authorities, "ulimit -a" shows "file - unlimited".
    But, after 1h and 30 minutes it just stops with an message
    "SQL2059W A device full warning was encountered on device /backup'. Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t)".
    But backup directory is only 40 % full.
    It stops when completes 68 589 453 312 B.
    /backup directory is 174 214 610 944 B.

    I can't see anything to avoid the problem.

    Any advice I appreciate.
    Thank you,
    NNicole

    After changing ulimite , you MUST restart instance, please use db2stop; db2start; and try again.
    let us know what happened.

  4. #4
    Join Date
    May 2003
    Posts
    57

    Now it is working...

    I didn't have problem with changing ulimite because I didn't update it, so I didn't need stop/start...
    But backup in three directories - work...

    db2 backup database sample to /backup/a, /backup/b, /backup/c

    Thank you!!

    NNicole

Posting Permissions

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