11 Great DB 2 Questions from Stack Overflow

11 Great DB 2 Questions from Stack Overflow (Answers Included) Dr. Henrik Loeser IBM Germany Research & Development Session Code: 4054 Date and Time of Presentation | Platform: DB 2 LUW

Objectives Introduce the platform Stack Overflow � Learn how to ask great questions � Learn how to share your DB 2 knowledge � Learn DB 2 by using Stack Overflow � 2

You are a hero! You are great! Share your knowledge � Find answers to your questions � Get known � Do something useful, at least once a week. . . : ) � 3

Agenda What is Stack Overflow? � How to get started � Learn DB 2 � Open Data � Summary � 4

What – Stack Overflow / Stack Exchange Inc. � Founded 2008 � Network of knowledge sharing / Q&A sites � • Stack. Overflow. com related to programming • Stack. Exchange. com for other topics • dba. stackexchange. com for DBAs • Superuser. com for computer enthusiasts and power users • 150+ individual Q&A sites > 5 Mio users � > 10 Mio Questions � > 100 Mio unique monthly visitors � Open data – can be directly queried or downloaded � 5

How – Stack Overflow / Stack Exchange Gamification of questions & answers � Possibly earn (or lose) reputation points for answers or great questions, for „community work“, etc. � Set bounties to draw more attention to a question (bounty taken from your points) � Earn badges, more reputation for completing tasks / milestones, e. g. , reviews, #answers, topic expert, popular q/a, . . . � 6

How – Stack Overflow / Stack Exchange Questions are tagged with topics � New tags can only be created by users with enough reputation � Search by topic � „[db 2] and [security]“ => Q is about DB 2 and Security � „[db 2] xmlagg“ => Q is about DB 2 and contains „XMLAGG“ � Subscribe to topics (RSS, email, Slack, . . . ) � 7

DB 2 on Stack Overflow / Stack Exchange 8

Stack Exchange – Open Data http: //data. stackexchange. com/ � License: CC BY-SA 3. 0 � Use data � Online Data Explorer, including query interface � Download Data Dumps � Data API � 9

11 Great DB 2 Questions from dba. stackexchange. com http: //data. stackexchange. com/dba/query/524535/top-11 -by-score-for-given-tagname? tagname=db 2 The Questions: � 10

11 Great DB 2 Questions from stackoverflow. com http: //data. stackexchange. com/stackoverflow/query/524537/11 -great-questions-by-score-for-giventagname-idug-presentation? tagname=db 2 The Questions: � 11

Live Look at #top 11 Q&A 12

Conclusions Stack Exchange / Stack Overflow � Great to � learn DB 2 � get quick help to DB 2 programming / DBA issues � prove that you know DB 2 : ) � get product feedback and insight � Great as input for DB 2 RUG (Regional User Group) meetings � Are you on Stack Overflow. . . ? ? ? � 13

Dr. Henrik Loeser IBM Germany R&D hloeser@de. ibm. com Session 4054 11 Great DB 2 Questions from Stack Overflow Please fill out your session evaluation before leaving!