myschema - excalibur textblade
Posted in 2003
I am running 9.21.hc5 on hp-ux 11.0
Running the following myschema (Version 6.24, Source
Revision: 2.114) command fails
[informix]#myschema -E -v -M max -n 10 -d dw -t
texts_dim aaa.sql
Writing full schema DDL to: aaa.sql
Connecting to host: @dwtcp.
Opening Sysmaster database.
Fetching system pagesize... System pagesize is: 2K.
Collecting DBSPACE information.
Collecting table space usage information.
Opening database: dw.
Preparing Cursors.
Analyzing schema.
Memory fault(coredump)
The table schema is:
CREATE TABLE texts_dim
(
language_cd char(1),
text_nbr integer,
text lvarchar
) WITH ROWIDS
fragment by round robin in dbsa_2 , dbsa_3 , dbsa_4 ,dbsa_5
CREATE UNIQUE INDEX idx_txtdim_1 ON
texts_dim(text_nbr,language_cd)
IN dbsa_1 ;
ALTER TABLE texts_dim ADD CONSTRAINT PRIMARYKEY(text_nbr, language_cd);
CREATE INDEX idx_txtdim_ext_1 ON texts_dim(text
etx_lvarc_ops)
USING etx (word_support='EXACT',
phrase_support= 'MEDIUM',
STOPWORD_LIST = 'text_stopword') IN sbspace1 ;
What am I doing wrong?
The index idx_txt_dim_ext_1 is using the excalibur text
blade.
I also have the sqexplain.out file if needed.
Thanks,
Andy
sending to informix-list