IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Thu Jun 13, 2013 7:01 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Jun 13, 2013 7:18 pm
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
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
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

Moderator Emeritus


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

PostPosted: Thu Jun 13, 2013 8:42 pm
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
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
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: 1020
Location: India

PostPosted: Mon Jun 17, 2013 12:52 pm
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
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
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: 1020
Location: India

PostPosted: Tue Jun 18, 2013 10:55 am
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
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

Moderator Emeritus


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

PostPosted: Tue Jun 18, 2013 8:52 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


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
Search our Forums:

Back to Top