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

dbimport problem

361 views
Skip to first unread message

John Whelan

unread,
Jan 9, 2002, 1:52:31 PM1/9/02
to
Hi,
I exported a large database using dbexport and I am trying to import it back
into the same
database server using dbimport (after dropping the existing database) and I
keep getting the
following problem:

131 - ISAM error: no free disk space

I've tried increasing my temp dbspace but I still get the same problem.

Any ideas ?

Thanks,
John Whelan

Hal Maner

unread,
Jan 9, 2002, 3:35:11 PM1/9/02
to
Assuming you are running IDS version 7 or greater under a UNIX operating
system, while you are running the dbimport, open up another couple of telnet
sessions and in one, run the onstat -dr command and monitor the free space
in dbspaces, and in the other run the df -k command to see what is happening
with the UNIX filesystems/tmp space. This should show you what is getting
full... Most likely, it is one of the informix dbspaces or the /tmp
filesystem (or its equivalent).

Hal Maner
M Systems International, Inc.
www.msystemsintl.com


"John Whelan" <john....@marconi.com> wrote in message
news:a1i37i$ki2$1...@newsfeed.pit.comms.marconi.com...

Paul Watson

unread,
Jan 9, 2002, 3:43:31 PM1/9/02
to
Are you sure you created the database in the correct dbspace and not
rootdbs by mistake?

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
www.oninit.com #

Sheila Fule-de Leon

unread,
Jan 9, 2002, 4:18:23 PM1/9/02
to

Hi John!

Please post your onstat -d output.

I'd suggest to check the dbspace to which you're trying to import the database
have enough space to store your database.

Did you specify the dbspace when you issued the import command?

John Whelan wrote:

> Hi,
> I exported a large database using dbexport and I am trying to import it back
> into the same
> database server using dbimport (after dropping the existing database) and I
> keep getting the
> following problem:
>
> 131 - ISAM error: no free disk space
>
> I've tried increasing my temp dbspace but I still get the same problem.
>
> Any ideas ?
>
> Thanks,
> John Whelan


"WorldSecure Server <safeway.com>" made the following
annotations on 01/09/02 14:18:23
------------------------------------------------------------------------------
Warning:
All e-mail sent to this address will be received by the Safeway corporate e-mail system, and is subject to archival and review by someone other than the recipient. This e-mail may contain information proprietary to Safeway and is intended only for the use of the intended recipient(s). If the reader of this message is not the intended recipient(s), you are notified that you have received this message in error and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately.

==============================================================================

COOPER, Joseph

unread,
Jan 10, 2002, 6:30:40 AM1/10/02
to

The original database may have been using more than one dataspace.
The dbexport will only include this info if you use the -ss option.

If the database used multiple dataspaces and you didn't use the -ss option
then you need to start hoping that you kept the sql file from the dbexport
in a safe place and that you didn't let this file end up on the tape. If you
did the export to a HDD then you are safe.

In either case you need to be able to hack the sql file and specify where
you want each table to be stored.

Jo

-----Original Message-----
From: John Whelan [mailto:john....@marconi.com]
Sent: 09 January 2002 18:53
To: inform...@iiug.org
Subject: dbimport problem


Hi,
I exported a large database using dbexport and I am trying to import it back
into the same
database server using dbimport (after dropping the existing database) and I
keep getting the
following problem:

131 - ISAM error: no free disk space

I've tried increasing my temp dbspace but I still get the same problem.

Any ideas ?

Thanks,
John Whelan


___________________________________________________________________________
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.
___________________________________________________________________________

John Whelan

unread,
Jan 10, 2002, 7:04:16 AM1/10/02
to
Hi,
After using onstat -d , I figured out that I was increasing the wrong
dbspaces. When I
increased the correct dbspaces, I was able to import successfully.


Many thanks for your help,
John Whelan


John Whelan <john....@marconi.com> wrote in message
news:a1i37i$ki2$1...@newsfeed.pit.comms.marconi.com...

0 new messages