imam fahrur rozi

User could use the following asadmin create-domain command to create a domain1 with saved credential.

$GF_INSTALL/bin/asadmin create-domain –user admin –adminport 4848 –profile developer –passwordfile mypasswordfile –savemasterpassword=true –savelogin=true domain1

The following files are very important and make sure you don’t delete them.

# ls -lF ~/.asadminpass

-rw——-   1 root    root         110 Apr  3 11:19 //.asadminpass

# ls -lF ~/.asadmintruststore

-rw——-   1 root    root         808 Apr  3 11:19 //.asadmintruststore

# ls -lF /opt/glassfish/domains/domain1/config/admin-keyfile

-rw——-   1 root    root         116 Apr  3 11:19 /opt/glassfish/domains/domain1/config/admin-keyfile

/opt/glassfish/bin/asadmin create-domain

Usage: create-domain [--user admin] [--adminport port_number] [--terse=false] [--echo=false] [--interactive=true] [--domaindir
domain_directory] [--profile profile_name] [--template domain_template]  [--passwordfile filename ] [--instanceport
port_number] [--savemasterpassword=false] [--domainproperties (name=value)[:name=value]*] [--portbase portbase] [--savelogin=false]
[--checkports=true] domain_name

Create domain1

Start domain1

mypasswordfile

AS_ADMIN_PASSWORD=adminadmin
AS_ADMIN_MASTERPASSWORD=changeit

Hope this information helps.

ke sini aja

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
>
>

Dear Mr John,

After you gone from our office yesterday, i had re-install and configure
my IDS including the DRDA. As you have said, that the connection error
with IDS by using db2jcc.jar that appeared in my case, caused by
unconfigured DRDA. And after i install it, the error have been resolved
very well, it cold be connectd.

But there is another error while I tried to connect with the  error:
=========================================================================
ERROR :
feLoaderException: Schema load failed - feLoaderException: Replica server
load failed: com.ibm.db2.jcc.b.SqlException: IDS SQL Error: SQLCODE=-256,
SQLSTATE=IX000, SQLERRMC=null, DRIVER=3.50.152
=========================================================================
Do you have any suggestion for me to resolve the problem please..

Thank you

Regards,
Imam F Rozi
RCS - Solusi247
Segitiga Emas Business Park unit no.6
Jl. Prof. Dr. Satrio kav. 6, Jakarta 12940
Phone: +62 21 57951133,
Fax: +62 21 57951138

>Dear Imam,
>
>         Good to hear that you had setup the DRDA driver to connect to
> Informix database.. The current error mentioned below is  due to  that
> your current IDS database does not support  transaction. The default
> logging mode of IDS database is no logging mode  and hence your BEGIN WORK
> or COMMIT WORK statement will not work.  I recommend you to create a
> database with transactional logging enabled.
>
> dbaccess -> database -> create -.>RCStest -> Log -> buffered or log ->exit
> -> create database.
>
> Also  kindly send me  the sample  connectivity program ,  so that I may
> understand which step  is causing you an error.
>
> I have attached  the  Lab cache presentation for your reference on how to
> setup and test the IDS Cache with soliddb.
>
>
>
> kindly let me know if you need any further assistance.
>
> Regards,
> John Isaac
> Information Management Architect
> IBM Software Group

Dear Mr John,

I have configured my solid.ini, and change the durability level of
transaction logging by mode 1 (relaxed mode). And it could increase the
performance, like in my unix machine i have. For this case, i used the
persistent table in the windows env.
Thank you for the advise, and i have enclosed the pmon.out file i have.
Thank you.

Regards,
Imam F Rozi
Radar and Communication System (RCS) Div
Solusi247

--- laporan gw ke John Christopher Issac (Information Management Architect IBM Software Group, ASEAN) klo udah bs nemuin parameter yg bisa naikin perf--
Jakarta - Indonesia