Re: Removing Outstanding In-place alter (Migrating to 9.40 from 9.21)

Posted in 2004

Rajib Sarkar — Wed, 8 Sep 2004 08:28:59 -0700 — source: Usenet: comp.databases.informix

--0__=88BBE59ADFC7292C8f9e8a93df938690918c88BBE59ADFC7292C Content-type: multipart/alternative; Boundary="1__=88BBE59ADFC7292C8f9e8a93df938690918c88BBE59ADFC7292C" --1__=88BBE59ADFC7292C8f9e8a93df938690918c88BBE59ADFC7292C Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Yes, it does. Actually, when a in-place alter happens ..only the partit= ion page is updated and another page with slot#6 is created to keep track o= f the in-place alters. As you go along and keep on using the pages it cop= ies them into new pages with the new "table layout" ..that's why the onchec= k -pT shows different # of pages in different versions .. the way we keep= track of in-place alter pages is that we keep the version# in the page headers and that's what the oncheck -pT reads and reports. So, when you do the dummy update, it actually physically goes ahead and= copies all of the pages for the table into new pages and "actually" rem= oves the pending IPAs. HTH Thanx much, Rajib Sarkar Advisory Software Engineer DB2/UDB Regional Advanced Support IBM Data Management Group If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = Deepak.Patel@in.e = funds.com = Sent by: = To owner-informix-li informix-list@iiug.org = st@iiug.org = cc ScanDBA_Chennai%INEFUNDS@in.efun= ds. com = 09/08/2004 06:13 Subj= ect AM Removing Outstanding In-place al= ter (Migrating to 9.40 from 9.21) = = = = = = = We are in the process of migrating from IDS 9.21 UC3X1 to IDS 9.40 in S= un Solaris 5.7, We need to remove all the outstanding In-Place alters from the altered tables in t= he database. To consolidate tables into one version, I am using the following dumm= y update: UPDATE table SET col1=3Dcol1 WHERE 1=3D1; Output of oncheck -pT database:tablename before the dummy update. Home Data Page Version Summary Version Count 0 (oldest) 7780 1 0 2 0 3 0 4 (current) 0 Output of oncheck -pT database:tablename after the dummy update. Version Count 0 (oldest) 0 1 0 2 0 3 0 4 (current) 7780 Question: Does this really remove the outstanding In-Place alter or is there any other method without recreating the table in fresh ? TIA Deepak ***********************************************************************= ****************** This electronic mail message is intended solely for the named recipients and may contain confidential and proprietary business information of eFunds Corporatio= n and all its subsidiaries.If you are not a named recipient, please notify the sender immediately.You may not disclose the contents to any other person; use this electronic mail message = or its contents for any other purpose; or further store or copy its contents in any medium. ***********************************************************************= ****************** sending to informix-list = --1__=88BBE59ADFC7292C8f9e8a93df938690918c88BBE59ADFC7292C Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> Yes, it does. Actually, when a in-place alter happens ..only the par= tition page is updated and another page with slot#6 is created to keep = track of the in-place alters. As you go along and keep on using the pag= es it copies them into new pages with the new "table layout" = ..that's why the oncheck -pT shows different # of pages in different ve= rsions .. the way we keep track of in-place alter pages is that we keep= the version# in the page headers and that's what the oncheck -pT reads= and reports. So, when you do the dummy update, it actually physically goes ahead and= copies all of the pages for the table into new pages and "actuall= y" removes the pending IPAs. HTH Thanx much, Rajib Sarkar Advisory Software Engineer DB2/UDB Regional Advanced Support IBM Data Management Group If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison <img src=3D"cid:10__=3D88BBE59ADFC7292C8f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for Deepak.Patel@in.efu= nds.com">Deepak.Patel@in.efunds.com <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE59= ADFC7292C8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul>Deepak.Patel@in.efunds.com Sent by: owner-informix-list@iiug.org 09/08/2004 06:13 AM</ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE59ADFC7292C8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> @@