Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007

    Unanswered: device full warning in Restoring the database


    I'm using db2v8.1 on aix.

    when I run the restore script, I'm getting the below error.

    SQL2059W A device full warning was encountered on device "TSCDTABLES".
    Do you want to continue(c), terminate this device only(d), abort the utility(t) ? (c/d/t)

    I tried to increase the container size of each folder and tried to introduce sub folders also. I'm unable to find the device TSCDTABLES.

    I'm unable to restore the database and this warning is getting even with all the options I tried so far. I 've issued the command ulimit -a and below is the output.

    time(seconds) unlimited
    file(blocks) unlimited
    data(kbytes) 245760
    stack(kbytes) 16384
    memory(kbytes) unlimited
    coredump(blocks) unlimited
    nofiles(descriptors) 2000

    I'm refreshing the database with the same script for many times. This is the first time I'm getting this. The database is offshore database and server not enterprise server. Only single user is accessing the file system.

    Any help to restore the database succesfully?

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    this is a tablespace I presume
    ts cd-tables the tablespaces for keeping the cd tables for replication
    probably sms container and filesystem is full where this container is located
    try to check the history for this db and see the tablespaces
    do you have a db2Look of this db
    try redirected restore
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Oct 2004
    I had the same exact problem and had to allocate more space to drive with smitty on the file system. Do a:

    df -m and look how much free space you have left. Then, take into account the database size you are restoring.


Posting Permissions

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