RE: COBOL TO ORACLE

What OS are you using? I assume the COBOL app resides on the same box as the database? When performance is poor, can you see what the top processes are?

As for the merits of COBOL, our COBOL apps hum along very nicely, processing millions of records a month. Also, I like having conversations with developers that tell me "I connect to the database and run this SQL statement..." vs getting into some convoluted discussion about objects, object servers, ODBC formatted SQL, etc. Perhaps I'm blissfully ignorant about some aspects of programming, but I can tell you that our COBOL programs that follow the KISS method give us the least amount of headaches.

Jay

>>> babette.turnerunderwood_at_hrdc-drhc.gc.ca 10/01/03 03:09PM >>> Then perhaps you can help me . . .

We are suffering through a Pro*Cobol / Oracle on the mainframe implementation for a newly developed in house application.

We have a mainframe with 1.7GB - 2GB REAL memory. 4 CPU machine - we have two logical CPUs in our LPAR We have 8 instances running (each with at least 300MB SGA) We are having major performance problems when people start doing a lot of work on these instances.

The Mainframe SYSADMIN insists that there is NO swapping, NO paging occuring. There is no problem because each instance can have 2GB VIRTUAL memory and this is fine and dandy because this is how the mainframe works.

Did you ever use Oracle on a mainframe? Did you come up with guidelines for minimum requirements? (like in the UNIX install guides / NT install guides, you need X RAM, etc)

Thanks
Babette

-----Original Message-----
Sent: 2003-09-30 5:15 PM
To: Multiple recipients of list ORACLE-L

On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote:
> Like Thomas Day said, Oracle is an rdbms and COBOL a programming language.
>

COBOL *** WAS *** a programming language. Horse *** WAS *** basis of transport. You should have used past tense, Stephane. I'm not really that partial when it comes to horses, but having suffered COBOL, I would really leave it in the ancient past, together with Spanish Inquisition and crucifiction as a viable capital punishment.

**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Hostetter
  INET: jhostetter_at_decommunications.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).