Oracle-L: Re: No DBAs needed on AS400

From: Tim Gorman <Tim_at_SageLogix.com>
Date: Thu, 11 Apr 2002 13:58:32 -0800
Message-ID: <F001.00442874.20020411135832@fatcity.com>

RE: No DBAs needed on AS400I believe that there are ODBC and JDBC drives for OS/400...

Original Message ----- From: Godlewski, Melissa To: Multiple recipients of list ORACLE-L Sent: Thursday, April 11, 2002 1:28 PM Subject: RE: No DBAs needed on AS400

Comments were made that DB2 and AS400s are not "open". Does this mean that you couldn't write a client/server program to access data on DB2 (say using C++ from Windows 2000)?

RUMBA/400 formerly pc support connects to the AS400 from a windows pc. Last I knew, the AS400 data need to be converted from EBCDIC into the wrkdoc area for ASCII in order for Rumba/400 to work with it correctly.

-----Original Message-----
From: Jay Hostetter [mailto:jhostetter_at_decommunications.com] Sent: Thursday, April 11, 2002 2:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: No DBAs needed on AS400

Thank you for all the replies that I have received.

It sounds like a version of DB2 comes along with the OS, or a full fledged version of DB2 can be installed. From what I have heard about their AS400 system, they can access their files directly - without going through a database. This reminds me of my COBOL days on VMS. It sounds like DB2 can be configured to use files, which would mean that you could either update the file directly or go through DB2 - is this correct? I can also make another VMS relation here - we had a tool called DataTrieve which you could configure to use regular files. You could then issue SQL like statements through DataTrieve against your files. Is DB2 like this? Somebody needed to configure DataTrieve before it could reference a file - what about DB2? Unless "they" never changed/added files on the AS400.

Comments were made that DB2 and AS400s are not "open". Does this mean that you couldn't write a client/server program to access data on DB2 (say using C++ from Windows 2000)?

I'm off to find on-line docs...

Answers to some questions:

>Does it have DB2 as the database?

He didn't say that it was running DB2.

>If you are performing queries from Oracle to DB2 (SQL Queries), that is being performed through Oracle's gateway product.

We are not doing this.

>>> DWILLIAMS_at_LIFETOUCH.COM 04/11/02 10:44AM >>>
Jay - I can see the manager's confusion. After all, one expects computers to become easier and require less effort to maintain as time goes by. I forwarded your question to another list that has some AS/400 programmers.

On the AS400 you can run queries and use SQL even though the machine is configured to use files. Under the covers it is still AS400/DB2.

The AS/400 has a full-featured database built into the operating system. Originally it didn't even have a name but IBM started calling it DB2/400 when they found out that some people didn't know it was there. And you don't need a DBA. Virtually all the functions that are performed by a DBA on an Oracle database, for example, are handled automatically by the AS/400 under the covers.

  Dennis Williams
  DBA
  Lifetouch, Inc.
  dwilliams_at_lifetouch.com

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

  Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 
  San Diego, California        -- Public Internet access / Mailing Lists 
  --------------------------------------------------------------------

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.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Thu Apr 11 2002 - 16:58:32 CDT