By IBM Redbooks, Whei-Jen Chen
DB2 common Database (DB2 UDB) has lengthy been recognized for its expertise management. This IBM Redbook is an informative advisor that describes find out how to migrate the database approach from Oracle to DB2 UDB model 8.1 on AIX, Linux, and the Microsoft home windows platform. This advisor provides the easiest practices in migration process and making plans, migration instruments, and sensible migration examples. it truly is meant for technical employees who're fascinated with an Oracle to DB2 UDB conversion project.This Redbook presents migration making plans guidance, with step by step directions for fitting and utilizing IBM Migration Toolkits (MTK) to port the database gadgets and information from Oracle to DB2 UDB. It illustrates with examples tips on how to convert the kept approaches, features, and triggers. software programming and conversion concerns are mentioned in addition to the variations in positive factors and performance of the 2 products.In addition, you'll find script conversion samples for facts loading, database management, and experiences, that are important for DBAs. The checking out part offers methods and guidance for conversion trying out and database tuning.
Read Online or Download Oracle to DB2 UDB Conversion Guide PDF
Similar databases books
It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can continually come up over the proper meanings of phrases, misunderstandings which could have a major influence at the good fortune of your database initiatives. for instance, listed here are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating workforce, sign up for dependency.
Extra info for Oracle to DB2 UDB Conversion Guide
The larger the amount of data you have, the longer and more sophisticated your strategy will become, especially if you need your database always on line. This section gives you some of the basics, and points you to much more information. • Replication: The DB2 UDB replication feature enables you to transfer data between systems for the purpose of building new data stores, or for duplicating some, or all of the original data in another DBMS. • High availability: High availability ensures that your data sources are always available for use (regardless of failures in hardware and software).
The translator requires that all of the dependent objects for the SQL that you wish to convert are available to MTK. ) • The objects on which the SQL statement depends will be created in the SQL Translator window by placing them before the SQL that is to be converted. 2 MTK planning MTK runs on a variety of operating system platforms including AIX, Linux, Sun Solaris, and Windows. Before installing MTK, please verify the hardware and software requirements provided in this section. 2 Hardware requirements The hardware requirements for installation of MTK on UNIX platforms are: • 50 MB of disk space for installation • 5 MB per project plus space to unload data • 128 MB minimum memory recommended.
Large tablespace is designed to store long character or LOB type data. • Temporary tablespace is designed to store temporary tables. A user cannot define a permanent table in a temporary table space. Note Only users with SYSADM or SYSCTRL authority can create table spaces. Table 4-4: Differences between SMS and DMS table spaces Table space type Can dynamically increase the number of containers in a table space Can store index data for a table stored in a separate table space Can store long data for a table stored in a separate tablespace One table can span multiple table spaces Space allocated only when needed Table space can be placed on different disks Extent size can be change after creation SMS table space SMS No No No No Yes Yes Yes DMS Yes Yes Yes Yes No Yes No This type of table space stores its containers in the form of operating system directories.