Moving a db2 database

You must have encountered this problem sometime while working on db2. It doesn't have a proper GUI for direct moving of a database from one system to another. Here are the detailed steps.

Step1:
Export using following command sequence

/>db2move databasename export

Commet: this generates files Export.out - ASCI info about export db2move.lst - has table info tabn.ixf - info exchange format, holds data .msg -message files tabna.nnn - large object data

/>db2look -d databasename -e -a -o outputfilename.sql

Comment: generates the sql file holding DDL data

Step2:
move all files to the target system

Step3:
Import using following command sequence

/>db2 create databasename
comment: creates the database
/>db2 -tvf sqlfile.sql
comment: structure the generated database with the sql file from the export
/>db2move databasename load

/*HURRAY DATABASE MOVED */

Design Phase - 3

Continuing further, we see the drawing of sequence diagram. Check the tutorial here. This diagram shows the various actors we have from our use case diagrams interact with the various classes in our class diagram. This UML specified the object to object message passing via various operations.

Eclipse - Problems and solutions

People encounter a lot of nerve wrecking problems, not while installing or using eclipse but while configuring it for particular project requirements. Here are a few common problems are their solutions.

¿   Cannot find Data source explorer view

√  You are using the wrong type/version of eclipse. You need to download the eclipse package for Java EE      developers

¿  Cannot install WAS CE 2.0 in Eclipse ganymade. Gives dependency problems error message.

√ There is no WAS CE plugin available for Eclipse ganymade(3.4). You need to use the older Eclipse Europa(3.3) to solve this dependency issues.

¿ Cannot install WAS CE plugin directly even in Eclipse Europa

√ You need to install the database plugin before installing WAS CE plugins.

¿ the instruction at "0x7c93426d" referenced memory at "0x00000000"

√ Your installation is faulty/ is corrupted. Reinstalling eclipse will solve this problems

Design phase - 2

Continuing further from use cases, we reach the part of designing classes for the users and for different uses they do the system. Again on rational ROSE we've developed the following class diagram. (see this to learn how to draw class diagrams in UML). The next time I write about class diagrams, it would be expanded to its fullest possible extend. Catch a glipse of this to get a sneak peak on UML,

[caption id="attachment_18" align="aligncenter" width="497" caption="Class_diag_ver_1"][/caption]

Design phase - 1

After figuring out the host of technologies we reqire to our enterprise project and after our really long chat out at coffee day on 15th july Rahul and me immersed ourselves with design duties. He'll come around with the databases(DB2) soon with all the research work coming up from jan. Now into the tech stuff.

We used a trial version of IBM's ROSE to develop the following use case UML diagram. (see this to learn how to draw use case diagrams). After a few hours of pondering i've come up with the following use case view


[caption id="attachment_11" align="aligncenter" width="497" caption="UML_USE_CASE"][/caption]