3b51cb70528d35a2fe1ac9718feff7ca.ppt
- Количество слайдов: 18
Man. Tech Database Migration Products and Services IBM DB 2 Gold Consultants Briefing San Jose - September 18 , 2000
Summary of Man. Tech Established in 1968 • Privately Held Professional and Technical Services Firm 5, 000 Employees Worldwide • Provides Technical, Engineering, Scientific, Analytical, Logistics, Software Development, Program Management, Publications, and Support Services 120 U. S. Locations 30 International Locations • Worldwide Professional and Technical Resources • Corporate Headquarters in Fairfax, VA Over $500 Million in Annual Revenues • Current backlog of over $1 Billion
Man. Tech International Corporation Man. Tech International GSE Systems Man. Tech Systems Solutions Corporation Man. Tech Systems Engineering Corporation Man. Tech Advanced Systems International Man. Tech Environmental Corporation Man. Tech Database Services Europe Man. Tech Europe Limited (MEL) Man. Tech Australia Telecommunications and Information Systems Corporation PRAXA Limited
Competencies: Software l MVS, CICS, UNIX, Linux, Windows NT p p p l l Installation/Configuration/Tailoring Tuning Troubleshooting Performance Monitors Database Management Systems p p p p IBM DB 2/Universal Data Base IMS IDMS Total/TIS/Supra Oracle Informix Microsoft SQL Server Sybase
Competencies: Application Development l Architectures p p l Host-centric Client/Server Distributed Web-based IBM Mainframe Various UNIX Intel Software Environments p p Languages p Hardware Environments p p p l l Legacy p 4 GL p Client-Server/Web MVS AIX/UNIX OS/2 Windows l 8 8 8 COBOL PL/1 Assembler 8 8 ADS/O MANTIS Natural Ideal 8 8 8 8 C/C++ Visual Basic Java/Websphere Developer 2000 Powerbuilder Object. View Vision DHTML/ASP/IIS CASE Tools p p p Visual. Age Generator ADW Designer 2000
Competencies: Database Services Database and Application Conversion Database Design, Development, & Warehousing Website Design, Development, and Hosting
Man. Tech’s Relationship with IBM • Man. Tech has provided database migration services and tools targeting DB 2 since 1993 – IBM Premier Business Partner – Worked with IBM Santa Teresa and Toronto Labs in requirements definition and testing/acceptance of recent DB 2 functionality support in our software – Service Provider to IBM Software Migration Project Office (SMPO) – IBM license of Stored Procedure Conversion Tool (SPro. CT) for general distribution
SQL-CW Offerings Version 3 (SPro. CT) • www. ibm. com/software/data/db 2/migration – FREE DOWNLOAD • • • IBM licensed V 3 for individuals and businesses targeting DB 2 through 12/01 – Free License Agreement does not support 3 rd party service provider or consultants – Can join Man. Tech Business Partner Program Provides: – Metadata extract from source environment – Automatic generation of target DB 2 schema definition that can be customized – Generate DDL, unload, and load procedures – Conversion of Sybase Transact-SQL, Microsoft Transact-SQL and Oracle PL/SQL procedural language to DB 2 SQL Procedures Language (DB 2 SPL) OS/390 V 6 and UNO V 7 Support Approx. 950 registered users since 4/19/00 GA with DB 2 UDB V 7 on 6/16
SQL-CW Offerings Version 4 • Distributed by the IBM Software Migration Project Office (SMPO) for 90 -day trials • Licensed through Man. Tech thereafter • Provides: – All features of Version 3 – Pro*C and Pro*COBOL embedded conversions
Additional Functionality in Version 3/4 • DB 2 SPL • DB 2 V 7 Support • Data migration mapping changes and enhancements • Added Sybase 12, Microsoft 7, and Oracle 8 support to existing Sybase V 4. x, 10, 11; Microsoft V 6. 5; Oracle 7. 3 support
An Automated Migration • Minimized manual effort and repetition • Increased code modification and data definition accuracy • Increased maintenance quality through consistent source modification • Reduced hardware capacity requirements • Reduced time and cost
Man. Tech Conversion Approaches l Automation p SPro. CT/SQL Conversion Workbench® 8 8 p Microsoft SQL Server, Sybase, Informix (services), and Oracle to DB 2 Cincom Supra to DB 2 (services) WORx Adabas/Natural, IDMS/ADS, and Datacom DB/Ideal to DB 2/COBOL 8 COBOL to VA Gen 8 l Manual p p All of the most widely installed mid-tier data bases to DB 2 All of the most widely installed legacy mainframe databases to DB 2
Getting to Conversion is (Usually) Incremental Perform Pilot Test Assessment Conversion Assessment Plan “Ballpark” Scan source code/ Questionnaire Conversion
Process is Key Quality Assurance Data Convert Assess Modelling Convert and Code and Adjust DB and Plan Environment Structure Data Setup Unit Test Project Management System Test and Production Cutover
Man. Tech Differentiators • 12 years of DB 2 migration, development, and administration experience • Unrivaled knowledge of source and target platforms • Conversion management and methodology experience • Optimization of DB 2 and resulting performance benefit • Availability of highly technical consultative services as part of the Man. Tech conversion package • Man. Tech tools, with additional automated capabilities: – DB-Lib/CT-Lib to X/Open CLI/ODBC – Powerbuilder – Triggers – Informix/Informix 4 GL – Cincom Total/Supra
Man. Tech Migration Services Engagement • Cost and duration estimates based on questionnaire or code scan • Assessment and planning – – – Sizing of conversion and testing effort Initial Plan Roles and Responsibilities Technical infrastructure impact Identify co-existence or bridging strategy if phasing is required – Potential Prototype
Man. Tech Migration Services Engagement • Migration – Verification of Metrics – Detailed project plan – Management reporting – Configuration Management – Acquire integrity test resources – DB schema and data – Procedural code – Application code – Quality Assurance – Fixed price through integrity test – Performance history/assurance – Optional implementation and skills transfer support
For More Information… • Carroll Hummer Man. Tech Systems Solutions Corporation 2700 S. Quincy St. – 4 th Floor Arlington, VA 22206 (703) 575 -3063 carroll. hummer@mantech. com • Martin Spratt IBM SMPO DB 2 Migration Team (DB 2 Migration Business Partners) sprattm@us. ibm. com (309) 797 -7312
3b51cb70528d35a2fe1ac9718feff7ca.ppt