Re: Dbexport failure

Posted in 2004

Ferronato — 13 May 2004 12:04:20 -0700 — source: Usenet: comp.databases.informix

Hi all, TO Savio Pinto: voce fala portugues ?? Well, I use RS/6000 boxes with AIX 4.3.3 and AIX 5.2 and I had the same problem some months ago and I discovered a bug (reported to IBM Informix support group) and they repaired it, in recently versions of IDS 7.31. I now using 7.31.UD6X5 (a special patch for us, ~cause they solved other problem - bug - with GateWay - DRDA ). The problem was when dbschema - it runs under dbexport tool - find a table that has the data dbspace separated of index dbspaces. I mean: create table1 (col1 <datatype>, col2 <datatype>, col....) in dbspace1 extent .... next .... lock mode .... ; create index ix1tab1 on table1 (col1, col2) in dbspace_ix ;In the newest version of IDS 7.31.UD6W8 or later as 7.31.UD7 , the problem is solved. Have you possibility to update uour RDBMS ? I hope it helps you ! BR . R. Ferronato "Savio Pinto (s)" <spinto@cap.org> wrote in message news:<c7or5u$u0a$1@terabinaries.xmission.com>... > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > ------_=_NextPart_001_01C436D1.F5E978C0 > Content-Type: text/plain; > charset="iso-8859-1" > > were there any changes to the environment variables?, make sure FET_BUF_SIZE > or BIG_FET_BUF_SIZE environment variables are not set when you do a > dbexport. > > i used to get some errors with dbexport on HP UX and informix 9.3, it turned > out that dbexport utility was sensitive to the above env variables, had to > unset these environment variables before doing a dbexport of the database. > > > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On > Behalf Of CKGeier@nwc.edu > Sent: Monday, May 10, 2004 2:14 PM > To: informix-list@iiug.org > Subject: Dbexport failure > > > > I tried to dbexport the database (has always run successfully in the past > )and received an error message. > While looking through the dbexport.out and db.sql output files I saw the > following information. I also saw that the dbexport.out text stopped where > the next statement outputted to the dbexport.out/db.sql files would have > been a "create index" line, and the previous line it seemed possibly to > succeed at was a "revoke all on tablename from public" statement. > Aix 5.1 > Informix IDS 7.31 UD6 > ____________________________________________________________________________ > _ > *** Error fetching data row > > 408 - Invalid message type received from the sqlexec process. > > -404 - The cursor or statement is not available. > -349 - Database not selected yet. > ____________________________________________________________________________ > __ > It appears as if the process lost connection to the db or died...? and while > we suspect memory issues, I had just rebooted the server and it appeared as > if we had enough memory. > > C Geier > System Admin/IS support > St. Paul, MN > > > > > > ------_=_NextPart_001_01C436D1.F5E978C0 > Content-Type: text/html; > charset="iso-8859-1" > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> > > > <META content="MSHTML 5.50.4731.2200" name=GENERATOR></HEAD> > <BODY> > <DIV>were > there any changes to the environment variables?, make sure FET_BUF_SIZE or > BIG_FET_BUF_SIZE  environment variables are not set when you do a > dbexport.</DIV> > <DIV> size=2> </DIV> > <DIV>i used > to get some errors with dbexport on HP UX and informix 9.3, it turned out that > dbexport utility was sensitive to the above env variables,  had to unset > these environment variables before doing a dbexport of the > database.</DIV> > <DIV> size=2> </DIV> > <BLOCKQUOTE> > <DIV class=OutlookMessageHeader dir=ltr align=left> size=2>-----Original Message----- From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of > CKGeier@nwc.edu Sent: Monday, May 10, 2004 2:14 PM To: > informix-list@iiug.org Subject: Dbexport > failure </DIV> I tried to > dbexport the database (has always run successfully in the past )and received > an error message. size=2> While looking through the dbexport.out and db.sql output files I > saw the following information. I also saw that the dbexport.out text stopped > where the next statement outputted to the dbexport.out/db.sql files would have > been a "create index" line, and the previous line it seemed possibly to > succeed at was a "revoke all on tablename from public" statement. Aix > 5.1 Informix IDS > 7.31 UD6 size=2> _____________________________________________________________________________ size=3> *** Error fetching data > row 408 - > Invalid message type received from the sqlexec process. > -404 - The cursor or statement is > not available. size=2> -349 - Database not selected yet. face=sans-serif > size=2> ______________________________________________________________________________ size=3> It appears as if the process > lost connection to the db or died...? and while we suspect memory issues, I > had just rebooted the server and it appeared as if we had enough > memory. C > Geier System Admin/IS support St. Paul, > MN </BLOCKQUOTE></BODY></HTML> > > ------_=_NextPart_001_01C436D1.F5E978C0-- > sending to informix-list

Re: Dbexport failure

Related threads

Your privacy choices