Unable to get complete export.
A user on IDS 7.31UD9 / AIX 5.2 found that dbexport of one particular database produced an .sql schema file that stopped after the stored procedures, omitting all views; other databases in the same instance exported fine, and restoring a level-0 backup elsewhere gave the same result. Suggestions included checking filesystem space, logs, the 2GB file limit, dbexport.out, oncheck/update statistics, dbschema output and the -ss flag. Gaurav Saxena concluded dbexport had hit an error after 'end procedure' without reporting it (a known class of defects) and advised opening a support case. No fix is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, I am exporting a databae from following environment. informix 7.31UD9 AIX 5.2 The sql file file in the exp directory looks incomplete. It is not having information of complete database and ALL the views are missing. What can be the problem? Nandkishor.
I would check couple of things first: 1. space on filesystem? 2. Online logs 3. 2GB limit 4. Syslogs Cheers. Nandkishor Singare <ns.singare@gmail.com> wrote: Hi, I am exporting a databae from following environment. informix 7.31UD9 AIX 5.2 The sql file file in the exp directory looks incomplete. It is not having information of complete database and ALL the views are missing. What can be the problem? Nandkishor. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Need a vacation? Get great deals to amazing places on Yahoo! Travel.
Hi, File system space and logs show no problem. If I export another database from same instance then I am able to get complete database with all views. Only for this database the export looks incomplete. I am able to import from this exported dump but it is not having the views. Also I tried following - I took complete level 0 backup and restored it on another server. Still if i export the database it is not having the views. Is there anything to do with catalog tables? I tried running update statistics for this database but no help. Regards. On 7/18/07, H.G <hariog@yahoo.com> wrote: > > I would check couple of things first: > 1. space on filesystem? > 2. Online logs > 3. 2GB limit > 4. Syslogs > > Cheers. > Nandkishor Singare <ns.singare@gmail.com> wrote: > Hi, > > I am exporting a databae from following environment. > informix 7.31UD9 > AIX 5.2 > > The sql file file in the exp directory looks incomplete. It is not having > information of complete database and ALL the views are missing. > > What can be the problem? > > Nandkishor. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --------------------------------- > Need a vacation? Get great deals to amazing places on Yahoo! Travel. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
I will do an oncheck and update statistics on the database, ensuring
that it is not already corrupted. What is the output in the log file
(dbexport.out) that you get?
David Reed
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Nandkishor Singare
Sent: 18 July 2007 11:20 AM
To: ids@iiug.org
Subject: Re: Unable to get complete export. [9567]
Hi,
File system space and logs show no problem. If I export another database
from same instance then I am able to get complete database with all
views.
Only for this database the export looks incomplete. I am able to import
from
this exported dump but it is not having the views.
Also I tried following -
I took complete level 0 backup and restored it on another server. Still
if i
export the database it is not having the views.
Is there anything to do with catalog tables? I tried running update
statistics for this database but no help.
Regards.
On 7/18/07, H.G <hariog@yahoo.com> wrote:
>
> I would check couple of things first:
> 1. space on filesystem?
> 2. Online logs
> 3. 2GB limit
> 4. Syslogs
>
> Cheers.
> Nandkishor Singare <ns.singare@gmail.com> wrote:
> Hi,
>
> I am exporting a databae from following environment.
> informix 7.31UD9
> AIX 5.2
>
> The sql file file in the exp directory looks incomplete. It is not
having
> information of complete database and ALL the views are missing.
>
> What can be the problem?
>
> Nandkishor.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---------------------------------
> Need a vacation? Get great deals to amazing places on Yahoo! Travel.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Hello,
Did you use the -ss option of the dbexport command ?
like dbexport carpa1 -ss
"David Reed" <david.reed@tollink.co.za>
Sent by: ids-bounces@iiug.org
18/07/2007 11:28
Please respond to
ids@iiug.org
To
ids@iiug.org
cc
Subject
RE: Unable to get complete export. [9568]
I will do an oncheck and update statistics on the database, ensuring
that it is not already corrupted. What is the output in the log file
(dbexport.out) that you get?
David Reed
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Nandkishor Singare
Sent: 18 July 2007 11:20 AM
To: ids@iiug.org
Subject: Re: Unable to get complete export. [9567]
Hi,
File system space and logs show no problem. If I export another database
from same instance then I am able to get complete database with all
views.
Only for this database the export looks incomplete. I am able to import
from
this exported dump but it is not having the views.
Also I tried following -
I took complete level 0 backup and restored it on another server. Still
if i
export the database it is not having the views.
Is there anything to do with catalog tables? I tried running update
statistics for this database but no help.
Regards.
On 7/18/07, H.G <hariog@yahoo.com> wrote:
>
> I would check couple of things first:
> 1. space on filesystem?
> 2. Online logs
> 3. 2GB limit
> 4. Syslogs
>
> Cheers.
> Nandkishor Singare <ns.singare@gmail.com> wrote:
> Hi,
>
> I am exporting a databae from following environment.
> informix 7.31UD9
> AIX 5.2
>
> The sql file file in the exp directory looks incomplete. It is not
having
> information of complete database and ALL the views are missing.
>
> What can be the problem?
>
> Nandkishor.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> ---------------------------------
> Need a vacation? Get great deals to amazing places on Yahoo! Travel.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
NO...
But the export will have the views without -ss option also. As I got them in
another database without using -ss option.
Regards,
Nandkishor
On 7/18/07, Bernard Caillet <CAILLETB@fr.ibm.com> wrote:
>
> Hello,
>
> Did you use the -ss option of the dbexport command ?
>
> like dbexport carpa1 -ss
>
> "David Reed" <david.reed@tollink.co.za>
> Sent by: ids-bounces@iiug.org
> 18/07/2007 11:28
> Please respond to
> ids@iiug.org
>
> To
> ids@iiug.org
> cc
>
> Subject
> RE: Unable to get complete export. [9568]
>
> I will do an oncheck and update statistics on the database, ensuring
> that it is not already corrupted. What is the output in the log file
> (dbexport.out) that you get?
>
> David Reed
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Nandkishor Singare
> Sent: 18 July 2007 11:20 AM
> To: ids@iiug.org
> Subject: Re: Unable to get complete export. [9567]
>
> Hi,
>
> File system space and logs show no problem. If I export another database
>
> from same instance then I am able to get complete database with all
> views.
>
> Only for this database the export looks incomplete. I am able to import
> from
> this exported dump but it is not having the views.
>
> Also I tried following -
>
> I took complete level 0 backup and restored it on another server. Still
> if i
> export the database it is not having the views.
> Is there anything to do with catalog tables? I tried running update
> statistics for this database but no help.
>
> Regards.
>
> On 7/18/07, H.G <hariog@yahoo.com> wrote:
> >
> > I would check couple of things first:
> > 1. space on filesystem?
> > 2. Online logs
> > 3. 2GB limit
> > 4. Syslogs
> >
> > Cheers.
> > Nandkishor Singare <ns.singare@gmail.com> wrote:
> > Hi,
> >
> > I am exporting a databae from following environment.
> > informix 7.31UD9
> > AIX 5.2
> >
> > The sql file file in the exp directory looks incomplete. It is not
> having
> > information of complete database and ALL the views are missing.
> >
> > What can be the problem?
> >
> > Nandkishor.
> >
> >
> >
> >
> ************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > ---------------------------------
> > Need a vacation? Get great deals to amazing places on Yahoo! Travel.
> >
> >
> >
> >
> ************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Can you do a dbschema successfully?
David Reed
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Nandkishor Singare
Sent: 18 July 2007 11:52 AM
To: ids@iiug.org
Subject: Re: Unable to get complete export. [9572]
NO...
But the export will have the views without -ss option also. As I got
them in
another database without using -ss option.
Regards,
Nandkishor
On 7/18/07, Bernard Caillet <CAILLETB@fr.ibm.com> wrote:
>
> Hello,
>
> Did you use the -ss option of the dbexport command ?
>
> like dbexport carpa1 -ss
>
> "David Reed" <david.reed@tollink.co.za>
> Sent by: ids-bounces@iiug.org
> 18/07/2007 11:28
> Please respond to
> ids@iiug.org
>
> To
> ids@iiug.org
> cc
>
> Subject
> RE: Unable to get complete export. [9568]
>
> I will do an oncheck and update statistics on the database, ensuring
> that it is not already corrupted. What is the output in the log file
> (dbexport.out) that you get?
>
> David Reed
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Nandkishor Singare
> Sent: 18 July 2007 11:20 AM
> To: ids@iiug.org
> Subject: Re: Unable to get complete export. [9567]
>
> Hi,
>
> File system space and logs show no problem. If I export another
database
>
> from same instance then I am able to get complete database with all
> views.
>
> Only for this database the export looks incomplete. I am able to
import
> from
> this exported dump but it is not having the views.
>
> Also I tried following -
>
> I took complete level 0 backup and restored it on another server.
Still
> if i
> export the database it is not having the views.
> Is there anything to do with catalog tables? I tried running update
> statistics for this database but no help.
>
> Regards.
>
> On 7/18/07, H.G <hariog@yahoo.com> wrote:
> >
> > I would check couple of things first:
> > 1. space on filesystem?
> > 2. Online logs
> > 3. 2GB limit
> > 4. Syslogs
> >
> > Cheers.
> > Nandkishor Singare <ns.singare@gmail.com> wrote:
> > Hi,
> >
> > I am exporting a databae from following environment.
> > informix 7.31UD9
> > AIX 5.2
> >
> > The sql file file in the exp directory looks incomplete. It is not
> having
> > information of complete database and ALL the views are missing.
> >
> > What can be the problem?
> >
> > Nandkishor.
> >
> >
> >
> >
>
************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > ---------------------------------
> > Need a vacation? Get great deals to amazing places on Yahoo! Travel.
> >
> >
> >
> >
>
************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
************************************************************************
*******
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Reason for incomplete export file:
Mostly some error occurred during export and dbexport is not very good at
giving meaningful errors. That too in version 7.31.UD9.
Last statement exported in dbexported .sql may give you the clue about the
error encountered. Give last and last but one statement in .sql file to
this forum and preferably the error which you get when dbexport kind of
aborted. It may be as unmeaningful as "memory allocation failed".
Have you tried contacting Support ... looks like a defect to me.
Thanks and Regards,
Gaurav
"Nandkishor
Singare"
<ns.singare@gmail To
.com> ids@iiug.org
Sent by: cc
ids-bounces@iiug.
org Subject
Re: Unable to get complete export.
[9572]
18/07/2007 15:21
Please respond to
ids@iiug.org
NO...
But the export will have the views without -ss option also. As I got them
in
another database without using -ss option.
Regards,
Nandkishor
On 7/18/07, Bernard Caillet <CAILLETB@fr.ibm.com> wrote:
>
> Hello,
>
> Did you use the -ss option of the dbexport command ?
>
> like dbexport carpa1 -ss
>
> "David Reed" <david.reed@tollink.co.za>
> Sent by: ids-bounces@iiug.org
> 18/07/2007 11:28
> Please respond to
> ids@iiug.org
>
> To
> ids@iiug.org
> cc
>
> Subject
> RE: Unable to get complete export. [9568]
>
> I will do an oncheck and update statistics on the database, ensuring
> that it is not already corrupted. What is the output in the log file
> (dbexport.out) that you get?
>
> David Reed
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Nandkishor Singare
> Sent: 18 July 2007 11:20 AM
> To: ids@iiug.org
> Subject: Re: Unable to get complete export. [9567]
>
> Hi,
>
> File system space and logs show no problem. If I export another database
>
> from same instance then I am able to get complete database with all
> views.
>
> Only for this database the export looks incomplete. I am able to import
> from
> this exported dump but it is not having the views.
>
> Also I tried following -
>
> I took complete level 0 backup and restored it on another server. Still
> if i
> export the database it is not having the views.
> Is there anything to do with catalog tables? I tried running update
> statistics for this database but no help.
>
> Regards.
>
> On 7/18/07, H.G <hariog@yahoo.com> wrote:
> >
> > I would check couple of things first:
> > 1. space on filesystem?
> > 2. Online logs
> > 3. 2GB limit
> > 4. Syslogs
> >
> > Cheers.
> > Nandkishor Singare <ns.singare@gmail.com> wrote:
> > Hi,
> >
> > I am exporting a databae from following environment.
> > informix 7.31UD9
> > AIX 5.2
> >
> > The sql file file in the exp directory looks incomplete. It is not
> having
> > information of complete database and ALL the views are missing.
> >
> > What can be the problem?
> >
> > Nandkishor.
> >
> >
> >
> >
> ************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > ---------------------------------
> > Need a vacation? Get great deals to amazing places on Yahoo! Travel.
> >
> >
> >
> >
> ************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Gaurav,
The last thing in exported sql file is a procedure ---
create procedure "xcal".hx270taxid_ssno(p_iface_key INTEGER)
returning char(30)
....
...
RETURN p_string ;
end procedure ;
Actually the exported dump is fine because I can import the database from
this dump... only thing is it is not having the views. There is no issue
with export and import of another database on same instance.
Nandkishor
On 7/18/07, Gaurav Saxena3 <gsaxena3@in.ibm.com> wrote:
>
> Reason for incomplete export file:
> Mostly some error occurred during export and dbexport is not very good at
> giving meaningful errors. That too in version 7.31.UD9.
>
> Last statement exported in dbexported .sql may give you the clue about the
> error encountered. Give last and last but one statement in .sql file to
> this forum and preferably the error which you get when dbexport kind of
> aborted. It may be as unmeaningful as "memory allocation failed".
>
> Have you tried contacting Support ... looks like a defect to me.
>
> Thanks and Regards,
> Gaurav
>
> "Nandkishor
>
> Singare"
>
> <ns.singare@gmail To
>
> ..com> ids@iiug.org
>
> Sent by: cc
>
> ids-bounces@iiug.
>
> org Subject
>
> Re: Unable to get complete export.
>
> [9572]
>
> 18/07/2007 15:21
>
> Please respond to
>
> ids@iiug.org
>
> NO...
>
> But the export will have the views without -ss option also. As I got them
> in
> another database without using -ss option.
>
> Regards,
> Nandkishor
>
> On 7/18/07, Bernard Caillet <CAILLETB@fr.ibm.com> wrote:
> >
> > Hello,
> >
> > Did you use the -ss option of the dbexport command ?
> >
> > like dbexport carpa1 -ss
> >
> > "David Reed" <david.reed@tollink.co.za>
> > Sent by: ids-bounces@iiug.org
> > 18/07/2007 11:28
> > Please respond to
> > ids@iiug.org
> >
> > To
> > ids@iiug.org
> > cc
> >
> > Subject
> > RE: Unable to get complete export. [9568]
> >
> > I will do an oncheck and update statistics on the database, ensuring
> > that it is not already corrupted. What is the output in the log file
> > (dbexport.out) that you get?
> >
> > David Reed
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Nandkishor Singare
> > Sent: 18 July 2007 11:20 AM
> > To: ids@iiug.org
> > Subject: Re: Unable to get complete export. [9567]
> >
> > Hi,
> >
> > File system space and logs show no problem. If I export another database
> >
> > from same instance then I am able to get complete database with all
> > views.
> >
> > Only for this database the export looks incomplete. I am able to import
> > from
> > this exported dump but it is not having the views.
> >
> > Also I tried following -
> >
> > I took complete level 0 backup and restored it on another server. Still
> > if i
> > export the database it is not having the views.
> > Is there anything to do with catalog tables? I tried running update
> > statistics for this database but no help.
> >
> > Regards.
> >
> > On 7/18/07, H.G <hariog@yahoo.com> wrote:
> > >
> > > I would check couple of things first:
> > > 1. space on filesystem?
> > > 2. Online logs
> > > 3. 2GB limit
> > > 4. Syslogs
> > >
> > > Cheers.
> > > Nandkishor Singare <ns.singare@gmail.com> wrote:
> > > Hi,
> > >
> > > I am exporting a databae from following environment.
> > > informix 7.31UD9
> > > AIX 5.2
> > >
> > > The sql file file in the exp directory looks incomplete. It is not
> > having
> > > information of complete database and ALL the views are missing.
> > >
> > > What can be the problem?
> > >
> > > Nandkishor.
> > >
> > >
> > >
> > >
> > ************************************************************************
> > *******
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > > ---------------------------------
> > > Need a vacation? Get great deals to amazing places on Yahoo! Travel.
> > >
> > >
> > >
> > >
> > ************************************************************************
> > *******
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > ************************************************************************
> > *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
>
>
*******************************************************************************
>
> >
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Is the dbschema complete?
David Reed
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Nandkishor Singare
Sent: 18 July 2007 14:25 PM
To: ids@iiug.org
Subject: Re: Unable to get complete export. [9575]
Hi Gaurav,
The last thing in exported sql file is a procedure ---
create procedure "xcal".hx270taxid_ssno(p_iface_key INTEGER)
returning char(30)
.....
....
RETURN p_string ;
end procedure ;
Actually the exported dump is fine because I can import the database
from
this dump... only thing is it is not having the views. There is no issue
with export and import of another database on same instance.
Nandkishor
On 7/18/07, Gaurav Saxena3 <gsaxena3@in.ibm.com> wrote:
>
> Reason for incomplete export file:
> Mostly some error occurred during export and dbexport is not very good
at
> giving meaningful errors. That too in version 7.31.UD9.
>
> Last statement exported in dbexported .sql may give you the clue about
the
> error encountered. Give last and last but one statement in .sql file
to
> this forum and preferably the error which you get when dbexport kind
of
> aborted. It may be as unmeaningful as "memory allocation failed".
>
> Have you tried contacting Support ... looks like a defect to me.
>
> Thanks and Regards,
> Gaurav
>
> "Nandkishor
>
> Singare"
>
> <ns.singare@gmail To
>
> ..com> ids@iiug.org
>
> Sent by: cc
>
> ids-bounces@iiug.
>
> org Subject
>
> Re: Unable to get complete export.
>
> [9572]
>
> 18/07/2007 15:21
>
> Please respond to
>
> ids@iiug.org
>
> NO...
>
> But the export will have the views without -ss option also. As I got
them
> in
> another database without using -ss option.
>
> Regards,
> Nandkishor
>
> On 7/18/07, Bernard Caillet <CAILLETB@fr.ibm.com> wrote:
> >
> > Hello,
> >
> > Did you use the -ss option of the dbexport command ?
> >
> > like dbexport carpa1 -ss
> >
> > "David Reed" <david.reed@tollink.co.za>
> > Sent by: ids-bounces@iiug.org
> > 18/07/2007 11:28
> > Please respond to
> > ids@iiug.org
> >
> > To
> > ids@iiug.org
> > cc
> >
> > Subject
> > RE: Unable to get complete export. [9568]
> >
> > I will do an oncheck and update statistics on the database, ensuring
> > that it is not already corrupted. What is the output in the log file
> > (dbexport.out) that you get?
> >
> > David Reed
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf
Of
> > Nandkishor Singare
> > Sent: 18 July 2007 11:20 AM
> > To: ids@iiug.org
> > Subject: Re: Unable to get complete export. [9567]
> >
> > Hi,
> >
> > File system space and logs show no problem. If I export another
database
> >
> > from same instance then I am able to get complete database with all
> > views.
> >
> > Only for this database the export looks incomplete. I am able to
import
> > from
> > this exported dump but it is not having the views.
> >
> > Also I tried following -
> >
> > I took complete level 0 backup and restored it on another server.
Still
> > if i
> > export the database it is not having the views.
> > Is there anything to do with catalog tables? I tried running update
> > statistics for this database but no help.
> >
> > Regards.
> >
> > On 7/18/07, H.G <hariog@yahoo.com> wrote:
> > >
> > > I would check couple of things first:
> > > 1. space on filesystem?
> > > 2. Online logs
> > > 3. 2GB limit
> > > 4. Syslogs
> > >
> > > Cheers.
> > > Nandkishor Singare <ns.singare@gmail.com> wrote:
> > > Hi,
> > >
> > > I am exporting a databae from following environment.
> > > informix 7.31UD9
> > > AIX 5.2
> > >
> > > The sql file file in the exp directory looks incomplete. It is not
> > having
> > > information of complete database and ALL the views are missing.
> > >
> > > What can be the problem?
> > >
> > > Nandkishor.
> > >
> > >
> > >
> > >
> >
************************************************************************
> > *******
> > > Forum Note: Use "Reply" to post a response in the discussion
forum.
> > >
> > > ---------------------------------
> > > Need a vacation? Get great deals to amazing places on Yahoo!
Travel.
> > >
> > >
> > >
> > >
> >
************************************************************************
> > *******
> > > Forum Note: Use "Reply" to post a response in the discussion
forum.
> > >
> > >
> >
> >
************************************************************************
> > *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
>
>
************************************************************************
*******
>
> >
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
>
>
************************************************************************
*******
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
>
************************************************************************
*******
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
That exactly means that you got some error while dbexporting. And dbexport
was not kind enough to tell you the error. Normal flow would be:
.....
create tables
create procedures after which in normal scenarios following two statements:
revoke usage on language SPL from public ;
grant usage on language SPL to public ;
...
and then create view statements.
....
There were a lot of defects around "end procedure ;" and not reporting the
error but during import. This looks like a new testcase worth reporting to
techsupport and get the fix.
Thanks and Regards,
Gaurav
"Nandkishor
Singare"
<ns.singare@gmail To
.com> ids@iiug.org
Sent by: cc
ids-bounces@iiug.
org Subject
Re: Unable to get complete export.
[9575]
18/07/2007 17:54
Please respond to
ids@iiug.org
Hi Gaurav,
The last thing in exported sql file is a procedure ---
create procedure "xcal".hx270taxid_ssno(p_iface_key INTEGER)
returning char(30)
.....
....
RETURN p_string ;
end procedure ;
Actually the exported dump is fine because I can import the database from
this dump... only thing is it is not having the views. There is no issue
with export and import of another database on same instance.
Nandkishor
On 7/18/07, Gaurav Saxena3 <gsaxena3@in.ibm.com> wrote:
>
> Reason for incomplete export file:
> Mostly some error occurred during export and dbexport is not very good at
> giving meaningful errors. That too in version 7.31.UD9.
>
> Last statement exported in dbexported .sql may give you the clue about
the
> error encountered. Give last and last but one statement in .sql file to
> this forum and preferably the error which you get when dbexport kind of
> aborted. It may be as unmeaningful as "memory allocation failed".
>
> Have you tried contacting Support ... looks like a defect to me.
>
> Thanks and Regards,
> Gaurav
>
> "Nandkishor
>
> Singare"
>
> <ns.singare@gmail To
>
> ..com> ids@iiug.org
>
> Sent by: cc
>
> ids-bounces@iiug.
>
> org Subject
>
> Re: Unable to get complete export.
>
> [9572]
>
> 18/07/2007 15:21
>
> Please respond to
>
> ids@iiug.org
>
> NO...
>
> But the export will have the views without -ss option also. As I got them
> in
> another database without using -ss option.
>
> Regards,
> Nandkishor
>
> On 7/18/07, Bernard Caillet <CAILLETB@fr.ibm.com> wrote:
> >
> > Hello,
> >
> > Did you use the -ss option of the dbexport command ?
> >
> > like dbexport carpa1 -ss
> >
> > "David Reed" <david.reed@tollink.co.za>
> > Sent by: ids-bounces@iiug.org
> > 18/07/2007 11:28
> > Please respond to
> > ids@iiug.org
> >
> > To
> > ids@iiug.org
> > cc
> >
> > Subject
> > RE: Unable to get complete export. [9568]
> >
> > I will do an oncheck and update statistics on the database, ensuring
> > that it is not already corrupted. What is the output in the log file
> > (dbexport.out) that you get?
> >
> > David Reed
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Nandkishor Singare
> > Sent: 18 July 2007 11:20 AM
> > To: ids@iiug.org
> > Subject: Re: Unable to get complete export. [9567]
> >
> > Hi,
> >
> > File system space and logs show no problem. If I export another
database
> >
> > from same instance then I am able to get complete database with all
> > views.
> >
> > Only for this database the export looks incomplete. I am able to import
> > from
> > this exported dump but it is not having the views.
> >
> > Also I tried following -
> >
> > I took complete level 0 backup and restored it on another server. Still
> > if i
> > export the database it is not having the views.
> > Is there anything to do with catalog tables? I tried running update
> > statistics for this database but no help.
> >
> > Regards.
> >
> > On 7/18/07, H.G <hariog@yahoo.com> wrote:
> > >
> > > I would check couple of things first:
> > > 1. space on filesystem?
> > > 2. Online logs
> > > 3. 2GB limit
> > > 4. Syslogs
> > >
> > > Cheers.
> > > Nandkishor Singare <ns.singare@gmail.com> wrote:
> > > Hi,
> > >
> > > I am exporting a databae from following environment.
> > > informix 7.31UD9
> > > AIX 5.2
> > >
> > > The sql file file in the exp directory looks incomplete. It is not
> > having
> > > information of complete database and ALL the views are missing.
> > >
> > > What can be the problem?
> > >
> > > Nandkishor.
> > >
> > >
> > >
> > >
> >
************************************************************************
> > *******
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > > ---------------------------------
> > > Need a vacation? Get great deals to amazing places on Yahoo! Travel.
> > >
> > >
> > >
> > >
> >
************************************************************************
> > *******
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> >
************************************************************************
> > *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
>
>
*******************************************************************************
>
> >
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.