FAQ
Is there a tool available to move data from COBOL to ORACLE directly?
One way to do is get COBOL >data on a flat file and then use SQL*Loader
to insert into ORACLE tables.


If you are using SQL*Loader make sure to check the log after load. For
larger loads i would suggest
direct load.
The second question is did anyone use DESIGNER to connect to COBOL to
create an ERD and then >transform into ORACLE tabels script?


I wonder how a tool will take care of Implicit Redefinition/Multiple
Record Structures unless the
Developer/DBA mentions them somewhere.


HTH

GovindanK

<-----Original Message----->

From: Muqthar Ahmed
Sent: 9/30/2003 12:16:28 PM
To: ORACLE-L_at_fatcity.com

Hi,

Thanks
Muqthar Ahmed
DBA

Author: Muqthar Ahmed
INET: Muqthar.Ahmed_at_decoratetoday.com

.


Get Your 10MB account for FREE at http://mail.arabia.com !
Access MILLIONS of JOBS NOW!
<http://ads.arabia.com/?SHT=text_email_english>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Govindan K
INET: gkatteri_at_omanmail.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).

Search Discussions

  • Thomas Day at Oct 1, 2003 at 1:14 pm
    LOL

    Of course the spent a lot on money on veterinarians to inoculate the horses
    against the Y2K bug.

    Mladen Gogala

    @wangtrading.com cc:
    Subject: RE: COBOL TO ORACLE
    Sent by:
    ml-errors

    09/30/2003 05:14
    PM
    Please respond
    to 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: 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).
  • Mladen Gogala at Oct 1, 2003 at 1:49 pm
    COBOL isn't dead, it just smells funny. You know what COBOL stands for,
    don't you? COBOL=Completely Outdated, Badly Overused Language.
    On Tue, 2003-09-30 at 17:24, April Wells wrote:
    COBOL still lives and breathes, though, in many MANY shops (this one
    included). Just like the Mainframe, it won't go away easily or
    soon...

    I feel your pain, though, I lived through it too... and if I never
    have to figure out where an "alter" sends the program based on the
    data ever again I will die happy... worse than any goto around!

    April Wells
    Oracle DBA/Oracle Apps DBA
    Corporate Systems
    Amarillo Texas
    /\
    / \
    / \
    \ /
    \/
    \< \
    \<
    \
    Few people really enjoy the simple pleasure of flying a kite
    Adam Wells age 11



    -----Original Message-----
    From: Mladen Gogala
    Sent: Tuesday, September 30, 2003 4:15 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: COBOL TO ORACLE

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

    The information contained in this communication, including attachments, is strictly
    confidential and for the intended use of the addressee only; it may also contain
    proprietary, price sensitive, or legally privileged information. Notice is hereby given that
    any disclosure, distribution, dissemination, use, or copying of the information by anyone
    other than the intended recipient is strictly prohibited and may be illegal. If you have
    received this communication in error, please notify the sender immediately by reply e-mail,
    delete this communication, and destroy all copies.


    Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to
    this e-mail has been swept for viruses. We specifically disclaim all liability and will
    accept no responsibility for any damage sustained as a result of software viruses and advise
    you to carry out your own virus checks before opening any attachment.
    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).
  • Tim Gorman at Oct 1, 2003 at 4:44 pm
    Wonderful race, the Romans. Just super!
    on 9/30/03 3:34 PM, Jesse, Rich at Rich.Jesse_at_qtiworld.com wrote:

    Crucifixion is a perfectly viable form of punishment, but only for the first
    offense.

    Best thing the Romans ever done for us. Oh, yeah. If we didn't have
    crucifixion, this country would be in a right bloody mess.


    Rich Jesse,
    People's Front of Judea
    -----Original Message-----
    From: Mladen Gogala
    Sent: Tuesday, September 30, 2003 4:15 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: COBOL TO ORACLE

    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.
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Tim Gorman
    INET: tim_at_sagelogix.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).
  • Babette.turnerunderwood_at_hrdc-drhc.gc.ca at Oct 1, 2003 at 7:09 pm
    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: 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).
  • Jesse, Rich at Oct 1, 2003 at 7:29 pm
    Eeep! Reminds me of my CICS programming in school on a 4MB (MEGA bytes) IBM
    4341 with the student partition on the lowest priority. For some reason,
    the operator got really mad at me when I forgot to put an unexecutable EXIT
    statement in my code...

    Barring any OS stats, have you tried a 10046 trace on any of the slow
    processes to see where the holdup is? It's been about 15 years since my
    mainframe days in school, but I'd still question 2.4GB worth of SGA on a 2GB
    machine, and that's without server processes, OS, etc... What is "virtual"
    memory? DISK!

    Rich

    Rich Jesse System/Database Administrator
    rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
    -----Original Message-----
    From: babette.turnerunderwood_at_hrdc-drhc.gc.ca

    Sent: Wednesday, October 01, 2003 2:10 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: COBOL TO ORACLE


    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.
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Jesse, Rich
    INET: Rich.Jesse_at_qtiworld.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).
  • Thomas Day at Oct 1, 2003 at 7:59 pm
    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.

    @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: 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).
  • Jay Hostetter at Oct 1, 2003 at 7:59 pm
    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).
  • Babette.turnerunderwood_at_hrdc-drhc.gc.ca at Oct 7, 2003 at 7:59 pm
    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.

    @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: 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: 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).
  • Thomas Day at Oct 7, 2003 at 8:29 pm
    I went to IBM's web site (http://www-1.ibm.com/servers/eserver/zseries/os/)
    and found OS/390 -

    OS/390
    OS/390, the foundation of the new z/OS, provides high levels of availability, scale and
    manageability for mission-critical workloads, with such features as Workload Manager and
    Parallel Sysplex support. OS/390 is an integrated offering of many elements and optional
    features, including new technologies such as Enterprise Java Beans, XML, and HTML. OS/390
    provides the qualities of service needed to meet the demands of global e-business.

    Notice the mention of Workload Manager --- Basically setting the priorities
    of various processes as to when they will be swapped back in. I suspect
    that your SYSADMIN is trained in the current version but does not
    understand the underlying technology. If there were no swapping then only
    one user could be signed on at a time, they could only run one process, and
    when they went to print the process would stop until the printing was
    finished.

    @hrdc-drhc.gc.ca cc:
    Subject: RE: COBOL TO ORACLE
    Sent by:
    ml-errors

    10/07/2003 03:59
    PM
    Please respond
    to ORACLE-L

    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.

    @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:
    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:
    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).
  • Babette.turnerunderwood_at_hrdc-drhc.gc.ca at Oct 8, 2003 at 2:34 pm
    Welcome to MY world :-(

    Basically, we need to get a Volkswagen to run faster than a Ferrari.

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

    I went to IBM's web site (http://www-1.ibm.com/servers/eserver/zseries/os/)
    and found OS/390 -

    OS/390
    OS/390, the foundation of the new z/OS, provides high levels of availability, scale and
    manageability for mission-critical workloads, with such features as Workload Manager and
    Parallel Sysplex support. OS/390 is an integrated offering of many elements and optional
    features, including new technologies such as Enterprise Java Beans, XML, and HTML. OS/390
    provides the qualities of service needed to meet the demands of global e-business.

    Notice the mention of Workload Manager --- Basically setting the priorities
    of various processes as to when they will be swapped back in. I suspect
    that your SYSADMIN is trained in the current version but does not
    understand the underlying technology. If there were no swapping then only
    one user could be signed on at a time, they could only run one process, and
    when they went to print the process would stop until the printing was
    finished.

    @hrdc-drhc.gc.ca cc:
    Subject: RE: COBOL TO ORACLE
    Sent by:
    ml-errors

    10/07/2003 03:59
    PM
    Please respond
    to ORACLE-L

    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.

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 1, '03 at 12:04a
activeOct 8, '03 at 2:34p
posts11
users7
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase