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

[Mark A]

<pa***************@yahoo.co.in> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.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.

[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

[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

[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

[pankaj_wolfhunter]

Thnx Serge.