Friday May 04, 2012

Migrating DB2 z/OS to Oracle Database

I have been receiving many requests for information on migrating IBM z/OS DB2 databases to Oracle so I thought this would be a great topic.
Third Party Tool Solutions
1.Ispirer- Ispirer - I have worked with there tool before and it is solid. They offer services as well.

Third Party SI Providers (with their own tools)
1.Prac Trans - Prac Trans - I have worked a lot with this company. They have both internal tools to migrate db2 z/OS and very skilled mainframe DB2 resources.

Oracle Solutions
A. Oracle ART Tuxedo Workbench - Oracle ART Workbench
Note: This costs minimum of $80K for two developer licenses.
Solution is disk to disk based.
B. Oracle Warehouse Builder - Free Oracle database ETL tool. You would use JDBC as listed here:
OWB
OWB supports importing of COBOL copybooks where DB2 tables are often defined. NOTE: JDBC connection to mainframe DB2 can be slow.
Solution can be disk to Oracle DB or DB2 to Oracle (stream based).
C. Oracle DRDA Gateway - Connect to DB2 on mainframe from Oracle and use Select statements to migrate (nothing to install on mainframe) Oracle DRDA Gateway
Solutions is stream based/disk less.
D. Oracle Data Integrator - No DB2 Knowledge built for DB2 mainframe but one could be developed.

Tuesday May 01, 2012

What makes a DB2 migration easy ?

The four key elements are:
1. COTS application - This means no application database access or database schema to migrate (assuming no database customizations)
2. No integration interfaces - There are no web service, FTP/file, COTS API or other input, output or input/output interfaces.
3. No ETL / batch processing - The is no batch processing or ETL jobs (Oracle Data Integrator, Informatica, IBM DataStage etc.) that are outside the COTS application.
4. No data to migrate - Really ? Yes, all the data is transient. It is part of a print server, real time data capture or caching system.
This may seem like it does not happen. However, I just encountered a set of applications run by a major corporation that has all four elements!

Friday Apr 27, 2012

SAP database HANA sales disappoint

Not sure why the analyst thought HANA was going to 'blow it out of the water'. Oracle has had TimesTen for years and their are other in memory database that have been around for ten years or more.

Saturday Apr 21, 2012

Data migration testing - Oracle Flashback Database makes life easier

Whether it is unit, QA, system or development testing using Oracle Flashback database can reduce time and make the process easier
Oracle Flashback for testing on OTN

Wednesday Apr 18, 2012

Do More with SOA Integration

Packt has come out with a new SOA 'greatest hits' (SOA content from a number of Packt books) book:

Do More with SOA Integration on Amazon
Book contains content from a couple Packt books I have co-authored.

IBM iSeries Migrations - Interesting facts on iSeries

I am working with a major corporation that has a number of iSeries machines that are mostly running AIX and Redhat Linux. This is interesting as I would think there is a premium for running
applications and databases on a hardware platform that has minmal processing power and is optimized for a different OS (i5/OS). This lead me to do some research on where iSeries and i5/OS is headed.
Interesting facts found on an iSeries blog:
"First, some statistics. According to IBM's own internal research, some 80 percent of shops have one or two OS/400 or i5/OS systems; this means that 20 percent have more than three machines in their shop. Moreover, IBM believes that 85 percent of the machines installed at OS/400 and i5/OS shops have only a single processor core in them; this again implies that only 15 percent have multicore boxes." There are 1/2 million iSeries machines installed. Seems like many of these could be run on cheap x86 hardware platforms.
First, some statistics. According to IBM's own internal research, some 80 percent of shops have one or two OS/400 or i5/OS systems; this means that 20 percent have more than three machines in their
shop. Moreover, IBM believes that 85 percent of the machines installed at OS/400 and i5/OS shops have only a single processor core in them; this again implies that only 15 percent have multicore
boxes.

Tuesday Apr 03, 2012

Oracle partner modernization session in UK

Check out this session in London:
ZSL and Oracle Modernization Session

What is SOA ?

First, let’s mention what SOA is not:
• SOA is not the same thing as web services. Web Services implies the use of standard such as Java/JAX-RPC, .NET or REST. Web Services also implies the use of a WSDL, SOAP, and/or J2EE Connector Architecture (J2EE CA) and HTTP. SOA architectures can be implemented using J2EE CA, XML file transfer or Remote Procedural Call (RPC) over File Transfer Protocol (FTP), TCP/IP, Remote Method Invocation (RMI) or other protocols. In other words, Web Services are a very specific set of technologies. SOA is a concept and can be implemented in many different ways. Some very rudimentary, such as transfering flat files between applications.
• SOA will not solve all of your problems. It will make your business more agile, increase business visibility, reduce integration costs and provide better reuse. However, if you don’t need help in these area or expect SOA to cure all of your IT problems, you are looking in the wrong place.
• The concepts behind SOA are not new, but SOA is also not mature. SOA as it stands today has really only been around for 5 years. The concepts of standards based protocol handlers, predefined communication schemas and remote method invocation have been around for decades. So, what is SOA? SOA is an architectural blueprint, a way of developing applications, and a set of best practices. SOA is not an ‘out of the box’ solution you buy, install and then have up and running in a matter of months. SOA is a journey to a better way of doing business and the technology architecture to support this better way of doing business. SOA is also a broader set of technologies including more then just web services. Techologies like an Enterpirse Service Bus (ESB), Business Processs Execution Language (BPEL), message queues and Business Activity Monitoring (BAM) all are part of a SOA architecture.

So, what is SOA? SOA is an architectural blueprint, a way of developing applications, and a set of best practices. SOA is not an ‘out of the box’ solution you buy, install and then have up and running in a matter of months. SOA is a journey to a better way of doing business and the technology architecture to support this better way of doing business. SOA is also a broader set of technologies including more then just web services. Techologies like an Enterpirse Service Bus (ESB), Business Processs Execution Language (BPEL), message queues and Business Activity Monitoring (BAM) all are part of a SOA architecture.
Read more here: Oracle Modernization Solutions

Monday Apr 02, 2012

Cloud consolidation handling multi databases

I have spoken about virtualization and the different types of virtualization. Which includes OS zones, application server domains, database schemas, VLANS and other approaches. Another approach is to create a virtually federated database in the cloud. DBSpaces is a company that has a technology to created a virtually federated database in the cloud. DBSpaces is a Virtual Database technology that allows an organisation thru a single Virtual Database access multiple data sources (or database spaces) in real-time. Additionally dbSpaces can be configured to access an organisations data internally using a remote gateway so that their dbSpace is seamless across the Public and Private cloud.

Friday Mar 30, 2012

What does private cloud Daas or DBaaS really mean ?

Just had meeting with Fortune 1000 company regarding their private DBaaS or DaaS offering. Interesting to see what DBaaS really means to them:
1. Automated Database provisioning - Being able to 'one button' provision databases and database objects. This
includings creating the database instance, creating database objects, network configuration and security
provisioning. It is estimated that just being able to provision a new DB table in automated fashion will reduce time
required to create a new DB table from 60 hours down to 8 hours.
2. Virtualization and blades - DBaaS infrastructure is all based upon VMs and blades.
3. Consolidation of database vendors - Moving from over ten database vendors down to three.

Tuesday Mar 27, 2012

SQL Server 2012 price increase - what is the impact to migrations ?

SD Times as well as other publications have been discussing the pricing change that is coming for Microsoft SQL Server 2012 when it was released on March 6th.
SD Times SQL Server 2012 license changes bring new concerns.
It will be interesting to see what impact this has on folks that are considering Oracle or looking to migrate from Sybase to SQL Server or Oracle.

Monday Mar 19, 2012

Chargeback and showback...both a 'throw back'

Been getting asked again by customers and partners about chargeback and showback in the cloud so thought I would blog on my response to this question. Charge Back background, information and industry analysis: Cloud computing is all about shared resources. These shared resources are computer servers (including memory and CPU), network devices, hard disk storage, database servers, application servers, cooling, floor space, electricity and more. These resources are shared by departments within a company, or by a number of companies, when resources are hosted in the public or hybrid cloud. Currently, hosting providers that run other companies on their cloud platforms do not have an accurate way to measure the shared computing resources used by a specific user let alone used by a specific customer. Additionally, companies running their own cloud data centers, for private or hybrid clouds, have no way of measure and charging back the departments in the company that are using these shared cloud resources. In both cases, the lack of determine shared resource costs and to charge them back to the company, department or user that is using this resources is limited a clear measure of business benefit and impacting company’s ability to measure the Return on Investment (ROI). An IT chargeback system is an accounting strategy that applies the costs of IT services, hardware or software to the business unit in which they are used. This system contrasts with traditional IT accounting models in which a centralized department bears all of the IT costs in an organization and those costs are treated simply as corporate overhead. Showback involves showing the IT costs to a department or customer but not actually charging them for their IT usage. Showback is a gradual method of introducing chargeback into an enterprise. Most companies implement a show back mechanism before a full chargeback system is put in place. Oracle chargeback product: Oracle Enterprise Manager provides tools for defining detailed Chargeback plans spanning different metrics collected for each type of resources as well as defining Cost Centers for grouping costs across multiple developers. Chargeback plans can use not only usage based costs, but also configuration based costs (e.g. version of the platform) or fixed costs (e.g. flat-rate management fee). Chargeback has rich out of the box reports. Trending reports show how charge and resource consumption varies over time, while Summary reports show the breakdown of charges or usage by different dimensions such as Cost Center or Target Type. These reports help consumers in understanding how their charges relate to their consumption and also assist the IT department with budgeting and planning activities. With BI Publisher, the reports can be made available in a variety of formats such as PDF, HTML, Word, Excel or PowerPoint.

Friday Mar 16, 2012

Deploying Oracle in the cloud

http://searchoracle.techtarget.com/news/2240113336/Book-outlines-strategies-for-switching-to-Oracle-in-the-cloud
About

Migrating legacy client/server and mainframe technologies to the Oracle cloud.

Search

Categories
Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today