file system full on redirected restore

jyoung · #1 (**permalink**) 05-31-11, 09:25

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.

Marcus_A · #2 (**permalink**) 05-31-11, 09:33

Your redirect path is 'db2prod\dbcon0', but your mount point is /db2prod.

jyoung · #3 (**permalink**) 05-31-11, 09:46

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech