Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 25664 invoked from network); 2 Feb 2007 15:43:28 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2007 15:43:19 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B5ED5D4EDD; Fri, 2 Feb 2007 15:36:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28941-06-3; Fri, 2 Feb 2007 15:36:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9832B5D4EF0; Fri, 2 Feb 2007 15:36:16 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 02 Feb 2007 15:35:04 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A37115D4E28 for ; Fri, 2 Feb 2007 15:35:04 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28590-04 for ; Fri, 2 Feb 2007 15:35:04 -0500 (EST) Received: from plmler1.mail.eds.com (plmler1.mail.eds.com [199.228.142.71]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4356C5D4DF9 for ; Fri, 2 Feb 2007 15:34:59 -0500 (EST) Received: from plmlir4.mail.eds.com (plmlir4-2.mail.eds.com [199.228.142.134]) by plmler1.mail.eds.com (8.13.8/8.12.10) with ESMTP id l12Ka3fw008915 for ; Fri, 2 Feb 2007 14:36:04 -0600 Received: from plmlir4.mail.eds.com (localhost [127.0.0.1]) by plmlir4.mail.eds.com (8.13.8/8.12.10) with ESMTP id l12KZEuX021319 for ; Fri, 2 Feb 2007 14:35:14 -0600 Received: from usplm016.amer.corp.eds.com ([148.94.166.9]) by plmlir4.mail.eds.com (8.13.8/8.12.10) with ESMTP id l12KZECm021314 for ; Fri, 2 Feb 2007 14:35:14 -0600 Received: from usahm208.amer.corp.eds.com ([130.175.198.40]) by usplm016.amer.corp.eds.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 2 Feb 2007 14:35:13 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C74709.A3E83234" Subject: RE: DB2 for Oracle DBAs Date: Fri, 2 Feb 2007 15:35:13 -0500 Message-ID: In-reply-to: <65464.30434.qm@web30103.mail.mud.yahoo.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: DB2 for Oracle DBAs From: "Powell, Mark D" To: "oracle-l" X-OriginalArrivalTime: 02 Feb 2007 20:35:13.0865 (UTC) FILETIME=[A4365390:01C74709] X-archive-position: 45098 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-to: mark.powell@eds.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------_=_NextPart_001_01C74709.A3E83234 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I installed, configured, and briefly worked with a DB2 UDB database around version 8.1 on a mainframe Linux partition. =20 Everything you know about how Oracle works internally has tot be suppressed.=20 =20 You will need to learn a new read consistency and locking model. Locks are kept in memory with a lock file written to disk. =20 There is a utility for everything though IBM was working to create ALTER DATABASE commands to perform tasks from within the database like you do with Oracle. =20 The documentation tells you to reorganize indexes for performance. =20 SQL/PL is the internal scripting language. It was new. I found the name interesting. The syntax is not very similar to Oracle's PL/SQL. Prior to SQL/PL you wrote your procedures in COBOL or C and compiled them into the database. Explain plans were created at compile time and if you added a new index it would not be used till you recompiled. =20 I think the manuals are decent. The IBM site provides online access to the official documentation plus IBM Redbooks on specific subjects. =20 The IBM partner who came out to visit us told us that IBM was working as hard as they could to make DB2 more like Oracle and by now some of this may have changed. =20 -- Mark D Powell --=20 Phone (313) 592-5148=20 =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mindaugas Navickas Sent: Friday, February 02, 2007 2:52 PM To: oracle-l Subject: DB2 for Oracle DBAs =09 =09 Hi, =20 I know that some DBAs are tasked to work in mixed environments were they should maintain different databases.=20 If on the list are people who made a transition from Oracle to DB2 DBA, I would appreciate if they can share their experience on following topics: - what resources they found most valuable; - is there any DB2 list similar to Oracle-l; - what experience as Oracle DBA is completely unapplicable as DB2 DBA. =20 Thank you Mindaugas Navickas Oracle DBA OCP 8i,9i,10g =20 ------_=_NextPart_001_01C74709.A3E83234 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
I installed, configured, and briefly worked = with a DB2=20 UDB database around version 8.1 on a mainframe Linux=20 partition.
 
Everything you know about how Oracle works = internally=20 has tot be suppressed. 
 
You will need to learn a new read consistency = and=20 locking model.  Locks are kept in memory with a lock file = written to=20 disk.
 
There is a utility for everything though IBM = was=20 working to create ALTER DATABASE commands to perform tasks from within = the=20 database like you do with Oracle.
 
The documentation tells you to reorganize = indexes for=20 performance.
 
SQL/PL is the internal scripting = language.  It was=20 new.  I found the name interesting.  The syntax is not very = similar to=20 Oracle's PL/SQL.  Prior to SQL/PL you wrote your procedures in = COBOL or C=20 and compiled them into the database.  Explain plans were created at = compile=20 time and if you added a new index it would not be used till you=20 recompiled.
 
I=20 think the manuals are decent.  The IBM site provides online access = to the=20 official documentation plus IBM Redbooks on specific=20 subjects.
 
The=20 IBM partner who came out to visit us told us that IBM was working as = hard as=20 they could to make DB2 more like Oracle and by now some of this may have = changed.
 
-- Mark D Powell = --=20
Phone (313) = 592-5148=20
 

From: = oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mindaugas=20 Navickas
Sent: Friday, February 02, 2007 2:52 = PM
To:=20 oracle-l
Subject: DB2 for Oracle DBAs

Hi,
 
I know that some DBAs are tasked to work in mixed environments = were they=20 should maintain different databases.
If on the list are people who made a transition from Oracle to = DB2 DBA, I=20 would appreciate if they can share their experience on following = topics:
- what resources they found most valuable;
- is there any DB2 list similar to Oracle-l;
- what experience as Oracle DBA is completely unapplicable as DB2 = DBA.
 
Thank you
Mindaugas Navickas
Oracle DBA
OCP 8i,9i,10g
 
------_=_NextPart_001_01C74709.A3E83234-- -- http://www.freelists.org/webpage/oracle-l