Hi all,


on AIX db2 v9.5 , i'm trying to restore db v8.2 (offline backup).
I use command :
db2 "restore db merlin from . to '/db2data1/merlin/db2inst1' REPLACE HISTORY FILE without prompting"

(in order to using it like HADR stand by db ).

but i'd get the message : SQL0968C The file system is full. SQLSTATE=57011

i've enough space in Fs /db2data1, and the ulimit is up of 2G .
All db containers are on /db2data1/merlin/db2inst1 path.

What am i missing ?
Pls help !1

Tnks,

do you get the error while executing restore ?
any indication in diag.log ? this file indicates the fs that is full or what db2 is trying to access. is instance owner owner of fs for db ?
have you verified the container paths on primary ?
have you checked the migration guide /infocenter - sometimes it is indicated that wile migration from x to y you need x space in catalog tablespace - log space should be x.....

hi Guy,
In db2diag i saw that some tablespace containers creation is faild because file system is full, but this container is defined on fs with enough free space available .
I also can see during the restore that db2 try to create files on this fs, but after 0.21G , it fail with this message of not enough space

When creating a DB2 HADR standby database, you should be able to restore without specifying any "TO" or "INTO" options, assuming that two servers are set up with the same paths for the instance (which is highly recommended).

So you should be able to do this:

db2 "restore db merlin from /xxx... REPLACE HISTORY FILE without prompting"

If you have more than one backup on the "from path" obviously you will need to use the TAKEN AT clause.

Hi,
If i Don't use to.. in the restore order , iget : SQL0298N Bad container path. SQLSTATE=428B2.

In db2diag i get : OSERR : ENOENT (2) "A file or directory in the path name does not exist."

I prepare exact path in the new server, like in the old one .
How can i know wich file or directory in not exists ?

Tks,

when the restore ends (with error) do you see any files already created with larger size?
can you execute df -k
ls -latr on the db filesystem
while creating a hadr standby db - upgrading at the same time from V8 to V9 ?
put some details - from command - messages - diag.... fs.

I don't see any file created during the restore .

message in db2diag :
2011-08-18-16.58.57.538298-300 I2737533A523 LEVEL: Info (OS)
PID : 557074 TID : 772 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000
EDUID : 772 EDUNAME: db2acd 0
FUNCTION: DB2 Common, OSSe, OSSHIPCMemory::attach, probe:20
MESSAGE : ECF=0x90000047=-1879048121=ECF_MEM_DOESNT_EXIST
The specified memory is not found and IPC_CREAT flag is not specified.
CALLED : OS, -, shmget
OSERR : ENOENT (2) "A file or directory in the path name does not exist."


command line message :
$ db2 "restore db merlin from . REPLACE HISTORY FILE without prompting"
SQL0298N Bad container path. SQLSTATE=428B2

this is the containers in old db:
/db2data1/merlin2/db2inst1/NODE0000/SQL00001/SQLT0000.0
/db2data1/merlin2/db2inst1/NODE0000/SQL00001/SQLT0001.0
/db2data1/merlin2/db2inst1/NODE0000/SQL00001/SQLT0002.0
/db2data1/merlin/db2inst1/NODE0000/SQL00001/tbs/rmaxdat
SQL0445W Value "/db2data1/merlin/db2inst1/NODE0000/SQL00001/tbs/rmaxdata" has
been truncated. SQLSTATE=01004

/db2data1/merlin/db2inst1/NODE0000/SQL00001/tbs/rmaxidx
/db2data1/merlin/db2inst1/NODE0000/SQL00001/tbs/temp
/db2data1/merlin2/db2inst1/NODE0000/SQL00001/SYSTOOLSPA
SQL0445W Value "/db2data1/merlin2/db2inst1/NODE0000/SQL00001/SYSTOOLSPACE"
has been truncated. SQLSTATE=01004

/db2data1/merlin2/db2inst1/NODE0000/SQL00001/SYSTOOLSTM
SQL0445W Value "/db2data1/merlin2/db2inst1/NODE0000/SQL00001/SYSTOOLSTMPSPAC"
has been truncated. SQLSTATE=01004

in new server , i have those directories :
/db2data1/merlin/db2inst1
/db2data1/merlin2/db2inst1

something i miss ?

I do not see any indication about FULL - where did it come from
where was the db generated : db2 list db directory should tell
probably this is the problem or the default db path is pointing to a non existing path
you are misleading the people that are trying to help you..
specify in restore where to create the db on.. see syntax diagram..

Hi ,
During the restore order , i looked on " list db directory" and i see that the db going to another place : /db2/db2inst1/db2data

Why it try to created on this fs ?
is the any parameter told db2 to create this new db in this fs ?

why do you think IBM has created some doc.. please read..
RESTORE DATABASE