This value should be about 1% of the numbers of rows of the biggest table to be imported. In fact, an R3load process for each package defined is started at once. A prerequisite is that the table structure is not changed between the test migration and the final migration. However, the data is also imported unsorted and thus the database performance may not be optimal. If the system is large or the time frame is tight, special optimizations to the export and import process must take place. Figure 11-11 Time join diagram for MigMon B + C. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication.
The structure of this table is shown in Figure 4-1. Even the number of the physical records belonging to a logical record may change. Automate dump shipping between source and target system. Note: The unsorted export is one of the most powerful optimizations to improve the export time. . The Unicode character notation is similar to the concept described above.
If so, there are two optimizations available to overcome this bottleneck: You may run the R3szchk while the system is still up and running and used for production. The compression rate depends much more on the structure of a table. It can be used as a quick reference for experienced migration consultants. Waldemar holds a degree in Geodetic Engineering from Rheinische Friedrich-Wilhelms University in Bonn, Germany. They are compressed during the import. Export dump files are written to the application server machine.
Any sap notes would be really helpfull there was one 12904 but was removed from sap. The migration was done using the migration monitor. Figure 11-12 Time join diagram for MigMon A + C. If the cluster ratio is not optimal, data pages will not be read continuously, but there will be mechanical movements of the disk heads on the spindles. Tools overview 19 Figure 3-2 illustrates the tasks performed by R3ldctl and R3szchk.
Advanced optimization techniques Chapter 6. For example, the following options are available for a source system during a heterogeneous system migration: Export preparation Table splitting preparation Database Instance export 3. Table 10-7 lists the additional hardware requirements for Unicode. The next chapter explains how this can be achieved. Once the tables are split. Therefore, we recommend comparing the actual number of records on the source and target database. For our test, we used the tables listed in Figure 4-5 on page 44.
However, not all tables can be exported in this way. Uncompressed loadExample A-6 shows the import monitor properties file for uncompressed load and subsequent compression triggered by R3load. You can use these tools both for homogeneous and heterogeneous system copies. Be aware that creation of additional indexes can impact production operation, as this requires additional hardware resources and may also affect the access plans of queries. Since the check and adjustment for this can only be done in a system that supports Unicode, you must provide such a system. Figure 4-5 Tables for export comparison The tables were exported with the following options: Non-Unicode with sorted export Non-Unicode with unsorted export Unicode conversion with sorted export Unicode conversion with unsorted export which is ignored for cluster tables Four parallel processes were used for each case. Analyzing such systems might be complex and time consuming.
Split structure files for which the tables exceed a defined size limit. Time: The runtime required to import the table Using this information you can easily identify the tables that contribute mostly to the import time of a package that comprises more than one table. Readers interested in more details can find the in-depth information beginning with Chapter 3, Tools overview on page 17. Restrictions for the migration procedure due to Chapter 1. A good starter is to use the planned configuration for production. This table splitting approach is used for very large tables to improve the export and import runtime.
Therefore, you get a good and fast overview of the packages that require the most time. This file consists of two parts. Note: Do not set the jobNum parameter to 0. To improve the export performance of those tables, they may be split into pieces using the table-splitting technique described in 5. However, since Solaris and Linux are on different code page, would that cause an issue? Java, Solaris, and all Java-based trademarks are trademarks of Sun Microsystems, Inc. In this section we describe the most prominent options. These options improve the migration throughput but must be planned and executed carefully.
Tools that are used for heterogeneous system copies are often also referred to as migration tools. The list is sorted descending by the export time. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental. We performed tests with these techniques and different options that are available for the corresponding tools. If you have a table with many indexes, it seems to be more effective to create the indexes before the data is loaded and with more significant effect if parallel insert is used. In most cases the majority of the project runtime and efforts are spent on the application-related conversion tasks. Using this parameter you can use a R3load executable different from the one in the kernel directory.
Export packages are distributed among two groups. Instead of the dataCodepage like on the export part , the dbCodepage must be set to the Unicode code page. This implies that those systems must be converted to Unicode. Parallel processing no matter which tool is used. Especially for tables with many columns, the db2look method needs more time than for tables with fewer columns. The reason is that the sorted unload of table clusters can have runtimes that are by far higher than those of an unsorted export. Any references in this information to non-ibm Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites.