Migrating Siebel Database from DB2/Oracle for NT to DB2 for OS/390

Book description

This IBM Redbooks publication will help you to migrate the Siebel 2000 V6.2.1 database from:
DB2 for NT V6 to DB2 for OS/390 V6
Oracle for NT V8.1.6 to DB2 for NT V6
Oracle for NT V8.1.6 to DB2 for OS/390 V6
The book describes the migration experiences gained while migrating a Siebel 2000 database at the IBM ITSO Poughkeepsie Center in New York, and at the IBM Hursley Laboratory in the UK.
It provides an overview of Siebel architecture, and introduces the migration methodology needed to move the Siebel database from a DB2/Oracle for NT platform to a DB2 for OS/390 platform. It offers a step-by-step description of the database migration process, and discusses in detail the different methods of moving data from one platform to the other.
This book will be especially useful for those migrating the Siebel database for the first time.

Table of contents

  1. Preface
    1. The team that wrote this redbook
    2. Special notice
    3. IBM Trademarks
    4. Comments welcome
  2. Chapter 1: Introducing Siebel database migration
    1. Siebel architecture and configurations
    2. When should you migrate the Siebel database
    3. Siebel database migration
    4. Siebel database structure
      1. The repository
      2. The data
    5. Which tool should you use to move data
      1. Siebel database utilities
      2. RDBMS-specific database utilities
      3. Data warehousing tools
    6. Methodology for migrating to DB2 for OS/390
    7. Migration scenarios
  3. Chapter 2: Implementing the target Siebel environment on OS/390
    1. Preparing the OS/390 environment for the Siebel database
      1. Checking the maintenance level
      2. Creating RACF user IDs
      3. Creating a large VTOC
      4. Creating DB2 storage groups
      5. Customizing DB2 buffer pools
      6. Customizing the EDM pool
      7. Customizing DSNZPARM parameters
      8. Enabling DB2 stored procedures
    2. Enabling database connections to DB2 for OS/390
      1. DDF setup on OS/390
      2. DB2 Connect EE setup on NT
      3. Client setup on a PC
    3. Installing Siebel 2000 on the NT server
      1. Creating required NT user accounts
      2. Creating the Siebel File System
      3. Installing the Siebel Gateway Server
      4. Installing the Siebel Server
    4. Installing the Siebel Database Server on OS/390
      1. Installing the database server scripts
      2. Creating the Siebel physical schema on OS/390 (1/2)
      3. Creating the Siebel physical schema on OS/390 (2/2)
      4. Importing seed data
      5. Importing the Siebel repository
    5. Populating the File System
    6. Installing the Siebel connected client
    7. Testing the installation using Siebel Call Center
  4. Chapter 3: Migrating Siebel data from DB2 for NT to DB2 for OS/390
    1. Preparing for data migration
      1. Generating a list of tables to migrate
      2. Cleaning up target tables
    2. Moving data from DB2 for NT to DB2 for OS/390
    3. Siebel Dataexp/Dataimp - no schema changes
      1. Exporting data with Dataexp
      2. Importing data with Dataimp
      3. Validating the migration
    4. Siebel EIM
      1. EIM export
      2. Dataexp
      3. Dataimp
      4. EIM Import
    5. DB2 for NT Import/Export
    6. DB2 for OS/390 DSNTIAUL and LOAD
    7. DB2 family cross-loader function
  5. Chapter 4: Migrating Siebel data from Oracle for NT to DB2 for NT
    1. Test configuration
    2. Migrating Siebel data from Oracle for NT to DB2 for NT
      1. Siebel Dataexp/Dataimp - with schema changes
      2. Siebel Dataexp/Dataimp - no schema changes
      3. Siebel EIM
  6. Chapter 5: Migrating Siebel data from Oracle for NT to DB2 for OS/390
    1. Two-phase migration - Oracle for NT to DB2 for OS/390
    2. One-phase migration - Oracle for NT to DB2 for OS/390
    3. Dataexp/Dataimp - no schema changes
    4. Dataexp/Dataimp - with schema changes
      1. Verifying object names
      2. Consolidating object names before the migration
      3. Consolidating object names during the migration
    5. Dataexp/FTP/DB2 Load
    6. Relational Connect/DB2 LOAD (1/2)
    7. Relational Connect/DB2 LOAD (2/2)
  7. Appendix A: Implementing the Siebel source environment on NT
    1. Setting up a source environment
    2. Installing the base NT software
      1. Installing Microsoft Windows NT 4.0 server
      2. Installing Microsoft Office 2000
      3. Installing Adobe Acrobat
      4. Installing Internet Explorer
    3. Installing DB2 for NT
      1. Creating the DB2 startup account
      2. Installing the DB2 server
      3. Installing the Siebel 2000 DB2 for NT Fix Pack
      4. Verifying the DB2 installation
    4. Configuring DB2 for Siebel 2000
      1. DB2 Database Manager configuration parameters
      2. Setting the DB2 environment parameters
    5. Creating the initial DB2 database
      1. Creating the skeleton Siebel database
      2. Creating the initial buffer pools
      3. Verifying the buffer pools
      4. Creating the regular and temporary table spaces
      5. Verifying the table spaces
      6. Configuring the database
    6. Creating required NT user accounts
    7. Creating the Siebel File System
    8. Installing the Siebel Gateway Server
      1. Installing the Siebel Gateway Server
      2. Starting the Siebel Gateway Server NT service
      3. Inspecting the Gateway Server directory
    9. Installing the Siebel Server
      1. Installing the Siebel Server
      2. Inspecting the Siebel Server directory
      3. Starting the Siebel Server NT service
      4. Verifying the Siebel Server ODBC data source
    10. Installing the Siebel Database Server
      1. Installing the Siebel Database Server scripts
      2. Granting database privileges
      3. Configuring the Siebel DB2 instance
      4. Installing the stored procedures code
    11. Initializing the Siebel database
      1. Creating the Siebel schema
      2. Verifying the results of install.ksh
      3. Importing the Siebel object definitions
      4. Verifying the results of imprep.ksh
      5. Populating the Siebel File System
    12. Verifying the install
      1. Installing the Siebel client
      2. Testing the installation using the Siebel Call Center
    13. Installing Siebel Tools
      1. Detailed instructions
      2. Testing Siebel Tools
    14. Creating sample data
  8. Appendix B: The .bat files
    1. db2_db_mgr_cfg.bat
    2. db2_db2set.bat
    3. db2_db_cfg.bat
    4. tablespace.bat
    5. forceit.bat
    6. bufferpool.bat
  9. Appendix C: Creating sample data
    1. Entering data using Siebel Call Center
    2. Migrating the Siebel sample database
  10. Appendix D: DB2 customization jobs
    1. DSNZPARM parameters (1/2)
    2. DSNZPARM parameters (2/2)
    3. Creating STOGROUPs
    4. Creating the Siebel databases
    5. Creating the Siebel table spaces (1/4)
    6. Creating the Siebel table spaces (2/4)
    7. Creating the Siebel table spaces (3/4)
    8. Creating the Siebel table spaces (4/4)
    9. Creating Siebel tables and indexes
    10. Creating stored procedure objects
  11. Appendix E: DB2 DSNTIAUL and LOAD jobs
    1. REXX EXEC to generate DSNTIAUL unload jobs
    2. REXX EXEC to generate DB2 LOAD jobs
  12. Appendix F: Validating object names
    1. Table names > 18 characters
    2. Index names > 18 characters
    3. Column names > 18 characters
    4. Index key > 255 bytes
    5. The .dat file
  13. Appendix G: Dataexp/FTP/DB2 Load programs and jobs
    1. REXX procedure
    2. JCL to run the REXX procedure
    3. PLFSIEBL COBOL program (1/5)
    4. PLFSIEBL COBOL program (2/5)
    5. PLFSIEBL COBOL program (3/5)
    6. PLFSIEBL COBOL program (4/5)
    7. PLFSIEBL COBOL program (5/5)
    8. JCL to run the PLFSIEBL program
    9. JCL to run the DB2 LOAD utility
  14. Related publications
    1. IBM Redbooks
      1. Other resources
    2. Referenced Web sites
    3. How to get IBM Redbooks
      1. IBM Redbooks collections
  15. Special notices
  16. Index
  17. Back cover

Product information

  • Title: Migrating Siebel Database from DB2/Oracle for NT to DB2 for OS/390
  • Author(s): Viviane Anavi-Chaput
  • Release date: November 2001
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738421551