Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL2544N : Restore fail due to directory full

319 views
Skip to first unread message

Fabrizio Napolitano

unread,
Jul 3, 2002, 4:32:22 PM7/3/02
to
Hi everyone,

I'm at the moment stuck on this problem:
I have A DB2 udb 5.2 on an AIX server, and trying to Restore a Backup
from another UDB 5.2 on a different AIX box.
The source DB has only the 3 default tablespaces (SMS).
The Backup Image is 2.2 GB in size.

I have defined a Large enabled Filesystem (size 5.5GB) on the new box.
And I have setted to -1 the soft file size for both root and instnace
owner .

I have tranferred the Backup Image on this filesystem and this worked
smoothly.


But when I try to restore the database, after a while (when the
Userspace1 directory reach the size of 1.2GB), the command stop with
error SQL2544N saying that the target directory is full! The
filesystem has still at least 2GB free.

I have looked at the errpt output and no filesystem got full.

To be sure where the file were going I even tried a redirected restore
but I caught the same behaviour.

Are there any limit I missed to set properly??
What else can be the problem??

Any idea is welcome...
Thank you
Fabrizio

Jan M. Nelken

unread,
Jul 3, 2002, 5:13:08 PM7/3/02
to

What is ard file size limit?
Did you reboot Aix box after changing file limit(s)?
You are using Db2 which support ended several years ago. What are you
going to do about it?

Jan M. Nelken

Michael Bhola

unread,
Jul 3, 2002, 5:28:05 PM7/3/02
to
Check your filesize ulimits on the 2 boxes.

"Fabrizio Napolitano" <fnapo...@insirio.it> wrote in message
news:ee331dd9.0207...@posting.google.com...

Joerg Ammann

unread,
Jul 4, 2002, 2:27:21 AM7/4/02
to
"Michael Bhola" <bho...@nospam.uk.ibm.com> wrote in message news:<afvqeh$mbk$1...@sp15at20.hursley.ibm.com>...

> Check your filesize ulimits on the 2 boxes.
>
> "Fabrizio Napolitano" <fnapo...@insirio.it> wrote in message
> news:ee331dd9.0207...@posting.google.com...
> > But when I try to restore the database, after a while (when the
> > Userspace1 directory reach the size of 1.2GB), the command stop with
> > error SQL2544N saying that the target directory is full! The
> > filesystem has still at least 2GB free.

did you check the entries in db2diag.log ?
it should say more about the problem (especially what is getting full,
i had once the problem that the logfile-dir got full not the SMS-dirs,
took me some time to realize)

joerg

Fabrizio Napolitano

unread,
Jul 4, 2002, 2:29:17 PM7/4/02
to
Hello,

Thank you to everyone who answered.

It was indeed a problem of the instance owner ulimit.

I was a bit to impatient maybe,and I thought that after changing the
ulimit parameters you need only to close the shell and open a new
one...

forgetting about the instance already running with the old settings...
anyway this morning we had to do a reboot and after it everything went
easily!

Thank you again and forgive my impatience!
Fabrizio


"Michael Bhola" <bho...@nospam.uk.ibm.com> wrote in message news:<afvqeh$mbk$1...@sp15at20.hursley.ibm.com>...

0 new messages