News from IDUG: EMEA conference registration and important podcast episode
2025
ETL for my blog: Migration mostly completed
Have issues? Communicate! A brief look at Db2 SQLCA
Db2 for your data lakehouse
Db2 catalog: Updated documentation links to database metadata
Db2: Loading and unloading of data on remote clients with external tables
Simple container-based Minio deployment for Db2
Once again: Db2 External Tables
Db2 12.1 Community Edition for Docker on Fedora
2024
Db2 12.1 is now available
See you at IDUG EMEA, in person or as virtual attendee
A look at local external tables in Db2
My adventure of fixing Windows 10 boot issues
Revisited: Db2 backup to S3 / Object Storage
Three plus one simple (and free) ways to test Db2
About BIRD, SQL, IBM granite models, and your business reporting
Lakehouse: Bronze, silver, and gold levels of data
Get ready for IDUG North America Db2 Tech Conference
Registration for IDUG EMEA 2024 Db2 Tech Conference is now open
Follow-up on resource reclamation: Search resources and Code Engine commands
Next German Db2 User Group meeting in Munich on April 12th
Authentication for your IBM Cloud Code Engine functions
Spreadsheets: How to excel with Db2 data
Tutorial on cloud end-to-end security - an overview
DeDUG: German Db2 User Group meeting February 2nd
2023
Thoughts on how to move from Cloud Functions to Code Engine
Tips and tricks for using IBM Cloud Code Engine functions
Unicode string length, code points, and Db2
Db2 11.5.9 is available
🎃 Unicode characters and Db2 🕸️ 🏚️
What a community event: IDUG 2023 EMEA Db2 Tech Conference in Prague
Blog series on cloud security and account cleanup
Last days of early bird rate for IDUG 2023 EMEA Db2 Tech Conference
Simple installation: Python driver for IBM Db2 (finally) has wheel support
Trusted Contexts for enhanced security: Both in Db2 and IBM Cloud
IDUG 2023 EMEA Db2 Tech Conference in Prague in October
Decode JWTs in bash
Blast from the past: Procfile for Python cloud apps
IBM Cloud and Terraform: How to use a REST API
Analyze your IBM Cloud access management setup
flatpak: How to deal with unwanted package updates
Create your IBM Cloud toolchain with Terraform
Generate PowerPoint slides from your Db2 data with Python
2022
Dates for the IDUG Db2 Tech conferences in 2023
Finally together: Db2 and Zeppelin
IDUG 2022 EMEA conference is over - keep it going
Things I learned at IDUG on JSON Web Token support in Db2
Terraform multi-account setup for IBM Cloud
New IBM Cloud security features you should know
Database event in Edinburgh: IDUG 2022 EMEA Db2 Tech Conference
Use event subscriptions for scheduled scale up and down of your IBM Cloud Code Engine apps
Create a REST API with OpenAPI spec for your database objects
Containerize your Db2 Python app
Some fun with traefik routing on the edge of a reverse proxy
A simple nginx deployment on IBM Cloud Code Engine
Custom domain for your serverless Code Engine app
Best practices for successful support cases
Required IAM privileges for a service ID to update Code Engine app
Blue-green deployment with IBM Cloud Code Engine and Knative
From Bluemix to IBM Cloud, from Cloud Foundry to Code Engine
IDUG EMEA 2022 Tech Conference: Call for presentations open
Get certified for IBM Cloud, new certifications available
Simple, quick and secure cloud onboarding for workshops and hackathons
2021
Rate-limit Kafka event generation with kcat and bash
Get educated: The IDUG Virtual 2021 EMEA Db2 Tech Conference is coming up
On serverless data scraping, cloud object storage, MinIO and rclone
Db2 SQL PL book as PDF and many useful doc links
IBM Cloud resource reclamations: Some more details and my best practices
Db2 on Cloud credentials and how to connect from your app
To restore or to delete: Working with IBM Cloud resource reclamation
Serverless Twitter Bot using IBM Cloud
Password expiration and vacation planning
How to connect from Python to Db2
Cloud Security: BYOK vs. KYOK explained
Cloud-based HSM with PKCS #11 for Db2 Native Encryption
Db2 11.5.6 is available
Quickly deploy the serverless cloud mailer using Terraform
IBM Cloud: Send out alert emails using SMTP
My best practices: How to search Db2 documentation
Wireshark with Lua on RHEL / CentOS
Upcoming Db2 IDUG conferences
cron-like scheduling on IBM Cloud
Cloud tutorial on serveless web app and eventing
Pseudo-decorators for my Python Flask app
JWT token authentication in Db2 runtimes like Python or Node.js
Great chatbots in no time
IBM Cloud CLI: Some tips and tricks - make it a home
Follow-up to Db2 and JWT: What is JOSE...?
Db2 Security: Configure JSON Web Token (JWT) authentication
2020
OBS on Linux: Green screen and virtual camera for video conferencing
New Db2 V11.5 Mod Pack 5
Not just during Covid-19: Time for data masking
IBM Cloud: Considerations for role and resource setup
Terraform: Best practices for the cloud onboarding of enterprise projects
Details available: IDUG EMEA 2020 as virtual conference
Use alfaview on rpm-based Linux (Fedora, Red Hat, CentOs)
Some fun digging into IBM Cloud access policies
Db2 and S3-compatible Cloud Object Storage
IDUG EMEA 2020 goes virtual, moved to November 16-19
New JWT-based SSO in Db2 11.5
Db2 11.5 Mod Pack 4 is available
Getting started with Db2 on Cloud Lite
Hands-on security: Share resources on IBM Cloud
New performance and security feature in Db2: Authentication cache
Use Chromium-based browsers to manage FIDO security keys
Some advanced SQL to analyze COVID-19 data
IBM Watson Studio: Download pandas DataFrame as CSV or Excel file
All the best combined: Cloud, Db2, Python, Serverless and Security
Home office and rubber duck debugging, 5 levels
Key Protect as vault for multi-cloud setup
Encode credentials and upload to Key Protect
Covid19 phone challenge: My old Nokia has Android now
My best practices for 2FA and FIDO2 security keys
Obtaining device metadata for FIDO / FIDO2 security devices
My best practices for home office - Corona edition
How to: Slack or email notifications for IBM Cloud security issues
Use Cloud Functions for security scans (IBM Cloud Security Advisor)
Manage your Security Advisor custom findings from the command line
Extend IBM Cloud Security Advisor with your own security metrics
Swashbooking for crowd-sourced book reviews and fun
25th meeting of German Db2 User Group
Use an API KEY or ACCESS TOKEN to connect to Db2 on IBM Cloud
2019
asd765 cloud 87ohhlj db2 askh security xbas chatbot
New Db2 Fix Packs and Mod Packs available
ETL in the cloud using SQL Query and Db2
Control your database encryption keys for Db2 on Cloud
My passwordless app on IBM Cloud thanks to FIDO2
Quick notes on using FIDO2 security keys on Linux
Using your FIDO2 key for 2FA on IBM Cloud apps
New tutorial discuss how to enhance cloud app security
Trip report: Sustainability management and reporting
Updated: Cloud App Security - an introduction
Track API key usage by combining IBM Cloud IAM and LogDNA search
Offboarding on IBM Cloud: Considerations when removing a user
Get some REST with Db2
Track it from the command line: Search audit events in LogDNA using Python
Use a Delivery Pipeline to rotate credentials
Rotate service credentials for Cloud Foundry apps on IBM Cloud
Rotating service credentials for IBM Cloud Functions
New! Db2 11.5 is available
After IDUG is before IDUG: Back from Db2 conference in Charlotte, NC
Cloud-based FIPS 140-2 Level 4 crypto service
Your chatbot with Watson Discovery News
Db2: SQL-based explain and printed acccess plan
Updated tutorial: Database-driven chatbot
Running Db2 Developer-C as Docker container
Digital ethics, trusted AI and IBM
Startup lessons from a Fuckup Night
Enterprise digitalization and cybersecurity: How companies struggle
Hello again, Davos, AI ethics, cybersecurity, Db2 events and IBM Cloud
2018
Db2 2 V11.1 Mod Pack4 and Fix Pack 4 is available
IBM Cloud: The 5 minute barebone news chatbot
Incorporate Git and IBM Cloud information into BASH command prompt
IBM Watson Assistant: Chatbot tool now supports testing client actions
Automated reports with IBM Cloud Functions, Db2 and Slack
Use a custom domain, manage TLS certificates and apply e2e security to cloud app
BYOK to encrypt Kubernetes secrets on IBM Cloud
Impressions from Zeppelin flight
Db2 Node.js and Python drivers and ORM
More tricks for building chatbots with IBM Watson Assistant
Cloud app development with Db2 - Db2 Aktuell Conference
Tutorial on how to apply end to end security to a cloud application
Upcoming Db2 events for the German and European crowd
Db2: Some Friday Fun with XML and SQL recursion
IBM Cloud and Db2 News - August 2018 Edition
Secure apps on IBM Cloud Kubernetes Service with Let's Encrypt wildcard certificates
Now on GitHub: Understand and build chatbots the easy way
Extended: Manage and interact with Watson Assistant from the command line
How to: Enable Let's Encrypt SSL wildcard certificates for your IBM Cloud apps
Learn about chatbots at upcoming IBM Cloud Meetup
Enable Botkit Middleware for Watson Assistant for serverless actions
DeDUG-Treffen in Ehningen / Db2 User Group meeting near Stuttgart
Use BotKit Middleware to create Watson-powered database interface
Securing your Python app with OpenID Connect (OIDC)
June 2018 Edition: Latest IBM Cloud news and links (Db2 included)
Tutorial: Analyze and visualize open data with Apache Spark
How to pack serverless Python actions
Db2: CTE and CONNECT BY - two kinds of recursion
Automated, regular database jobs with IBM Cloud Functions (and Db2)
Use Db2 and IBM Cloud to analyze GitHub traffic data (tutorial)
IBM Cloud and Watson security questionnaires
DeDUG-Treffen in München / German Db2 User Group Meeting in Munich
Security Details: Serverless database access within IBM Watson Conversation service
New tutorial: Db2-driven Slackbot
Easy Database Setup the Serverless Way
Chatbots: Some tricks with slots in IBM Watson Conversation
Access Db2 from IBM Cloud Functions the Easy Way (Node.js)
DeDUG-Treffen in Karlsruhe bei Fiducia GAD (Db2 User Group Meeting)
2017
News on IBM Cloud and Db2 - December 2017 Edition
IBM Cloud: Some fun with Python and Cloud Foundry Logging
Latest News on Bluemix and IBM Cloud
EU Cloud: IBM gives client full control over their data
Cloud Foundry Logging Sources Deciphered
Use Db2 as Cloud SQL Database with Python
Security-Related News for the IBM Bluemix Cloud Platform
App Security Scanner: My Cloud Database App is Secure
2017 IDUG Db2 Tech Conference in Lisbon, Portugal
Db2 with External Tables: First Tests
Combining Db2 and Cloud Object Storage
Secure Your Db2 Data Base - Using Trusted Contexts
Introduction to Cloud App Security - Part 2
Introduction to Cloud App Security - Part 1
Db2 Quiz: Oh what files!?
Db2 Catalog - A Guided Tour
Chatbots: Testing Contexts
Best practices for lively chatbots
IBM Marketing and DB2, Db2 and dashDB
More Tips and Tricks for Building Chatbots
DB2 Security: Privilege(d) Insight
EgoBot: Fun with a Slightly Mutating ChatBot
How to Manage Bluemix Service Keys via CLI
DB2 Security Mysteries, Surrogates and Trusted Contexts
Updates to Chatbot API and Tooling
Chatbot Hackathon: Lessons Learned and Tips
DB2 Easter Egg Quiz - Kind of
Aero Expo, Drones and the IBM Cloud
The 10 Top Stories at April Fools' Day
Chatbots: Manage Your Watson Conversations from the Command Line or App
IBM Bluemix in Germany, includes dashDB and Cloudant
Securing Workloads on IBM Cloud - Some Resources
Location and Intent Matter: Data Privacy vs. US Government
Write Your Own CLI Plugins for Bluemix Cloud Foundry
Carnival: Even DB2 Wears a Mask (Database Security)
Security and Compliance for IBM dashDB and Cloudant
Improve Security for your Domains on IBM Bluemix
Context Path Routing of Apps and Services in Bluemix
Bluemix: Simplified Deployment of Complex Cloud Foundry Apps
DB2 Quiz for the Resource-Minded & IDUG EMEA 2017
2016
New Mod Pack and Fix Pack for DB2 V11 available now
SQL Magic in Notebooks in the IBM Data Science Experience
Stuff - The Day of the BLOB and Object Storage
DB2/dashDB Security: Implicit Privileges Through Group Membership
IDUG EMEA: Henrik's Session Recommendations
Bluemix: How to Register Your Own Service Broker
Extend the Bluemix CLI Through Plugins
Easy to identify: Does the table have a primary key?
Notes on Notebooks, Data, DB2, and Bluemix
Data, Dialogs, and Databases
Bluemix: Where Python and Watson are in a Dialog
Store and Query XML Data with dashDB on Bluemix
Now available: DB2 Version 11 for Linux, UNIX, and Windows
Learn DB2 and dashDB with Stack Overflow
New IBM Knowledge Center for DB2 and other products
Starter Kit for Data-Driven Cloud App with Access to On-prem Resources
Data Protection, Privacy, Security and the Cloud
New Bluemix Data Sink Service Tackles Data Overload
CeBIT: Goldsmith in the Hybrid Cloud - How to Create Value from Enterprise Data
Coincidence? CeBIT visitors and weather featuring Jupyter Notebooks, Spark and dashDB
Mom, I joined the cloud! (or: Use old stuff with new stuff - DB2 federation)
Building a Solution? The Cloud Architecture Center has Blueprints
How to Navigate Bluemix - My Starter Guide
Parse shutting down, move your data
Combining Bluemix, Open Data on Tourism and Watson Analytics for some Friday Insight
A Cache of Identities and a Sequence of Events
The Cloud, Mood-Enhancing Substances, World Economic Forum, and More
2015
DB2: The last query...
MySQL-Style LIMIT and OFFSET in DB2 Queries
IDUG 2015 in Dublin: A week with friends
DB2, Halloween, and a Time Saver
Utilizing User-Provided Services to Link Bluemix Apps to External Databases
Altering tables in the SQLDB service on Bluemix
Keeping track of "my" DB2
Wired or weird Tweets? Doesn't matter to Bluemix, DB2, and Node-RED...
Bluemix: Simple cron-like service for my Python code
DB2 Encryption: Some rotation before the weekend
DIY: 3D-printing a quadrocopter (or hardware for IoT)
DB2 pureScale for the Masses
Bluemix: Combining the Cloud App with my On-Premise DB2 Using the Secure Gateway
My DB2 pureScale / Parallel Sysplex Moment
Using dashDB or DB2 with Apache OpenOffice (or LibreOffice)
Dealing with DB2 Security and my Stupidity...
My 10 Minute DB2 App on Bluemix
German DB2 User Group (DeDUG), 08.05., with/mit Leo Martin (ex-BND)
db2audit & syslog: Who Stole my Chocolate Easter Eggs?
DB2 Battle: Optimization Profile vs. Statement Concentrator (Part 2)
DB2 Battle: Optimization Profile vs. Statement Concentrator (Part 1)
DB2 License Management, new Offerings, and an hour of fun
Boss, I rotated the keys! (DB2 database encryption)
Plain and clear: Native encryption in DB2
2014
Data and 2014: Security and privacy
New fixpack for DB2 10.5 brings in-memory analytics to Windows and zLinux
Introduction and resources for migrating from Oracle to DB2
Useful DB2 administrative functions and views
A quick look at dashDB and a happy SQuirreL
Apply DB2 skills to Hadoop by using Big SQL on Bluemix
Node-RED: Simple "phoney" JSON entries in Cloudant
Starvation: Electronic books, DRM, the local library, and database locks
Enforce backup encryption with encrlib and encropts
New DB2 Cancun Release (Version 10.5 Fixpack 4) offers many enhancements
What a plot: DB2, R, and Bluemix help with vacation weather
Setting up and using a DB2 in-memory database on IBM Bluemix
Sample IBM Bluemix Application: Extended IP logging with node.js and DB2
Accessing DB2 from node.js on IBM Bluemix and locally
Using some Workload Management for free in non-Advanced Editions of DB2
Manage a DB2 database on IBM Bluemix
Using DB2 with Python on Cloud Foundry-Based IBM Bluemix
DB2 Quiz: Which tool provides this output?
What's Going On? - DB2 Workload Management: Identification of Activities
Quiz? State of Affairs...!
The Hunt for the Chocolate Thief (Part 2) - Putting IBM Bluemix, Cloudant, and a Raspberry Pi to good use
Catching the mean chocolate thief with Raspberry Pi, Bluemix, and Cloudant
Watch this! Move your DB2 monitoring to the in-memory interface (WLM monitoring)
DB2 Quiz: Processes and CPU
Nice Cloud, no rain: Using Cloudant/couchDB with Python on Bluemix
Using a custom domain for my Bluemix Python-based weather app
Some fun with Bluemix, Cloud Foundry, Python, JSON, and the Weather
Why we need and have workload management
Video: Introduction to IBM Bluemix User Interface
DB2 Screenshot Quiz: Where is this taken from?
Improved db2look in DB2 to mimic database environments
With some magic through the cloud(s)
Clouds ahead: Playing with DB2 and Cognos (FREE)
SQL Quiz: Which command did I run?
Tuning your DB2 CLP environment: Customize appearance and editor
New DB2 BLU video - Analytics on IBM POWER: the game is changing
Trimming the fun? LTRIM and RTRIM extended
DB2 Quiz: Find the website for this screenshot
50 Years of IBM Mainframe: The Art of Selling
(SOLVED) DB2 Quiz: What function do I call?
DB2: First enterprise-ready wearable database system
XML or JSON: When to choose what for your database
From Lake Constance with love: A new Goodyear Blimp
Free trainings on using DB2 with BLU Acceleration
Today I did NOT work. I worked, had fun, and learned a lot
DB2 10.5 Fixpack 3 is available
Family life and DB2 BLU
Security and DB2 LUW
New Redbook: Leveraging DB2 10 for High Performance of Your Data Warehouse
Using hidden columns for range partitioning (Temenos T24)
!!!STOP!!! Birthday Party for 5 Years of Blogging (Your participation needed)
2013
The DB2 10.5 Year End Quiz
DB2: Nothing to hide...
MySQL-style LIMIT and OFFSET in DB2
DB2 10.5: Overview of product editions, licensing and features
TRANSFER OWNERSHIP: Pass objects on to others...
BLU(e)! Cloud! In-Memory! FREE!!!
Heavy hitter: SYSIBM.SYSTABLES
Friday DB2 Quiz: Not much to report...
connect_proc and locales: Connecting the dots for combined fun
IBM Commercial: Back in Mobile Computing
DB2 V10.5 Fixpack 2 available
I'm not you - Ways to customize a DB2 application environment
Best Practices: Troubleshooting DB2 servers
xkcd comic: Opinions on Internet Privacy - what to add?
ROI at IOD 2013, Some numbers for your boss
Everything is my IP: Obfuscating a "Good Morning"
BLU: Begin Learning blU - A good overview and introduction
Redpaper: IBM Predictive Maintenance and Quality Technical Overview
(Updated) Quiz: What are these tables for?
Redbook updated for DB2 10.5: Oracle to DB2 Conversion Guide - Compatibility Made Easy
Gradual Adjustments: Back to school, epilepsy medication, and DB2
Oracle DBLINK and DB2 Three-Part-Names for Federation
Best Practices for DB2 with BLU Acceleration
DB2 10.5 Fix Pack has been released
Bananas, pants, and DB2 with BLU Acceleration
Video: Interview with IBM Fellow Tim Vincent about DB2 with BLU Acceleration
German DB2 event: DB2 Aktuell 2013 - Last days for discount
DB2 Quiz: Where does this output belong to?
Now available: DB2 BLU Acceleration Kit for Trial
DB2 BLU: Some additional metadata, the synopsis table, and page map indexes
IOQWT - A typical IBM acronym that works for DB2 BLU
DB2 BLU: A look at the catalog tables and the synopsis table
CTQ: Come on, Tune my Query (with DB2 BLU)
Hot out of the lab: DB2 Best Practices: Tuning and monitoring database system performance (Completely Revised!)
Time to restructure life: Cognos with DB2 BLU for extreme performance
Epilepsy and computers: Types of Memory
DB2 in virtualized environments
Redbook Solution Guide: Faster DB2 Performance with IBM FlashSystem
Articles related to database security (relational, NoSQL, Big Data)
Extended row size support in DB2: Fitting more data into a single row than the page size would typically allow (and sometimes it makes sense, but that is another story - stay tuned for user experience...)
Friday Film: IBM history in 30 minutes
IBM and DB2 analytics accelerators, in-memory computing, Big Data, NoSQL, ...
Video: say No! No! and No! (NoSQL, Big Data Parody)
(Updated) NoSQL and JSON with DB2
Combining data to find suspect in over 700 highway shootings
DB2 SQL Compatibility: CREATE INDEX ... EXCLUDE NULL KEYS
WLB, ACR, and Client Affinity in a DB2 pureScale environment
developerWorks article on setting up DB2 for encrypted communication with SSL
DB2 10.5 (Kepler) and Information Center available now
Some typical DB2 registry settings for Temenos T24 and other OLTP systems
Optim Query Capture and Replay for system tests
Performance Tuning for XML-based OLTP Systems (Temenos T24)
In-depth article on DB2 Statistical Views published on developerWorks
Videos on DB2 BLU Acceleration
DB2 Quiz: Which command did I run?
New Best Practices Paper: DB2 V10 Silent Installation and Uninstallation
Surrogates, my other self, SET SESSION AUTHORIZATION, and where it is recorded (DB2 Security)
(Updated) Special hybrid, object-capable, all purpose database
Passing string sequences to SQL/XML functions: Tokenize to the rescue
Photo campaign for epilepsy awareness and tolerance
Upcoming DB2 Bootcamps
SQL Quiz: How to get this XML output?
pureXML: The two most beautiful words in the English language
Video: Live migration of OpenBravo from Oracle to DB2
New page with DB2 pureScale-related acronyms
Some fun with DB2 Maintenance Policies and pureXML (Part 2)
Some fun with DB2 Maintenance Policies and pureXML (Part 1)
(DB2) Redbooks as eBooks (epub)
My money, SEPA payments, DB2 z/OS, and pureXML
Puzzling: Enterprise Amnesia vs. Enterprise Intelligence (IBM Redbook Video)
VIP jets, clouds, and DB2 on cloud
Genealogy of RDBMSs, 30 Years of DB2
Parents at the playground and DB2 components
2012
Winter at the lake
Tune in to DB2 FM... (Happy Holidays)
Buffer pools, registers, working memory, and epilepsy
DB2 fixpacks, support, APARs, and other information
DB2 10.1 Fixpack 2 is available
Quiz: Where is a good place to find information about DB2 fixpacks?
Black Friday and DB2 recovery objects - new db2adutl feature
Where to find information about granted privileges in DB2
Where are the soap bars...? - Database Appliances
INCLUDE columns in IUD operations?!
Law License Enforcement options in DB2
Updated Redbook for DB2 10: High Availability and Disaster Recovery Options
Answer to DB2 Quiz: Don't forget to close what was opened...
DB2 Quiz: Why the error? (create function)
IBM PureData follows PureFlex and PureApplication Systems
PureSystems meets Data: Register for October 9th event
How the iPad changed our vacation
DB2 10.1 - the first fixpack is out
DB2 Information Center: English, deutsch, español, italiano, etc.
DB2 on Android? Yes! IBM Mobile Database
San Francisco vacation, Audi cars, and DB2 replacing Oracle
New Redbook on pureScale: Delivering Continuity and Extreme Capacity with the IBM DB2 pureScale Feature
XML Devotee session with z/OS topics
It is coming up, here is the video
Welcome to Switzerland! Choose your database territory wisely...
Two whales in the air: Zeppelins over Friedrichshafen
Partial early blog posting
Vacation: Time to REBALANCE (and to look at DB2 10)
A box of ice cream?
Another year passed by: Energy consumption in a passive house
Big Data, Big Problems, Right Questions?
Index something non-existing - functional indexes in DB2
Another quiz: How to index something non-existing?
Implicitly hidden columns in DB2
A small DB2 SQL quiz - why the SQL error?
Want to learn about DB2 security? New best practices paper
How to communicate within your family (kids, significant other, DB2)...
NoSQL, SPARQL, RDF, Graph Store, and more buzzwords - all new in DB2 10
It is "venerdi" in "it" - a Friday idea
DB2 pureXML and bufferpools - revisited
Learn about DB2 10 in free bootcamps
IBM Commercial from the past with a still up-to-date problem
Partial Early Desk Cleaning - New in DB2
Travel and Security Concepts
Business Travel and DB2 SQL Compatibilty
DB2 10.1 for LUW now online!
DB2 and important stuff my smartphone can do...
Consistency checks: Failed Groupon email
Webcast: Architecting with XML and temporal data
New DB2 10 Bootcamps are coming
DB2 10.1 for Linux, UNIX, and Windows announced!!!
Aero Expo and Database Monitoring
Today is Document Freedom Day
Basics: Multi-language support in DB2 Information Center
What is security and should I care?
Turn XML data into columnar, relational format using SQL (lots of useful links inside)
Business trips and database migrations
Try MONREPORT to generate monitoring reports
DB2, I love you!
Quick answer: Yes, there is DB2 LUW on the mainframe under zLinux
XMLQuery: The document that never was and the intermediate step error
DB2 and PL/SQL features
Hospitals - a place of extremes
2011
If you are late, just say you are super asynchronous... (HADR)
5 minutes, 60 seconds, and ATS: the Friday learning
Scaling of memory-related configuration settings for tests of DB2 LUW
WMD: Weapon of mass destruction? No, Workload Multiuser Driver!
All the news: DB2 Express-C with PL/SQL, new TPoX version, DS 3.1, and hello to all PMs
Monitoring: Three new for three old monitoring functions
Ready for an IBM puzzle? Some links and a question...
DB2 9.7 Fixpack 5 is available
Epilepsy, computer viruses, and personality changes
IBM Data Studio Version 3.1 consolidates some Optim tools
What is a smart phone?
WOW for MDC on MQT - How to speed up the load process for a warehouse
IDAA: IBM DB2 Analytics Accelerator announced
Su casa es mi casa: Restore in DB2 and obtaining SECADM and other privileges
High availability, epilepsy, functional MRI, and DB2 commands
"Remember to flush" - Your options in DB2
Some DB2 commands for the pureScale feature that saved my box...
New Redbook: Security Functions of IBM DB2 10 for z/OS
DB2 pureXML for the Protein Data Bank - Managing Atoms and Molecules with XML
Things for the curious: db2greg
Summer (vacation) is over: Build up skills - DB2 Aktuell conference
How to find out that it is time for vacation
A small update on updating XML data in DB2
Energy consumption for another year in our passive house
Data inconsistency causing 30 minute flight delay
XQuery: Variable-based step in XPath expression
Daddy in the cloud vs. Daddy as a Service vs. Traditional Daddy
The military, the space, the mainframe, and YOU
DB2 Merge Backup: When some deltas make a full
Happy Birthday IBM!
Friday Fun: What people drink on the airplane...
DB2: What does the error code mean?
Several new Best Practices for DB2 papers on IBM developerWorks
Friday Fun: IBM Commercial from the past
Memory leaks in software and epilepsy
Epilepsy: When computer science and medical science meet
Overview: DB2 Base Tables, Created Temporary Tables and Declared Temporary Tables
How to stretch a pureScale cluster: Configuring geographically dispersed DB2 pureScale clusters
DB2 9.7 FP4 is out: Trigger support has been enhanced and some other goodies
New IBM Redpaper: Highly Available and Scalable Systems with IBM eX5 and DB2 pureScale
My resource page has been updated
Pure and free: Test pureXML on pureScale
Some more time, some XML functions
(Updated) Times are changing: DB2 vs. Oracle mode
Get the hint: How to enable support for Oracle-style hints in DB2
Oracle compatibility in DB2: Some strings attached
One day DB2 pureScale workshops in Ehningen (Stuttgart) and Paris coming up
Valentine's Day: How to date with DB2...
Power of attorney and trusted contexts
Redbook published: Extremely pureXML in DB2 10 for z/OS
World Economic Forum, Parking Problems, and DB2 pureXML
Why XML columns have a length of zero
Current DB2 Fixpacks
Hello and some lessons from the holidays
2010
Gaining access to DB2 data through indirect means
How long does it take to build workload optimized systems?
More on full text indexing: XML documents and XPath
Indexing PDF Files with DB2 Text Search
Black Friday Special: DB2 for free (no MIR required)!!!
pureXMLness - Explained!
One editor, many tools: The SQL and XQuery editor has been enhanced
What "pureXMLness" do you have...?
SQL and XML Limits in DB2
Oracle to DB2 terminology mapping
How long is long? Maximum size of an XML text node in DB2
Some flights, appliances, and "one size fits all"
DB2 9.7 and changes to DBADM authorities
Some more pureXML bootcamps this year
Performance: Statement concentrator, small knob with an impact
Boring news? Yet another benchmark record for DB2 on POWER
Where do you want to have a DB2 pureXML bootcamp?
DB2 Advanced Enterprise Server Edition: All you need in one package
Using DB2 pureXML and ODF Spreadsheets
New fixpack (FP3) for DB2 9.7
Zeppelin: There are no whales in Lake of Constance
Automatic compression in DB2? Good question and some answers
Just in time - autonomics in action
Obtaining information about the installed DB2 version (level)
Food: Where business and life meet
Beer or wine, elements or attributes? Designing XML schemas
Yes or no: What is better for your data?
To APPEND or not to APPEND: Insert and Import Performance
"BY REF" in XML processing
Real life: May all your transactions commit!
Smaller, but way faster and cheaper: IBM sets new TPC-C record
pureXML Indexing - Behind the scenes
Performance scale-out and continous availability: DB2 pureScale now available on System x
Fat-free and now in a light edition: DB2 Express-C download image
I wish they had...
Catalog view xmlstrings for simpler access to stringID information
New generation of mainframes and an integrated accelerator for warehouse workloads
Two days in France (in August for pureXML)
Another year gone by: Energy consumption in our passive house
Passive Houses in the US
Forrester Analyst: Customers report success with DB2's out-of-the-box compatibility to Oracle's SQL
Experience: Switching the laptop from Windows to Linux
Housing Transactional and Data Warehouse Workloads on System z
Moving? Pack your tablespaces - Transportable tablespaces and schemas (sets)
SSacSA - A typical IBM acronym, but not the typical product (Move from Sybase to DB2)
Obfuscate your DDL statements (aHJgFSG127_henRIK)
Catching up - 5 weeks in review
Automate DB2 database maintenance
New uses for the DATE function?
Passive houses, windmills, clouds, ice saints, DB2, and some nice prizes
New "Best Practices" for DB2 on AIX 6.1 on Power
Overview: DB2 tablespaces and bufferpools
Happy eating: Separation of duties and DB2 security
DB2 (for z/OS), COBOL, CICS, and ....: pureXML
A word on design and Star Wars
Have you booked your trip to IDUG?
Smart Vacation and Smarter Systems
(Updated) Strange error on insert into DB2
Sink Friday
Accessing and processing embedded textual XML documents
The trouble with processing embedded textual XML (CDATA)
My SYSDUMMY1 has turned DUAL
General Availability!!!
Deadlock and Hot Spot in Real Life (Police Report)
IBM XML Index Advisor for DB2
Is it me or the database topic? Simple reading guaranteed
DB2 Performance and cost savings tip: Don't maintain unused stuff (LASTUSED)
Understanding Processor Value Units (PVUs)
Traveling too often? Dealing with not so easy customers? Try this...
Servers For Truth or IBM vs. Oracle
The most advanced voice recognition system of its kind
New Redpaper on System x Virtualization Strategies
Google Buzz educates public about data privacy
Bank Data R Us (not anymore)
Playing around with db2diag
Electrocardiography (ECG), Health Checks, Performance Expert, DB2, and Oracle
Electrocardiography (ECG), Twitter, and Databases
One more thing: An amazing, unbelievable, great video - wonderful!!!
Give me what that guy had... (Larry E.)
Today is Data Privacy Day
What our dishwasher knows about my family
Why old hardware is great for production performance
Separating diagnostic logs in DB2 9.7 (to split or not to split)
Funny video: How to turn the iPhone into a WWII war plane
About my watch and your workloads or projects....
About my pants and your systems...
2009
Happy Holidays
Excuse me, what year do we have? - Some usability enhancements for XQuery in DB2
XML Processing on z/OS
Orwell, 1984, and Google
Why? Motivation (based on fun)
Shock or Joy? Power Meters and the core of everything: Data
Friday Fun with Airlines
Tell me what you are (or could be) - Admin functions for inlining
Holiday Preparations - Your action required!
Call with IBM experts on Using JDBC with pureXML (updated)
Let's phone, shop, and whatever.... - Testing new limits
The importance of correct and integrated data
Learn about MySQL and DB2
Address databases (CRM), the holiday season, and load balancing
My topics as Wordle
DB2 9.7 FP1 is available, supports read on standby (HADR)
Do you webcam?
The last one
Small is beautiful (and fast): LOB Inlining
Cooperate for greater performance! (Share a scan)
From small to big, and always good...
Save Money, Get Promoted!!!
Bringing fun, a Zeppelin, the Bay Area, and Europe together
Call with DB2 experts on XMLTABLE (2009-11-10)
How much does Google know (officially)?
Additional information and help for DB2 pureXML
How much data do I generate each day?
Social Computing from Mobile Devices in a Cloud Computing Environment for Advanced Analytics,,,
What is the difference between a laptop and a mainframe?
Hey, what's wrong with you?!?
Learn more about pureXML for z/OS and LUW
Teeth Whitening Tips and DB2 Express-C (and not Oracle 11g XE)
IBM Presentation Program / IBM Vortragsprogramm
Mixing cookies, sales records, and DB2 pureScale
First official word on DB2 pureScale
Diagnosis: Simple(r) Life
Virtual machines, but real books, real products and - yes - really useful
A passive house in Fall / Unser Passivhaus im Herbst
New TPoX release and performance numbers
TPC fines Oracle for recent benchmark claims
XMLTABLE - Explained, the easy way (Part 2, References)
A look at free database systems (from the XML perspective)
XMLTABLE - The all-in-one function?! (Part 1, Syntax)
Selling pre-owned cars (and Oracle Exadata)
Wow, Oracle combines database system with disks (again!)
From kitchen to datacenter - consolidate and generalize
New in 9.7: XML index creation/reorg with concurrent writes
Moving and transforming (XML) data
XML and Big Data - And why DB2 is hybrid
Sent from my... (Information Overload)
Clicks, Hefeweizen, and Transactions
Wikibooks, XQuery, and Sudoku
Did you get it? Setting up analytic systems is simpler now
Is it real? A virtual conference again
Travel: Using humor to cope with stress
Beware Be aware of the invisible!
Relational vs. pureXML: Some indexing differences
Fun with databases: How cereals turn into silverware
pureXML for your well-being!
Job vs. Life: The importance of tools and ROI
Energy Consumption in our Passive House / Jahresstromverbrauch in unserem Passivhaus
Oracle + TPoX = no results?
Step back: I am a DBA! (or DB2 developer or IM specialist)
Lessons from the field: Simplicity wins - XMLGROUP, XMLROW, and XMLAGG
Two essential links: IBM Data Studio and a free book
The DB2 Process Model - Some Links
DB2 Information Center - Revisited
So many reasons to...
Lessons from the field (again): Remember the trees!
Some basic presentation/Powerpoint rules...
XML: Learn how to say NO
pureXML performance tip: A sequence of good indices...
How to insert XML data into DB2
What makes a great XML schema?
Buy groceries, produce XML, feed DB2, gain weight insight
Ups and downs with phone conferences
db2top: What's going on?
Friedrichshafen, Dornier, Herschel, Planck, Hubble, Zeppelins, and Codernauts!
Which payment is greener: Cash or Credit?
DB2 9.7 (Cobra) for extended vacations?!
Pass it to me, no, wait, to me! (Parameter passing from SQL to XQuery and back)
Modeling messed-up Mashups means more money mapReduced?!
DB2 pureXML: All the XQuery features you need
Jeopardy, Watson, Goldfarb, Mosher, Lorie
stringIDs in DB2 pureXML: What and Why
Passive House, Electric Cars, Noise, and DB2 diagnostics
A rabbit in your life?
XML arrives in the warehouse
Q4U: R U Cmprsng UR DTA?
Now it's final: Oracle buys SUN
Home Automation, SOA, DB2, and an awning
Lessons from the field: Remember the trees and your relational data!
XML, WebSphere DataPower, and Data Studio
A day at AERO 2009: About aviation and databases
DB2 pureXML and stringIDs
Thermal Images have arrived
pureXML Devotee call today
One year ago: Moving in
Puzzled about the XML Regions Index?
About Tecology, Lamp Mounts, and Empty Spots
Everybody hates DB2, and pureXML is crap!
Spring has arrived (no Java inside!)
Smart Metering / DB2 Performance Expert
Hundreds of indexes on a single XML column - why not?
Does you car need different engines? (XML Storage)
The DB2 Information Center has: Information!
Zeppelin NT Review in "Road & Track" (no DB2)
I am not allowed to tell you
DB2 pureXML And Bufferpools - XDA Object
How many trees does a forest need? (DB2 pureXML Indexing)
Passive House & "Arctic" Wheather / Ein Passivhaus bei den arktischen Temperaturen
Virtual Here, Virtual There
Valentine's Day, DB2 pureXML, and XQuery - How To Impress Your Spouse
Organic Food and pureXML (now included in core DB2 license)
XML Database Benchmarks, TPoX, and DB2 pureXML
Some San Francisco fun / Mit Skiern durch San Francisco
DB2 jack-of-all-trades: Hybrid, native, bilingual, pureXML
Thermal Imaging - QA work for your house
Would Harry Potter use pureXML?
An Even More Secret Advice About db2-fn:sqlquery() - Casting in XQuery
A cheer for a new chair? / Auf der Suche nach DEM Drehstuhl
Gas prices and pureXML / Benzinpreis
pureXML Puzzle