DB2: Unterschied zwischen den Versionen
Rts (Diskussion | Beiträge) |
Rts (Diskussion | Beiträge) |
||
(19 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
Zeile 20: | Zeile 20: | ||
[http://www.channeldb2.com/ DB2-Community] | [http://www.channeldb2.com/ DB2-Community] | ||
− | [http://www.idug.org/p/cm/ld/fid=103 Liste der | + | [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://www.bonniebaker.com/programmers_only.htm Links der DB2-"Guruin" Bonnie Baker] | ||
Zeile 26: | Zeile 26: | ||
[http://ibmsystemsmag.com/Blogs/DB2utor/ Alle Blogs von DB2utor / Troy L Coleman] | [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"] | + | [http://www.idug.org/p/bl/et/blogid=143 IDUG Blog for Beginners in DB2 (auch toll für "alte Hasen")] |
== "Deutsches" == | == "Deutsches" == | ||
Zeile 41: | Zeile 41: | ||
[http://www.redbooks.ibm.com/abstracts/redp4799.html?Open DB2 for z/OS: Configuring TLS/SSL for Secure Client/Server Communications] | [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!) == | == 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 == | == Beispiele und Beiträge == | ||
Zeile 59: | Zeile 105: | ||
[http://www.idug.org/p/bl/et/blogaid=369 Beispiel zu Multi Row insert] | [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 == | == Videos == |
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