DB2 on Windows to DB2 On Mainframe

pankaj_wolfhunter

Greetings,
I just want to know what are the points or performance
issues to consider while migrating database objects(like sp's,
triggers, tables etc) from DB2 UDB on Windows to DB2 on Mainframe7.1 or
any link where i can find some important information regarding the
same?

Help will be greatly appreciated

TIA

Nov 30 '05 #1

Subscribe Reply

1418

Mark A

<pa************ ***@yahoo.co.in > wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .

Greetings,
I just want to know what are the points or performance
issues to consider while migrating database objects(like sp's,
triggers, tables etc) from DB2 UDB on Windows to DB2 on Mainframe7.1 or
any link where i can find some important information regarding the
same?

Help will be greatly appreciated

TIA

You need to understand table clustering (by defining one index as the
clustered index). This optional on DB2 for LUW, but on z/OS, if you don't
define a clustering index for each table, the first index created will
become the clustered index. This will affect percent free calculations and
how often you reorg the tables/indexes.

The only other thing I can think of offhand is that z/OS stored procedures
do not allow commit statements, but that is not really a performance issue.

Nov 30 '05 #2

peteh

Still LOTS of SQL incompatibility if you are using latest and greates
V8 syntax on LUW, you're in for some ugly surprises. Probably no
show-stoppers, but potentially lots of complex SQL. There used to be a
running and comprehensive list of these (FRED manual or Redbook?), but
I'm not sure if it's published anymore. Check out this link:
http://www-128.ibm.com/developerwork...206sqlref.html

Of course on the DBA and sysadmin side there are all KINDS of things to
be concerned about... Don't read into this that I'm discouraging you at
all. DB2 for z/OS is a great platform - we use it and have multiple LUW
servers as well.

Pete H

Nov 30 '05 #3

pankaj_wolfhunter

Thnx for all the replies.
Mark, thnx for the points. will it be possible to give me some
reference links where i can get more information about these points?
Peteh. i went thro the books but these books describe migrating from
one version to another version on z/OS. i mean is it same when
migrating to z/OS from Windows version?

TIA

Dec 1 '05 #4

Serge Rielau

pa************* **@yahoo.co.in wrote:

Thnx for all the replies.
Mark, thnx for the points. will it be possible to give me some
reference links where i can get more information about these points?
Peteh. i went thro the books but these books describe migrating from
one version to another version on z/OS. i mean is it same when
migrating to z/OS from Windows version?

TIA

Not suer where you looked but:
http://www-128.ibm.com/developerwork...206sqlref.html
Point to three versions of the cross-platform SQL Reference manual.
You are going from DB2 V8 for LUW to DB2 V7 for zOS so you develop
against this book:
ftp://ftp.software.ibm.com/ps/produc.../cpsqlrv11.pdf
Note that DB2 V8 for zOS would be much better. DB2 V8 for zOS has been
closing a lot of SQL gaps to DB2 for LUW

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Dec 1 '05 #5

pankaj_wolfhunter

Thnx Serge.

Dec 1 '05 #6

Similar topics

18835

javascript error window.top.mainframe is null or not an object

by: Erik-Jan Bakker | last post by:

Hi I am not a javascript expert and I have a problem that the guru's in this newsgroup probably can solve quickly. ;-) I've made a webpage with three frames: top, left and mainframe. I defined this in a frameset called index.htm. Each frame is loaded with a specific page: top:title.htm, left:menu.htm and mainframe:start.htm. So far so...

Javascript

2760

Are people using db2 on Windows?

by: Bruce Jin | last post by:

I wonder how many people are using db2 on Windows? I know db2 is native to AS400 which has about 800,000 installations. Thanks!

DB2 Database

712

Migration from MFC to C# Windows Forms

by: Scott | last post by:

I have written windows applications using MFC for several years and have frequently used MFC techniques. Now I'm moving to C# .NET WinForm. Mostly C# books describes C# language (sometimes compared with C++) and then how to use Windows Forms but without comparison with MFC. Would you recommend any book or online stuff to guide migration...

C# / C Sharp

5108

Mainframe - VB?

by: Jay | last post by:

All, I am looking for a process to 'authorize' certain mainframe files to be selected for processing on mainframe using a VB screen? I mean to say the VB screen will act as 'select/authorize' screen for a mainframe process... Is such a setup possible?

Visual Basic .NET

5018

Using Web Service for Integrating Mainframe Applications

by: karpagam | last post by:

Since WebServices are a standardized way to invoke a method of another application over the internet, is there a way to integrate two different applications running on different platforms (Say a .NET client application, used for implementing the presentation logic, and a mainframe application that contains the business logic). Is there a way...

.NET Framework

2172

Any easy way to compile, link, exceute, debug C++ on IBM mainframe?

by: Thureen | last post by:

I just started using the mainframe (z/OS) 2 days ago, so I am very inexperienced in it. However, I need to write c++ programs for mainframe. Right now, the other mainframe programmers have showed me a complicated (seemed very complicated and painful to me) on how to compile, link, and execute using JCL (job control language) on the mainframe....

C / C++

5381

How to connect to Mainframe to download a file

by: dinoo | last post by:

Hi, I need help here. I am converting an vb application to c#. The existing application connects to the mainframe server using FTP and downloads a file (dataset). Is it possible in .NET to avoid FTP and use any providers to connect to the mainframe server and download a file. I would appreciate if someone can give a reference to a link...

ASP.NET

1638

Developing application for DB2 Mainframe

by: Gil Lapid | last post by:

Hi, What is the recommended way to develop DB2 Mainframe application without buying this expensive hardware/software ? I'd like to develop the software for a Mainframe customer. Thanks, Gil

DB2 Database

2685

php on a Mainframe

by: R. Vince | last post by:

I'm been roped into a techical discussion next week as to whether our Java applet / php site can run on a "mainframe." (I know not what kind of "mainframe" or OS). Is this kind of thing even in the realm of possibility? Or should i tell them to rewrite the whole thing in COBOL? Thanks

PHP

2593

Mainframe software pricing, DB2, RACF, security/audit

by: systemzq | last post by:

Hi all, I am new to mainframes and am doing some research to look for security solutions for our mainframe environment. I appreciate any responses that will help me out. I have a few questions, primarily around pricing for mainframe software and add-ons. - How is software for mainframe priced. eg. DB2 and any add-on products that are...

DB2 Database

7666

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7584

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7888

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

8108

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

5213

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3626

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2083

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1201

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

925

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General