alter fragment attach ...

ids 11.70.fc3xc aix 6.1 Looking to move some fragmented tables around .. and before figuring out exactly what we are doing I was doing a simple test with detach and attach .. So, here is my question ... I have a table fragmented over 40 periods ... Took the indexes off the table ... cause I wanted to do a simple detach .. and then attach to make sure things did what I expected them to do .. alter table ... detach ... statement works and results in the table with the expected data. alter fragment on table ... attach ... giving the exact expression ... with the before dbspace (same one it preceded before) ... In doing this I am getting a -783, Cannot attach because of incompatible schema ... Any clues .. seems to me that I should be able to reattach the fragment I just detached .... Peter Logan Senior Database Administrator Phone: 616/878-8309

When you detach the fragment, all of the things you wanted to go along = with it - I forget which, but NOT NULL, constraints ya-di-ya go away. = You have to re-add them before attaching. j. On Sep 17, 2013, at 2:19 PM, "Peter_Logan@spartanstores.com" = <Peter_Logan@spartanstores.com> wrote: > ids 11.70.fc3xc=20 > aix 6.1=20 >=20 > Looking to move some fragmented tables around .. and before figuring = out=20 > exactly what we are doing I was doing a simple test with detach and = attach=20 > ... So, here is my question ...=20 >=20 > I have a table fragmented over 40 periods ... Took the indexes off the=20= > table ... cause I wanted to do a simple detach .. and then attach to = make=20 > sure things did what I expected them to do ..=20 >=20 > alter table ... detach ... statement works and results in the table = with=20 > the expected data.=20 >=20 > alter fragment on table ...=20>=20 > attach ...=20 >=20 > giving the exact expression ... with the before dbspace (same one it=20= > preceded before) ...=20 >=20 > In doing this I am getting a -783, Cannot attach because of = incompatible=20 > schema ...=20 >=20 > Any clues .. seems to me that I should be able to reattach the = fragment I=20 > just detached ....=20 >=20 > Peter Logan=20 > Senior Database Administrator=20 > Phone: 616/878-8309=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

forgot about that ... Thanks ... Too bad that stuff all goes away ... other than like a serial column ... can't see why .. but that's why I don't write the DB ... Peter Logan Senior Database Administrator Phone: 616/878-8309 From: "Jack Parker" <jack.parker4@verizon.net> To: ids@iiug.org, Date: 09/17/2013 02:28 PM Subject: Re: alter fragment attach ... [31435] Sent by: ids-bounces@iiug.org When you detach the fragment, all of the things you wanted to go along = with it - I forget which, but NOT NULL, constraints ya-di-ya go away. = You have to re-add them before attaching. j. On Sep 17, 2013, at 2:19 PM, "Peter_Logan@spartanstores.com" = <Peter_Logan@spartanstores.com> wrote: > ids 11.70.fc3xc=20 > aix 6.1=20 >=20 > Looking to move some fragmented tables around .. and before figuring = out=20 > exactly what we are doing I was doing a simple test with detach and = attach=20 > ... So, here is my question ...=20 >=20 > I have a table fragmented over 40 periods ... Took the indexes off the=20= > table ... cause I wanted to do a simple detach .. and then attach to = make=20 > sure things did what I expected them to do ..=20 >=20 > alter table ... detach ... statement works and results in the table = with=20 > the expected data.=20 >=20 > alter fragment on table ...=20>=20 > attach ...=20 >=20 > giving the exact expression ... with the before dbspace (same one it=20= > preceded before) ...=20 >=20 > In doing this I am getting a -783, Cannot attach because of = incompatible=20 > schema ...=20 >=20 > Any clues .. seems to me that I should be able to reattach the = fragment I=20 > just detached ....=20 >=20 > Peter Logan=20 > Senior Database Administrator=20 > Phone: 616/878-8309=20 >=20 >=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 discussion forum.