Attach fragment from a table in another database

Posted in 2014

JACOB SALOMON — Tue, 30 Dec 2014 00:59:39 — source: IIUG Forums & Mailing Lists

Hi Folks (capitalized! :-) My client just asked me the wildest question: > if there is a fragment associated with one database like dbase_1@my_server, > can that fragment be detached and moved to another table on another database > like dbase_2@myserver? Actually, he asked if the detached fragment could be attached to a table in a different server. To that the answer is surely NO, since it is the identical work to select from the detached fragment (now a table) to insert into a new table on the second server. But considering the internal structures that delineate the pages of tablespace, it is possible to attach that detached fragment to a table in another database on the *same* server? My bets are with NO on this one as well but I figured I would ask the experts before being such a naysayer. Thanks much. -- Jacob S.

↪ replying to JACOB SALOMON

John Miller — Tue, 30 Dec 2014 18:10:51 — source: IIUG Forums & Mailing Lists

Jacob: To your surprise you can do scenario #1, but you can not do scenario #2. Scenario #1 is generally referred to as sharding a table (the ability to keep parts of a table on different servers) and this functionality was introduced into version 12.10.xC2. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 12/29/2014 04:59:39 PM: > From: "JACOB SALOMON" <jakesalomon@yahoo.com> > To: ids@iiug.org > Date: 12/29/2014 05:00 PM > Subject: Attach fragment from a table in another database [34411] > Sent by: ids-bounces@iiug.org > > Hi Folks (capitalized! :-) > > My client just asked me the wildest question: > > if there is a fragment associated with one database like dbase_1@my_server, > > can that fragment be detached and “moved” to another table on another > database > > like dbase_2@myserver? > > Actually, he asked if the detached fragment could be attached to a table in a > different server. To that the answer is surely NO, since it is the identical > work to select from the detached fragment (now a table) to insert into a new > table on the second server. > > But considering the internal structures that delineate the pages of > tablespace, it is possible to attach that detached fragment to a table in > another database on the *same* server? My bets are with NO on this > one as well > but I figured I would ask the experts before being such a naysayer. > > Thanks much. > > -- Jacob S. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

↪ replying to John Miller

Marcus — Fri, 02 Jan 2015 10:26:43 — source: IIUG Forums & Mailing Lists

What John tried to say (decoded): Jacob: To your surprise you can do scenario #1, but you can not do scenario #2. Scenario #1 is generally referred to as sharding a table (the ability to keep parts of a table on different servers) and this functionality was introduced into version 12.10.xC2. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ----- Ursprüngliche Mail ----- Von: "John Miller iii" <miller3@us.ibm.com> An: ids@iiug.org Gesendet: Dienstag, 30. Dezember 2014 19:10:52 Betreff: Re: Attach fragment from a table in another da.... [34413] Jacob: To your surprise you can do scenario #1, but you can not do scenario #2. Scenario #1 is generally referred to as sharding a table (the ability to keep parts of a table on different servers) and this functionality was introduced into version 12.10.xC2. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 12/29/2014 04:59:39 PM: > From: "JACOB SALOMON" <jakesalomon@yahoo.com> > To: ids@iiug.org > Date: 12/29/2014 05:00 PM > Subject: Attach fragment from a table in another database [34411] > Sent by: ids-bounces@iiug.org > > Hi Folks (capitalized! :-) > > My client just asked me the wildest question: > > if there is a fragment associated with one database like dbase_1@my_server, > > can that fragment be detached and “moved” to another table on another > database > > like dbase_2@myserver? > > Actually, he asked if the detached fragment could be attached to a table in a > different server. To that the answer is surely NO, since it is the identical > work to select from the detached fragment (now a table) to insert into a new > table on the second server. > > But considering the internal structures that delineate the pages of > tablespace, it is possible to attach that detached fragment to a table in > another database on the *same* server? My bets are with NO on this > one as well > but I figured I would ask the experts before being such a naysayer. > > Thanks much. > > -- Jacob S. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.