Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005
    Posts
    31

    Unanswered: file system full on redirected restore

    Hello,
    I am attempting to do a redirected restore on my test system from a production backup. The steps below are how I started it:
    1. Drop db.
    2. start restore
    Code:
    db2 restore db prod9 taken at 20110526233139 redirect
    3 set tables spaces.
    Code:
           db2 set tablespace containers for 0 using "path 'db2prod\dbcon0')"
           db2 set tablespace containers for 1 using "path 'db2prod\dbcon1')"
           db2 set tablespace containers for 2 using "path 'db2prod\dbcon2')"
           db2 set tablespace containers for 3 using "(file 'db2prod\dbcon3\prod9data_01.dbf' 4804096)"
    On the last one I receive the following error
    Code:
    SQL0968C  The file system is full.  SQLSTATE=57011
    I checked the file system db2prod and it is currently at
    Code:
    /dev/lv05      134217728 130004624    4%       32     1% /db2prod
    - 512 k blocks

    I ran the ulimit -a command and received the following:
    Code:
       time(seconds)        unlimited
    file(blocks)         unlimited
    data(kbytes)         245760
    stack(kbytes)        16384
    memory(kbytes)       unlimited
    coredump(blocks)     unlimited
    nofiles(descriptors) unlimited
    finally I checked the db2diag.log file and found the following:
    Code:
        2011-05-31-08.18.19.737177-240 I613772C662        LEVEL: Error
    PID     : 41952                TID  : 1           PROC : db2agent (PROD9) 0
    INSTANCE: db2inst1             NODE : 000         DB   : PROD9
    APPHDL  : 0-1256               APPID: *LOCAL.db2inst1.110531120307
    FUNCTION: DB2 UDB, oper system services, sqlowrite, probe:200
    MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
              DIA8312C Disk was full.
    DATA #1 : File handle, PD_TYPE_SQO_FILE_HDL, 8 bytes
    0x2FF17588 : 0000 0005 0000 0000                        ........
    DATA #2 : unsigned integer, 4 bytes
    131072
    DATA #3 : signed integer, 4 bytes
    57344
    DA
    2011-05-31-08.18.21.068946-240 I614401C432        LEVEL: Error
    PID     : 41952                TID  : 1           PROC : db2agent (PROD9) 0
    INSTANCE: db2inst1             NODE : 000         DB   : PROD9
    APPHDL  : 0-1256               APPID: *LOCAL.db2inst1.110531120307
    FUNCTION: DB2 UDB, buffer pool services, sqlbSetPoolCont, probe:1360
    RETCODE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."
              DIA8312C Disk was full.
    From the above how do I tell which file system is full. Also, to resolve this problem do I have to stop and start db2, reboot the system? If so how would I restart my restore?
    db2 version is DB2 v8.1.1.144 fixpack 16

    Thank you.

    - edit
    I forgot to mention that this is the same size it was set at previously.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Your redirect path is 'db2prod\dbcon0', but your mount point is /db2prod.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jul 2005
    Posts
    31
    Thank you Marcus. I retried the settables spaces command:
    Code:
    db2 set tablespace containers for 3 using "(file '/db2prod/dbcon3/prod9data_01.dbf' 4804096)"
    And that is working.

    My next question is since I screwed up and the previous set tablespaces - path commands by using the "\" instead of "/" will that cause a problem?

    I suppose once the restore is completed and I don't like the way it worked I could start over and do it correctly.

Posting Permissions

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