Ebexport

Does dbexport lock the database while running? Larry

Yep -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Tuesday, August 09, 2016 11:33 AM To: ids@iiug.org Subject: Ebexport [37554] Does dbexport lock the database while running? Larry **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Yes, dbexport does lock the database in exclusive mode. This helps ensure data consistency/integrity and that you won't run into problems when building foreign keys when importing your database later on. You can look into Art's myexport/myimport utilities which do not lock the database. Mike Walker Advanced DataTools Corporation -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Tuesday, August 09, 2016 10:33 AM To: ids@iiug.org Subject: Ebexport [37554] Does dbexport lock the database while running? Larry **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

If you have an older version ( one was 11.10 AFAIK) you can run dbexport on a secondary - was extremely useful -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Mike Walker Sent: Tuesday, August 09, 2016 11:46 AM To: ids@iiug.org Subject: RE: Ebexport [37556] Yes, dbexport does lock the database in exclusive mode. This helps ensure data consistency/integrity and that you won't run into problems when building foreign keys when importing your database later on. You can look into Art's myexport/myimport utilities which do not lock the database. Mike Walker Advanced DataTools Corporation -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Tuesday, August 09, 2016 10:33 AM To: ids@iiug.org Subject: Ebexport [37554] Does dbexport lock the database while running? Larry **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

I would say yes, as it also needs exclusive access, in order to run a dbexp= ort. Otherwise you receive a -107, if you have other shared connections to= the database. Thanks, ***************************************************************************= *************** Ernie Knox Sr. Technologist, Member Technology - Database Management Sears Holdings Management Corp 3333 Beverly Rd. Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Cell: (847) 665-0722 Corp. Cell: 224-465-0553=A0 Corp. Text: 2244650553@txt.att.net Informix Email: ifmxdba@searshc.com and Team: InformixDBA@searshc.com Informix Primary: INFORMIXDBAPrimaryPager@searshc.com Informix Secondary: INFORMIXDBASecondaryPager@searshc.com MySQL Email: MYSQLDBAe@searshc.com and Team: MySQLDBA2@searshc.com MySQL Primary: MYSQLDBAPrimaryPager@searshc.com MySQL Secondary: MYSQLDBASecondaryPager@searshc.com For more information, view our DBA Wiki page link below: http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Managemen= t#DatabaseManagement For creating ServiceNow request, use the link below: https://sears.service-now.com Have I provided a WOW member experience today? Send a Members' First Recognition to this Associate Nominate this Associate for a Technology Excellence Award My Area: " Yes we can make a Change! " " IF you can think it, you can do it! " " Sometimes to secure the future, you have to let go of the past! " " IT'S always a great day to watch=A0Sports: FOOTBALL " GSU MISSION: " The focus of my life begins at home with family, loved ones, and friends.= =A0 I want to use my resources to create a secure environment that fosters love, learning, laughter, and mutual succes= s.=A0 I will protect and value integrity.=A0 I will admit and quickly correct my mistakes.=A0 I will be a self-starter.=A0= I will be a caring person.=A0 I will be a good listener with an open mind.=A0 I will continue to grow and learn.=A0 I will facilita= te and celebrate the success of others. " ***************************************************************************= *************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY= SORENSEN Sent: Tuesday, August 09, 2016 11:33 AM To: ids@iiug.org Subject: Ebexport [37554] Does dbexport lock the database while running?=20 Larry=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20 This message, including any attachments, is the property of Sears Holdings = Corporation and/or one of its subsidiaries. It is confidential and may cont= ain proprietary or legally privileged information. If you are not the inten= ded recipient, please delete it without reading the contents. Thank you.

Yes. You can use my dbexport replacement utility, myexport, to get better speed and functionality without the lock. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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, 2016 at 12:33 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote: > Does dbexport lock the database while running? > > Larry > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1144c0d60e22620539a69f90

Thank you all for your responses. Do you have a link to the programs myexport, myimport and dbcopy as well as some instructions on how to set them up and compile them (and what, if anything special, is needed to install before compiling them)? Larry ________________________________ From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Paul Watson <paul@oninit.com> Sent: Tuesday, August 9, 2016 10:53 AM To: ids@iiug.org Subject: RE: Ebexport [37557] If you have an older version ( one was 11.10 AFAIK) you can run dbexport on a secondary - was extremely useful -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Mike Walker Sent: Tuesday, August 09, 2016 11:46 AM To: ids@iiug.org Subject: RE: Ebexport [37556] Yes, dbexport does lock the database in exclusive mode. This helps ensure data consistency/integrity and that you won't run into problems when building foreign keys when importing your database later on. You can look into Art's myexport/myimport utilities which do not lock the database. Mike Walker Advanced DataTools Corporation -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Tuesday, August 09, 2016 10:33 AM To: ids@iiug.org Subject: Ebexport [37554] Does dbexport lock the database while running? Larry **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Larry: You can download myexport from the IIUG Software Repository ( www.iiug.org/software). It is a set of scripts (there is one executable C utility in the package that is only needed if you want to use the parallel load/unload options). You will also need my utils2_ak package. The latest version of that can be downloaded from my web site ( www.askdbmgt.com/my-utilities.html) there is a build instruction document included, but it builds just by unpacking the shell archive and running make on linux (and usually Solaris as well). If you use external table exports and imports (the -E option) that's all you need. To use the default export/import, which is the slowest option, you'll also need Jonathan Leffler's sqlcmd package the latest of which is in the IIUG Repository as well. To use the HP Loader options you'll need the myonpload utility from the IIUG Repository. Note that the external table option is the fastest unload/load so you can ignore the HP Loader options. Dbcopy is included in the utils2_ak package, so you'll be good once you built that. Note that due to a looong standing bug in the ESQL/C libraries you can't use dbcopy on tables with LVARCHAR columns and it doesn't work correctly on tables with more than one dumb blob type column. For those cases you can use the dbmove utility (also in the package). If you have any trouble building or using these, let me know. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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, 2016 at 1:33 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote: > Thank you all for your responses. > > Do you have a link to the programs myexport, myimport and dbcopy as well as > some instructions on how to set them up and compile them (and what, if > anything special, is needed to install before compiling them)? > > Larry > > ________________________________ > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Paul Watson > <paul@oninit.com> > Sent: Tuesday, August 9, 2016 10:53 AM > To: ids@iiug.org > Subject: RE: Ebexport [37557] > > If you have an older version ( one was 11.10 AFAIK) you can run dbexport on > a secondary - was extremely useful > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Mike > Walker > Sent: Tuesday, August 09, 2016 11:46 AM > To: ids@iiug.org > Subject: RE: Ebexport [37556] > > Yes, dbexport does lock the database in exclusive mode. This helps ensure > data consistency/integrity and that you won't run into problems when > building foreign keys when importing your database later on. > > You can look into Art's myexport/myimport utilities which do not lock the > database. > > Mike Walker > Advanced DataTools Corporation > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LARRY > SORENSEN > Sent: Tuesday, August 09, 2016 10:33 AM > To: ids@iiug.org > Subject: Ebexport [37554] > > Does dbexport lock the database while running? > > Larry > > ************************************************************ > **************** > > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > ************************************************************ > **************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1143f0a6907d740539a966e2

Thank you. I will give it a try. Larry ________________________________ From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel <art.kagel@gmail.com> Sent: Tuesday, August 9, 2016 2:30 PM To: ids@iiug.org Subject: Re: Ebexport [37562] Larry: You can download myexport from the IIUG Software Repository ( www.iiug.org/software<http://www.iiug.org/software>). It is a set of scripts (there is one executable C International Informix Users Group<http://www.iiug.org/software>; www.iiug.org About the Software Repository. These pages allow you to access the IIUG Software Repository and other Informix-related archives on the Net. Quick Links: utility in the package that is only needed if you want to use the parallel load/unload options). You will also need my utils2_ak package. The latest version of that can be downloaded from my web site ( www.askdbmgt.com/my-utilities.html<http://www.askdbmgt.com/my-utilities.html>) there is a build instruction document included, but it builds just by unpacking the shell archive and running make on linux (and usually Solaris as well). If you use external table exports and imports (the -E option) that's all you need. To use the default export/import, which is the slowest option, you'll also need Jonathan Leffler's sqlcmd package the latest of which is in the IIUG Repository as well. To use the HP Loader options you'll need the myonpload utility from the IIUG Repository. Note that the external table option is the fastest unload/load so you can ignore the HP Loader options. Dbcopy is included in the utils2_ak package, so you'll be good once you built that. Note that due to a looong standing bug in the ESQL/C libraries you can't use dbcopy on tables with LVARCHAR columns and it doesn't work correctly on tables with more than one dumb blob type column. For those cases you can use the dbmove utility (also in the package). If you have any trouble building or using these, let me know. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com<http://www.askdbmgt.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 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, 2016 at 1:33 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote: > Thank you all for your responses. > > Do you have a link to the programs myexport, myimport and dbcopy as well as > some instructions on how to set them up and compile them (and what, if > anything special, is needed to install before compiling them)? > > Larry > > ________________________________ > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Paul Watson > <paul@oninit.com> > Sent: Tuesday, August 9, 2016 10:53 AM > To: ids@iiug.org > Subject: RE: Ebexport [37557] > > If you have an older version ( one was 11.10 AFAIK) you can run dbexport on > a secondary - was extremely useful > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Mike > Walker > Sent: Tuesday, August 09, 2016 11:46 AM > To: ids@iiug.org > Subject: RE: Ebexport [37556] > > Yes, dbexport does lock the database in exclusive mode. This helps ensure > data consistency/integrity and that you won't run into problems when > building foreign keys when importing your database later on. > > You can look into Art's myexport/myimport utilities which do not lock the > database. > > Mike Walker > Advanced DataTools Corporation > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LARRY > SORENSEN > Sent: Tuesday, August 09, 2016 10:33 AM > To: ids@iiug.org > Subject: Ebexport [37554] > > Does dbexport lock the database while running? > > Larry > > ************************************************************ > **************** > > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > ************************************************************ > **************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1143f0a6907d740539a966e2 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

I was just re-reading the email chain below, and I wanted to get clarification on something. I saw Paul, below, say that you can run a dbexport from a secondary server without breaking replication? Is this true. It would save me a lot of problems. Larry ________________________________ From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel <art.kagel@gmail.com> Sent: Tuesday, August 9, 2016 2:30 PM To: ids@iiug.org Subject: Re: Ebexport [37562] Larry: You can download myexport from the IIUG Software Repository ( www.iiug.org/software<http://www.iiug.org/software>). It is a set of scripts (there is one executable C International Informix Users Group<http://www.iiug.org/software>; www.iiug.org About the Software Repository. These pages allow you to access the IIUG Software Repository and other Informix-related archives on the Net. Quick Links: utility in the package that is only needed if you want to use the parallel load/unload options). You will also need my utils2_ak package. The latest version of that can be downloaded from my web site ( www.askdbmgt.com/my-utilities.html<http://www.askdbmgt.com/my-utilities.html>) there is a build instruction document My Utilities - ASK Database Management<http://www.askdbmgt.com/my-utilities.html>; www.askdbmgt.com Utils2_ak is my primary package of utilities. This is the July 28, 2016 release. Included: dbping.ec - Tests connections and reports connection time as well as ... included, but it builds just by unpacking the shell archive and running make on linux (and usually Solaris as well). If you use external table exports and imports (the -E option) that's all you need. To use the default export/import, which is the slowest option, you'll also need Jonathan Leffler's sqlcmd package the latest of which is in the IIUG Repository as well. To use the HP Loader options you'll need the myonpload utility from the IIUG Repository. Note that the external table option is the fastest unload/load so you can ignore the HP Loader options. Dbcopy is included in the utils2_ak package, so you'll be good once you built that. Note that due to a looong standing bug in the ESQL/C libraries you can't use dbcopy on tables with LVARCHAR columns and it doesn't work correctly on tables with more than one dumb blob type column. For those cases you can use the dbmove utility (also in the package). If you have any trouble building or using these, let me know. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com<http://www.askdbmgt.com>; ASK Database Management - Home<http://www.askdbmgt.com/>; www.askdbmgt.com This is the site for Art S. Kagel's consultancy. The soaring majesty and beauty in the image above hides the complex ecology and detail of its existence. Blog: http://informix-myview.blogspot.com/ Informix - My view<http://informix-myview.blogspot.com/>; informix-myview.blogspot.com A place to share my views and ideas which may be of interest to the Informix user Community. 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 Tue, Aug 9, 2016 at 1:33 PM, LARRY SORENSEN <LSORENSEN25@msn.com> wrote: > Thank you all for your responses. > > Do you have a link to the programs myexport, myimport and dbcopy as well as > some instructions on how to set them up and compile them (and what, if > anything special, is needed to install before compiling them)? > > Larry > > ________________________________ > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Paul Watson > <paul@oninit.com> > Sent: Tuesday, August 9, 2016 10:53 AM > To: ids@iiug.org > Subject: RE: Ebexport [37557] > > If you have an older version ( one was 11.10 AFAIK) you can run dbexport on > a secondary - was extremely useful > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Mike > Walker > Sent: Tuesday, August 09, 2016 11:46 AM > To: ids@iiug.org > Subject: RE: Ebexport [37556] > > Yes, dbexport does lock the database in exclusive mode. This helps ensure > data consistency/integrity and that you won't run into problems when > building foreign keys when importing your database later on. > > You can look into Art's myexport/myimport utilities which do not lock the > database. > > Mike Walker > Advanced DataTools Corporation > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LARRY > SORENSEN > Sent: Tuesday, August 09, 2016 10:33 AM > To: ids@iiug.org > Subject: Ebexport [37554] > > Does dbexport lock the database while running? > > Larry > > ************************************************************ > **************** > > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > ************************************************************ > **************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1143f0a6907d740539a966e2 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

AFAIK, this is available on - updatable RSS with - STOP=5FAPPLY on (and LOG=5FSTAGING=5FDIR pointing to a secure directory) - DBSPACETEMP (onconfig) needs to point to a real temp space Andreas From: "LARRY SORENSEN" <LSORENSEN25@msn.com> To: ids@iiug.org Date: 12.10.2016 21:57 Subject: Re: dbexport [37970] Sent by: ids-bounces@iiug.org I was just re-reading the email chain below, and I wanted to get=20 clarification=20 on something.=20 I saw Paul, below, say that you can run a dbexport from a secondary server = without breaking replication? Is this true. It would save me a lot of=20 problems.=20 Larry=20 =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F=5F=5F=5F=20 From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel=20 <art.kagel@gmail.com>=20 Sent: Tuesday, August 9, 2016 2:30 PM=20 To: ids@iiug.org=20 Subject: Re: Ebexport [37562]=20 Larry:=20 You can download myexport from the IIUG Software Repository (=20 www.iiug.org/software<http://www.iiug.org/software>). It is a set of=20 scripts=20 (there is one executable C=20 International Informix Users Group<http://www.iiug.org/software>=20 www.iiug.org=20 About the Software Repository. These pages allow you to access the IIUG=20 Software Repository and other Informix-related archives on the Net. Quick=20 Links:=20 utility in the package that is only needed if you want to use the parallel = load/unload options). You will also need my utils2=5Fak package. The latest= =20 version of that can be downloaded from my web site (=20 www.askdbmgt.com/my-utilities.html< http://www.askdbmgt.com/my-utilities.html>)=20 there is a build instruction document=20 My Utilities - ASK Database=20 Management<http://www.askdbmgt.com/my-utilities.html>=20 www.askdbmgt.com=20 Utils2=5Fak is my primary package of utilities. This is the July 28, 2016=20 release. Included: dbping.ec - Tests connections and reports connection=20 time=20 as well as ...=20 included, but it builds just by unpacking the shell archive and running=20 make on linux (and usually Solaris as well). If you use external table=20 exports and imports (the -E option) that's all you need.=20 To use the default export/import, which is the slowest option, you'll also = need Jonathan Leffler's sqlcmd package the latest of which is in the IIUG=20 Repository as well.=20 To use the HP Loader options you'll need the myonpload utility from the=20 IIUG Repository.=20 Note that the external table option is the fastest unload/load so you can=20 ignore the HP Loader options.=20 Dbcopy is included in the utils2=5Fak package, so you'll be good once you=20 built that. Note that due to a looong standing bug in the ESQL/C libraries = you can't use dbcopy on tables with LVARCHAR columns and it doesn't work=20 correctly on tables with more than one dumb blob type column. For those=20 cases you can use the dbmove utility (also in the package).=20 If you have any trouble building or using these, let me know.=20 Art=20 Art S. Kagel, President and Principal Consultant=20 ASK Database Management=20 www.askdbmgt.com<http://www.askdbmgt.com>=20 ASK Database Management - Home<http://www.askdbmgt.com/>=20 www.askdbmgt.com=20 This is the site for Art S. Kagel's consultancy. The soaring majesty and=20 beauty in the image above hides the complex ecology and detail of its=20 existence.=20 Blog: http://informix-myview.blogspot.com/=20 Informix - My view<http://informix-myview.blogspot.com/>=20 informix-myview.blogspot.com=20 A place to share my views and ideas which may be of interest to the=20 Informix=20 user Community.=20 Disclaimer: Please keep in mind that my own opinions are my own opinions=20 and do not reflect on the IIUG, nor any other organization with which I am = associated either explicitly, implicitly, or by inference. Neither do=20 those opinions reflect those of other individuals affiliated with any=20 entity with which I am affiliated nor those of the entities themselves.=20 On Tue, Aug 9, 2016 at 1:33 PM, LARRY SORENSEN <LSORENSEN25@msn.com>=20 wrote:=20 > Thank you all for your responses.=20 >=20 > Do you have a link to the programs myexport, myimport and dbcopy as well = as=20 > some instructions on how to set them up and compile them (and what, if=20 > anything special, is needed to install before compiling them)?=20 >=20 > Larry=20 >=20 > =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F=5F=5F=5F=5F=20 > From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Paul=20 Watson=20 > <paul@oninit.com>=20 > Sent: Tuesday, August 9, 2016 10:53 AM=20 > To: ids@iiug.org=20 > Subject: RE: Ebexport [37557]=20 >=20 > If you have an older version ( one was 11.10 AFAIK) you can run dbexport = on=20 > a secondary - was extremely useful=20 >=20 > -----Original Message-----=20 > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of=20 Mike=20 > Walker=20 > Sent: Tuesday, August 09, 2016 11:46 AM=20 > To: ids@iiug.org=20 > Subject: RE: Ebexport [37556]=20 >=20 > Yes, dbexport does lock the database in exclusive mode. This helps=20 ensure=20 > data consistency/integrity and that you won't run into problems when=20 > building foreign keys when importing your database later on.=20 >=20 > You can look into Art's myexport/myimport utilities which do not lock=20 the=20 > database.=20 >=20 > Mike Walker=20 > Advanced DataTools Corporation=20 >=20 > -----Original Message-----=20 > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of=20 > LARRY=20 > SORENSEN=20 > Sent: Tuesday, August 09, 2016 10:33 AM=20 > To: ids@iiug.org=20 > Subject: Ebexport [37554]=20 >=20 > Does dbexport lock the database while running?=20 >=20 > Larry=20 >=20 > ************************************************************=20 > ****************=20 >=20 > ***=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 > ************************************************************=20 > ****************=20 > ***=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 > ************************************************************=20 > *******************=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 > ************************************************************=20 > *******************=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20 >=20 >=20 --001a1143f0a6907d740539a966e2=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussio

Here are the steps to be followed if you want to perform a *dbexport* on a secondary sever. 1/ Make sure that a dbspace of type TEMP is available * before doing a dbexport , you have to have a TEMP dbspace 2/ Make sure the secondary server is RSS or make it RSS if you are in HDR secondary mode 3/ Stop APPLY in order not apply the logs * onmode -wm LOG_STAGING_DIR=$INFORMIXDIR/tmp * onmode -wm STOP_APPLY=1 4/ Perform your dbexport on the RSS secondary * dbexport -d <database name> 5/ Apply the logs * onmode -wm STOP_APPLY=0 6/ Wait until the secondary has caught up with the primary and make it HDR secondary if that is what you want * onmode -d secondary <name of the primary instance> Cordialement, Regards, Khaled Bentebal Directeur Général - ConsultiX Tél: 33 (0) 1 39 12 18 00 Fax: 33 (0) 1 39 12 18 18 Mobile: 33 (0) 6 07 78 41 97 Email: khaled.bentebal@consult-ix.fr Site Web: www.consult-ix.fr Le 13/10/16 10:51, Andreas Legner a écrit : > AFAIK, this is available on > - updatable RSS with > - STOP=5FAPPLY on (and LOG=5FSTAGING=5FDIR pointing to a secure directory) > - DBSPACETEMP (onconfig) needs to point to a real temp space > > Andreas > > From: "LARRY SORENSEN"<LSORENSEN25@msn.com> > To: ids@iiug.org > Date: 12.10.2016 21:57 > Subject: Re: dbexport [37970] > Sent by: ids-bounces@iiug.org > > I was just re-reading the email chain below, and I wanted to get=20 > clarification=20 > on something.=20 > > I saw Paul, below, say that you can run a dbexport from a secondary server = > > without breaking replication? Is this true. It would save me a lot of=20 > problems.=20 > > Larry=20 > > =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= > =5F=5F=5F=5F=5F=5F=5F=20 > From: ids-bounces@iiug.org<ids-bounces@iiug.org> on behalf of Art Kagel=20 > <art.kagel@gmail.com>=20 > Sent: Tuesday, August 9, 2016 2:30 PM=20 > To: ids@iiug.org=20 > Subject: Re: Ebexport [37562]=20 > > Larry:=20 > > You can download myexport from the IIUG Software Repository (=20 > www.iiug.org/software<http://www.iiug.org/software>). It is a set of=20 > scripts=20 > (there is one executable C=20 > > International Informix Users Group<http://www.iiug.org/software>=20 > www.iiug.org=20 > About the Software Repository. These pages allow you to access the IIUG=20 > Software Repository and other Informix-related archives on the Net. Quick=20 > Links:=20 > > utility in the package that is only needed if you want to use the parallel = > > load/unload options). You will also need my utils2=5Fak package. The latest= > =20 > version of that can be downloaded from my web site (=20 > www.askdbmgt.com/my-utilities.html< > http://www.askdbmgt.com/my-utilities.html>)=20 > there is a build instruction document=20 > > My Utilities - ASK Database=20 > Management<http://www.askdbmgt.com/my-utilities.html>=20 > www.askdbmgt.com=20 > Utils2=5Fak is my primary package of utilities. This is the July 28, 2016=20 > release. Included: dbping.ec - Tests connections and reports connection=20 > time=20 > as well as ...=20 > > included, but it builds just by unpacking the shell archive and running=20 > make on linux (and usually Solaris as well). If you use external table=20 > exports and imports (the -E option) that's all you need.=20 > > To use the default export/import, which is the slowest option, you'll also = > > need Jonathan Leffler's sqlcmd package the latest of which is in the IIUG=20 > Repository as well.=20 > > To use the HP Loader options you'll need the myonpload utility from the=20 > IIUG Repository.=20 > > Note that the external table option is the fastest unload/load so you can=20 > ignore the HP Loader options.=20 > > Dbcopy is included in the utils2=5Fak package, so you'll be good once you=20 > built that. Note that due to a looong standing bug in the ESQL/C libraries = > > you can't use dbcopy on tables with LVARCHAR columns and it doesn't work=20 > correctly on tables with more than one dumb blob type column. For those=20 > cases you can use the dbmove utility (also in the package).=20 > > If you have any trouble building or using these, let me know.=20 > > Art=20 > > Art S. Kagel, President and Principal Consultant=20 > ASK Database Management=20 > www.askdbmgt.com<http://www.askdbmgt.com>=20 > > ASK Database Management - Home<http://www.askdbmgt.com/>=20 > www.askdbmgt.com=20 > This is the site for Art S. Kagel's consultancy. The soaring majesty and=20 > beauty in the image above hides the complex ecology and detail of its=20 > existence.=20 > > Blog: http://informix-myview.blogspot.com/=20 > > Informix - My view<http://informix-myview.blogspot.com/>=20 > informix-myview.blogspot.com=20 > A place to share my views and ideas which may be of interest to the=20 > Informix=20 > user Community.=20 > > Disclaimer: Please keep in mind that my own opinions are my own opinions=20 > and do not reflect on the IIUG, nor any other organization with which I am = > > associated either explicitly, implicitly, or by inference. Neither do=20 > those opinions reflect those of other individuals affiliated with any=20 > entity with which I am affiliated nor those of the entities themselves.=20 > > On Tue, Aug 9, 2016 at 1:33 PM, LARRY SORENSEN<LSORENSEN25@msn.com>=20 > wrote:=20 > >> Thank you all for your responses.=20 >> =20 >> Do you have a link to the programs myexport, myimport and dbcopy as well = > as=20 >> some instructions on how to set them up and compile them (and what, if=20 >> anything special, is needed to install before compiling them)?=20 >> =20 >> Larry=20 >> =20 >> =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= > =5F=5F=5F=5F=5F=5F=5F=5F=20 >> From: ids-bounces@iiug.org<ids-bounces@iiug.org> on behalf of Paul=20 > Watson=20 >> <paul@oninit.com>=20 >> Sent: Tuesday, August 9, 2016 10:53 AM=20 >> To: ids@iiug.org=20 >> Subject: RE: Ebexport [37557]=20 >> =20 >> If you have an older version ( one was 11.10 AFAIK) you can run dbexport = > on=20 >> a secondary - was extremely useful=20 >> =20 >> -----Original Message-----=20 >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of=20 > Mike=20 >> Walker=20 >> Sent: Tuesday, August 09, 2016 11:46 AM=20 >> To: ids@iiug.org=20 >> Subject: RE: Ebexport [37556]=20 >> =20 >> Yes, dbexport does lock the database in exclusive mode. This helps=20 > ensure=20 >> data consistency/integrity and that you won't run into problems when=20 >> building foreign keys when importing your database later on.=20 >> =20 >> You can look into Art's myexport/myimport utilities which do not lock=20 > the=20 >> database.=20 >> =20 >> Mike Walker=20 >> Advanced DataTools Corporation=20 >> =20 >> -----Original Message-----=20 >> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of=20 >> LARRY=20 >> SORENSEN=20 >> Sent: Tuesday, August 09, 2016 10:33 AM=20 >> To: ids@iiug.org=20@