• About Dangerous DBA
  • Table of Contents
Dangerous DBA A blog for those DBA's who live on the edge

IDUG – EMEA – 15th – Day Two

November 15, 2011 11:14 pm / Leave a Comment / dangerousDBA

Been a long day at IDUG today with talks starting at 0830 till 1645 today, which is a lot to take in back to back but I will attempt to summarise and say what I have learnt quickly before I turn in for the night:

Smarter Analytics for big data – Steven Sit

Informative talk with some topics and content covered in other talks but good for reinforcement and introduction of new stuff. Things I learnt:

  1. Big data is about Volume, Velocity and Variety.
  2. It is iterative and you are probably not going to get it right first time.
  3. Get ready for Zettabyte!
  4. Learn JAQL and a whole lod of other languages for big data processing.

SQL on Fire – Serge Rielau

This was next level stuff, with him creating and testing functions and other things for problems that I have never considered, but may need now with Big data coming into the warehouse. This presentation will definatly take another look or two to understand what is going on in some of the code.

DB2 and Cloud computing why should I care? – Leon Katsnelson

This was a very good foundation and refresher for the concepts, uses and vendors of the cloud. Will defiantly be firing up some free instances once I get back home, and find the time. I learnt that:
  1. A US agency has managed to define what a cloud should be in a two page document.
  2. The cloud has use cases make sure yours is right

ADMIN_MOVE_TABLE() the new DBA’s Swiss army knife

Again this will take another look through to full appreciate, but on the face of it could be a good way to move say a testing table to production without too much hassel as long as you set it up right and dont fall into a GOTCHA.
  1. ADMIN_MOVE_TABLE does not have to be done all at once, and can be done in stages and equally cancelled.
  2. Does not move foreign keys!!

Stuffed with great enhancements DB2 9.7 FixPacks – Melanie Stofer

All kudos to  Melanie she went through 60 slides in 60 mins and there is 120 in the download! A lot of information to take in and no time to make notes at the pace she went through stuff, but all very useful stuff.

The evening was good with free beer from IDUG and a trip out to the Steak house round the corner on Triton Consulting with the guys from Triton and DBI software thank you very much, very tasty and good conversation. Freebies again were good with an excellent glass from Triton and I got my Ticket for the IBM customer dinner tomorrow night, dont forget to get yours!

Tomorrow I will be hopefully going to:

Wednesday, November 16, 2011

08:30 AM – 09:30 AM
Session 9
2092:A DBA’s guide to using TSA (Aquarius)
09:45 AM – 10:45 AM
Session 10
2131:Managing DB2 Performance in a Heterogeneous Environment (Leo)
11:00 AM – 12:00 PM
Session 11
2098:Deep dive in DB2 LUW’s offline table reorg and index reorg (Stella)
12:00 PM – 01:00 PM
Wednesday Lunch
01:00 PM – 02:00 PM
Wednesday SIGS
02:15 PM – 03:15 PM
Session 12
2027:Back to the Fifties… 50 Fabulous ways for forecasting failures, flaws, & finding flubber in DB2 LUW(Taurus)
03:15 PM – 03:45 PM
Wednesday Coffee Break
03:45 PM – 04:45 PM
Session 13
1831:Useful but widely unknown DB2 functionalities (Taurus)
05:00 PM – 06:00 PM
Session 14
1897:DB2 LUW Index Design, Best Practices, and Case Studies -Updated (Taurus)

For the SIG session I am torn between Data Warehousing and DB2 LUW Upgrade or Migrate to New features. I would like to know a lot more about what the agenda is for them. Anyone got any offers?

So may see you around tomorrow have a good night.

Posted in: Uncategorized

Leave a Reply Cancel reply

Post Navigation

← Previous Post
Next Post →

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 757 other subscribers

Recent Posts

  • Self generating Simple SQL procedures – MySQL
  • Google Cloud Management – My Idea – My White Whale?
  • Position Tracker – The Stub – Pandas:
  • Position Tracker – The Stub
  • Position Tracker – In the beginning
  • Whats been going on in the world of the Dangerous DBA:
  • QCon London Day 1
  • Testing Amazon Redshift: Distribution keys and styles
  • Back to dangerous blogging
  • DB2 10.1 LUW Certification 611 notes 1 : Physical Design

Dangerous Topics

added functionality ADMIN_EST_INLINE_LENGTH Bootcamp colum convert data types DB2 db2 DB2 Administration DB2 Development db2advis db2licm Decompose XML EXPORT GCP Google IBM IBM DB2 LUW idug information centre infosphere IOT LOAD merry christmas and a happy new year Position Tracking python Recursive Query Recursive SQL Reorganisation Reorganise Reorganise Indexes Reorganise Tables Runstats sql statement Stored Procedures SYSPROC.ADMIN_CMD Time UDF User Defined Functions V9.7 V10.1 Varchar XML XML PATH XMLTABLE

DangerousDBA Links

  • DB2 for WebSphere Commerce
  • My Personal Blog

Disclaimer:

The posts here represent my personal views and not those of my employer. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. DB2 is a trademark of IBM. I am not an employee or representative of IBM.

Advertising

© Copyright 2021 - Dangerous DBA
Infinity Theme by DesignCoral / WordPress