tag:blogger.com,1999:blog-64326781087374875452011-04-21T18:12:25.014-07:00duduhttp://www.blogger.com/profile/07640220666785289980noreply@blogger.comBlogger11100tag:blogger.com,1999:blog-6432678108737487545.post-20834722987008289462008-11-19T05:42:00.000-08:002009-01-27T06:27:37.034-08:00<span style="font-family:courier new;">1. Get IBM Data Server Client from here </span><span style="font-family:courier new;"></span><span style="font-family:courier new;"><span style="font-size:85%;"><a href="https://webmail.webox07.com/OWA/redir.aspx?C=8d176f665375426e88993a3d83a05cbb&amp;URL=http%3a%2f%2fwww-01.ibm.com%2fsoftware%2fdata%2fdb2%2fexpress%2fadditional-downloads.html" target="_blank"> http://www-01.ibm.com/software</a><a href="https://webmail.webox07.com/OWA/redir.aspx?C=8d176f665375426e88993a3d83a05cbb&amp;URL=http%3a%2f%2fwww-01.ibm.com%2fsoftware%2fdata%2fdb2%2fexpress%2fadditional-downloads.html" target="_blank">/data/db2/express/additional-downloads.html</a></span></span><br /><span style="font-family:courier new;"><br />2. It should be named like </span><span style="font-family:courier new;"><span style="font-weight: bold;">v9.5_linuxia32_rtcl.tar.gz</span></span><span style="font-family:courier new;"><span style="font-size:85%;"><span style="font-weight: bold;"><br /></span></span></span><br /><span style="font-family:courier new;">3. Install it using XWindows GUI installation: rtcl/db2setup<br /><br />4. During the installation process create a user named db2inst1<br /><br />5. In a case of the successful installation perform the following steps:<br /><br />5.1 [...~]$ su - </span><span style="font-family:courier new;">db2inst1<br />5.2</span><span style="font-family:courier new;"> [...~]$</span><span style="font-family:courier new;"> db2<br />5.3 => CATALOG TCPIP NODE <span style="font-weight: bold;">MY_NODE</span> REMOTE remote_host SERVER <span style="font-weight: bold;">50000</span><br />5.4 => CATALOG DB <span style="font-weight: bold;">MY_DB</span> AT NODE <span style="font-weight: bold;">MY_NODE</span><br />5.5 => terminate<br />5.6 </span><span style="font-family:courier new;">[...~]$</span><span style="font-family:courier new;"> isql -v MY_DB <user> <passwd><remote_db_user> <remote_db_password><remote_user_name> <remote_password><br />5.7 SQL> SELECT * FROM <span style="font-weight: bold;">MY_TABLE</span></remote_password></remote_user_name></remote_db_password></remote_db_user></passwd></user></span><br /><span style="font-family:courier new;"></span><span style="font-family:courier new;"><span style="font-size:85%;"><br />Interested in PostgreSQL? See the following blog: <span style="text-decoration: underline;"><a href="http://postgre-sql.blogspot.com">PostgreSQL</a><br /><br /></span></span></span><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/6432678108737487545-2083472298700828946?l=db2-sql.blogspot.com' alt='' /></div>duduhttp://www.blogger.com/profile/07640220666785289980noreply@blogger.com1