RE: dbexport and dbimport problem .... help
Is it possible that you are running out of space on the tape? I don't know
if dbexport prompts for a second tape.
You could try to use the -f switch to write the SQL schema file to disk,
then you should be able to look at this file to see where it is cutting off.
Jamie A. Kohm
PeopleSoft Team/Corporate Database Team
MS CIS, MCSE, MCP+I, ICP, HP-UX CSA, CCNA
National Linen Service
1420 Peachtree St., NE
Atlanta, GA 30309
Voice: (404) 853-6234
Fax: (404) 853-6485
Email: mailto:jkohm@trusted.net
> -----Original Message-----
> From: Ameerul@mesiniaga.com.my [SMTP:Ameerul@mesiniaga.com.my]
> Sent: Wednesday, October 27, 1999 4:56 AM
> To: informix-list@iiug.org
> Cc: h.leininger@bull.at
> Subject: Re: dbexport and dbimport problem .... help
>
>
> Yes, it was done using a DBA privilege id. Some how the dbexport done was
> not complete. No error
> messages were returned. Unless the dbexport was done to the hard disk, we
> could see the dbexport.out
> file but now it is done to a tape device. We could not dbexport to hard
> disk since don't have
> enough disk space to do so.
>
> If the dbexport completed successfully, there should be a message
> "dbexport completed" at the end of
> the dbexport process but in this case it stop somewhere during unload of
> one of the tables and then
> the UNIX prompt came out with no indication of error.
>
> Thank you for the first feedback. Please continue on helping me in this
> case.
>
> regards.
>
>
>
>
>
>
> Helmut Leininger <h.leininger@bull.at>@iiug.org on 27/10/99 02:30:56 PM
>
> Please respond to h.leininger@bull.at
>
> Sent by: owner-informix-list@iiug.org
>
>
> To: informix-list@iiug.org
> cc:
> Subject: Re: dbexport and dbimport problem .... help
>
>
> Ameerul@mesiniaga.com.my wrote:
>
> > I'm using Informix Online on AIX. Have problem with dbexport to a 4mm
> tape (2Gb) and then dbimport
> > back. Done dbexport with stated command :
> > dbexport dbname -t /dev/rmt0 -b 16 -s 2048000
> >
> > When dbimport, it is not complete.
> >
> > dbimport dbname -t /dev/rmt0 -b 16 -s 2048000
> >
> > But some tables are missing. Thank God I have a backup.
> >
> > Tried again dbexport and dbimport, still same problem. Could anyone help
> me?
>
> Hi,
>
> I assume you ran the job with DBA privileges. Are there any massages in
> the logfiles of dbexport /
> dbimport that indicate a problem?
>
>
> Regards
> --
> Helmut Leininger
>
> Bull AG / Vienna
> Open Systems Support
>
> Email: h.leininger@bull.at
> helmut.leininger@bull.net
>
> This opinion is mine and not necessarily that of my employer.
> No guarantees whatsoever.
>
>
>
>