DB2 and Java or Cobol

Bill Thompson

DB2 and Java or Cobol
Our organization is looking at converting our current Adabas / Natural
environment to possibly COBOL / DB2 or JAVA / DB2...

Since the upcoming decision is kind of new technical wise to both myself and
my colleague..we were wondering what others might be doing out there and
what works better than the other

My colleague and I had the pleasure of attending the IBM IOD Conference this
past October in Las Vegas..the thing we focused on was trying to learn all we
could about DB2 and what it could do...let's just say it was information
overload after we were done...

I guess the thing we probably didn't consider or just plain forgot to find out is
what works best with DB2...

Do most people run COBOL or Java...maybe both?

We are being asked to make Technical decisions about both products but how
can we make that decision since we are Adabas Natural people...

Right now our current environment could support COBOL if they go that
route...we have no clue on Java and its ramifications....

I know the question is pretty open ended but I thought I would ask...

Thanks,
Bill

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Brenda Boshoff

Re: DB2 and Java or Cobol
(in response to Bill Thompson)
Hi,

I cannot answer the question of what works better, Cobol or Java, but perhaps it is of interest that we are in the beginning stages of converting our main Z/OS based application to Java/ DB2. We have been running Natural/SAG products on Z/OS with DB2 as the data repository. Adabas is only used to store the SAG products. Our data will remain in DB2 and no conversion is necessary. The Natural developers are now learning Java and EJBs. We are in the process of upgrading DB2 v8 to DB2 v9 and I am looking forward to using the new security features and the native SQL stored procedures.

Regards,
Brenda.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Bill Thompson
Sent: Thursday, January 29, 2009 10:19 AM
To: [login to unmask email]
Subject: DB2 and Java or Cobol

Our organization is looking at converting our current Adabas / Natural
environment to possibly COBOL / DB2 or JAVA / DB2...

Since the upcoming decision is kind of new technical wise to both myself and
my colleague..we were wondering what others might be doing out there and
what works better than the other

My colleague and I had the pleasure of attending the IBM IOD Conference this
past October in Las Vegas..the thing we focused on was trying to learn all we
could about DB2 and what it could do...let's just say it was information
overload after we were done...

I guess the thing we probably didn't consider or just plain forgot to find out is
what works best with DB2...

Do most people run COBOL or Java...maybe both?

We are being asked to make Technical decisions about both products but how
can we make that decision since we are Adabas Natural people...

Right now our current environment could support COBOL if they go that
route...we have no clue on Java and its ramifications....

I know the question is pretty open ended but I thought I would ask...

Thanks,
Bill

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Larry Jardine

Re: DB2 and Java or Cobol
(in response to Brenda Boshoff)
You can use Natural with DB2, too.

Larry Jardine
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bill Thompson
Sent: Thursday, January 29, 2009 10:19 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 and Java or Cobol

Our organization is looking at converting our current Adabas / Natural
environment to possibly COBOL / DB2 or JAVA / DB2...

Since the upcoming decision is kind of new technical wise to both myself
and
my colleague..we were wondering what others might be doing out there and

what works better than the other

My colleague and I had the pleasure of attending the IBM IOD Conference
this
past October in Las Vegas..the thing we focused on was trying to learn
all we
could about DB2 and what it could do...let's just say it was information

overload after we were done...

I guess the thing we probably didn't consider or just plain forgot to
find out is
what works best with DB2...

Do most people run COBOL or Java...maybe both?

We are being asked to make Technical decisions about both products but
how
can we make that decision since we are Adabas Natural people...

Right now our current environment could support COBOL if they go that
route...we have no clue on Java and its ramifications....

I know the question is pretty open ended but I thought I would ask...

Thanks,
Bill

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events
*
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password.
You should have gotten an e-mail with the temporary password assigned to
your account. Please log in and update your member profile. If you are
not already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html
This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Cuneyt Goksu

Re: DB2 and Java or Cobol
(in response to Larry Jardine)
Hi,

From the app dev point, cobol is very similar to natural. Java will be new world for you. Cobol will perform better than java. It depends where u run your java workload, in z or non z platform, jdbc or sqlj and more. I have been working a similar project mig from nat\db2 to java\db2 and have many things to say.
Moving data is another story.. From pe\mu to relational.
There are some vendors that provide both code conv and data migration with lots of pros and cons.

Briefly, it works but needs really really good project management.

Regards
Cuneyt
------Original Message------
From: Bill Thompson
Sender: DB2 Data Base Discussion List
To: [login to unmask email]
ReplyTo: DB2 Database Discussion list at IDUG
Subject: [DB2-L] DB2 and Java or Cobol
Sent: Jan 29, 2009 17:18

Our organization is looking at converting our current Adabas / Natural
environment to possibly COBOL / DB2 or JAVA / DB2...

Since the upcoming decision is kind of new technical wise to both myself and
my colleague..we were wondering what others might be doing out there and
what works better than the other

My colleague and I had the pleasure of attending the IBM IOD Conference this
past October in Las Vegas..the thing we focused on was trying to learn all we
could about DB2 and what it could do...let's just say it was information
overload after we were done...

I guess the thing we probably didn't consider or just plain forgot to find out is
what works best with DB2...

Do most people run COBOL or Java...maybe both?

We are being asked to make Technical decisions about both products but how
can we make that decision since we are Adabas Natural people...

Right now our current environment could support COBOL if they go that
route...we have no clue on Java and its ramifications....

I know the question is pretty open ended but I thought I would ask...

Thanks,
Bill

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html


AVEA BlackBerry® Servisi ile gönderildi.

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Philip Sevetson

Re: DB2 and Java or Cobol
(in response to Cuneyt Goksu)
Bill,

I worked, a couple of years ago, for a company that used COBOL for its
mainframe processing and DB2 stored procedures (Wakefern Food Corp. of
Elizabeth, NJ), and then used JAVA for its browser-based front end.
There weren't a lot of people who knew both COBOL and JAVA, but the
company got very good results as far as both flexibility and processing
speed (as someone else has mentioned, COBOL is statement-for-statement
faster to execute than Java, and is therefore preferred for
high-frequency and/or CPU intensive stored procedures).

--Phil

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bill Thompson
Sent: Thursday, January 29, 2009 10:19 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 and Java or Cobol

Our organization is looking at converting our current Adabas / Natural
environment to possibly COBOL / DB2 or JAVA / DB2...

Since the upcoming decision is kind of new technical wise to both myself
and my colleague..we were wondering what others might be doing out there
and what works better than the other

My colleague and I had the pleasure of attending the IBM IOD Conference
this past October in Las Vegas..the thing we focused on was trying to
learn all we could about DB2 and what it could do...let's just say it
was information overload after we were done...

I guess the thing we probably didn't consider or just plain forgot to
find out is what works best with DB2...

Do most people run COBOL or Java...maybe both?

We are being asked to make Technical decisions about both products but
how can we make that decision since we are Adabas Natural people...

Right now our current environment could support COBOL if they go that
route...we have no clue on Java and its ramifications....

I know the question is pretty open ended but I thought I would ask...

Thanks,
Bill

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events
* ______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password.
You should have gotten an e-mail with the temporary password assigned to
your account. Please log in and update your member profile. If you are
not already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html


=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

M. Khalid Khan

Re: DB2 and Java or Cobol
(in response to Philip Sevetson)
I'd suggest you to use both Java and COBOL as well as SQL PL (for native
stored procedures). Use COBOL for non interactive (batch) processes and
use Java for interactive ones. Let Java handle the user interaction and
display but use stored procedure for the rest i.e. business logic and data
access. Avoid the natural tendency of Java designers and coders to use
database as an index file system i.e. accessing row at a time, always
selecting/updating all columns, not using SQL joins etc.. You will be
paying for DB2, make use of its capabilities.

Khalid




Our organization is looking at converting our current Adabas / Natural
environment to possibly COBOL / DB2 or JAVA / DB2...

Since the upcoming decision is kind of new technical wise to both myself
and
my colleague..we were wondering what others might be doing out there and
what works better than the other

My colleague and I had the pleasure of attending the IBM IOD Conference
this
past October in Las Vegas..the thing we focused on was trying to learn all
we
could about DB2 and what it could do...let's just say it was information
overload after we were done...

I guess the thing we probably didn't consider or just plain forgot to find
out is
what works best with DB2...

Do most people run COBOL or Java...maybe both?

We are being asked to make Technical decisions about both products but how

can we make that decision since we are Adabas Natural people...

Right now our current environment could support COBOL if they go that
route...we have no clue on Java and its ramifications....

I know the question is pretty open ended but I thought I would ask...

Thanks,
Bill

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You
should have gotten an e-mail with the temporary password assigned to your
account. Please log in and update your member profile. If you are not
already an IDUG.org member, please register at
http://www.idug.org/component/juser/register.html




**********

The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312)653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas.

**********


______________________________________________________________________

* IDUG 2009 Rome, Italy * 5-9 October * http://IDUG.ORG/Events *
______________________________________________________________________



IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Ed Krisiewicz

Re: DB2 and Java or Cobol
(in response to M. Khalid Khan)
Be careful with Cobol. I hear it's going away!!

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Troy Coleman

Re: DB2 and Java or Cobol
(in response to Ed Krisiewicz)
Too Funny! COBOL is never going away. It just keeps getting better :-)

Troy Coleman, Technical Sales Engineer
IBM Certified Database Administrator - DB2 9 for z/OS and LUW

SoftBase Systems, Inc.
847-776-0618
828-670-9900 ext. 334
[login to unmask email]

Compliance Challenged with Test Data Privacy? White Papers and More at http://www.softbase.com/

The information contained in this message may be CONFIDENTIAL and is for the intended addressee only. Any unauthorized use, dissemination of the information, or copying of this message is prohibited. If you are not the intended addressee, please notify the sender immediately and delete this message.



Ed Krisiewicz wrote:
> Be careful with Cobol. I hear it's going away!!
>
> ______________________________________________________________________
>
> * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
> ______________________________________________________________________
>
>
>
>
> IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html
>
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Roger Miller

Re: DB2 and Java or Cobol
(in response to Troy Coleman)
At IOD, Gopal Krishnan and Todd Munk of the DB2 performance group
presented session 2296, a discussion of what language to use for stored
procedure development with some of the typical factors and some
performance measurements. I think we discussed high performance Java as
well in another session. I think those sessions will be at conferences this year
too, as they were well received.

The key is to understand your priorities and types of applications
– Throughput Performance
– Billable CPU Cost (reduced accounting for zIIP and zAAP)
– Productivity
– Future availability of development resource
– Scope of application, data to logic ratio, skills, existing portfolio, workload, ...

The languages are fairly competitive, and your priorities will generally
shift the choice of languages significantly.

Roger Miller, DB2 for z/OS

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html

Ted MacNEIL

Re: DB2 and Java or Cobol
(in response to Roger Miller)
>Be careful with Cobol. I hear it's going away!!

I assume you're joking!
COBOL is NOT going away.

-
Too busy driving to stop for gas!

______________________________________________________________________

* IDUG 2009 Melbourne, Australia * 18-20 March * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html