Posted by: imam fahrur rozi on: August 27, 2009
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
Starting Domain domain1, please wait.
Log redirected to /opt/glassfish/domains/domain1/logs/server.log.
Redirecting output to /opt/glassfish/domains/domain1/logs/server.log
Domain domain1 is ready to receive client requests. Additional services
are being started in background.
Domain [domain1] is running [Sun Java System Application Server 9.1.1
(build b14-fcs)] with its configuration and logs at:
[/opt/glassfish/domains].
Admin Console is available at [http://localhost:4848].
Use the same port [4848] for “asadmin” commands.
User web applications are available at these URLs:
[http://localhost:8080 https://localhost:8181 ].
Following web-contexts are available:
[/web1 /__wstx-services ].
Standard JMX Clients (like JConsole) can connect to JMXServiceURL:
[service:jmx:rmi:///jndi/rmi://localhost:8686/jmxrmi] for domain management purposes.
Domain listens on at least following ports for connections: [8080 8181 4848 3700 3820 3920 8686 ].
Domain does not support application server clusters and other standalone instances.
mypasswordfile
AS_ADMIN_PASSWORD=adminadmin
AS_ADMIN_MASTERPASSWORD=changeit
Hope this information helps.
Posted by: imam fahrur rozi on: August 27, 2009
Posted by: imam fahrur rozi on: December 21, 2008
Dear Mr. John, I am very well, thank you so much for your kindlinessAnd 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 > >
Posted by: imam fahrur rozi on: December 21, 2008
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
Posted by: imam fahrur rozi on: December 21, 2008
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
Recent Comments