Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Upgrade V8 to V10 & PL/I Upgrade from V1.1 to V4.2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sundarkudos

New User


Joined: 16 Oct 2008
Posts: 39
Location: Chennai

PostPosted: Thu Jun 13, 2013 6:26 am    Post subject: DB2 Upgrade V8 to V10 & PL/I Upgrade from V1.1 to V4.2
Reply with quote

Hello All,

In my mainframe project, in order to upgrade DB2 from V8 to V10, IBM is planning to perform prerequisite PL/I upgrade from V1.1 to Enterprise PL/I V4.2 for DB2 compatibility. Initial study has been done and approach has been finalized for PL/I upgrade and it will be upgraded application wise, Phase wise in order to reduce the risk i.e., we have different applications such as finance, marketing etc. which will be upgraded one by one.

And, the problem here is, one of the application is plan to decommission sometime next year, so client has requested us not to touch that application. This application 'A' is tightly coupled with other application 'B' (that is, 'A' is calling few DB2/IMS subroutines of 'B') which is participating in PL/I. So, once the upgrade is done, application 'A' runs in PL/I V1.1 and application 'B' runs in Enterprise PL/I V4.2. When 'A' calls 'B' DB2 subroutine, definitely there would be runtime exception because of version incompatibility.

One solution I can think of is,

Copying B subroutine(to V1.1 and rename the DB2 subroutine and use in calling program of 'A')before we upgrade to V4.2. If this is the case, when application A uses DB2 table with v8 and application B uses DB2 table with v10, when DB2 is upgraded for this application, will this really possible and works?

or is there any other way we can achieve this?

Please let me know if any additional information is required.

Thanks in Advance,
Sundar Rajan S
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 13, 2013 7:01 pm    Post subject:
Reply with quote

Hello,

As all of the system software is from IBM, i'd ask IBM for guidance and alternatives.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Jun 13, 2013 7:18 pm    Post subject: Reply to: DB2 Upgrade V8 to V10 & PL/I Upgrade from V1.1
Reply with quote

Quote:
... ... IBM is planning to perform prerequisite PL/I upgrade from V1.1 to Enterprise PL/I V4.2 for DB2 compatibility.


since IBM is already involved why ask on a Forum ???
Back to top
View user's profile Send private message
sundarkudos

New User


Joined: 16 Oct 2008
Posts: 39
Location: Chennai

PostPosted: Thu Jun 13, 2013 7:27 pm    Post subject: Reply to: DB2 Upgrade V8 to V10 & PL/I Upgrade from V1.1
Reply with quote

Hi,

IBM has requested us to come up with our own suggestions and the better one will be taken into the account for finalizing approach/method.

Need your help on this.

Thanks in Advance,
Sundar Rajan S
Back to top
View user's profile Send private message
sundarkudos

New User


Joined: 16 Oct 2008
Posts: 39
Location: Chennai

PostPosted: Thu Jun 13, 2013 7:29 pm    Post subject:
Reply with quote

Thanks dick.

Awaiting for your valuable inputs.

Thanks in Advance,
Sundar Rajan S
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 13, 2013 8:42 pm    Post subject:
Reply with quote

Hello,

If the application is to be decommissioned soon and it heavily integrated with other processes, what is to replace the decommissioned application?

I believe i've confused myself . . . icon_confused.gif

d
Back to top
View user's profile Send private message
sundarkudos

New User


Joined: 16 Oct 2008
Posts: 39
Location: Chennai

PostPosted: Fri Jun 14, 2013 9:39 am    Post subject:
Reply with quote

Hello Dick,

I should have written the other way.

The application which is planned to decommission will be replaced by a another product which runs outside mainframe and interacts with Mainframe application to pull out the required data's.

Thanks,
Sundar.
Back to top
View user's profile Send private message
sundarkudos

New User


Joined: 16 Oct 2008
Posts: 39
Location: Chennai

PostPosted: Mon Jun 17, 2013 11:10 am    Post subject: Reply to: DB2 Upgrade V8 to V10 & PL/I Upgrade from V1.1
Reply with quote

Hello,

Anyone here to help me out?

Thanks,
Sundar.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Jun 17, 2013 12:52 pm    Post subject:
Reply with quote

Sundar,

Quote:
when application A uses DB2 table with v8 and application B uses DB2 table with v10, when DB2 is upgraded for this application, will this really possible and works?

DB2 Tables for Application A and Application B are in different sub-system right ?

Regards,
Sushanth
Back to top
View user's profile Send private message
sundarkudos

New User


Joined: 16 Oct 2008
Posts: 39
Location: Chennai

PostPosted: Mon Jun 17, 2013 2:32 pm    Post subject:
Reply with quote

Yes Sushanth. Both DB2 tables are in different subsystems.
Back to top
View user's profile Send private message
sundarkudos

New User


Joined: 16 Oct 2008
Posts: 39
Location: Chennai

PostPosted: Mon Jun 17, 2013 2:37 pm    Post subject:
Reply with quote

One more thing is,

After the upgrades(Enterprise PL/I V4.2 & DB2 V10),

The DB2 table of application B(Enterprise PLI V4.2 & DB2 V10) has to be called (via subroutine) in application A(PLI V1.1 & DB2 V8), in order to retrieve few critical data's every few seconds.

Since application A with V1.1 cannot call DB2 V10, is there any other way, we can make it possible without changing the architecture?


Thanks,
Sundar.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Jun 18, 2013 10:55 am    Post subject:
Reply with quote

Sundar,

icon_smile.gif

What are the suggestions that IBM is giving ?

Regards,
Sushanth
Back to top
View user's profile Send private message
sundarkudos

New User


Joined: 16 Oct 2008
Posts: 39
Location: Chennai

PostPosted: Tue Jun 18, 2013 11:29 am    Post subject:
Reply with quote

Sushanth,

icon_confused.gif

IBM has requested us to come up with our own suggestions. Scratching my head now. icon_rolleyes.gif

Thanks,
Sundar.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jun 18, 2013 8:52 pm    Post subject:
Reply with quote

Hello,

I suspect that if IBM has been unwilling or unable to provide what you want, it will probably not be anything simple/straight forward.

One approach (though probably not desired) is to run as-is until that app has been decommissioned . . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm
No new posts CICS TS 5.3 migr after DFHCSDUP UPGRA... Kyle Carroll CICS 6 Wed Aug 31, 2016 10:58 pm
No new posts COBOL compiler upgrade vicky10001 COBOL Programming 4 Mon Jul 25, 2016 1:44 pm
No new posts Enterprise COBOL Upgrade from 4.2 to 5.2 enrico-sorichetti COBOL Programming 2 Fri Jan 08, 2016 11:45 am
No new posts Looking for experience sharing for CO... Francis Tchang COBOL Programming 0 Tue Dec 09, 2014 11:57 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us