User Guide

Introduction

Oracle Tuxedo Application Rehosting Workbench

Sequence of the Rehosting Workbench Processes

Oracle Tuxedo Application Rehosting Workbench Cataloger

Overview

Purpose

Skills

Migration Process and Concepts

UNIX/Linux Skills

z/OS Skills

Organization

Requirements & Prerequisites

Preparing the Migration Platform

Overview of the Cataloger in the Replatforming Process

Simple Sample Application

Cataloging Migration Steps

Cataloging Steps

Building-up an Asset

Completion Criteria

Using the Make Utility

Make Configuration

Version.mk

MakeFile

Parsing

Parsing All Programs

Check Need to Be Parsed

Parsing of One Program

Cataloging

Advanced Usage of Make

To Add or Update a Target

Debugging the Make Target

Using the Command with Option VERIF=TRUE

Oracle Tuxedo Application Rehosting Workbench File-to-File Converter

Overview

Purpose

Skills

Organization

File-to-File Migration Process

File Organizations

PDS File Organization

GDG File Organization

Migration Process Steps

Initializing the Process

Requirements

Listing the Files to Be Migrated

File Descriptions and Managing Files With the Same Structure

COBOL Description

COBOL Description Format

COBOL Description and Related Discrimination Rules

Redefinition Examples

Non-Equivalent Redefinition

Equivalent Redefinition Called Technical Redefinition

Preparing the Environment

Initializing Environment Variables

Implementing the Configuration Files

Configuring the Files

Database Parameter File (db-param.cfg)

Mandatory Parameter

Optional Parameter

Datamap Parameter File (Datamap-<configuration name>.re)

Mapping Parameter File (mapper-<configuration name>.re)

Installing the Copy Files

Generating the Components

file.sh

Locations of Generated Files

Modifying Generated Components

Using the Make Utility

Configuring a Make File

Version.mk

Using a Makefile with the Rehosting Workbench File-To-File Converter

Performing the Migration

Preparation

Configuring the Environments and Installing the Components

Installing the Unloading Components Under z/OS

Installing the Reloading Components on Target Platform

Unloading JCL

Transferring the Files

Compiling the Transcoding Programs

Sequential Files(VSAM ESDS, QSAM, Generation Data Set)

VSAM KSDS Files

Executing the Transcoding and Reloading Scripts

Checking the Transfers

Troubleshooting

Overview

Common Problems and Solutions

Error: Unknown file organization *UNDEFINED*

Error: Record... not found

Error: External Variable PARAM is not set

Oracle Tuxedo Application Rehosting Workbench DB2 to Oracle Converter

Overview

Purpose

Skills

Organization

The DB2-to-Oracle Migration Process

File Organizations Processed

Migration Process Steps

Interaction With Other Oracle Tuxedo Application Rehosting Workbench Tools

Reengineering Rules to Implement

Migration Rules Applied

DB2-to-Oracle Data Type Migration Rules

DB2-to-Oracle Column Property Migration Rules

Preparing and Implementing Renaming Rules

Preparing and Implementing LOBS Data Type Migration

Preparing and Implementing MBCS Data Migration

Example of a Migration of DB2 Objects

Preparing the Environment

Implementing the Cataloging of the DB2 DDL Source Files

system.desc File Parameters

Schemas

Implementing the Configuration Files

Initializing Environment Variables

Generation Parameters

Mandatory Parameters

Optional Parameters

Optional Parameters in Case of DATE, TIME and TIMESTAMP Data Types

Optional Parameters in Case of CLOB or BLOB Data Types

Optional Parameters for JCL Unloading Utility

Generating the Components

rdbms.sh

Generation Options

Modification Options

Installation Option

Generate Configuration Files for COBOL Conversion

Using the Make Utility

Configuring a Make File

Version.mk

Using a Makefile With the Rehosting Workbench DB2-To-Oracle Converter

Locations of Generated Files

Modifying Generated Components

Performing the Migration

Preparation

Configuring the Environments and Installing the Components

Installing the Unloading Components Under z/OS

Installing the Reloading Components on the Target Platform

Installing the MWDB2ORA Package Component on the Target Platform

Unloading JCL

Transferring the Files

Creating the Generated Oracle Objects

Compiling the Transcoding Programs

Executing the Transcoding and Reloading Scripts

Transcoding and Reloading Command

Checking the Transfers

Troubleshooting

Overview

Common Problems and Solutions

Error: RDBMS-0105

Error: conversion aborted. Can not read

Error: Configuration file /db-param.cfg is missing!

Error: Target output directory... is missing

Error: Abort when using -c option... in case of unsupported features

Oracle Tuxedo Application Rehosting Workbench File-To-Oracle Converter

Overview

Purpose

Skills

Organization

The File-to-Oracle Migration Process

File Organizations Processed

Migration Process Steps

Interaction With Other Oracle Tuxedo Application Rehosting Workbench tools

Initializing the Process

Listing the Files to Be Migrated

File Descriptions and Managing Files With the Same Structure

COBOL Description

COBOL Description Format

COBOL Description and Related Discrimination Rules

Redefinition Examples

Non-Equivalent Redefinition

Equivalent Redefinition Called Technical Redefinition

Re-engineering Rules to Implement

Migration Rules Applied

Rules Applied to Picture Clauses

Rules Applied to Occurs and Redefines Clauses

Example VSAM File Migration to Oracle Table

Preparing the Environment

Initializing Environment Variables

Implementing the Configuration Files

Configuring the Files

Database Parameter File (db-param.cfg)

Mandatory Parameters

Optional Parameters

Datamap Parameter File (Datamap-<configuration name>.re)

Mapping Parameter File (mapper-<configuration name>.re)

Installing the Copy Files

Generating the Components

file.sh

Using the Make Utility

Configuring a Make File

Version.mk

Using a makefile with the Rehosting Workbench File-To-Oracle Converter

Locations of Generated Files

Examples of Generated Components

Modifying Generated Components

Performing the Migration

Preparation

Configuring the Environments and Installing the Components

Installing the Unloading Components Under z/OS

Installing the Reloading Components Under UNIX

Installing the Oracle Object Creation Components

Setting the Target Platform Environment Variables

Unloading the JCL

Transferring the Files

Compiling the Transcoding Programs

Executing the Oracle Object Creation Scripts

Executing the Transcoding and Reloading Scripts

Checking the Transfers

Compiling the Access Routines and Utilities

Troubleshooting

Overview

Common Problems and Solutions

Error: External Variable PARAM is not set

Error: Target directory does not exist

Error: Unknown file organization

Error: The illegal text is: "converted

Error: Cannot find file in file table named PJ01AAA.SS.VSAM.CUSTOMERS

Oracle Tuxedo Application Rehosting Workbench File-To-Db2/Luw converter

Overview

Purpose

Skills

Organization

The File-To-Db2/luw (UDB) Migration Process

File Organizations Processed

Migration Process Steps

Interaction With Other Oracle Tuxedo Application Rehosting Workbench tools

Initializing the Process

Listing the Files to Be Migrated

File Descriptions and Managing Files With the Same Structure

COBOL Description

COBOL Description Format

COBOL Description and Related Discrimination Rules

Redefinition Examples

Non-Equivalent Redefinition

Equivalent Redefinition Called Technical Redefinition

Reengineering Rules to Implement

Migration Rules Applied

Rules Applied to Picture Clauses

Rules Applied to Occurs and Redefines Clauses

Example VSAM File Migration to Db2/Luw(udb) Table

Preparing the Environment

Initializing Environment Variables

Implementing the Configuration Files

Configuring the Files

Database Parameter File (db-param.cfg)

Mandatory Parameters

Optional parameters

Datamap Parameter File (Datamap-<configuration name>.re)

Mapping Parameter File (mapper-<configuration name>.re)

Installing the Copy Files

Generating the Components

file.sh

Using the Make Utility

Configuring a Make File

Version.mk

Using a makefile with the Rehosting Workbench File-To-Db2/luw (udb) Converter

Locations of Generated Files

Examples of Generated Components

Modifying Generated Components

Performing the Migration

Preparation

Configuring the Environments and Installing the Components

Installing the Unloading Components Under z/OS

Installing the Reloading Components Under UNIX

Installing the Db2/luw (udb) Object Creation Components

Setting the Target Platform Environment Variables

Unloading the JCL

Transferring the Files

Compiling the Transcoding Programs

Executing the Oracle Object Creation Scripts

Executing the Transcoding and Reloading Scripts

Checking the Transfers

Compiling the Access Routines and Utilities

Troubleshooting

Overview

Common Problems and Solutions

Error: External Variable PARAM is not set

Error: Target directory does not exist

Error: Unknown file organization

Error: The illegal text is: "converted

Error: Can't find file in file table named PJ01AAA.SS.VSAM.CUSTOMERS

Oracle Tuxedo Application Rehosting Workbench COBOL Converter

Overview

Purpose

Skills

Organization

Requirements & Prerequisites

Cataloguing Requirements

Data Conversion

Overview of the COBOL Converter in the Replatforming Process

Conversion Steps

Building and Setting the Configuration Files

Configuring config-COBOL

keywords-file

tr-hexa.map

rename-call-map-file

Conversion

Translation of Batch, CICS Programs and Sub-Programs

Reconciling Copybooks

Checking Results

Compiling

Compilation Options and Settings

Compilation Command

Using a make File

Configuration

COBOL Conversion

Reconciling Copybooks

Troubleshooting the COBOL Converter

Configuration File Does Not Exist

Message

Solution

Missing POB file

Message

Solution

POB File Too Old

Message

Solution

Parsing error encountered

Message

Solution

Oracle Tuxedo Application Rehosting Workbench JCL Converter

Overview

Purpose

Skills

Organization

Requirements & Prerequisites

Cataloguing Requirements

Data Conversion

Overview of the JCL Translator in the Replatforming Process

Translation Steps

Building and Setting the Configuration Files

Top Skeleton and Bottom Skeleton

List of Data Files Converted to Oracle Tables

Full Example Configuration

Launchers Configuration

Full Example Configuration

Translation Steps

Set Environment Variables

Translation Commands

Command Line to Translate One JCL File

Command Line to Translate a List of JCL Files

Command Line to Translate All JCL Files

JCL Post-translation Steps

Post-Translation Example

Checking Results

Using a Make File

Configuration

JCL Translation

Oracle Tuxedo Application Rehosting Workbench Eclipse Plug-in

Overview

Purpose

Product Functions

Prerequisites

Platform

Software Environment

Skills

Installing the Plug-in

Component and Layout

ART Workbench Perspective

ART Workbench Navigator

Cataloger Report View

Progress Monitor View

Migration Process Cheat Sheet

Eclipse Preferences

Using the ART Workbench Eclipse Plug-in

Creating ART Project

Configuring Project Properties

Executing Conversion

Oracle Tuxedo Application Rehosting Workbench MBCS Support