tag:blogger.com,1999:blog-5700399228771658115.post1395405495159267965..comments2024-03-09T12:01:19.288+03:00Comments on Techie Architect: Configure Squirrel SQL to connect to IBM DB2Ashraf Fouadhttp://www.blogger.com/profile/08164634185768329685noreply@blogger.comBlogger64125tag:blogger.com,1999:blog-5700399228771658115.post-79048067041086799842018-02-05T07:24:56.023+03:002018-02-05T07:24:56.023+03:00I tried but getting the error as
java.util.concu...I tried but getting the error as <br /><br />java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][3.69.24] The application server rejected establishment of the connection.<br />An attempt was made to access a database, DEBTPBD9, which was either not found or does not support transactions. Bhabanihttps://www.blogger.com/profile/05861489953484789614noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-40306220803028990482017-09-28T02:50:29.457+03:002017-09-28T02:50:29.457+03:00Squirrel SQL is lightweight client that provides U...Squirrel SQL is lightweight client that provides UI, I thought you have installed it on your PC not the server. If you have SSH access to the server how you will manage to run the GUI of squirrel SQL?<br /><br />I recommend:<br />1- Installing Squirrel SQL on your PC.<br />2- Copy the two jar files to your PC.<br />3- Add the classpath (steps 1 to 7).<br />4- Open the ports to connect to MySQL, Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-58099090527851162752017-09-28T02:43:08.924+03:002017-09-28T02:43:08.924+03:00where I have to install? in the server of Mysql or...where I have to install? in the server of Mysql or db2? , really I have the two databases in the same machineANDREShttps://www.blogger.com/profile/04548693142409442071noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-86513477856687994892017-09-27T20:33:40.994+03:002017-09-27T20:33:40.994+03:00Where did u install squirrel sql?Where did u install squirrel sql?Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-40500438200112092242017-09-27T17:58:05.616+03:002017-09-27T17:58:05.616+03:00really in my pc I don't have installed nothing...really in my pc I don't have installed nothing because I work direct in the server by ssh.<br /><br />As I said I am working on a migration from a database from mysql to db2.<br /><br />I installed a program called IBMdatamovetool in the same directory that the I have installed db2 in the server but and I run it and this problem appear<br />Driver com.ibm.db2.jcc.DB2Driver could not be loadedANDREShttps://www.blogger.com/profile/04548693142409442071noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-56919521149823345022017-09-27T16:56:29.814+03:002017-09-27T16:56:29.814+03:00These jars exists in the server, you need to copy ...These jars exists in the server, you need to copy them to yr PC that u have installed squirrel sql to.<br />I think yr PC is normally a windows PC or am I missing something?Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-71616892370989606372017-09-27T16:49:23.880+03:002017-09-27T16:49:23.880+03:00but I think that i have it:
login as: root
root@1...but I think that i have it:<br /><br />login as: root<br />root@10.0.2.81's password:<br />Last login: Tue Sep 26 20:53:25 2017 from 10.0.2.242<br />[root@ITSTSMR01 ~]# locate db2jcc.jar<br />/var/opt/IBM/DB2/V10.5/java/db2jcc.jar<br />[root@ITSTSMR01 ~]# ^C<br />[root@ITSTSMR01 ~]# cd /var/opt/IBM/DB2/V10.5/java/<br />[root@ITSTSMR01 java]# ls<br />42E32181339E47B2BF8145FD26612E69.propertiesANDREShttps://www.blogger.com/profile/04548693142409442071noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-72875041715139484922017-09-27T10:52:40.840+03:002017-09-27T10:52:40.840+03:00This error is not because u don't have access ...This error is not because u don't have access to server other than SSH, it is simply u didn't download & define jar files to yr PC not the server, you need to do this first. Either have these files from DB2 client or server installation CD or use this link to download such files:<br />https://developer.ibm.com/answers/questions/264361/Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-12431379661672524992017-09-27T05:07:15.021+03:002017-09-27T05:07:15.021+03:00the problem is that I can't or I don't kno...the problem is that I can't or I don't know how do it.<br />Really this problem is because I am doing a migration for a database mysql to db2 and I only have access to the machine through SSH (only console), can you help me?<br />I am searching documentacion but I dont found, only here. <br />thanks from colombia! (excuse me for the english)ANDREShttps://www.blogger.com/profile/04548693142409442071noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-52309704873096330442017-09-27T04:21:43.206+03:002017-09-27T04:21:43.206+03:00This means it can't find the class that is loc...This means it can't find the class that is located already in the 2 jar files you need to define in the extra classpath, please make sure you follow the steps correctly, and these two jars are accessable.Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-70737667079104651622017-09-26T23:35:02.699+03:002017-09-26T23:35:02.699+03:00hi I have this problem:
someone can help me?
jav...hi I have this problem:<br /><br />someone can help me?<br /><br />java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver<br /> at java.net.URLClassLoader$1.run(URLClassLoader.java:366)<br /> at java.net.URLClassLoader$1.run(URLClassLoader.java:355)<br /> at java.security.AccessController.doPrivileged(Native Method)<br /> at java.net.URLClassLoader.findClass(ANDREShttps://www.blogger.com/profile/04548693142409442071noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-65848740878046804682017-05-26T08:06:30.143+03:002017-05-26T08:06:30.143+03:00I tried it out...
I am getting the below exception...I tried it out...<br />I am getting the below exception -<br /><br />java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][3.59.81] The application server rejected establishment of the connection.<br />An attempt was made to access a database, z1u11, which was either not found or does not support Anonymoushttps://www.blogger.com/profile/08434377226668268886noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-63175412159997812972017-05-26T05:28:14.678+03:002017-05-26T05:28:14.678+03:00Should be:
jdbc:db2://z1u11udb.corp.cat.com:3708/z...Should be:<br />jdbc:db2://z1u11udb.corp.cat.com:3708/z1u11Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-17752753097542669172017-05-25T08:04:12.382+03:002017-05-25T08:04:12.382+03:00Hey Ashraf,
I have hostname = z1u11udb.corp.cat.co...Hey Ashraf,<br />I have hostname = z1u11udb.corp.cat.com<br />port = 3708 and instance = z1u11<br />What would my url = jdbc:db2://:/<br />look like ?<br /><br />Thanks<br />ABAnonymoushttps://www.blogger.com/profile/08434377226668268886noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-10598185664858837702017-04-28T12:45:42.468+03:002017-04-28T12:45:42.468+03:00Welcome :)Welcome :)Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-37103682810699090872017-04-27T16:46:16.255+03:002017-04-27T16:46:16.255+03:00Thanks man, quick and easy to follow guide. Helped...Thanks man, quick and easy to follow guide. Helped a ton!Danilohttps://www.blogger.com/profile/14930562583208097269noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-76436798950179678242017-04-19T12:11:16.879+03:002017-04-19T12:11:16.879+03:00WelcomeWelcomeAshraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-56367032928801071002016-12-01T20:30:46.153+03:002016-12-01T20:30:46.153+03:00:):)Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-45424556085988102712016-12-01T13:48:40.248+03:002016-12-01T13:48:40.248+03:00ThanksThanksAnonymoushttps://www.blogger.com/profile/03687185917436720874noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-31278813262407012692016-11-14T15:22:49.906+03:002016-11-14T15:22:49.906+03:00Thank you, very helpfulThank you, very helpfulAnonymoushttps://www.blogger.com/profile/16582047308361308578noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-19874751439128101222016-09-13T21:10:04.990+03:002016-09-13T21:10:04.990+03:00:):)Ashraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-24236092011854639712016-09-13T20:36:12.145+03:002016-09-13T20:36:12.145+03:00Thank you! This worked like a charm! I was able to...Thank you! This worked like a charm! I was able to do this while sitting in a meeting -- that's when you know a guide was written very well!Brandenhttps://www.blogger.com/profile/05873625613385315712noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-62180180465374400812016-07-21T07:57:19.050+03:002016-07-21T07:57:19.050+03:00ThanksThanksAshraf Fouadhttps://www.blogger.com/profile/08164634185768329685noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-43431138178027701652016-06-02T01:53:22.878+03:002016-06-02T01:53:22.878+03:00Thanks man, this is still really useful, even in 2...Thanks man, this is still really useful, even in 2016.aodaimaidhttps://www.blogger.com/profile/12918356719608300768noreply@blogger.comtag:blogger.com,1999:blog-5700399228771658115.post-68505986296064278172016-03-04T18:09:31.682+03:002016-03-04T18:09:31.682+03:00Thanks for your helpThanks for your helpAnonymoushttps://www.blogger.com/profile/00623720976981723028noreply@blogger.com