DB2: Unterschied zwischen den Versionen

Aktuelle Version vom 1. November 2016, 08:55 Uhr

DB2 (Database 2) ist ein relationales Datenbanksystem des Unternehmens IBM. Es wird auf verschiedenen Plattformen angeboten. Es bietet Schnittstellen via TCP/IP in die "offene Welt"...

Seit einiger Zeit gibt es DB2 als Freeware für verschiedene Plattformen; es nennt sich DB2 Express-C.

IBM-Seiten zu DB2

Einstiegsseite der IBM zu DB2 for z/OS

DB2 for z/OS - Technical Resources

DB2 for z/OS - Library

DB2 11 for z/OS Technical Overview (Redbook)

DB2-Wiki (Win/Linux/Unix)

Communities / Blogs

DB2-Community

Liste der Blogs von IDUG

Links der DB2-"Guruin" Bonnie Baker

Alle Blogs von DB2utor / Troy L Coleman

IDUG Blog for Beginners in DB2 (auch toll für "alte Hasen")

"Deutsches"

Links des deutschen DB2-"Gurus", Herrn Norbert Denne

SQL-Tutorial Schulserver Hessen

SQL-Tutorial, auch deutsch

Spezielles

Online schema change - Minimize planned outages when making changes to your database objects

DB2 for z/OS: Configuring TLS/SSL for Secure Client/Server Communications

DB2 11 for z/OS Application Developer - Part 1 - Database Objects

DB2 11 for z/OS Application Developer - Part 2 - Data Retrieval and Manipulation

DB2 11 for z/OS Application Developer - Part 3 - Distributed Access to DB2 for z/OS

DB2 11 for z/OS Application Developer - Part 4 - Coding SQL in Application Programs

DB2 11 for z/OS Application Developer - Part 5 - Processing Options that Affect Program Design

DB2 11 for z/OS Application Developer - Part 6 - Performance Considerations

DB2 11 for z/OS Application Developer - Part 7 - Units of work, concurrency, and checkpoint/restart

DB2 11 for z/OS Application Developer - Part 8 - Application Design and Lifecycle

DB2 11 for z/OS Application Developer - Part 9 - Access to Non-Structured Data

DB2 11 for z/OS Application Developer - Part 10 - Advanced Programming Topics

DB2 SQL Enhancements You May Have Missed

Introduction to XML in DB2 11 for z/OS - Part 1

Introduction to XML in DB2 11 for z/OS - Part 2

The Evolution of DB2 Block-Fetch

DB2 11 Block Fetch Capabilities

DB2 Express-C (Freeware!)

Inzwischen nicht mehr so einfach zu finden; auch die deutsche Literatur findet man / finde ich nicht mehr. :-(

Einstiegsseite der IBM zu DB2-LUW (Stand des Link: 01.11.2016) Dort den Butto Products anklicken, dann kommt auch ein Link zu DB2-Express-Edition

Einstiegsseite mit Link zu Downloads (Stand des Link: 01.11.2016)

Dokumentation DB2 LUW 10.5 auch deutsch (Stand des Link: 01.11.2016)

Download DB2 Express-C (Stand des Link: 01.11.2016)

Support Forum (Stand des Link: 01.11.2016)

Beispiele und Beiträge

Accessing DB2 Directory Tables Using SQL

Batch SPUFI

Beispiel zu SQL MERGE

Beispiel zu Multi Row insert

Sorting data from a sql ascii

DB2 11 OSE Enhancements (Online Schema Evolution) - auch Referenzen sind hochinteressant

Videos

Lesson 1: Installation and DB2 Editions

Lunch with DB2 - Episode 1: Installation

@@ Zeile 4: / Zeile 4: @@
+== IBM-Seiten zu DB2 ==
-----
+[http://www.ibm.com/software/data/db2/zos/family/                           Einstiegsseite der IBM zu DB2 for z/OS]
+[http://www-01.ibm.com/support/docview.wss?uid=swg27039165                  DB2 for z/OS - Technical Resources]
-== verschiedene Links zum Thema DB2 ==
+[http://www-01.ibm.com/software/sw-library/en_US/products/L374840M53366O19/ DB2 for z/OS - Library]
-[http://www.ibm.com/software/data/db2/zos/family/                           Einstiegsseite der IBM zu DB2 for z/OS]
+[http://www.redbooks.ibm.com/redpieces/abstracts/sg248180.html?Open         DB2 11 for z/OS Technical Overview (Redbook)]
-[http://www-01.ibm.com/support/docview.wss?rs=64&uid=swg27011656            DB2 for z/OS - Technical Resources]
+[https://www.ibm.com/developerworks/wikis/display/DB2/DB2+wiki              DB2-Wiki (Win/Linux/Unix)]
-[http://www-01.ibm.com/software/sw-library/en_US/products/L374840M53366O19/ DB2 for z/OS - Library]
+== Communities / Blogs ==
 [http://www.channeldb2.com/                                                 DB2-Community]
+[http://www.idug.org/p/cm/ld/fid=103                                        Liste der Blogs von IDUG]
+[http://www.bonniebaker.com/programmers_only.htm                            Links der DB2-"Guruin" Bonnie Baker]
+[http://ibmsystemsmag.com/Blogs/DB2utor/                                    Alle Blogs von DB2utor / Troy L Coleman]
+[http://www.idug.org/p/bl/et/blogid=143                                     IDUG Blog for Beginners in DB2 (auch toll für "alte Hasen")]
+== "Deutsches" ==
+[http://www.dgd-ub.de/index.html                                            Links des deutschen DB2-"Gurus", Herrn Norbert Denne]
+[http://www.schulserver.hessen.de/darmstadt/lichtenberg/SQLTutorial/        SQL-Tutorial Schulserver Hessen]
+[http://www.sql-und-xml.de/sql-tutorial/                                    SQL-Tutorial, auch deutsch]
+== Spezielles ==
+[http://www.ibm.com/developerworks/data/library/techarticle/dm-0907db2outages/index.html Online schema change - Minimize planned outages when making changes to your database objects]
+[http://www.redbooks.ibm.com/abstracts/redp4799.html?Open                   DB2 for z/OS: Configuring TLS/SSL for Secure Client/Server Communications]
+[http://www.idug.org/p/bl/et/blogaid=425                                    DB2 11 for z/OS Application Developer - Part  1 - Database Objects]
+[http://www.idug.org/p/bl/et/blogaid=429                                    DB2 11 for z/OS Application Developer - Part  2 - Data Retrieval and Manipulation]
+[http://www.idug.org/p/bl/et/blogaid=435                                    DB2 11 for z/OS Application Developer - Part  3 - Distributed Access to DB2 for z/OS]
+[http://www.idug.org/p/bl/et/blogaid=442                                    DB2 11 for z/OS Application Developer - Part  4 - Coding SQL in Application Programs]
+[http://www.idug.org/p/bl/et/blogaid=461                                    DB2 11 for z/OS Application Developer - Part  5 - Processing Options that Affect Program Design]
+[http://www.idug.org/p/bl/et/blogaid=465                                    DB2 11 for z/OS Application Developer - Part  6 - Performance Considerations]
+[http://www.idug.org/p/bl/et/blogaid=470                                    DB2 11 for z/OS Application Developer - Part  7 - Units of work, concurrency, and checkpoint/restart]
+[http://www.idug.org/p/bl/et/blogaid=472                                    DB2 11 for z/OS Application Developer - Part  8 - Application Design and Lifecycle]
+[http://www.idug.org/p/bl/et/blogaid=479                                    DB2 11 for z/OS Application Developer - Part  9 - Access to Non-Structured Data]
+[http://www.idug.org/p/bl/et/blogaid=484                                    DB2 11 for z/OS Application Developer - Part 10 - Advanced Programming Topics]
+----
+[http://www.idug.org/p/bl/et/blogaid=456                                    DB2 SQL Enhancements You May Have Missed]
+----
+[http://www.idug.org/p/bl/ar/blogaid=478                                    Introduction to XML in DB2 11 for z/OS - Part 1]
+[http://www.idug.org/p/bl/ar/blogaid=492                                    Introduction to XML in DB2 11 for z/OS - Part 2]
 ----
+[http://www.ibmsystemsmag.com/Blogs/DB2utor/April-2016/The-Evolution-of-DB2-Block-Fetch/                  The Evolution of DB2 Block-Fetch]
-[http://www.bonniebaker.com/programmers_only.htm                            Links eines DB2-"Gurus"]
+[http://ibmsystemsmag.com/Blogs/DB2utor/April-2016/DB2-11-Block-Fetch-Capabilities/                       DB2 11 Block Fetch Capabilities]
 ----
-[http://www.channeldb2.com/                                                 DB2-Community]
+== DB2 Express-C (Freeware!) ==
+Inzwischen nicht mehr so einfach zu finden; auch die deutsche Literatur findet man / finde ich nicht mehr. :-(
+[https://www.ibm.com/analytics/us/en/technology/db2/db2-linux-unix-windows.html                         Einstiegsseite der IBM zu DB2-LUW] (Stand des Link: 01.11.2016)
+Dort den Butto Products anklicken, dann kommt auch ein Link zu DB2-Express-Edition
+[http://www.ibm.com/software/products/en/db2expressc                                                    Einstiegsseite mit Link zu Downloads] (Stand des Link: 01.11.2016)
+[http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg27038856                                        Dokumentation DB2 LUW 10.5 auch deutsch] (Stand des Link: 01.11.2016)
+[http://www.ibm.com/developerworks/downloads/im/db2express/                                             Download DB2 Express-C] (Stand des Link: 01.11.2016)
+[https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000000805 Support Forum] (Stand des Link: 01.11.2016)
+== Beispiele und Beiträge ==
+[http://ibmsystemsmag.com/Blogs/DB2utor/October-2014-%281%29/Accessing-DB2-Directory-Tables-Using-SQL/  Accessing DB2 Directory Tables Using SQL]
+[http://ibmsystemsmag.com/Blogs/DB2utor/October-2014-%281%29/Batch-SPUFI/                               Batch SPUFI]
-[http://www-01.ibm.com/software/data/db2/express/         Einstiegsseite der IBM zu DB2 Express-C]
+[http://www.idug.org/p/bl/et/blogaid=363&source=1                                                       Beispiel zu SQL MERGE]
-[https://www.ibm.com/developerworks/wikis/display/DB2/FREE+Book-+Getting+Started+with+DB2+Express-C         Handbücher der Community zu DB2 Express-C (auch deutsch)]
+[http://www.idug.org/p/bl/et/blogaid=369                                                                Beispiel zu Multi Row insert]
-[http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.fs.doc/                                                deutsche Informationen zu DB2-Express C]
+[https://www.ibm.com/developerworks/community/forums/html/topic?id=2940123d-cf86-4b2a-985d-ee1876403629 Sorting data from a sql ascii]
-[https://www.ibm.com/developerworks/wikis/display/DB2/DB2+wiki     DB2-Wiki (Win/Linux/Unix)]
+[http://ibmsystemsmag.com/Blogs/DB2utor/August-2015/DB2-11-OSE-Enhancements/                            DB2 11 OSE Enhancements (Online Schema Evolution) - auch Referenzen sind hochinteressant]
-----
+== Videos ==
 [http://www.channeldb2.com/video/video/show?id=807741:Video:4442     Lesson 1: Installation and DB2 Editions]

DB2: Unterschied zwischen den Versionen

Aktuelle Version vom 1. November 2016, 08:55 Uhr

Inhaltsverzeichnis

IBM-Seiten zu DB2

Communities / Blogs

"Deutsches"

Spezielles

DB2 Express-C (Freeware!)

Beispiele und Beiträge

Videos

Navigationsmenü

Seitenaktionen

Seitenaktionen

Meine Werkzeuge

Navigation

Suche

Werkzeuge