dbexport with multiple users
In recent versions of IDS It is possible to run a dbexport with multiple
user on-line?
I know it is not possible in previous versions because dbexport put an
exclusive lock on the database and I understand that: because of
consistency.
However I don't know if 11.10 or 11.5 address this like ontape/onbar does
where you can do a consistent archive no matter if there are multiple users.
Thanks in advance.
J.
No, you still cannot do that. If you need to take an export of an entire
database while users are online, get my dbexport/dbimport replacement
utilities, myexport/myimport in the package 'myexport' from the IIUG
Software Repository (www.iiug.org/software). You will also need the
following other utilities: sqlunload & sqlreload from Jonathan Leffler's
sqlcmd package, myonpload package by Ravi Krishna, and myschema from my
package utils2_ak.
Myexport and myimport are fully compatible with dbexport and dbimport but do
not lock the database. In addition, they provide useful options like
parallel unloading of tables to minimize the possibility of inconsistent
data due to partially updated records created during the export, a myimport
feature to filter out such inconsistent data, the ability to optionally use
the High Performance Loader to perform the actual data movement which tends
to be faster than dbexport/dbimport, and others.
On Tue, May 27, 2008 at 12:05 PM, Jean Sagi <jeansagi.ifx@gmail.com> wrote:
> In recent versions of IDS It is possible to run a dbexport with multiple
> user on-line?
>
> I know it is not possible in previous versions because dbexport put an
> exclusive lock on the database and I understand that: because of
> consistency.
>
> However I don't know if 11.10 or 11.5 address this like ontape/onbar does
> where you can do a consistent archive no matter if there are multiple
> users.
>
> Thanks in advance.
>
> J.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitely or implicitely. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
Thank you very much ! (What else can I say ;) )
J.
2008/5/27 Art Kagel <art.kagel@gmail.com>:
> No, you still cannot do that. If you need to take an export of an entire
> database while users are online, get my dbexport/dbimport replacement
> utilities, myexport/myimport in the package 'myexport' from the IIUG
> Software Repository (www.iiug.org/software). You will also need the
> following other utilities: sqlunload & sqlreload from Jonathan Leffler's
> sqlcmd package, myonpload package by Ravi Krishna, and myschema from my
> package utils2_ak.
>
> Myexport and myimport are fully compatible with dbexport and dbimport but
> do
> not lock the database. In addition, they provide useful options like
> parallel unloading of tables to minimize the possibility of inconsistent
> data due to partially updated records created during the export, a myimport
> feature to filter out such inconsistent data, the ability to optionally use
> the High Performance Loader to perform the actual data movement which tends
> to be faster than dbexport/dbimport, and others.
>
> On Tue, May 27, 2008 at 12:05 PM, Jean Sagi <jeansagi.ifx@gmail.com>
> wrote:
>
> > In recent versions of IDS It is possible to run a dbexport with multiple
> > user on-line?
> >
> > I know it is not possible in previous versions because dbexport put an
> > exclusive lock on the database and I understand that: because of
> > consistency.
> >
> > However I don't know if 11.10 or 11.5 address this like ontape/onbar does
> > where you can do a consistent archive no matter if there are multiple
> > users.
> >
> > Thanks in advance.
> >
> > J.
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitely or implicitely. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity
> with which I am affiliated nor those of the entities themselves.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>