RE: Dbexport failure

Posted in 2004

Savio Pinto (s) — Mon, 10 May 2004 16:01:27 -0500 — source: Usenet: comp.databases.informix

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> </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> </DIV> <BLOCKQUOTE> <DIV class=OutlookMessageHeader dir=ltr align=left>-----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. 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 </BLOCKQUOTE></BODY></HTML> ------_=_NextPart_001_01C436D1.F5E978C0-- sending to informix-list

RE: Dbexport failure

Related threads

Your privacy choices