Dear Mr. John,

I am very well, thank you so much for your kindliness :)
And I would love to say thanks for the solution given by you.
While i am waiting for your reply, i have been learning
about spatial database. And I have tried to render some
spatial data (from flat file) by using a desktop   GIS freeware.

I would like to try to store that spatial data to IDS.
But I couldnt find out the trial version for Spatial DataBlade
and also DataBalde's Tool. And by reading
http://www-01.ibm.com/software/data/informix/downloads.html, It was said
that the trial version could be got from the IBM's Sales.

Could you help me again Mr John? Pardon me, if I have made you
facing some bustle

Thank you
Imam F Rozi
Radar and Communication System
Solusi247

> Hi Imam,
>
> How are you?..
>
> We have simulated the error in our setup and found that there is locking
> issue  when you write into back end database.
> You can resolve the issue  the below command in the informix side.
> ALTER TABLE "TARGET_TABLE" LOCK MODE (ROW);
>
> In Informix , the default locking  level is PAGE  and hence  you need to
> change the  table definition..ROW level locking .
>
> 1.You can create table with lock  level Row.
> create table "TARGET_TABLE"
> ("ID_TARGET" integer not null primary key,
> "VALUE_BEARING" smallint,
> "RANGE_TARGET" float,
> "RCS_TARGET" float,
> "DOPPLER_TARGET" float,
> "TIME_TARGET" float,
> "STATUS_TARGET" smallint)
> LOCK MODE ROW;
>
> 2. You can alter the table
>
> 3. You can change DB parameter to behave default as row level..
>
>
> Regards,
> John Isaac
> Information Management Architect
> IBM Software Group, ASEAN           eMail:isaacjc@sg.ibm.com
> Tel:+65-64182032   Mob:+65-96336427
> ----------------------------------------------------------------------------
> IBM Accreditated
> IBM Certified Advanced Database Administrator
> IBM Certified Application Developer
> IBM Certified DB2 9 Database Administrator
> IBM Certified Solution Designer -- DB2 Data Warehouse Edition V9.1
>
>
>
> From:
> Kyosti Laiho <kyosti.laiho@fi.ibm.com>
> To:
> "imam f" <imam.rozi@solusi247.com>
> Cc:
> beno.pradekso@solusi247.com, "imam f" <imam.rozi@solusi247.com>, John
> Christopher Isaac/Singapore/IBM@IBMSG, ya.kirana@solusi247.com
> Date:
> 09/16/2008 03:16 PM
> Subject:
> Re: SolidDB & IDS
>
>
>
>
> Hi,
>
> A quick (but intermediate) update from my side. I was able to reproduce
> the problem here using the files you sent (small modifications here and
> there, but otherwise very much the same).
>
> The problem occurs when using the 10ms sleep time between the inserts to
> solidDB. The 'solconnector' is having two JDBC connections to Informix (to
> replicate the inserts to Informix), but then for some reason, the insert
> fails to Informix with error code
> -271 Could not insert new row into the table.
>
> We are currently looking into this, e.g. why the error is there. [John,
> any possible input from your side?]
>
> When I used 100ms sleep, or 1s sleep, the problem did not happen (at least
> as quickly after the beginning of the test).
>
> I will continue and do more testing, and hopefully return back to you soon
> with more info.
>
> Best Regards,
> Koppa
>
>
> From:
> "imam f" <imam.rozi@solusi247.com>
> To:
> Kyosti Laiho/Finland/IBM@IBMFI
> Cc:
> "imam f" <imam.rozi@solusi247.com>, beno.pradekso@solusi247.com,
> isaacjc@sg.ibm.com, ya.kirana@solusi247.com
> Date:
> 12.09.2008 12:37
> Subject:
> Re: SolidDB & IDS
>
>
>
>
> Dear Koppa,
>
> I included some config files in this mail.
> Thank you
>
> Regards,
> Imam F Rozi
>
>> Hi,
>>
>> This problem sounds something that seems to be quite easy to reproduce?
> In
>> terms of trying to save (your) time, and avoid (my) guessing... Would it
>> be possible for you to send to me info about the test setup, so that I
> can
>> take a look, and try to reproduce it here as well? This would make it
> much
>> faster for us to investigate where the problem is. I can then check the
>> issue with solidDB R&D guys as well. Is the test data something that is
>> fairly generic and ok to send, or are there some confidential parts? So,
>> if only possible, what I would like to see is the following:
>> - the table schema in informix (sql statement to create the table and
> all
>> constraints, like the primary key)
>> - the table schema in solidDB
>> - the test program (preferably with source code) that you use for
>> inserting the data to solidDB
>>
>> Best Regards,
>> Koppa
>>
>>
>>
>> From:
>> "imam f" <imam.rozi@solusi247.com>
>> To:
>> Kyosti Laiho/Finland/IBM@IBMFI
>> Cc:
>> "imam f" <imam.rozi@solusi247.com>, beno.pradekso@solusi247.com,
>> isaacjc@sg.ibm.com, ya.kirana@solusi247.com
>> Date:
>> 12.09.2008 07:28
>> Subject:
>> Re: SolidDB & IDS
>>
>>
>>
>> Dear Koppa,
>>
>> I just replicate a table with a column as primary key inside. And when i
>> restarted the solconnector in propagator mode again, the next data could
>> be catched-up from front end and inserted in the back-end immediately.
>> Then, the error appeared again. I restarted again, catch-up and
> propagated
>> next data to back-end done succesfully, and the error appeared again,
> and
>> soon.
>> Thank you so much Sir.
>>
>> Regards
>> Imam F Rozi
>> Radar and Communication System
>> solusi247
>> Jakarta - Indonesia
>>
>>> Hi,
>>>
>>> Based on the error.txt, propagating an insert statement from solidDB to
>> Informix failed, but the output data does not yet show why. Could it
>> possible that the inserted values have a problem (uniqueness of values,
>> or
>>> other constaints in the backend), is someone else locking any rows in
>> Informix, or any other apparent reason why Informix would 'reject' the
>> insert? If there is, the solconnector.jar is not able to continue with
>> the
>>> inserts, and then exits.
>>>
>>> Did you try to restart the solconnector.jar, and%[attachment "att.zip"
> deleted by Kyosti Laiho/Finland/IBM]
>
>
>
> Ellei edellä ole toisin mainittu: / Unless stated otherwise above:
> Oy International Business Machines Ab
> PL 265, 00101 Helsinki, Finland
> Business ID, Y-tunnus: 0195876-3
> Registered in Finland
>
>