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