Cannot start explain

Posted in 2005

Summary

A user on IDS 9.4 / HP-UX 11i could use "SET EXPLAIN ON" in dbaccess on one server but got "error 1: Not owner EXPLAIN output file" on another, despite seemingly identical installs and permissions. Replies suggested likely causes: the engine having been started as root rather than informix, no write permission on the current working directory where sqexplain.out is created (check the whole directory tree), an existing sqexplain.out owned by another user, and ownership mismatches on raw devices (compare ls -l vs ls -lL). The original poster never replied, so no confirmed resolution is recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Installation, Setup & Upgrades, Server Administration, Versions, Editions & End-of-Life

Anthony — Wed, 29 Jun 2005 15:19:14 — source: IIUG Forums & Mailing Lists

We are running IDS 9.4 on HPUX 11.I on two different boxes. On one box I can run "set explain on" from within dbaccess fine. On the other, I get an error 1: Not owner EXPLAIN output file. I have been comparing the Informix installations on the two systems, and have not yet found a differnece there. File permissions are OK. Has anyone run into this before?

↪ replying to Anthony

Andrus, Gary — Wed, 29 Jun 2005 16:22:24 — source: IIUG Forums & Mailing Lists

I have seen permission/owner issues when linking to a raw device and the owner/group information is not correct at the raw device level. In other words there's a difference in "ls -l" vs. "ls -lL" output. Hope this helps (or at least eliminates another possibility). -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Anthony Sent: Wednesday, June 29, 2005 11:19 AM To: ids@iiug.org Subject: Cannot start explain [5309] We are running IDS 9.4 on HPUX 11.I on two different boxes. On one box I can run "set explain on" from within dbaccess fine. On the other, I get an error 1: Not owner EXPLAIN output file. I have been comparing the Informix installations on the two systems, and have not yet found a differnece there. File permissions are OK. Has anyone run into this before? ----------------------------------------- This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. Thank you. Aetna

↪ replying to Anthony

Darren_Jacobs@carmax.com — Wed, 29 Jun 2005 17:42:43 — source: IIUG Forums & Mailing Lists

Yes, I've seen this when the engine was started as root instead of informix. Thanks "Anthony" <ajudish@lextron- inc.com> To Sent by: ids@iiug.org forum.subscriber@ cc iiug.org Subject Cannot start explain [5309] 06/29/2005 11:19 AM We are running IDS 9.4 on HPUX 11.I on two different boxes. On one box I can run "set explain on" from within dbaccess fine. On the other, I get an error 1: Not owner EXPLAIN output file. I have been comparing the Informix installations on the two systems, and have not yet found a differnece there. File permissions are OK. Has anyone run into this before?

↪ replying to Anthony

Robert Roussey — Wed, 29 Jun 2005 18:28:04 — source: IIUG Forums & Mailing Lists

It may also be a matter of permissions of the current directory for read+write or permissions on the directory tree. Bob Roussey Spirit Airlines Informix/Unix Administration Phone: 586.741.8991 e-mail: RobertRo@SpiritAir.com -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of Anthony Sent: Wednesday, June 29, 2005 11:19 AM To: ids@iiug.org Subject: Cannot start explain [5309] We are running IDS 9.4 on HPUX 11.I on two different boxes. On one box I can run "set explain on" from within dbaccess fine. On the other, I get an error 1: Not owner EXPLAIN output file. I have been comparing the Informix installations on the two systems, and have not yet found a differnece there. File permissions are OK. Has anyone run into this before?

↪ replying to Anthony

Michael Hoffman — Wed, 29 Jun 2005 18:37:06 — source: IIUG Forums & Mailing Lists

> > We are running IDS 9.4 on HPUX 11.I on two different boxes. On one box I > can run "set explain on" from within dbaccess fine. On the other, I get an > error 1: Not owner EXPLAIN output file. > > I have been comparing the Informix installations on the two systems, and > have not yet found a differnece there. File permissions are OK. > > Has anyone run into this before? > "File permissions are OK" for which directories? The sqexplain.out file gets created in the local directory where dbaccess was initiated. If you do not have write premission for that directory, that error will occur. Michael Hoffman

↪ replying to Anthony

Support Informix — Thu, 30 Jun 2005 07:23:39 — source: IIUG Forums & Mailing Lists

Are also the file permissions for the Explain output file and the parent folder the same ? Perhaps created by another user. -----Original Message----- From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org] Sent: 29 June 2005 17:19 To: ids@iiug.org Subject: Cannot start explain [5309] We are running IDS 9.4 on HPUX 11.I on two different boxes. On one box I can run "set explain on" from within dbaccess fine. On the other, I get an error 1: Not owner EXPLAIN output file. I have been comparing the Informix installations on the two systems, and have not yet found a differnece there. File permissions are OK. Has anyone run into this before? ------_=_NextPart_001_01C57D41.44034B60 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: Cannot start explain [5309] </TITLE> </HEAD> <BODY> Are also the file permissions for the Explain output = file and the parent folder the same ? Perhaps created by another user. = -----Original Message----- From: nobody@ace.iiug.org [<A = HREF=3D"mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>] = Sent: 29 June 2005 17:19 To: ids@iiug.org Subject: Cannot start explain [5309] We are running IDS 9.4 on HPUX 11.I on two different = boxes.  On one box I can run "set explain on" from = within dbaccess fine.  On the other, I get an error 1: Not = owner  EXPLAIN output file. I have been comparing the Informix installations on = the two systems, and have not yet found a differnece there.  File = permissions are OK.  Has anyone run into this before? </BODY> </HTML> ------_=_NextPart_001_01C57D41.44034B60--

Cannot start explain

Glossary

Your privacy choices