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

IDUG – EMEA – 13th

November 13, 2011 8:50 pm / Leave a Comment / dangerousDBA

So the first full day here in Prague at IDUG EMEA and It has been all right. The day started with the very communal breakfast, which I suppose when you have as many people as this place holds to feed then it is going to happen. Ended up sat opposite this old German lady, who seemed a little shocked when I turned up, but my glass was there marking out my seat. It was good, but having sampled beans in several different places on my limited travels no where does baked beans as well as the UK, these ones were like bullets!

I have spent the day in the Pre certification class for the advanced DB2 DBA certificate. It was a good session run by Guy Przytula and the first time that it had been run. Which if I am being honest was obvious as there was some polish needed to the slides and the mock test that was presented. I would go again learnt stuff that I never knew and reading the certification book now will be easier as I will have another reference to look at. Top four things that I learnt today:

  1. Schema Shipping – Does what it says on the tin, move a schema and nothing else. Some pre reqs and GOTCHAS but seems useful.Dont know when I will use it.
  2. BLOCKNONLOGGED – Block non logged operations. Especially useful for HADR to stop non logged operations like LOAD ….. NONRECOVERABLE that will make the table-space on the HADR standby go inoperable. This is something that I will be defiantly putting on our servers when I get home.
  3. MAXVALUE and MINVALUE – This is for range partitioned tables and the partitions ranges. MINVALUE and MINVALUE will allow you to to specify open ended ranges.
  4. The book I bought just over a month ago for the advanced exam is now out of date as they have changed the exam, but is still the best reference out there currently – do’h
Tomorrow I want to attend sessions:

Monday, November 14, 2011

10:00 AM – 11:15 AM
Monday Keynote
11:30 AM – 12:30 PM
Session 1
1830:The proactive DBA (Leo)
12:30 PM – 01:30 PM
Monday Lunch
01:30 PM – 02:30 PM
Session 2
2079:Eliminating Performance Bottlenecks in DB2 9.7 and PureScale (Aquarius)
02:45 PM – 03:45 PM
Monday VSP
04:00 PM – 05:00 PM
Session 3
2018:Sneak peek at the future of DB2 application development (Aquarius)
The information material says that I should leave 75 mins plus for an exam. Exams are available tomorrow from 1130 till 1630, so unless there is a session that is shorter than it says I dont think there will be time to fit one in! I also plan to find the DB2 Geeks from Triton and tell them the answer to the question and get myself a T-shirt and find out how I can win an iPad.
Posted in: DB2, DB2 Administration, EMEA, IBM, IDUG, Triton

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 Amazon Bootcamp colum convert data types db2 DB2 DB2 Administration DB2 Development db2advis db2licm Decompose XML Exam EXPORT Google IBM IBM DB2 LUW idug information centre infosphere LOAD merry christmas and a happy new year Recursive Query Recursive SQL Redshift Reorganisation Reorganise Reorganise Indexes Reorganise Tables Runstats sqlcode 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