473,394 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

moving objects from db2 on windows to linux

Dear guys

I tried to search about this topic in forum but could not get my reply
properly, can somebody tell me the exact commands and how to right the
db2move and db2look ? I have migrated the tables and data but the
stored Procedures and also views. triggers have been left in windows,
what can i do to resolve it. I am interested to do it from the
scratch . please guide me through. Thank youu :)
Mar 8 '08 #1
4 1443
Meisam wrote:
Dear guys

I tried to search about this topic in forum but could not get my reply
properly, can somebody tell me the exact commands and how to right the
db2move and db2look ? I have migrated the tables and data but the
stored Procedures and also views. triggers have been left in windows,
what can i do to resolve it. I am interested to do it from the
scratch . please guide me through. Thank youu :)
What exactly have you tried and where exactly does it fail? Also, you care
to join with us which version(s) of DB2 you are using on the respective
platforms?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Mar 10 '08 #2
On Mar 11, 4:37 am, Knut Stolze <sto...@de.ibm.comwrote:
Meisam wrote:
Dear guys
I tried to search about this topic in forum but could not get my reply
properly, can somebody tell me the exact commands and how to right the
db2move and db2look ? I have migrated the tables and data but the
stored Procedures and also views. triggers have been left in windows,
what can i do to resolve it. I am interested to do it from the
scratch . please guide me through. Thank youu :)

What exactly have you tried and where exactly does it fail? Also, you care
to join with us which version(s) of DB2 you are using on the respective
platforms?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
dude

I have done db2look and then export everything in new database, my
windows DB2 is V9 and my Linux Db2 is version 9.5 :)
Mar 11 '08 #3
"Meisam" <me***************@gmail.comwrote in message
news:ab**********************************@e23g2000 prf.googlegroups.com...
dude

I have done db2look and then export everything in new database, my
windows DB2 is V9 and my Linux Db2 is version 9.5 :)
Check the "Command Reference" manual and make sure you used the correct
option to pull stored procedures and triggers. You will want to use your own
statement delimiter on the db2look command (such as '@') since stored
procedures and triggers have embedded ";' in them.
Mar 11 '08 #4
Meisam wrote:
On Mar 11, 4:37 am, Knut Stolze <sto...@de.ibm.comwrote:
>Meisam wrote:
Dear guys
I tried to search about this topic in forum but could not get my reply
properly, can somebody tell me the exact commands and how to right the
db2move and db2look ? I have migrated the tables and data but the
stored Procedures and also views. triggers have been left in windows,
what can i do to resolve it. I am interested to do it from the
scratch . please guide me through. Thank youu :)

What exactly have you tried and where exactly does it fail? Also, you
care to join with us which version(s) of DB2 you are using on the
respective platforms?

I have done db2look and then export everything in new database, my
windows DB2 is V9 and my Linux Db2 is version 9.5 :)
I had a good reason for asking what _exactly_ have you tried? You know...
like things you typed in and then pressed enter.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Mar 12 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Neil Zanella | last post by:
Hello, In Python, classes are objects. But there is no way to custom print a class object. This would require some syntax such as the one commented out below: With the current "foo =...
12
by: Des | last post by:
I am moving to PHP (I have C/C++ experiance) My problem is that I in converting files fromhtml to php, I can no longer test and run things localy on my PC. I could install IIS. Is there a PHP...
9
by: Norm Goertzen | last post by:
I've posted a previous question about IDEs and got some good feedback, thanks, but it does seem that everyone has their own favourite IDE -- in other words, no IDE was repeatedly recommended. ...
16
by: Kenneth McDonald | last post by:
For unfortunate reasons, I'm considering switching back to Win XP (from OS X) as my "main" system. Windows has so many annoyances that I can only compare it to driving in the Bay Area at rush hour...
2
by: MLH | last post by:
For simplicity, lets call my linux box L and my Windows box W. Both are nodes on the LAN. Here are the knowns: 1) I have an MS Access app that automates sending of eMail containing driver...
4
by: Ron Mexico | last post by:
Hi, Currently have an app that maintain that is written in VB6 and uses an access db (backend db only used as a data store not writing to the db). This app is a client app not server multi-teir...
18
by: steve.anon | last post by:
Hi I'm a Java developer moving to windows only applications. Of course the first thing I thought was "well at least, without the VM now I can write desktop applications that run real fast". So I...
3
by: AM Hulshoff | last post by:
Can someone tell me how I can move an object, in this case a listbox, over a form. The code below works, but not when the form is custom sized. It works perfectly when the form is maximized. And...
167
by: darren | last post by:
Hi I have to write a multi-threaded program. I decided to take an OO approach to it. I had the idea to wrap up all of the thread functions in a mix-in class called Threadable. Then when an...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.