DB2: Unterschied zwischen den Versionen
K (Hob den Schutz von „DB2“ auf) |
Rts (Diskussion | Beiträge) |
||
| (34 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
| − | 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".. | + | 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 == | ||
| + | [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] | ||
| + | |||
| + | [http://www-01.ibm.com/software/sw-library/en_US/products/L374840M53366O19/ DB2 for z/OS - Library] | ||
| + | |||
| + | [http://www.redbooks.ibm.com/redpieces/abstracts/sg248180.html?Open DB2 11 for z/OS Technical Overview (Redbook)] | ||
| + | |||
| + | [https://www.ibm.com/developerworks/wikis/display/DB2/DB2+wiki DB2-Wiki (Win/Linux/Unix)] | ||
| + | |||
| + | == 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/ | + | [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://ibmsystemsmag.com/Blogs/DB2utor/April-2016/DB2-11-Block-Fetch-Capabilities/ 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. :-( | ||
| + | |||
| + | [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.idug.org/p/bl/et/blogaid=363&source=1 Beispiel zu SQL MERGE] | ||
| + | |||
| + | [http://www.idug.org/p/bl/et/blogaid=369 Beispiel zu Multi Row insert] | ||
| + | |||
| + | [https://www.ibm.com/developerworks/community/forums/html/topic?id=2940123d-cf86-4b2a-985d-ee1876403629 Sorting data from a sql ascii] | ||
| + | |||
| + | [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 | + | [http://www.channeldb2.com/video/video/show?id=807741:Video:4442 Lesson 1: Installation and DB2 Editions] |
| + | [http://www.channeldb2.com/video/video/show?id=807741:Video:2562 Lunch with DB2 - Episode 1: Installation] | ||
| − | + | ---- | |
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 11 for z/OS Technical Overview (Redbook)
Communities / Blogs
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
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
DB2 11 OSE Enhancements (Online Schema Evolution) - auch Referenzen sind hochinteressant
Videos
Lesson 1: Installation and DB2 Editions
Lunch with DB2 - Episode 1: Installation
