DB2/LUW, Oracle, SQL-Server, ..? Corporations maintain large amounts of data in relational databases, and it is normal to find several instances for production, test and development. Refreshing testbeds from production systems is a vital part of the development, testing and quality assurance life cycle. Obtaining relevant test data requires copying from one instance to another. The window of opportunity for copying or migrating production data is constantly decreasing as the demands from 24×7 operations are increasing. Limited resources and shrinking batch windows make data delivery to QA difficult.
XDM quickly and efficiently copies, refreshes and replicates databases, tables, views, etc. XDM copies within the same or to different DBMS systems. A XDM copy task integrates both, the physical data movement and the appropriate DDL treatment. It copies tables and databases and creates the data objects at the target if they are not yet present. XDM always chooses the fastest and most efficient method to move the data. Hence copy tasks are completed in record time. DBAs are no longer forced to wait for weekend time slots. They are able to copy/migrate test data on regular weekday shifts, without preparing and controlling sophisticated processes. The huge checklist, which is usually indispensable for such tasks, can eventually be dropped. Test data on demand becomes reality. XDM offers relief where the need is greatest. It significantly cuts manual efforts: preparation lead-time is shortened by 90%+.
Automation required ?XDM provides completely automated copy procedures. Its workstation interface allows the copy process to be easily defined: Identify the objects to be copied by specifying select/exclude patterns. The powerful rename mask facility makes adhering to naming conventions a simple and error free task. A XDM copy task execute either under the control of the product itself or under control of an in-house scheduler. Once the copy process is started there is nothing else to do. XDM automatically generates the DDL for the selected objects/databases using the specified target names. It executes the DDL in the target DB2 environment, tailors the respective JCL and generates the required statements for the copy program. If the target objects are already present at the target system ensures that the target DB2 objects match the source objects. Structural differences are detected and successful completion of the copy process is guaranteed. Incompatible objects can be dropped and recreated, or skipped completely without any intervention by the user.
Speed XDM uses parallelism as a performance enhancement technique. It operates in a multi-threading mode and copies ten to eighteen tablespaces in parallel. Another performance enhancement feature involves copying indexes. Copying indexes is much faster than rebuilding them.
Making the Copy Process Easy? The XDM user interface is intuitive and easily meets the needs of both experienced efficiency-minded experts and less technical application level users. No need of any technical knowledge about the DBMS is required. Users only specify what they want to do in order to copy from here to there.
Who needs XDM?? In short, everyone who wants to improve and accelerate test data provision or data migration. Because XDM automates the conversion of DDL statements it is first choice for data migration between different DBMSs. Application development teams, QA groups, technical support staff, auditors need the data to get their jobs done.