Re: SQL Server replacement

2010-04-01 Thread Shmuel Metz (Seymour J.)
In 2d14e7856646224aacdda13ab1d3555706a2b36...@wdcv7exvs2.opm.gov, on
03/25/2010
   at 09:19 AM, Richards, Robert B. robert.richa...@opm.gov said:

If we were looking to replace Microsoft's SQL Server with something on
System z, what would my options be and how much effort would be required
to move it there?

I'd suggest DB2 or PostGreSQL, but there are plenty of other options.
 
-- 
 Shmuel (Seymour J.) Metz, SysProg and JOAT
 ISO position; see http://patriot.net/~shmuel/resume/brief.html 
We don't care. We don't have to care, we're Congress.
(S877: The Shut up and Eat Your spam act of 2003)

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-04-01 Thread Anne Lynn Wheeler
The following message is a courtesy copy of an article
that has been posted to bit.listserv.ibm-main,alt.folklore.computers as well.


mw...@ssfcu.org (Ward, Mike S) writes:
 I have heard of IFL's for zLinux and DB/2 running under zLinux. We have
 DB/2 running on z/OS and also DB/2 connect on the distributed side and
 it is used to access DB/2 on the mainframe.

then there is:
http://www.garlic.com/~lynn/2009p.html#43 From The Annals of Release No 
Software Before Its Time
http://www.garlic.com/~lynn/2009p.html#46 From The Annals of Release No 
Software Before Its Time

DB2 announces technology that trumps Oracle RAC and Exadata
http://freedb2.com/2009/10/10/for-databases-size-does-matter/

trivia ... SQL server was originally licensed from Sybase
http://en.wikipedia.org/wiki/Sybase

Founded by Epstein ... mentioned here:
http://en.wikipedia.org/wiki/Michael_Stonebraker

The original relational/sql was system/r ... some number of past posts
http://www.garlic.com/~lynn/subtopic.html#systemr

Bob had been CTO at Britton-Lee and after he left ... there were various
meetings across the street from bldg 28 ... recruiting his replacement.

After we left in the early 90s ... and during the mainframe troubles of
the period ... there was corporate effort to try and get a lot of
applications  DBMS made available on mainframes. In some number of
these discussions between people from corporate hdqtrs and others
(including Bob) ... we were ask to sit in ... as translators (being able
to speak both mainframe and non-mainframe).

-- 
42yrs virtualization experience (since Jan68), online at home since Mar1970

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-26 Thread Michael Knigge

Richards, Robert B. schrieb:

If we were looking to replace Microsoft's SQL Server with something on System 
z, what would my options be and how much effort would be required to move it 
there?


Well migrating to another DBMS is mostly a big challenge. If you are 
using just plain valinna stuff (i. e. no properitary column types, 
stored procedures, triggers, ...) then changin the DBMS is mostly 
painless...


But if there are a lot of special things (see samples above), then... 
eh... have fun ;-



As we are an ISV our products have to support a wide range of DBMS. We 
used MS-SQL Server, MySQL, PostgreSQL, Oracle and DB2 (unix and z/OS) in 
the past and they all have pros and cons.


For example: DB2 is rock-solid and very, very close on the SQL-92 
standard (well, but that is not always a gift - for example SQL-92 
states that leading spaces from CHAR(n) columns should not be removed 
and so DB2 doesn't removes them on retrieval - most other DBMS (as 
MS-SQL) do so). But administrating DB2 is not that easy imho.


Oracle is somehow rock-solid also, but I personally *HATE* tha Java 
Frontend that comes with Oracle. Furthermore I *HATE* the fact that you 
need a GUI to install Oracle (or I was too stupid to do without a GUI). 
I had to install X11 on a server just to install Oracle. Oracle also has 
its own datatypes (no INTEGER, SMALLINT and so on... Oracle knows 
NUMBER). And what is sometimes really a pain: Oracle doesn't know 
columns containiung NULL.


PostgreSQL... a great performer, great fetures but the ODBC driver is 
(sorry) crap, crap, crap If you really need ODBC, I pers. would 
avoid PostgreSQL.


MS-SQL Hmmm The system is somehow ok, the ODBC-Driver is 
stable but stupid (supports mostly just the base that is needed).


MySQL Well from a users, administrators and coders view, this is 
my favorite. Most of MySQL-Stuff is just so simple. The Server is 
installed in just one or two minutes, the ODBC-Driver is just a dream 
and using/administrating MySQL is *VERY* simple. But I've heard from 
some colleagues that they had problems with MySQL when they used rather 
big databases (multiple Gigs). But I don't remember exactly the problems 
they had...



As you see. The answer to your questing is it depends as always. I 
pers. would try MySQL on z/Linux. If ODBC is not needed you could/should 
try PostgreSQL also. DB2 is also great - I like this DBMS, but 
administrating is more overhead as for PostgreSQL and MySQL



Bye,
Michael

--
Yours sincerely

Michael Knigge
Development


S.E.T. Software GmbH
Lister Straße 15
30163 Hannover
GERMANY

Tel.  +49 511/3 97 80-23
Fax   +49 511/3 97 80-65
michael.kni...@set-software.de

Commercial Registry: HRB52778 Local Court Hannover
Chief Executive Officer: Till Dammermann, Dr. Bernd Huber

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-26 Thread Richards, Robert B.
Michael,

Thank you for your perspective. I'll pass it up the food chain. :-)

Bob

-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of 
Michael Knigge
Sent: Friday, March 26, 2010 5:40 AM
To: IBM-MAIN@bama.ua.edu
Subject: Re: SQL Server replacement

Richards, Robert B. schrieb:
 If we were looking to replace Microsoft's SQL Server with something on System 
 z, what would my options be and how much effort would be required to move it 
 there?

Well migrating to another DBMS is mostly a big challenge. If you are 
using just plain valinna stuff (i. e. no properitary column types, 
stored procedures, triggers, ...) then changin the DBMS is mostly 
painless...

But if there are a lot of special things (see samples above), then... 
eh... have fun ;-


As we are an ISV our products have to support a wide range of DBMS. We 
used MS-SQL Server, MySQL, PostgreSQL, Oracle and DB2 (unix and z/OS) in 
the past and they all have pros and cons.

For example: DB2 is rock-solid and very, very close on the SQL-92 
standard (well, but that is not always a gift - for example SQL-92 
states that leading spaces from CHAR(n) columns should not be removed 
and so DB2 doesn't removes them on retrieval - most other DBMS (as 
MS-SQL) do so). But administrating DB2 is not that easy imho.

Oracle is somehow rock-solid also, but I personally *HATE* tha Java 
Frontend that comes with Oracle. Furthermore I *HATE* the fact that you 
need a GUI to install Oracle (or I was too stupid to do without a GUI). 
I had to install X11 on a server just to install Oracle. Oracle also has 
its own datatypes (no INTEGER, SMALLINT and so on... Oracle knows 
NUMBER). And what is sometimes really a pain: Oracle doesn't know 
columns containiung NULL.

PostgreSQL... a great performer, great fetures but the ODBC driver is 
(sorry) crap, crap, crap If you really need ODBC, I pers. would 
avoid PostgreSQL.

MS-SQL Hmmm The system is somehow ok, the ODBC-Driver is 
stable but stupid (supports mostly just the base that is needed).

MySQL Well from a users, administrators and coders view, this is 
my favorite. Most of MySQL-Stuff is just so simple. The Server is 
installed in just one or two minutes, the ODBC-Driver is just a dream 
and using/administrating MySQL is *VERY* simple. But I've heard from 
some colleagues that they had problems with MySQL when they used rather 
big databases (multiple Gigs). But I don't remember exactly the problems 
they had...


As you see. The answer to your questing is it depends as always. I 
pers. would try MySQL on z/Linux. If ODBC is not needed you could/should 
try PostgreSQL also. DB2 is also great - I like this DBMS, but 
administrating is more overhead as for PostgreSQL and MySQL


Bye,
Michael

-- 
Yours sincerely

Michael Knigge
Development


S.E.T. Software GmbH
Lister Straße 15
30163 Hannover
GERMANY

Tel.  +49 511/3 97 80-23
Fax   +49 511/3 97 80-65
michael.kni...@set-software.de

Commercial Registry: HRB52778 Local Court Hannover
Chief Executive Officer: Till Dammermann, Dr. Bernd Huber

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-26 Thread Timothy Sipples
IBM offers a database migration toolkit at no charge here:

http://www-01.ibm.com/software/data/db2/migration/mtk/

The toolkit assists with migrations from Microsoft SQL Server (several
versions) to either DB2 or Informix. On System z that means you could run
any of these three choices:

DB2 for Linux on System z
Informix Dynamic Server for Linux on System z
DB2 for z/OS

The toolkit does not *explicitly* support migration from SQL Server to DB2
for z/OS, but you're supposed to read between the lines on that. In other
words, you just need a bootstrap migration via DB2 for Linux, thence to
DB2 for z/OS. (DB2 Express-C is probably sufficient as the intermediate
migration database, and you can download DB2 Express-C at no charge. Since
SQL Server only runs on Microsoft Windows you could probably use DB2
Express-C on Windows first, to avoid procuring additional hardware or
operating system licenses.)

If you need assistance with the migration, IBM offers services at
reasonable rates. Depending on the workload, IBM may also offer special
pricing. (If you qualify for the System z Solution Edition for Data
Warehousing, for example, that would probably be advantageous.)

- - - - -
Timothy Sipples
Resident Architect
STG Value Creation and Complex Deals
IBM Growth Markets
E-Mail: timothy.sipp...@us.ibm.com
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


SQL Server replacement

2010-03-25 Thread Richards, Robert B.
I am way out of my element on this topic, so I thought I'd post this query:

If we were looking to replace Microsoft's SQL Server with something on System 
z, what would my options be and how much effort would be required to move it 
there?

Bob

-
Robert B. Richards(Bob)
US Office of Personnel Management
1900 E Street NW Room: BH04L
Washington, D.C.  20415
Phone: (202) 606-1195
Email: robert.richa...@opm.govmailto:robert.richa...@opm.gov
-

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-25 Thread Scott Rowe
I would think that DB2 on z/OS, or any RDMS (DB2, Oracle, MySQL, etc) on Linux 
would do the job. 

 Richards, Robert B. robert.richa...@opm.gov 3/25/2010 9:19 AM 
I am way out of my element on this topic, so I thought I'd post this query:

If we were looking to replace Microsoft's SQL Server with something on System 
z, what would my options be and how much effort would be required to move it 
there?

Bob

-
Robert B. Richards(Bob)
US Office of Personnel Management
1900 E Street NW Room: BH04L
Washington, D.C.  20415
Phone: (202) 606-1195
Email: robert.richa...@opm.govmailto:robert.richa...@opm.gov
-

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html 



CONFIDENTIALITY/EMAIL NOTICE: The material in this transmission contains 
confidential and privileged information intended only for the addressee.  If 
you are not the intended recipient, please be advised that you have received 
this material in error and that any forwarding, copying, printing, 
distribution, use or disclosure of the material is strictly prohibited.  If you 
have received this material in error, please (i) do not read it, (ii) reply to 
the sender that you received the message in error, and (iii) erase or destroy 
the material. Emails are not secure and can be intercepted, amended, lost or 
destroyed, or contain viruses. You are deemed to have accepted these risks if 
you communicate with us by email. Thank you.


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-25 Thread David Andrews
On Thu, 2010-03-25 at 09:19 -0400, Richards, Robert B. wrote:
 If we were looking to replace Microsoft's SQL Server with something on
 System z, what would my options be and how much effort would be
 required to move it there?

I have no direct experience, so take this with a dumpster load of NaCl,
but PostgreSQL ought to run on Linux-on-z, and I believe there is an
ODBC driver.

If a Linux VM or LPAR is an option for you, you might ask about it over
on linux-390.

For LINUX-390 subscribe / signoff / archive access instructions,
send email to lists...@vm.marist.edu with the message: INFO LINUX-390 
or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

-- 
David Andrews
A. Duda and Sons, Inc.
david.andr...@duda.com

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-25 Thread Paul Gilmartin
On Thu, 25 Mar 2010 09:49:03 -0400, David Andrews wrote:

I have no direct experience, so take this with a dumpster load of NaCl,
but PostgreSQL ought to run on Linux-on-z, and I believe there is an
ODBC driver.

At:  http://en.wikipedia.org/wiki/Linux_on_zSeries
I see mentioned Oracle, MySQL, PostgreSQL, et al.

-- gil

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-25 Thread Austin, Andrew
I think the general answer you're going to get is 'it depends.'  If you have 
'vanilla' requirements, haven't specialized your SQLServer environment and 
aren't exploiting any SQLServer-only / T-SQL (there might be compatibility 
issues depending on the SQL flavor used by your new-target RDBMS) only 
functions and features, your migration to any other RDBMS might be relatively 
straightforward (yes, I'm hedging my bets with 'might be' and 'relatively').  
That's probably not the case, though . . .  You probably already knew this, but 
you're going to need to invest some time in analyzing your current setup and 
comparing it with the feature-set / configuration options of whatever your 
target system is going to be.

That said, DB2 for z/OS is an option if you intend to not run Linux on z, 
otherwise any Linux compatible RDBMS is a candidate for replacement (Oracle / 
DB2 on Linux / PostegreSQL / MySQL).  I'm not advocating one over the other, 
just outlining some options.  Good luck!




-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of 
Richards, Robert B.
Sent: Thursday, March 25, 2010 8:20 AM
To: IBM-MAIN@bama.ua.edu
Subject: SQL Server replacement

I am way out of my element on this topic, so I thought I'd post this query:

If we were looking to replace Microsoft's SQL Server with something on System 
z, what would my options be and how much effort would be required to move it 
there?

Bob

-
Robert B. Richards(Bob)
US Office of Personnel Management
1900 E Street NW Room: BH04L
Washington, D.C.  20415
Phone: (202) 606-1195
Email: robert.richa...@opm.govmailto:robert.richa...@opm.gov
-

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-25 Thread Richards, Robert B.
Andrew,

Linux on z *is* an option, as is Oracle there, DB2 there and z/OS' DB2.

I have no idea if there are any SQLServer-only exploits, but will relay that 
concern to others.

To all that replied, thanks!  :-)

Bob


-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of 
Austin, Andrew
Sent: Thursday, March 25, 2010 10:02 AM
To: IBM-MAIN@bama.ua.edu
Subject: Re: SQL Server replacement

I think the general answer you're going to get is 'it depends.'  If you have 
'vanilla' requirements, haven't specialized your SQLServer environment and 
aren't exploiting any SQLServer-only / T-SQL (there might be compatibility 
issues depending on the SQL flavor used by your new-target RDBMS) only 
functions and features, your migration to any other RDBMS might be relatively 
straightforward (yes, I'm hedging my bets with 'might be' and 'relatively').  
That's probably not the case, though . . .  You probably already knew this, but 
you're going to need to invest some time in analyzing your current setup and 
comparing it with the feature-set / configuration options of whatever your 
target system is going to be.

That said, DB2 for z/OS is an option if you intend to not run Linux on z, 
otherwise any Linux compatible RDBMS is a candidate for replacement (Oracle / 
DB2 on Linux / PostegreSQL / MySQL).  I'm not advocating one over the other, 
just outlining some options.  Good luck!




-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of 
Richards, Robert B.
Sent: Thursday, March 25, 2010 8:20 AM
To: IBM-MAIN@bama.ua.edu
Subject: SQL Server replacement

I am way out of my element on this topic, so I thought I'd post this query:

If we were looking to replace Microsoft's SQL Server with something on System 
z, what would my options be and how much effort would be required to move it 
there?

Bob

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-25 Thread Luis Andrade
DB2 UDB will fit most of the requirements on a z/OS or z/Linux LPAR.

IBM will tell you how to convert
http://www.redbooks.ibm.com/abstracts/sg246672.html

You can always use an automation tool. See Ispire SQLways or SwissSQL

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-25 Thread Galambos, Robert
This is a loaded question. The simply answer is it depends.

1) it depends on what platform you are talking about. Is it z\OS or USS (Linux 
on the IBM Iron horse)

2) Then it depends on what the DBMS is supporting. Is it a transaction based 
application where response time is important, is it a query type of application?

3) What kind of infrastructure do you have in place right now. Are you already 
running DB2 or Oracle or IMS etc.

4) And finally, but no less important is why the change. Is it because of 
reliability? Cost? DR or what.

Once these questions are asked/answered you can get a better idea on where to 
go from here

Hope this helps and if you want you can contact me off line

 
Robert Galambos CIPP/C CIPP/IT  

Compuware Senior Technical Specialist 
IBM Certified Database Associate 
IBM Certified DB2 9 for z/OS Database Administration
Certified Information Privacy Professional/Canada
Certified Information Privacy Professional/Information Technology
   
robert.galam...@compuware.com
 
Tel: +1 905 886 7000 
Toll Free: +1 800 263 7189
Fax: +1 905 886 7023
Quebec: +1 877-281-1888 
  

 
Le contenu de ce courriel s'adresse au destinataire seulement. Il contient de 
l'information pouvant être confidentielle. Vous ne devez ni le copier ni 
l'utiliser ni le divulguer à qui que ce soit à moins que vous soyez le 
destinataire ou une personne désignée autorisée. Si vous le receviez par 
erreur, veuillez nous aviser immédiatement et le détruire.
 
The contents of this e-mail are intended for the named addressee only. It 
contains information that may be confidential. Unless you are the named 
addressee or an authorized designee, you may not copy or use it, or disclose it 
to anyone else. If you received it in error please notify us immediately and 
then destroy it.
 



 Service in every product...

 Les renseignements contenus dans le présent message électronique sont 
confidentiels et concernent exclusivement le(s) destinataire(s) désigné(s). Il 
est strictement interdit de distribuer ou de copier ce message. Si vous avez 
reçu ce message par erreur, veuillez répondre par courriel à l'expéditeur et 
effacer ou détruire toutes les copies du présent message.
 -Original Message-
 From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
 Behalf Of Richards, Robert B.
 Sent: March 25, 2010 9:20 AM
 To: IBM-MAIN@bama.ua.edu
 Subject: SQL Server replacement
 
 I am way out of my element on this topic, so I thought I'd post this
 query:
 
 If we were looking to replace Microsoft's SQL Server with something on
 System z, what would my options be and how much effort would be
 required to move it there?
 
 Bob
 
 -
 Robert B. Richards(Bob)
 US Office of Personnel Management
 1900 E Street NW Room: BH04L
 Washington, D.C.  20415
 Phone: (202) 606-1195
 Email: robert.richa...@opm.govmailto:robert.richa...@opm.gov
 -
 
 --
 For IBM-MAIN subscribe / signoff / archive access instructions,
 send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
 Search the archives at http://bama.ua.edu/archives/ibm-main.html

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-25 Thread Richards, Robert B.
Robert, of course it was a loaded question. But it was also general in nature. 
I asked about System z alternatives. System z implies z/OS, USS and Linux on z 
(under z/VM here). I got the answer I was looking for. In-house discussions 
will reveal the additional details that you asked about but are unknown at this 
time. Once they are available and if needed, I'll come back to the list and ask 
further questions. For now, the high level answers were sufficient. :-)

Bob


-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of 
Galambos, Robert
Sent: Thursday, March 25, 2010 11:35 AM
To: IBM-MAIN@bama.ua.edu
Subject: Re: SQL Server replacement

This is a loaded question. The simply answer is it depends.

1) it depends on what platform you are talking about. Is it z\OS or USS (Linux 
on the IBM Iron horse)

2) Then it depends on what the DBMS is supporting. Is it a transaction based 
application where response time is important, is it a query type of application?

3) What kind of infrastructure do you have in place right now. Are you already 
running DB2 or Oracle or IMS etc.

4) And finally, but no less important is why the change. Is it because of 
reliability? Cost? DR or what.

Once these questions are asked/answered you can get a better idea on where to 
go from here

Hope this helps and if you want you can contact me off line


Robert Galambos CIPP/C CIPP/IT


 -Original Message-
 From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
 Behalf Of Richards, Robert B.
 Sent: March 25, 2010 9:20 AM
 To: IBM-MAIN@bama.ua.edu
 Subject: SQL Server replacement

 I am way out of my element on this topic, so I thought I'd post this
 query:

 If we were looking to replace Microsoft's SQL Server with something on
 System z, what would my options be and how much effort would be
 required to move it there?

 Bob


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-25 Thread Hal Merritt
It would be interesting (to me, anyway) to hear how this goes.  Please keep us 
posted.  


-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of 
Richards, Robert B.
Sent: Thursday, March 25, 2010 12:55 PM
To: IBM-MAIN@bama.ua.edu
Subject: Re: SQL Server replacement

Robert, of course it was a loaded question. But it was also general in nature. 
I asked about System z alternatives. System z implies z/OS, USS and Linux on z 
(under z/VM here). I got the answer I was looking for. In-house discussions 
will reveal the additional details that you asked about but are unknown at this 
time. Once they are available and if needed, I'll come back to the list and ask 
further questions. For now, the high level answers were sufficient. :-)

Bob

 
NOTICE: This electronic mail message and any files transmitted with it are 
intended
exclusively for the individual or entity to which it is addressed. The message, 
together with any attachment, may contain confidential and/or privileged 
information.
Any unauthorized review, use, printing, saving, copying, disclosure or 
distribution 
is strictly prohibited. If you have received this message in error, please 
immediately advise the sender by reply email and delete all copies.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html


Re: SQL Server replacement

2010-03-25 Thread Ward, Mike S
I have heard of IFL's for zLinux and DB/2 running under zLinux. We have
DB/2 running on z/OS and also DB/2 connect on the distributed side and
it is used to access DB/2 on the mainframe.

-Original Message-
From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On
Behalf Of Richards, Robert B.
Sent: Thursday, March 25, 2010 8:20 AM
To: IBM-MAIN@bama.ua.edu
Subject: SQL Server replacement

I am way out of my element on this topic, so I thought I'd post this
query:

If we were looking to replace Microsoft's SQL Server with something on
System z, what would my options be and how much effort would be required
to move it there?

Bob

-
Robert B. Richards(Bob)
US Office of Personnel Management
1900 E Street NW Room: BH04L
Washington, D.C.  20415
Phone: (202) 606-1195
Email: robert.richa...@opm.govmailto:robert.richa...@opm.gov
-

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
==
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity
to which they are addressed. If you have received this email in error please 
notify the system manager. This message
contains confidential information and is intended only for the individual 
named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please notify the 
sender immediately by e-mail if you
have received this e-mail by mistake and delete this e-mail from your system. 
If you are not the intended recipient
you are notified that disclosing, copying, distributing or taking any action in 
reliance on the contents of this
information is strictly prohibited.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html