z/OS, R810 Migration, DBINFO

Linda Hagedorn

z/OS, R810 Migration, DBINFO
Hi,

Migration Step 20, DBINFO. During migration, is anyone having their
applications read the source code to determine if DBINFO is checked?
How significant is this change to migrations? Is anyone having
DBINFO-related difficulties in migration? We're wondering if DBINFO is
interrogated in application programs in general. Any information about
DBINFO and migration is appreciated.
Ref: 2.7.21 Migration step 20: Ensure that routines use Version 8 DBINFO
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/DSNIGJ13/2.7.21?SHEL
F=dsnshja2&DT=20050324144101

Thanks, Linda


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Wayne Driscoll

Re: z/OS, R810 Migration, DBINFO
(in response to Linda Hagedorn)
Linda,
Issue the following sqlstatement:

select
schema,owner,name,specificname,routinetype,wlm_environment,external_name
from
sysibm.sysroutines where dbinfo='Y';

This will give you a list of stored procedures (routinetype='P' or functions
(routinetype='F') that have been defined as getting the dbinfo block passed
in. Then, (at least what I would do) provide that information to your
application development staff to review their code.

Wayne Driscoll
Product Developer
Western Metal Supply
NOTE: All opinions are strictly my own.



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Linda Hagedorn
Sent: Monday, January 09, 2006 4:46 PM
To: [login to unmask email]
Subject: [DB2-L] z/OS, R810 Migration, DBINFO



Hi,

Migration Step 20, DBINFO. During migration, is anyone having their
applications read the source code to determine if DBINFO is checked? How
significant is this change to migrations? Is anyone having DBINFO-related
difficulties in migration? We're wondering if DBINFO is interrogated in
application programs in general. Any information about DBINFO and migration
is appreciated.

Ref: 2.7.21 Migration step 20: Ensure that routines use Version 8 DBINFO
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/DSNIGJ13/2.7.21?SHELF=ds
nshja2&DT=20050324144101
<http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/DSNIGJ13/2.7.21?SHELF=d
snshja2&DT=20050324144101>

Thanks, Linda

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Linda Hagedorn

Re: z/OS, R810 Migration, DBINFO
(in response to Wayne Driscoll)
Hi Wayne,

That's what we're trying to avoid. DBINFO was specified in the creation of
the routine, but we suspect it's highly unlikly the routines use the
section of DBINFO that was changed between R710 and R810. We're trying to
get a feel for the use of the control block by other companies/users.

Any ideas?

Thanks, Linda

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm