IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

DB2 V10 upgrade -DSNTIJPM/Ajob


 
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: :: View next topic  
Author Message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 40
Location: india

PostPosted: Tue Jul 23, 2013 3:08 pm
Reply with quote

Hi DBA team,
We are going thru the V10 incompatibility list and could see most of the impacted DB2 objects are figured out with the job DSNTIJPM/A .Does that mean that DSNTIJPM/A reports(35 reports) will be having final list of impacted list of DB2 objects(ex.DBRMs bound to plan ,Explain tables list etc.) ? apart from that we could see some more incompatibilities as well "The following statements are no longer allowed in the body of a BEFORE trigger:
SELECT FROM DELETE
SELECT FROM INSERT
SELECT FROM MERGE
SELECT FROM UPDATE"
Similar to the above there were lots ,which were not covered as part of DSNTIJPM/A . Does it mean that it will not have impact or application team should take care ?I can list the DB2 objects by querying system catalogue tables ,but still wondering if my analysis is going in wrong direction . opening a forum "DB2 V10 upgrade" will be helpful for DB2 DBA s
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic All times are GMT + 6 Hours
Forum Index -> DB2
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Upgrade to Enterprise COBOL 6 COBOL Programming 4
No new posts Backup issues after upgrade to zOS 2.2 All Other Mainframe Topics 0
No new posts Conditional setting of return-code af... COBOL Programming 9
No new posts Cobol upgrade - source code missing f... IBM Tools 1
No new posts Single COPY CICS TS datasets and when... CICS 2

Back to Top