Re: Problem with Datablade Modules

From: Kirill Pirgalin <pirg_@hotmail.ru> > >Hello! >Please look on my problem and give advise what to do. > > > 1. I have a database with several tables use Image and Video >Datablade >modules. It was created a year ago imideatly after installation of >Informix >distributive packet. After that we were able to insert only 16 records >(images >and some numeric values)into DB. After that we were able to read and run > >simple queries as: > >-------------------------------------------------------------------------- > > select chunkid, rank from vidimgdesc where Resembles (image, > row('IpdColorImageFE(RETINA_WIDTH=32, RETINA_HEIGHT=32)', > row(row(row('IFX_FILE', NULL::LLD_Lob, >'/home/isl161/images/personnel/ido.gif'), > NULL::lvarchar), '','',0, 0, '')), rank #REAL);> >-------------------------------------------------------------------------- > >it returns frame number and resemblence degree. > >Tables were created by following queries: >-------------------------------------------------------------------------- > > create table personnel ( > personid int, > first varchar(255), > last varchar(255), > image ifdimgdesc, > primary key (personid) > );> > CREATE INDEX per_color_index on personnel (image IfdImgDesc_ops) > USING frnet(extractor='IpdColorImageFE(RETINA_WIDTH=32,>RETINA_HEIGHT=32)') in sbdbs; > > CREATE INDEX per_texture_index on personnel (image IfdImgDesc_ops) > USING frnet(extractor='IpdTextureImageFE(RETINA_WIDTH=32,>RETINA_HEIGHT=32)') in sbdbs; > >CREATE INDEX per_gestalt_index on personnel (image IfdImgDesc_ops) >USING frnet(extractor='IpdGestaltImageFE(RETINA_WIDTH=32,>RETINA_HEIGHT=32)') in sbdbs; > >insert into personnel values (0, 'nobody', 'nobody',>row(row(row('ifx_file',NULL::LLD_Lob,'/net/emc2-32/isl/home/isl161/images/personnel/ido.gif'),NULL::lvarchar),'NULL','NULL' >,NULL::lvarchar,NULL::lvarchar,NULL::lvarchar)::ifdimgdesc ); >insert into personnel values (1, 'Ido', 'Carmel',>row(row(row('ifx_file',NULL::LLD_Lob,'/net/emc2-32/isl/home/isl161/images/personnel/ido.gif'),NULL::lvarchar),'NULL','NULL' >,NULL::lvarchar,NULL::lvarchar,NULL::lvarchar)::ifdimgdesc ); > >-------------------------------------------------------------------------- > >But at some day Informix stoped to work properly. >- Unable to register Datablade modules for new-created databases (by >blademgr) >- Unable to insert any record contains image/video linked field >- Unable to compare images and etc. > >I receive next messages while registering DataBledes for new Database: > >-------------------------------------------------------------------------- > >10 2000-07-25 11:54:56 Register video.1.20.UC1 Fail - Log in >/tmp/blademgr/50040/log010.log >Pick the number of a log or N to cancel :- 10 > blade: video.1.20.UC1 >err expct: unexpected > SQL stmt: create index Idx1ChunkMD on VidChunkMD (Chunk MedChunk_ops) >using rtree; >SQL state: XRLT70:-937 : RLT70: cannot create rtree index in >non-logging(??? - K.) database ontape -s -L 0 -B yourdatabasename You have to have logging on your new databases. Clearly, you don't. > blade: video.1.20.UC1 >err expct: unexpected > SQL stmt: drop type MedPtr restrict; >SQL state: XIX000:-9630 : Cannot drop type (medptr): still in use. > > blade: video.1.20.UC1 >err expct: unexpected > SQL stmt: EXCEPTION >SQL state: Registration failed for DataBlade module "video.1.20.UC1", >recovery was unsuccessful. > >-------------------------------------------------------------------------- > >Our sysadmin claims that everything as usual, excepts that mainframe >with >Informix sometimes fails... >He can RE-install informix (or only these DataBlades) but after >- He won't know any other way to fix this problem >- And what to do with existed database? > >I ask you to give advise what can we do and may be with your >recomendations sysadmin will permit to us reinstall Informix. > >Best regards, Kirill Pirgalin. >Technion, Israel. > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com