Hi,

I am looking into migrating a database from DB2 on z/OS to Oracle on
Windows.

I am quite new to databases and would appeciate any information on
free programs that do this or a good process for carrying this out.

Thanks,

Noel

goooooglegroups (AT) yahoo (DOT) com wrote in news:1179611855.163288.167510
@q75g2000hsh.googlegroups.com:

Let's review.
You are "new to databases".
This means that you don't know DB2.
This means that you don't know Oracle.
Please explain what qualifications you bring to this task & why you were
chosen to complete it?
Do you know & can you program in SQL?
Do you expect a point & click GUI to do EVERYTHING for you?

goooooglegroups (AT) yahoo (DOT) com wrote:
If your organization has enough money to have DB2 on z/OS there is
essentially no excuse for moving to Windows, definitely no excuse
for looking for free software, and absolutely no excuse for passing
this to someone with zero training.

More information and version numbers required. Before I would offer
help some assurances that this isn't just a troll. Because what you
wrote above is outrageous and an absolute guarantee of failure.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ana C. Dent wrote:

Why else would you go to Windows?
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGUA8GLw8L4IAs830RAqdOAKCIe4SnToYg6vvNpThLcu hldwq+QgCgjkN8
hHexevxCTK34hEnbT1n2FUY=
=WoSq
-----END PGP SIGNATURE-----

On May 20, 1:18 am, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
Hi,

The example I gave of migrating from DB2 on z/OS to Oracle on Windows
is just one example - in general I want to be able to move a database
from Oracle to DB2, and vica-versa, on both Windows and z/OS.

Even a process to move the data from DB2 on z/OS to Oracle on Windows
would be a good start as I already have the database structure setup
on both, but ideally I would like to take a database on DB2 (z/OS) and
create a similiar one on Oracle and then copy across all the data.

I see Oracle have a tool

http://www.oracle.com/technology/tec...nch/index.html

which handles most of this, however it does not handle migrating from
DB2 on z/OS to Oracle on Windows, hence why I am tackling this
particular setup.

The version of Oracle I am using is 10.2.0 the version of DB2 I am
using is 9.

I would have thought that this would be a common thing to do and thus
would have a solution that was well known among the database community
- so I am just looking for some help\guidance.

Thanks,

Noel

goooooglegroups (AT) yahoo (DOT) com wrote:
You haven't given any indication of the amount of data or the type of
application. OLTP or DSS? Megabytes or Petabytes? You've given no
indication of the migration windows or any other business rules. Nor
have you indicated whether what you intend is migrating only heap tables
or whether other object types, code, etc. are involved.

The only thing you have clearly communicated is that a very large and
financially successful organization has turned a critical task over to
someone with zero experience: A recipe for failure.

I have done what you are asking about numerous times. And it is
relatively straight-forward. But I'll not help someone fake their
credentials and ruin a company. You need to do far better to get help
from me and I suspect others here are reacting the same way.

Doesn't your management have a single person on the team who is
qualified to do the work? If not hire a consultant. I could easily
recommend one if you want and if so contact me off-line.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Sun, 20 May 2007 11:04:06 +0200, Frank van Bortel wrote:

Because Windows are, contrary to the popular belief, superior to Linux
in many aspects. One of the things Windows does far better then Linux
is I/O. On Linux, SCSI drivers are an emulation used to access things
like ATAPI DVD burners. That means an interrupt more for every SCSI disk
access on Linux which slows things down. Also, NTFS can do both direct and
async I/O and can be used in a cluster. It's far superior to Ext3.
Linux, on the other hand, has better memory management, primarily because
of MS idiotic refusal to implement shared memory and the usual IPC
primitives. The thread architecture of Windows means that the only way
that that two tasks have to share access to the same part of memory is to
run within the same process, as tasks. In that case, they share the entire
address space and their combined address space cannot exceed 4GB (32 bit).

On Windows, your SGA size is limited by the OS architecture, but
synchronization mechanisms are quite a bit cheaper. Mutexes are not
implemented as a separate device and are quite a bit faster then
semaphores. For a small database, with very few users, Windows will
probably be faster then Linux.

I'm a long time Unix user, having started with now forgotten Ultrix
and having worked with a large variety of exotic Unix varieties like
Wyse Unix, Irix or Bosix (Groupe Bull), I am very disappointed with the
quality of Linux. I am a Red Hat user since the version 5 and I am using
Linux because Unix-like operating systems are more familiar to me then
Windows, but I have no illusions about the quality of Linux.
Unfortunately, overall quality of Windows isn't much better, either.

Unix, on the other hand, is an ancient OS, in desperate need of a thorough
overhaul. SUN realized that and their Solaris is a significant departure
from the accepted Unix standards. Unix still can only return 8 bits as a
status code, Unix still doesn't have record management system and a lock
manager, Unix still doesn't have but a rudimentary system of privileges
and access control, Unix still doesn't do per process I/O accounting and
has sorely inadequate monitoring tool. It doesn't take a genius to
recognize the importance of the question "which process is responsible for
the most of I/O", but it is impossible to answer that question using only
standard monitoring tools on Unix.
OS religious wars are totally besides the point and are now more a part
of the hip hop culture then a part of debate among professionals. I am a
part of R&R generation, not hip hop, I have no objections to someone using
Windows. It's an OS, neither better nor worse then the other ones for the
same platform. If you want X11 server and Perl, there is always Cygwin.
--
http://www.mladen-gogala.com

On 20 mai, 20:49, Mladen Gogala <mgogala.SPAM_ME.... (AT) verizon (DOT) net>
wrote:
Hmm.. Not sure what you mean here, Mladen.
Memory-mapped files can be used to share memory between processes.

--- Raoul

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Mladen,

you totally missed the point.

- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGUUc0Lw8L4IAs830RAnzIAJ4u5de/oRHlOr9JV9D6/yTMIIW9AgCfW13f
Be+ljZeGTHHHVZE0d8MiYTs=
=i0zL
-----END PGP SIGNATURE-----

On Sun, 20 May 2007 12:10:51 -0700, hasta_l3 wrote:

There are no calls like shmat, shmget or shmdet. Moreover, memory mapped
files are not shared in real time. For the change to be visible by other
processes, it has first to be flushed to the disk. This type of sharing
is completely inadequate. What is needed are standard IPC primitives, not
supported by windows. That is why Oracle has multi-threaded architecture
on Windows, as opposed to the independent processes everywhere else.

--
http://www.mladen-gogala.com