dbimport - memory fault
Eduardo hit 'memory fault - core dump' running dbimport on IDS 7.31 FD4-W6 on HP-UX 11.11 while importing stored procedures. Neil Truby suggested running it in the background; Dragi Raos and Paul Watson suggested editing the stored procedures and grants out of the .sql file and running them later via dbaccess. Eduardo said he needed a permanent fix. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi,
I have a HP-UX 11.11 with informix 7.31 FD4-W6 - 64 bits. When I try
to do a dbimport command "(dbimport <database> -d datadbs1)" I recive
the following error message: "memory fault - core dump". This error
occours when dbimport start to import the Stored Procedures.
Somebody can help me ??
Tks,
Eduardo
Have you tried running it as a background task?
I've had this before when something "odd" about the data cannot be sent to
stdout.
"Eduardo" <cboccio@yahoo.com.br> wrote in message
news:3274f7d5.0312290813.3c2f0cd7@posting.google.com...
> Hi,
>
> I have a HP-UX 11.11 with informix 7.31 FD4-W6 - 64 bits. When I try
> to do a dbimport command "(dbimport <database> -d datadbs1)" I recive
> the following error message: "memory fault - core dump". This error
> occours when dbimport start to import the Stored Procedures.
>
> Somebody can help me ??
>
> Tks,
> Eduardo
As a stopgap measure, edit stored produre definitions and grants out of
database.sql and run that part later manually from dbaccess.
Dragi Raos
"Eduardo" <cboccio@yahoo.com.br> wrote in message
news:3274f7d5.0312290813.3c2f0cd7@posting.google.com...
> Hi,
>
> I have a HP-UX 11.11 with informix 7.31 FD4-W6 - 64 bits. When I try
> to do a dbimport command "(dbimport <database> -d datadbs1)" I recive
> the following error message: "memory fault - core dump". This error
> occours when dbimport start to import the Stored Procedures.
>
> Somebody can help me ??
>
> Tks,
> Eduardo
It doesn't solve the problem but it might be a solution, edit
the sql file then remove everything from the point of failure and import
the database. Then run the 'missing' part via dbaccess
Eduardo wrote:
>
> Hi,
>
> I have a HP-UX 11.11 with informix 7.31 FD4-W6 - 64 bits. When I try
> to do a dbimport command "(dbimport <database> -d datadbs1)" I recive
> the following error message: "memory fault - core dump". This error
> occours when dbimport start to import the Stored Procedures.
>
> Somebody can help me ??
>
> Tks,
> Eduardo
--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #
I have already done what you suggested, but I need a permanent
solution. It's because in each 4 months I have to run this process.
Please, send me as soon as possible this complete solution.
Regards,
Eduardo
"neil truby" <neil.truby@ntlworld.com> wrote in message news:<S4ZHb.12648$FN.3461@newsfep4-winn.server.ntli.net>...
> Have you tried running it as a background task?
> I've had this before when something "odd" about the data cannot be sent to
> stdout.
>
> "Eduardo" <cboccio@yahoo.com.br> wrote in message
> news:3274f7d5.0312290813.3c2f0cd7@posting.google.com...
> > Hi,
> >
> > I have a HP-UX 11.11 with informix 7.31 FD4-W6 - 64 bits. When I try
> > to do a dbimport command "(dbimport <database> -d datadbs1)" I recive
> > the following error message: "memory fault - core dump". This error
> > occours when dbimport start to import the Stored Procedures.
> >
> > Somebody can help me ??
> >
> > Tks,
> > Eduardo