Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / December 2005

Tip: Looking for answers? Try searching our database.

DB2 on Windows to DB2 On Mainframe

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
pankaj_wolfhunter@yahoo.co.in - 30 Nov 2005 11:10 GMT
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
Mark A - 30 Nov 2005 19:14 GMT
> Greetings,
>                 I just want to know what are the points or performance
[quoted text clipped - 6 lines]
>
> 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.
peteh - 30 Nov 2005 19:28 GMT
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/developerworks/db2/library/techarticle/0206sqlref/0206sql
ref.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
pankaj_wolfhunter@yahoo.co.in - 01 Dec 2005 04:16 GMT
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
Serge Rielau - 01 Dec 2005 04:32 GMT
> Thnx for all the replies.
> Mark, thnx for the points. will it be possible to give me some
[quoted text clipped - 4 lines]
>
> TIA

Not suer where you looked but:
http://www-128.ibm.com/developerworks/db2/library/techarticle/0206sqlref/0206sql
ref.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/products/db2/info/vr8/pdf/letter/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
Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

pankaj_wolfhunter@yahoo.co.in - 01 Dec 2005 05:01 GMT
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.