473,385 Members | 1,782 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,385 software developers and data experts.

DB2 migration issue from AIX to Linux

DB2 migration issue from AIX to Linux

I am trying to migrate database from AIX box to Linux box using the
db2move and db2look command. Everything worked fine for the tables with
user defined schema. But I am facing problem with four tables under the
schema SYSTOOLS. So I tried db2look for these four tables..what happens
is it is connecting to the database, but not extracting the DDL for
these tables, I tried for single table and all tables at once, but no
use. Without generating the DDL it's simply terminating from the
database. So is it possible to extract DDL for objects in schema
SYSTOOLS, if yes how should I further proceed.

Thanks in advance,
Kamal.

Jun 29 '06 #1
2 7243
Kamal:

DB2 CREATE TOOLS CATALOG USE EXISTING DATABASE

check in the DB2 COMMAND REFERENCE for further instructions.

cheers...
Shashi Mannepalli
Gladiator wrote:
DB2 migration issue from AIX to Linux

I am trying to migrate database from AIX box to Linux box using the
db2move and db2look command. Everything worked fine for the tables with
user defined schema. But I am facing problem with four tables under the
schema SYSTOOLS. So I tried db2look for these four tables..what happens
is it is connecting to the database, but not extracting the DDL for
these tables, I tried for single table and all tables at once, but no
use. Without generating the DDL it's simply terminating from the
database. So is it possible to extract DDL for objects in schema
SYSTOOLS, if yes how should I further proceed.

Thanks in advance,
Kamal.


Jun 30 '06 #2

Shashi Mannepalli wrote:
Kamal:

DB2 CREATE TOOLS CATALOG USE EXISTING DATABASE

check in the DB2 COMMAND REFERENCE for further instructions.

cheers...
Shashi Mannepalli
Gladiator wrote:
DB2 migration issue from AIX to Linux

I am trying to migrate database from AIX box to Linux box using the
db2move and db2look command. Everything worked fine for the tables with
user defined schema. But I am facing problem with four tables under the
schema SYSTOOLS. So I tried db2look for these four tables..what happens
is it is connecting to the database, but not extracting the DDL for
these tables, I tried for single table and all tables at once, but no
use. Without generating the DDL it's simply terminating from the
database. So is it possible to extract DDL for objects in schema
SYSTOOLS, if yes how should I further proceed.

Thanks in advance,
Kamal.


Thanks a lot shashi...

Kamal

Jun 30 '06 #3

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

Similar topics

4
by: Azhar Bilgrami | last post by:
Dear Hi: Hope to see u in good health. " I want to migrate a database which is currently running Unix as Operating System and Oracle ver 6 as Database, it is also using oracle froms version 3...
2
by: Pawel Gruszka | last post by:
Hello! I need a mdb 2 PostgtreSQL migration tool (something similar to pgAdmin plugin - "Database migration wizard") that don't needs M$ Windows or XWindow. It should also transfer data and...
7
by: Dave | last post by:
We are trying to migrate a MS SQL server app to DB2 8.1 Linux platform. Our database has got about 300+tables with total size - 150 GB We are using MS SQL's BCP utility to extract data from...
5
by: Christophe Musielak | last post by:
Hi everyone at the list, Some months ago i asked you some questions about 7.2 - 7.4.3 migration. Then i switched to the performance list to complain about postgres 7.2 poor performance and...
7
by: pkr | last post by:
Hi, In my shop, we have database in diverse platforms like mainframe, Linux, Windows 2000. We are planning to consolidate all iDB in a single platform and build one big monster DB, this monster...
60
by: Shawnk | last post by:
Some Sr. colleges and I have had an on going discussion relative to when and if C# will ever support 'true' multiple inheritance. Relevant to this, I wanted to query the C# community (the...
0
by: Gladiator | last post by:
DB2 migration issue from AIX to Linux I am trying to migrate database from AIX box to Linux box using the db2move and db2look command. Everything worked fine for the tables with user defined...
9
by: Troels Arvin | last post by:
At work, some people have found IBM's Migration Toolkit (MTK) to be a nice tool for copying data from one table (in another DBMS product) to DB2. Now, they want to do the same thing from one DB2...
1
by: danths | last post by:
Hello: We are trying to migrate DB2 Source: DB2 8.1 + Fixed Pack 5 on Sun Solaris -Target: DB2 9.X on Red Hat Linux . using db2move command we are trying out the migration. However one of the...
8
by: Tomasz J | last post by:
Hello developers, After migrating my web project application (using the old model) to .Net Framework 3.5 and Ajax Control Toolkit release 20820 the Accordion control no longer works correctly....
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
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
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.