International Informix Users Group

	Informix News

16 October 08 - VendorRate - Informix Earns Top Customer Satisfaction Score on VendorRate in Q3... Read 14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read 29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read 29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read 28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read 28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read 09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read 08 April 08 - IT-Director.com - Informix seeks developers... Read 18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read 17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read 17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read 16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read 16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read 28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read 27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read 14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read 14 June 07 - eChannelLine - IBM expands scope for IDS... Read 14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read 13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read 12 June 07 - IBM - IDS 11 release announcement (pdf)... Read 12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read 12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read 12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read 12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read 12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read 12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read 12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read 12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read 12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read 12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read 12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - golem.de - Informix 11 vorgestellt... Read 12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read 12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - Heise - IBM gibt Informix 11 frei... Read 25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read 18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read 18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read 7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read Previous news items

Home Member Area About IIUG

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

Redbrick List Forum

Re: attaching additional segments to index

Posted By: Mohd Shah M. Sood
Date: Thursday, 17 July 2003, at 3:03 a.m.

In Response To: attaching additional segments to index (Mohd Shah M. Sood)

This is a multi-part message in MIME format.

--Boundary_(ID_HvWjj+pCC6s+Ij76ZWonww)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT

Thanks for all the feedback. I'm currently trying to attach the index segment 200307 (i.e. yyyymm). What i found out is that when we have data in the 200306 segment, I can't attach the 200307 index segment! So what i did was basically unload and delete all data in my 200306_datasegment before attaching the index segment... and it worked!

but i'm facing a new problem now. when i try to load the 200306 data back into the segment, it complained that the 200306 segment is full.. and stopped after loading about 7 mill rows. (total about 21 mill rows unloaded). I believe that the space previously used by the deleted data (21 mill row) was not being reused. Anyone knows how I can reuse these space?

fyi, i did a 'delete from table where timestamp >= timestamp'2003-06-01 00:00:00'

I read something about 'alter segment clear' but not too sure if it'll help solve my problem. what i now have is 200306 data segment with 7 mill rows of data loaded. What i think i need to do the to delete these 7 mill rows and somehow get back all the freespace in the segment before i repeat the loading process.

hope to get some feedback. TIA
shah

"Mohd Shah M...." <md_shah@tm.net.my>
Sent by: forum.subscriber@iiug.org
07/09/2003 06:42 PM

To: redbrick-list@iiug.org
cc:
Subject: attaching additional segments to index [106]

Hi, I'm having trouble attaching additional segments to an index. below are
the scripts i ran:

create segment FACTEVENT_IDX_200307
storage '/dm08/factevent_idx_200307_psu01' maxsize 1000000 initsize 500000
extendsize 100000;
=> this is executed successfully.

alter segment FACTEVENT_IDX_200307 attach to index DM_FACT_EVENT_PK_IDX
range ( TIMESTAMP'2003-07-01 00:00:00': MAX );
=> [Red Brick][ODBC Driver]** FATAL ** (10410) Could not receive from the
server. OS error: No error (0).

and from the logs...
Jul 10 08:25:39 rbwapid[98088] ERR076A: Server PID:110202 terminated with
signal:11 User time:250 System time:730
Jul 10 08:25:48 rbwpchk[108160] OPE157A: Abnormally terminated process has
been detected. PID: 110202.
Jul 10 08:25:48 rbwpchk[108160] OPE6053A: All the shared resources cleanup
has completed.

similarly i've attached additional data segment with identical range values
without any problem. Anyone had this problem before? I've tried running the
script, also tried doing it through the 'manage segments' GUI wizard... both
failed. hope to get some suggestions on how to fix this.

i'm running redbrick 6.11 on AIX5.1, and it's a BTREE index

thanks
shah

--Boundary_(ID_HvWjj+pCC6s+Ij76ZWonww)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: 7BIT

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks for all the feedback. I'm currently trying
to attach the index segment 200307 (i.e. yyyymm). What i found out is that when
we have data in the 200306 segment, I can't attach the 200307 index segment! So
what i did was basically unload and delete all data in my
200306_datasegment before attaching the index segment... and it
worked!</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>but i'm facing a new problem now. when i try to
load the 200306 data back into the segment, it complained that the 200306
segment is full.. and stopped after loading about 7 mill rows. (total about 21
mill rows unloaded). I believe that the space previously used by the deleted
data (21 mill row) was not being reused. Anyone knows how I can reuse these
space? </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>fyi, i did a 'delete from table where timestamp
>= timestamp'2003-06-01 00:00:00'</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I read something about 'alter segment clear' but
not too sure if it'll help solve my problem. what i now have is 200306 data
segment with 7 mill rows of data loaded. What i think i need to do the to delete
these 7 mill rows and somehow get back all the freespace in the segment before i
repeat the loading process.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>hope to get some feedback. TIA</FONT></DIV>
<DIV><FONT face=Arial size=2>shah</FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT><BR> </DIV>
<DIV>
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD>
<TD><FONT face=sans-serif size=1><B>"Mohd Shah M...."
<md_shah@tm.net.my></B></FONT> <BR><FONT face=sans-serif size=1>Sent
by: forum.subscriber@iiug.org</FONT>
<P><FONT face=sans-serif size=1>07/09/2003 06:42 PM</FONT> <BR></P>
<TD><FONT face=Arial size=1>        </FONT><BR><FONT
face=sans-serif size=1>        To:    
   redbrick-list@iiug.org</FONT> <BR><FONT face=sans-serif
size=1>        cc:        </FONT>
<BR><FONT face=sans-serif size=1>        Subject:
       attaching additional segments to index
[106]</FONT> <BR></TR></TBODY></TABLE></DIV>
<DIV><BR><BR><BR><FONT face="Courier New" size=2>Hi, I'm having trouble
attaching additional segments to an index. below are<BR>the scripts i
ran:<BR><BR>create segment FACTEVENT_IDX_200307<BR>storage
'/dm08/factevent_idx_200307_psu01' maxsize 1000000 initsize 500000<BR>extendsize
100000;<BR>=> this is executed successfully.<BR><BR>alter segment
FACTEVENT_IDX_200307 attach to index DM_FACT_EVENT_PK_IDX<BR>range (
TIMESTAMP'2003-07-01 00:00:00': MAX );<BR>=> [Red Brick][ODBC Driver]** FATAL
** (10410) Could not receive from the<BR>server. OS error: No error
(0).<BR><BR>and from the logs...<BR>Jul 10 08:25:39 rbwapid[98088] ERR076A:
Server PID:110202 terminated with<BR>signal:11 User time:250 System
time:730<BR>Jul 10 08:25:48 rbwpchk[108160] OPE157A: Abnormally terminated
process has<BR>been detected. PID: 110202.<BR>Jul 10 08:25:48 rbwpchk[108160]
OPE6053A: All the shared resources cleanup<BR>has
completed.<BR><BR><BR>similarly i've attached additional data segment with
identical range values<BR>without any problem. Anyone had this problem before?
I've tried running the<BR>script, also tried doing it through the 'manage
segments' GUI wizard... both<BR>failed. hope to get some suggestions on how to
fix this.<BR><BR>i'm running redbrick 6.11 on AIX5.1, and it's a BTREE
index<BR><BR>thanks<BR>shah<BR><BR><BR></FONT><BR><BR></DIV></BODY></HTML>

--Boundary_(ID_HvWjj+pCC6s+Ij76ZWonww)--

Messages In This Thread

attaching additional segments to index
Mohd Shah M. Sood -- Wednesday, 9 July 2003, at 9:42 p.m.
- Re: attaching additional segments to index
  Mohd Shah M. Sood -- Thursday, 17 July 2003, at 3:03 a.m.
  - Re: attaching additional segments to index
    William Gates -- Friday, 18 July 2003, at 4:19 p.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

Redbrick List Forum is maintained by Administrator with WebBBS 5.12.