Oracle-L: RE: COBOL TO ORACLE

From: <babette.turnerunderwood_at_hrdc-drhc.gc.ca>
Date: Tue, 07 Oct 2003 11:59:25 -0800
Message-ID: <F001.005D24AF.20031007115925@fatcity.com>

Sorry for the delay ...

Was at Ottawa Oracle User Group Days last week and spent the time since then playing catch-up

Yes, we are using OS/390 v10.
I STRONGLY suspect the SYSADMIN is wrong. There HAS to be swapping / paging going on, but he insists this is not the case.

Babette Turner-Underwood
work: babette.turnerunderwood_at_hrdc-drhc.gc.ca home: babette_at_rogers.com
954-3752 (Mon - Fri 7am - 3pm)

-----Original Message-----
Sent: 2003-10-01 4:00 PM
To: Multiple recipients of list ORACLE-L

What kind of a mainframe is that?

Usually "mainframe" means an IBM machine based on 370 architecture. If that's the case then your SYSADMIN is wrong. Many, many years ago I started out as a computer operator for an IBM 370/165 and worked with IBM mainframes up through the E6000 series. They all work as virtual machines, swapping and paging sessions in and out of the physical RAM.

Of course, you may have some other type of mainframe, in which case, what I said doesn't apply.

                                                                                                                                       
                      <babette.turneru                                                                                                 
                      nderwood                 To:      Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      @hrdc-drhc.gc.ca         cc:                                                                                     
                      >                        Subject: RE: COBOL TO ORACLE                                                            
                      Sent by:                                                                                                         
                      ml-errors                                                                                                        
                                                                                                                                       
                                                                                                                                       
                      10/01/2003 03:09                                                                                                 
                      PM                                                                                                               
                      Please respond                                                                                                   
                      to ORACLE-L

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.

Note:
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
  INET: mladen_at_wangtrading.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <babette.turnerunderwood_at_hrdc-drhc.gc.ca
  INET: babette.turnerunderwood_at_hrdc-drhc.gc.ca

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).





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
  INET: tday6_at_csc.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <babette.turnerunderwood_at_hrdc-drhc.gc.ca
  INET: babette.turnerunderwood_at_hrdc-drhc.gc.ca

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).

Received on Tue Oct 07 2003 - 14:59:25 CDT