IDS Forum

Re: Informix 11 to 12 Upgrade ... "error"

Posted By: Art Kagel
Date: Friday, 5 September 2014, at 9:51 a.m.

In Response To: RE: Informix 11 to 12 Upgrade ... "error" (Dirk Moolman [ MTN - Commerce Square ])

Hmm, the documentation doesn't say what the default is if you do not have
it set in the ONCONFIG. Dirk: What is show for the effective value for
that in sysmaster:sysconfig?

Art

Art S. Kagel, Principal Consultant
ASK Database Management

Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.

On Fri, Sep 5, 2014 at 9:36 AM, Dirk Moolma.... <Dirk.Moolman@mtn.co.za>
wrote:

> Ok, interesting.
>
> In version 11 it is in the ONCONFIG:
>
> TEMPTAB_NOLOG 0
>
> But in version 12, the new version, it is hashed out completely
>
> #TEMPTAB_NOLOG 0
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Art Kagel
> > Sent: Friday, 05 September 2014 03:25 PM
> > To: ids@iiug.org
> > Subject: Re: Informix 11 to 12 Upgrade ... "error" [33684]
> >
> > Dirk:
> >
> > This is definitely a "it's supposed to work that way." But there may be
> > a contributing item. Do you have TEMPTAB_NOLOG set in both versions'
> > ONCONFIG or only in the v12 ONCONFIG?
> >
> > Guessing here: If TEMPTAB_NOLOG is set then all temp tables are non-
> > logging unless they are placed, without the WITH NO LOG clause, in a
> > logged temp table. Without TEMPTAB_NOLOG set the engine probably
> > creates the temp table in the logged dbspace but makes it a logged temp
> > table despite the WITH NO LOG clause. With that clause set it is
> > rejecting the request.
> > That might be a change in behavior between 11.70 and 12.10. Dunno.
> >
> > Art
> >
> > Art S. Kagel, Principal Consultant
> > ASK Database Management
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own
> > opinions and do not reflect on the IIUG, nor any other organization
> > with which I am associated either explicitly, implicitly, or by
> > inference. Neither do those opinions reflect those of other individuals
> > affiliated with any entity with which I am affiliated nor those of the
> > entities themselves.
> >
> > On Fri, Sep 5, 2014 at 9:07 AM, Dirk Moolma....
> > <Dirk.Moolman@mtn.co.za>
> > wrote:
> >
> > > 2 Versions:
> > >
> > > From: Version 11.70.FC8
> > > To: Version 12.10.FC4
> > >
> > > AIX 6
> > >
> > > Ok, here goes. Please note that I place "error" in quotes, because I
> > > do not believe this is an error. I just want to confirm my theory.
> > >
> > > We did a test upgrade from version 11 to version 12, and the
> > following
> > > statement failed on version 12 (where it was working previously on
> > > version
> > > 11)
> > >
> > > CREATE TEMP TABLE tmp_temptable
> > >
> > > (
> > >
> > > psh_id INTEGER,
> > >
> > > psh_service_code CHAR(4),
> > >
> > > psh_msisdn_no CHAR(15),
> > >
> > > psh_subscriber_id INTEGER,
> > >
> > > psd_param_id INTEGER,
> > >
> > > psd_param_value CHAR(20)
> > >
> > > ) WITH NO LOG IN inhousedbs
> > >
> > > SQL statement error number -229.
> > > Could not open or create a temporary file.
> > > SYSTEM error number -130.
> > > ISAM error: no such DBspace
> > >
> > > Also note that "inhousedbs" is not a TEMP space (DBSPACETEMP), but an
> > > actual dbspace. I believe that the previous version of Informix was
> > > less strict, and still allowed this syntax, but that version 12
> > > tightened the rules, and now forces all TEMP tables to go to actually
> > > TEMP dbspaces.
> > >
> > > So I do not believe this to be an error, but the way Informix is
> > > actually supposed to work.
> > >
> > > Can someone confirm this please ?
> > >
> > > Regards
> > > Dirk
> > >
> > > ________________________________
> > >
> > > NOTE: This e-mail message is subject to the MTN Group disclaimer see
> > > https://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
> > >
> > >
> > >
> > >
> > ***********************************************************************
> > ********
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c3bd50dbc0c4050251659a
> >
> >
> > ***********************************************************************
> > ********
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> ________________________________
>
> NOTE: This e-mail message is subject to the MTN Group disclaimer see
> https://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--089e0158ad540b3d66050251c071

Messages In This Thread

• Informix 11 to 12 Upgrade ... "error"
  Dirk Moolman [ MTN - Commerce Square ] -- Friday, 5 September 2014, at 9:07 a.m.
  • Re: Informix 11 to 12 Upgrade ... "error"
    Art Kagel -- Friday, 5 September 2014, at 9:25 a.m.
    • RE: Informix 11 to 12 Upgrade ... "error"
      Dirk Moolman [ MTN - Commerce Square ] -- Friday, 5 September 2014, at 9:36 a.m.
      • RE: Informix 11 to 12 Upgrade ... "error"
        Dirk Moolman [ MTN - Commerce Square ] -- Friday, 5 September 2014, at 9:45 a.m.
        • Re: Informix 11 to 12 Upgrade ... "error"
          Fernando Nunes -- Friday, 5 September 2014, at 9:50 a.m.
        • Re: Informix 11 to 12 Upgrade ... "error"
          Art Kagel -- Friday, 5 September 2014, at 9:52 a.m.
      • Re: Informix 11 to 12 Upgrade ... "error"
        Art Kagel -- Friday, 5 September 2014, at 9:51 a.m.
        • RE: Informix 11 to 12 Upgrade ... "error"
          Dirk Moolman [ MTN - Commerce Square ] -- Friday, 5 September 2014, at 9:56 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.