RSS Feed: IIUG Forum: Datablade List

Datablade list is a discussion forum dedicated to the discussion of Informix DataBlades. This is for both users and developers.

Older IDS release required
Posted by: osdbms@gmail.com (Wang Shiyi) - Thu, 03 Nov 2011 02:09:03 EDT
For some reasons, I need older IDS release, I want 9.4 and 10, does anybody
have it?

Thank you.

--00151750e42ab6e56e04b0ce6c53




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [263]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Text Search: bts versus excalibur
Posted by: rvilca@luzdelsur.com.pe (ROGER VILCA) - Thu, 01 Sep 2011 18:49:45 EDT
Hi,
I have issues with the indexing time using BTS. I probed that one sentence
"create index...using bts" takes about 38 hours with a table near one million
or records (indexing a field called name char(40)) .
I know that the BTS is built on clucene.
I want to probe with excalibur.
Do you know what is the engine of excalibur ?
Have you experienced similar problems with the indexing time?.
Please, provide me any clues according your experience.

Version: 11.50 FC8 Ultimate Edition

Thanks,
Roger Vilca




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [262]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Time Series Storage
Posted by: art.kagel@gmail.com (Art Kagel) - Sun, 17 Jul 2011 09:49:30 EDT
Yes. In general you should keep user data out of the rootdb dbspace.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.

On Sat, Jul 16, 2011 at 10:29 AM, THROSTUR JONSSON
<tj@rational-network.com>wrote:

> I have two timeseries containers in rootdbs for time sereis storage, one
> for
> regular time series and a second for irregualar timesereis.
>
> This is the content of tscontainertable:
> name subtype partitiondesc flags
> ===============================================================
> e2net_val_cont e2net_val e2net_val_cont rootdbs 604 35 1048849 1
> e2net_val_irr_cont e2net_val e2net_val_irr_cont rootdbs 16 16 1048926 3
> ===============================================================
> Now I want to reorganize things to get the best performance out of my
> TimeSeries engine. Should I use containers in a dedicated db-space(s) for
> this
> instead of using rootdbs?
> I'm asking general terms here as the IBM documentation is not very clare
> regarding this.
>
> Regards
> TJ
>
>
>
>

>
>
>

--bcaec50161819fc22704a844260f




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [261]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Time Series Storage
Posted by: tj@rational-network.com (THROSTUR JONSSON) - Sat, 16 Jul 2011 10:29:38 EDT
I have two timeseries containers in rootdbs for time sereis storage, one for
regular time series and a second for irregualar timesereis.

This is the content of tscontainertable:
name subtype partitiondesc flags
===============================================================
e2net_val_cont e2net_val e2net_val_cont rootdbs 604 35 1048849 1
e2net_val_irr_cont e2net_val e2net_val_irr_cont rootdbs 16 16 1048926 3
===============================================================
Now I want to reorganize things to get the best performance out of my
TimeSeries engine. Should I use containers in a dedicated db-space(s) for this
instead of using rootdbs?
I'm asking general terms here as the IBM documentation is not very clare
regarding this.

Regards
TJ




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [260]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

EXCALIBUR DATABLADE ON TEXT DATA TYPE COLUMN
Posted by: jessytapoli@hotmail.com (TATIANA FLORES) - Tue, 19 Apr 2011 18:52:07 EDT
Grettings!!

I have recently installed Excalibur Text Search Datablade 1.31 on Hp-UX 11.23
with Informix 11.50.FC7

I want to do some probes, I registered my datablade on my database and when I
wanted to create the ETX index, I got the following:

610 Index not allowed on TEXT or BYTE columns

I realized that TEXT data type is not supported to build an ETX index on it.
My question is if there is a way to build a ETX index using TEXT data type
column though the excalibur user's guide told me only 7 data types are
supported, less TEXT. Overall I want to know which operator class I can use to
build an ETX index.

thanks for your attention.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [259]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Excalibur blade, ext_GetHilite locking issue
Posted by: mrh@panix.com (MICHAEL HOFFMAN) - Thu, 02 Dec 2010 18:36:57 EST
Weiming,
Apologies for the very delayed repsonse! Thank you for the information. We
have upgraded the blade, and are now proceeding to modify the isolation
settings in the code. So far, it looks to be working well.

Michael




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [258]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Installation problem of Informix datablade....
Posted by: domusonline@gmail.com (Fernando Nunes) - Sun, 28 Nov 2010 18:17:18 EST
On Sun, Nov 28, 2010 at 3:58 PM, PRADEEP PENCHALA <pradeepkp@live.com>wrote:

> Hello,
>
> I have installed IBM informix dynamic server 11.50. Now I am trying to
> install
> IBM Informix Dynamic Server 4.20 TC1. I have installed it in the same
> folder
> where I installed IBM Informix dynamic server. Both were installed
> properly.
>
> But, now when I am trying to access BladeManager.exe it is saying
>
> "The program cant start because ic++t02a.dll is missing from your computer.
> Try reinstalling the program to fix this problem."
>
> Even after reinstalling, it didnt get resolved.
>
> Please help me in resolving it.
>
> Thanks,
> Pradeepkp
>

Can you find that DLL in the installation. I recently installed that
software and had some issues. But the error was slighlty different. It
complained that some DLL(s) was not registered. If that's the case, you can
register it by hand using regsvr32.exe

Regards.

>
>
>
>

>
>
>

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--0015174c4400ce34d10496252784




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [257]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Installation problem of Informix datablade manager
Posted by: pradeepkp@live.com (PRADEEP PENCHALA) - Sun, 28 Nov 2010 10:58:10 EST
Hello,

I have installed IBM informix dynamic server 11.50. Now I am trying to install
IBM Informix Dynamic Server 4.20 TC1. I have installed it in the same folder
where I installed IBM Informix dynamic server. Both were installed properly.

But, now when I am trying to access BladeManager.exe it is saying

"The program cant start because ic++t02a.dll is missing from your computer.
Try reinstalling the program to fix this problem."

Even after reinstalling, it didnt get resolved.

Please help me in resolving it.

Thanks,
Pradeepkp




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [256]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Excalibur blade, ext_GetHilite locking issue
Posted by: weiming@us.ibm.com (WEIMING YE) - Mon, 20 Sep 2010 18:54:53 EDT
Hi Michael,

Any release before ETX.1.31.xC1 didn't support concurrent sharing index
between reader and writer, it supported only multiple readers or one writer.
However from 1.31.xC1, it started to support multiple readers along with one
writer under the condition of DIRTY READ ISOLATION used by all reader(s).

So try that and see this still a problem for your case.

--weiming




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [255]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Autosvar - Ikke til stede: Digest 252
Posted by: obnoxio@serendipita.com (Obnoxio The Clown) - Fri, 10 Sep 2010 16:26:54 EDT
Peter Langseth wrote:
> Jeg arbejder ikke længere i DØF.
>
> Du kan kontakte webteamet@djoef.dk hvor mine kolleger kan hjælpe dig.

Din fisse.

--
Cheers,
Obnoxio The Clown

http://obotheclown.blogspot.com
I will now proceed to pleasure myself with this fish.

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [254]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Autosvar - Ikke til stede: Digest 252
Posted by: pel@djoef.dk (Peter Langseth) - Fri, 10 Sep 2010 16:12:38 EDT
Jeg arbejder ikke længere i DØF.

Du kan kontakte webteamet@djoef.dk hvor mine kolleger kan hjælpe dig.

Med venlig hilsen / Sincerely
Peter Langseth
Webkonsulent
____________________________________
DANMARKS JURIST- OG ØKONOMFORBUND
Gothersgade 133, Postboks 2126, 1015 København K

Telefon 33 95 97 00
Direkte 33 95 98 39
E-mail pel@djoef.dk
http://www.djoef.dk




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [253]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Excalibur text datablade error
Posted by: mrh@panix.com (MICHAEL HOFFMAN) - Fri, 10 Sep 2010 13:33:53 EDT
The following e-mail was sent to you via Datablade List Forum from MICHAEL HOFFMAN (mrh@panix.com) at IP address 165.127.77.148 (vp.sos.state.co.us).



Re: Excalibur text datablade error

Hi Gary,
Could you reach back into your memory... in 2006 you posted a problem about the Excalibur Datablade and a -937 error.

We are receiving this error now.

How did you correct this error?

Thanks,
Michael Hoffman




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: []

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Excalibur blade, ext_GetHilite locking issue
Posted by: mrh@panix.com (MICHAEL HOFFMAN) - Fri, 10 Sep 2010 13:28:28 EDT
We are experiencing a locking issue related to the Excalibur datablade, in the
etx_GetHilite function.
Has anyone else run across this issue?

The code to select records utilizes the etx_GetHilite blade routine. If
another user tries to insert anything into the CLOB, the insert fails with a
locking error.
A select is in progress, so updating the index is not allowed.Error Code:-937

Also, I can see the query creating a Transaction, via onstat -x:

14f0f8ad8 A-B-- 14f0bdbd8 1175 10346:0x1314018 10347:0x1714c4 COMMIT

This is a simple Select query:
select p.content_id,
p.xml,
etx_ViewHilite(etx_GetHilite(p.xml, rc),
"<span class=highlightWordsOfContext>",
"</span>") highlight,
[...]

Commenting out the etx_ViewHilite line returns results with no Transaction. (I
also modified the query to run just the etx_GetHilite piece, and a transaction
was started).

How do I prevent etx_GetHilite from creating a transaction and locking the
indexes?

Thanks!
Michael Hoffman




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [252]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: spatial datablade registeration on amazon IDS
Posted by: weiming@us.ibm.com (WEIMING YE) - Sun, 18 Apr 2010 23:56:19 EDT
when you login into remote terminal, did you check if your terminal
environment has setup following variables?

setenv INFORMIXDIR /ix/informix
setenv INFORMIXSQLHOSTS /ix/etc/sqlhosts
setenv ONCONFIG onconfig.mine
setenv INFORMIXSERVER miine

setenv PATH $INFORMIXDIR/bin:$PATH

setenv LD_LIBRARY_PATH $INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:/usr/lib

re-setup the PATH with $INFORMIXIDIR/bin after install.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [251]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

spatial datablade registeration on amazon IDS
Posted by: witsunny@gmail.com (MONDAY SUNDAY) - Sat, 17 Apr 2010 20:52:21 EDT
Hi
I am using Ibm informix data server available on Amazon web service.
I want to use spatial datablade over their. From configuration details i got
to know that Spatial datablade is installed their.

Bu using SSH, i can log into the remote terminal, but thing is am not able to
start blade manager or DBAccess.I can see those files in %informix%/bin but
they don't run. It gives me error "command not found".

Does any one know how to register spatial datablade while using IBM IDS on
amazon cloud.

thanks




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [250]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: mi_process_exec and shared memory
Posted by: jgoldrick@judsonu.edu (JIM GOLDRICK) - Thu, 15 Apr 2010 11:18:42 EDT
>
>
I bet you say that to all the girls!

--
Cheers,
Obnoxio The Clown

True, but for some reason they never understand me.

Anyway, I am now posting from the web.
I would like to start an external process from a trigger. So, I am looking at
the example on mi_process_exec() which is supposed to do a fork (I don’t want
to wait for the process to run). But I would like to make sure that this exec
call will not run in the Informix shared memory. Does anyone know if the
mi_process_exec() will use shared memory?

Also, anyone know why my messages were garbled?

Thanks,

Jim




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [249]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: mi_process_exec and shared memory
Posted by: obnoxio@serendipita.com (Obnoxio The Clown) - Thu, 15 Apr 2010 11:04:37 EDT
Goldrick, Jim wrote:
> #
> ..•Ùb‘ëh²Ö«µ©ÞÆ׫�©i®‡²Çë¢f­®(
>
z´¨!©¥¢‰"ž­¶žÅ©©•ê'š*k¡Ç¬±ì^sbr¬²êi¢Ç�¶‡hiú+�‡hžÜžÛhÁ¨­~Ší…êk¡Ç¬²Ú+ºpn´Œ(ºWeŠG­¢f¤zË«zØZ¶Øb±ì^qÆ¥—¥–z-®éâžØ^"wè®h±²«yÙžšŠò‡¬j|¨�é'£Ÿ¶¦Ššèqë,{œÂ)eºÇ¬…ªÞvg¦¢¼ˆ¶¬ŠÛ(Âzk¡Ç¬²'n�׫¶®±êçjg¨ž‹«µë-™§!Šw§¢Ò'~Šæ‹
>
>
>

>
>
>
I bet you say that to all the girls!

--
Cheers,
Obnoxio The Clown

http://obotheclown.blogspot.com
I will now proceed to pleasure myself with this fish.

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [248]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

FW: mi_process_exec and shared memory
Posted by: jgoldrick@judsonu.edu (Goldrick, Jim) - Thu, 15 Apr 2010 10:57:56 EDT
#
..•Ùb‘ëh²Ö«µ©ÞÆ׫�©i®‡²Çë¢f­®( z




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [247]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

mi_process_exec and shared memory
Posted by: jgoldrick@judsonu.edu (Goldrick, Jim) - Thu, 15 Apr 2010 10:52:57 EDT
#
..•Ùb‘ëh²Ö«µ©ÞÆ׫�©i®‡²Çë¢f­®(
z´¨!©¥¢‰"ž­¶žÅ©©•ê'š*k¡Ç¬±ì^sbr¬²êi¢Ç�¶‡hiú+�‡hžÜžÛhÁ¨­~Ší…êk¡Ç¬²Ú+ºpn´Œ(ºWeŠG­¢f¤zË«zØZ¶Øb±ì^qÆ¥—¥–z-®éâžØ^"wè®h±²«yÙžšŠò‡¬j|¨�é'£Ÿ¶¦Ššèqë,{œÂ)eºÇ¬…ªÞvg¦¢¼ˆ¶¬ŠÛ(Âzk¡Ç¬²'n�׫¶®±êçjg¨ž‹«µë-™§!Šw§¢Ò'~Šæ‹




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [246]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: phonetic datablade
Posted by: CSA@dk.ibm.com (Claus Samuelsen) - Tue, 23 Mar 2010 11:35:07 EDT
There is a Soundex bladelet. I'm not sure that it is still downloadable,
but you can find all the coding and how to use it in the RedBook
"Customizing Informix Dynamic Server for Your Environment". You can cut
and paste the C coding from the PDF file. It's all in chapter 8.5 and
appendix A.

Med venlig hilsen / Yours sincerely

Claus Samuelsen
Senior IT Specialist
IBM SWG Information Management

phone: +45 2880 3058
e-mail: csa@dk.ibm.com

From:
"BEVIS KENNEDY" <bkennedy@utah.gov>
To:
datablade-list@iiug.org
Date:
23-03-2010 15:30
Subject:
phonetic datablade [242]
Sent by:
datablade-list-bounces@iiug.org

Hi all,

Does anyone know of an existing phonetic datablade?
I have been tasked with coming up with a phonetic search tool. My first
instinct is to see if anyone has already created a datablade for this
purpose.

Thanks in advance.






Medmindre andet er angivet ovenfor: / Unless Otherwise Stated Above:
IBM Danmark ApS
Nymøllevej 91
2800 Kongens Lyngby, Danmark
CVR nr.: 65305216




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to datablade-list@iiug.org
2. Include the bracketed message number in the subject line: [245]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *