IDS Forum

Re: Shifting the Logical Logs

Posted By: Art Kagel
Date: Wednesday, 10 August 2011, at 9:47 a.m.

In Response To: Re: Shifting the Logical Logs (Henri MOUKOURI)

Yes, sorry, the API functions have to be run out of sysadmin not sysmaster.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, 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 Wed, Aug 10, 2011 at 3:03 AM, Henri MOUKOURI <h.moukouri@moukouri.net>wrote:

> Hi Art,
>
> May be dbaccess sysadmin ... ?
>
> On 8/9/2011 22:14, Art Kagel wrote:
> > Moving the physical log is trivial. Just run:
> >
> > onparams -p -s<newdbspace> -s<newsize>
> >
> > The logical logs are a little more involved, however, since you are using
> > 11.50, you can use the new dbschema -c feature.
> > dbschema -c -q>infrastructure_script.sql - generates an SQL script that
> > uses the SQL API that you can use to recreate your servers disk
> structures
> > (dbspaces, chunks, logical and physical logs).
> > dbschema -c -q -ns>infrastructure_script.sh - generates a shell script to
> > do the same thing using onspaces and onparams commands.
> >
> > Once you have to script you want, edit it to extract just the section for
> > the logical log processing (everything from after the physical log to the
> > end of the file) and edit it to change the dbspace references in the 'add
> > log' API commands or the onparams -a commandlines. Then just execute the
> > modified infrastructure_script.sh shell script or run dbaccess sysmaster
> -<
> > infrastructure_script.sql
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> > do not reflect on my employer, Advanced DataTools, 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 Tue, Aug 9, 2011 at 4:47 PM, RAY BURNS
> > <ray.burns@velocityglobal.co.nz>wrote:
> >
> >> I am using 11.5. I need to shift the logical and physical logs from one
> >> dbspace to another. (I am moving them to new physical disks). Can anyone
> >> give
> >> me any pointers as to how to go about this, especially any gotcha's that
> I
> >> need to be careful of?
> >>
> >> Many thanks
> >>
> >>
> >>
> >>
> >
>
> *******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> > --20cf3071c6ee1e77d804aa190bf9
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--20cf3079bbf8977f4904aa26ea44

Messages In This Thread

• Shifting the Logical Logs
  RAY BURNS -- Tuesday, 9 August 2011, at 4:47 p.m.
  • Re: Shifting the Logical Logs
    Art Kagel -- Tuesday, 9 August 2011, at 5:14 p.m.
    • Re: Shifting the Logical Logs
      Henri MOUKOURI -- Wednesday, 10 August 2011, at 3:03 a.m.
      • Re: Shifting the Logical Logs
        Art Kagel -- Wednesday, 10 August 2011, at 9:47 a.m.
        • Re: Shifting the Logical Logs
          RAY BURNS -- Wednesday, 10 August 2011, at 3:53 p.m.
          • Re: Shifting the Logical Logs
            Art Kagel -- Wednesday, 10 August 2011, at 4:56 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.