Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more

x
?
Solved

DB2 ddl command

Posted on 2010-09-09
4
Medium Priority
?
1,965 Views
Last Modified: 2012-06-21
Hi all DB2 experts !

I have received from our hosting company a zipped file with the following

1. One folder called lobs with 8  *.lob files
2.  One db2move.lst having over 700 row with the format
      !"ROBINSO0"."WMMATCH"!tab683.ixf!tab683.msg!  etc etc
3.  One MAXDB71.ddl   (CLP file) which, according to the header was created with DB2LOOK v. 9.5 on AIX/64 platform

4. Lots of *.ixf and *.msg files whose number I think it matches the number of rows specified in db2move.lst

Challenges
1.  From ddl file I noticed that DB2 Manager version is DB2?AIX  Version 9.5.4.  I am supposed to restore these on a new DB2 v 9.5 running on Windows platform.  Is that possible ?

2.  If the answer at 1 is affirmative, what is the command line and/or tool(s) to run this ddl ?
     Should I put all these files in bin> folder ?

and

3.  As you probably noticed the reason to do the above is to import tables/data  from Maximo application to a new database.  Once the new db is setup I have to pass it on to the developers to work on a Java interface accessing this new backend database.  Should I start fresh with a new database or use a Maximo DB2 which I can automatically create by running Maximo application on my Windows platform

Any input and/or hint will be greatly appreciated !

Cheers

0
Comment
Question by:Bibecu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 46

Accepted Solution

by:
Kent Olsen earned 2000 total points
ID: 33642545
HiBibecu,

1.  Yes.  (The answers get trickier from here on.....)

2.  I don't know what the ddl file is.  Go ahead and put all of the files in one folder.  It's probably easier that way.

3.  It looks like the tables were dumped to a set of files with the EXPORT command.  The inverse process would be to load the data with the IMPORT command.  Both commands are part of the command line interface.

EXPORT TO filename OF {IXF | DEL | WSF}
[LOBS TO lob-path [ {,lob-path} ... ] ][LOBFILE lob-file [ {,lob-file} ... ] ]

There are more parameters to the command, but this is the key part that generated the EXPORT files, including the LOB files.

To load those files, you'll have to run an IMPORT with the correct parameters/options.

IMPORT FROM filename OF {IXF | ASC | DEL | WSF}
[LOBS FROM lob-path [ {,lob-path} ... ] ]


Kent
0
 

Author Comment

by:Bibecu
ID: 33642786
Thanks Kent,

I will try tomorrow and let you know

About the ddl file mentioned above, it can be opened with a text application such as notepad or Wordpad
It seems that there are lots of DB2 statements in it, create, updates, etc

You are right, these files were created with an export command.  Forgot to mentioned that a file called export.out was also provided with the files mentioned above

Cheers
0
 
LVL 46

Expert Comment

by:Kent Olsen
ID: 33642928

.ddl is a well known extension in the Windows world.  I was concerned that it might be a binary file instead of containing the database's DDL.


Kent
0
 
LVL 46

Expert Comment

by:Kent Olsen
ID: 33691041

I have GOT to get stronger reading glasses.  I read 'ddl' as 'dll'.  Not at all the same thing...

Apologies if I confused you.


Kent
0

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

647 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question