Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    78

    Unanswered: how do you get to oracle from cics?

    currently, we have a mess. I believe we are running oracle v11 on aix. in our development region, we are running some sort of "oracle" connection code in our cics region with these libraries defined in our cics region.
    ORA1.ORAV10G.AUTHLOAD
    ORA1.ORAV10G.CMDAUTH,

    in production, we are running this "oracle" connection code v8 and it uses something called tnsproc that is somehow in the middle. about 5 years ago the upgrade stopped and never made it into production.

    now, i'm unsure what to do. is there any other way to get from cics running on z/os to oracle running on the server other than installing code on the cics region?

    I am familiar that if I had a db2 server running off the mainframe, I could set up the connections on z/os db2 and connect to the db2 running distributed. I assume (never tried) that you could get to this distributed server from a cics region using db2 without any type of change. maybe i'm talking out the other end, but I would love to get out of installing software for this...seems barbaric.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Those library names you posted may be specific to your installation, therefore mean nothing neither provide any useful information. Perhaps they only hint at version 10 of the Oracle software.

    What you need is two components:

    1) An Oracle client certified for your OS ( with corresponding libraries ).
    2) The Oracle Pro*COBOL® pre-compiler.
    3) A Network connection between your server and the server where the Oracle database resides.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I am unclear why you posted in this Oracle forum.
    Oracle DB does not know or care about the "flavor" of client that connects to it.
    If your software knows how to use any of the supported protocols (JDBC, ODBC, TNS, etc.), then Oracle will accept the connection request.

    Good Luck with you search for a solution.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Is the goal to transport CICS data sets to Oracle, or to allow CICS transactions to access data in the Oracle database?

    If you need to access the Oracle database interactively from CICS panels, then you will need to install the appropriate Oracle modules (including TNS in some form).

    Note that on a z/OS machine it is FAR easier to install the Oracle interface as its own LPAR, then use the appropriate libraries (CICS, TSO, etc.) to access the remote Oracle server.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •