planetDB2 logo

Planet DB2 is an aggregator of blogs about the IBM DB2 database server. We combine and republish posts by bloggers around the world. Email us to have your blog included.


March 22, 2019

DB2Night Show News

29 March 10am CDT: Db2 LUW Native Encryption with guest Paul Bird, IBM

New shows for Season #10 of The Db2Night Show are scheduled! Encryption! IDUG! IBM Breaking News! Problem Determination! Here are the highlights and registration links:


March 19, 2019

Ember Crooks

SQL Differences Between Db2 and Informix

I have been working with Informix from a user perspective recently. I learned about some of the SQL differences and developed a greater empathy for developers in the process. CTE Support is covered, along with comparing the date and time handling syntax.

March 18, 2019

DB2Night Replays

Db2Night Show #z95: Db2 Batch System Design for High Performance

Presented by: Neal Lozins Softbase "The DB2Night Show #Z95: Db2 Batch System Design for High Performance" Replays available in WMV and M4V formats! 94% of our studio audience learned something!Neal described the issues, challenges and techniques for designing optimal batch applications. Watch the replay...

(Read more)

March 14, 2019

Ember Crooks

SQL That Meant Well: Where Functions are Applied

Not only was this delete running unreasonably slow – it was also causing lock timeouts on the MEMBER table while running because of the slowness. This post contains application specific details that you don’t need to understand the underlying concept here, which applies across many SQL statements in the real world.

March 13, 2019

Triton Consulting

Expand your DB2 Knowledge – DB2 for z/OS Master Class 2019

There’s still time to book onto the week-long Db2 for z/OS Master Class offered by IBM’s Db2 for z/OS Development team. The UK class will be taking place at IBM Huxley in Hampshire and will be led by IBM Distinguished … Continue reading → The post Expand your DB2 Knowledge...

(Read more)

March 10, 2019

DB2 Guys

Use your Bathroom more Effectively

Whether you think about it an in-home escape out of your hectic day or just someplace to clean up, the lavatory is one place in your house everybody is bound to go to. Taking advantage of a small house is all the time a good suggestion, and turning bigger grasp bogs into spa-like getaway rooms is a rising pattern.

The next are some rest room adorning concepts for any toilet, irrespective of how a lot or how little you need to spend.

Make Easy Issues Depend

One of many best methods to replace your bathtub cupboards and add pizzaz is to swap out the previous hardware for brand new. You’ll have no drawback discovering an abundance of designs at retailers, which suit your type and finances. Earlier than you fall in love with a brand new pull, knob or deal with, you should definitely measure the space between holes to ensure the swap requires nothing greater than a screwdriver, and contemplate the end on the hinges to forestall clashing.

Add Some Ambiance

Spa parts—together with showers that double as steam rooms, Jacuzzis and decadent soaking tubs, mini-bars and warming trays for towels—are all widespread lavatory adorning concepts these days. “Individuals are spending extra time of their baths as a result of it’s a retreat from busy life,” says Susan Marinello, Principal Design Director. “It is sensible that they need the spa components that assist them to loosen up and rejuvenate.”

Though the sky’s the restrict, you may have an expensive grasp toilet even on a price range. “There are some actually low-cost tips you should use to occur a spa setting,” says inside designer Leslie Harris. “All lights needs to be on a dimmer, and a sound system and even an iPod for those who can’t wire for audio system goes a great distance in direction of creating a soothing setting.” You too can set up electrical heating pads below the flooring materials. “You’ll be able to simply warmth a three-foot by three-foot pad in entrance of the self-importance or bathe and actually improve the toilet expertise,” Marinello explains.

In fact, don’t overlook that little luxuries go a great distance. Place contemporary flowers and scented candles in your counter tops, fill up on great soaps and physique scrubs and some super-fluffy towels. Pure and soothing blues, greens, and gold are good. Touches of nature go a good distance, as nicely; add a window backyard or grasp framed images of your dream mountain getaway.

The post Use your Bathroom more Effectively appeared first on Decorate and Fun!.


March 09, 2019

DB2 Guys

Stylish Living Room

Magnificence Seems to be Straightforward

Elegant residing rooms show effective design with out showing flashy. And it’s tougher than it sounds. This lounge within the house of Washington, D.C. designer Skip Sroka reaches the head of stylish conventional design with light curves on the window therapies and furnishings. Each chairs and the couch have fantastically rolled arms in addition to refined curves on the again. The home windows are adorned with curved Roman shades in a damask tone-on-tone that underlie easy pleated silk panels. All collectively, the curves convey a shapely magnificence that ties the room collectively. That is the essence of sentimental adorning. The coffered ceiling and quiet palette proceed the understated attraction

Basic Strains

This hearth view of designer Skip Sroka’s Washington D.C. front room reveals extra of his secrets and techniques to creating a sublime area. The gold-leaf mirror above the hearth is ornamented with a Greek-key motif, the grandfather of traditional patterns. (Assume the alternative of classy.) The mirror does greater than introduce traditional strains, nevertheless. It additionally swings out to disclose a flat-screen TV. This type of cleverly hid hard-working operate supplies another clue to the that means of stylish adorning. Effectivity. (Apple merchandise’ effectivity makes them probably the most elegant of their business. The identical guidelines apply to each inside and industrial design.) The whole hearth presentation is refined via the symmetrical stability of the mirror between a pair of vintage sconces

Beautiful and Gentle Dwelling Room

Making the best adorning choice generally means doing nothing in any respect. When a front room just like the one on this East Hampton home is blessed with lovely French doorways and an abundance of sunshine, a sensible designer is aware of to depart nicely sufficient alone: Preserve the home windows undressed. Designer Larry Laslo did simply that. He additionally enhanced the structure’s airiness with a monochromatic palette of soppy pearl and sand with darkish wooden accents.

The post Stylish Living Room appeared first on Decorate and Fun!.


March 08, 2019

Ember Crooks

SQL That Meant Well: Applying Conditions in the Subquery vs the Outer Query

This is a new series that has been percolating in my head for a while. When I help clients with SQL, we’re often adding (or removing) indexes to help SQL performance. It has been said (though not by me) that SQL re-write is obsolete because the Db2 Optimizer will take care of that.… Read the rest

DB2 Guys

Mirror Decorating Ideas

Mirrors are one of many essential mandatory objects in home adorning. We searched some strategies which will mirror you in all of the exact strategies. Whether or not or not you’re looking for a model new addition to your bar cart or a glitzy contact in your mattress room, incorporating a mirror is a ought to.

Paired With a Facet Desk

We love the idea of pondering previous the dresser as regards to mattress room mirrors. Paired in opposition to your facet desk, a mirror creates a styled look and helps to reflect the lamp’s mild.

Hung Above a Mattress

No headboard? No disadvantage! A mirror makes an necessary substitute and helps to open up your room. Even in case you will have a headboard, hanging a mirror above it creates a gallery impression.

Rested In opposition to a Wall

An oversize mirror rested in the direction of your wall creates the final phrase, laid-back however luxe look. While you don’t want a set of three, the bigger the mirror, the upper for this styling trick.

Used Previous the Wall

For many who favor the look of mirrors, suppose previous the wall. Mirrored furnishings is a chic addition, notably when paired a set of mirrored frames!

Saved Typical

Usually, it’s OK to stick with customized. You probably cannot go incorrect hanging a mirror above your mantel, notably when your partitions are painted black.

The post Mirror Decorating Ideas appeared first on Decorate and Fun!.


March 07, 2019

DB2 Guys

Elegant Living Room Ideas

Magnificence with an Edge

So can a front room be elegant and edgy ? The Honolulu residence of designer Marion Philpotts Miller suggests the reply is sure. Sure stately furnishings like a grand piano are fixtures of finery, and music-loving Miller is a fan. However she’s an equally avid supporter of visible arts together with these with a contemporary bent. The lounge’s lavender pod chandelier provides an edgy layer of complexity to the room’s design, making it as fascinating as it’s elegant.

Sterling Design

Dove grey and a focus to element occur serene sophistication in the lounge of this Connecticut residence overlooking Lengthy Island Sound. “I didn’t need a beachy house so we went with darkish flooring and traditional particulars,” says the proprietor, architectural designer Louise Brooks. Farrow & Ball’s “Skimming Stone” is painted on the partitions, whereas the wooden comes clear within the venerable paint firm’s “All White.” Silver-gray cocktail and aspect tables choose up the thread of shade from the room’s gray-and-white striped  Elizabeth Eakins rug, whereas the furnishings stays calm in white upholstery materials. Even the equipment on the fireside wall’s cabinets are pared down for significance. Most notable is the pair of vintage lanterns on the center cabinets.

Fashionable Combine

Who higher than furnishings designer Bob Williams to grasp the fashionable combine? In the lounge of his house in Hickory, North Carolina, the cofounder of furnishings producer Mitchell Gold + Bob Williams pairs his new designs with classic favorites from the mid-century. His eye for high quality is revealed in his treasured outdated Lucite chair, Eames-style white leather-based armchair, and Frank Gehry cardboard chair, all of which mingle together with his personal clean-lined designs. Conventional toile draperies from Duralee and ice-blue partitions set off the elegant combine.

The post Elegant Living Room Ideas appeared first on Decorate and Fun!.


March 06, 2019

DB2 Guys

Merhaba dünya!

WordPress’e hoş geldiniz. Bu sizin ilk yazınız. Bu yazıyı düzenleyin ya da silin. Sonra yazmaya başlayın!

The post Merhaba dünya! appeared first on Best Template.

DB2 Guys

Cheap Diy Christmas Ideas

You already know it can save you cash with DIY (do it your self) Christmas present and Christmas appetizers you make your self, however your Christmas decorations do not have to interrupt the financial institution both. Use these do-it-yourself concepts for vacation adorning according to your  budget.

Have a Chocolate Jar

Seize your favourite sizzling chocolate model and toppings, a transparent mug or mason jar, and begin layering, in line with how does she. Maintain a number of stashed within the visitor room for guests who stick with you through the holidays. All they should do is add scorching water and revel in!

Mini Christmas Trees

Plain dry branches out of your yard—whether or not from inexperienced firs or naked deciduous bushes—make glorious decorations while you spray with silver or gold paint. Grasp, or tuck in a vase to embellish an entryway or eating room. Plus, add ornaments to the branches for an prompt Christmas tree.

Santa Chairs

These chair toppers are easy to make, washable, and charming! Watch and be taught as make it Find it irresistible reveals you the right way to add some colour to your eating room with these felt Santa Claus Hats.

Place Nice Pinecones

Dip pinecones in gold paint (both partially or the entire approach) or use a combination of water, glue, and glitter for a glowing impact. Place on aspect tables or use to fill baskets and bowls.

Create An Introduction Calendar

Begin by spraying an outdated body with a metallic base, says By Stephanie Lynn. Create tags utilizing a web-based template (see hyperlink beneath). Combine in gold, silver and impartial ornaments to tie the entire Calendar collectively.

Begin by spraying an outdated body with a metallic base, says By Stephanie Lynn. Create tags utilizing a web-based template (see hyperlink beneath). Combine in gold, silver and impartial ornaments to tie the entire Calendar collectively.

The post Cheap Diy Christmas Ideas appeared first on Decorate and Fun!.


March 05, 2019

Dave Beulke

5 THINK Conference Dreams, Themes, and Details

As I said before the IBM THINK conference was an interesting event. Having several different presentation venues, picking sessions to attend made planning your day and travel between sessions/venues a challenge. Also since most of the sessions didn’t have the presentations available for viewing...

(Read more)

DB2 Guys

Kitchen Decorating Ideas

Greater than only a house for cooking and consuming, the kitchen is the place all the motion within the dwelling takes place. We stay in our kitchens. From entertaining visitors to gathering collectively on Saturday mornings as a household, it is the true coronary heart of the house. Whether or not you are renovating, redecorating, or just updating this house, contemplate how you reside earlier than making any adjustments. Get impressed to rework this space with these sensible and easy-to-steal ornamental touches.

Shelf Life

Use each inch of area for sensible, space-saving storage. This 16-cube shelving unit steps as much as the problem of holding plates, linens, and serving items. For an surprising ornamental contact, line the backs with wallpaper so it coordinates along with your fashion.

Colour Story

In case you have a contemporary adorning type, embrace a daring shade and high-gloss end. Vanilla white and cherry purple lacquer cupboards take this kitchen to daring heights. To keep away from visible commotion, maintain the remainder of your equipment (kitchen textiles, servingware, plates) on this coloration palette.

White Wall

Adorning a big kitchen could be an intimidating activity. In the event you select to stay with a impartial palette for the bigger gadgets (white partitions, black granite counters, and ivory cupboards), then you definitely’ll have higher freedom and suppleness to replace accents like textiles, runners, and even place settings.

Island Child

A glossy, trendy kitchen needn’t really feel chilly. When you’re beginning with a black-and-white basis, infuse it with some colour, just like the muted aubergine on the overhead cupboards. Add texture by layering a striped rug over a seamless flooring. Moderately than recessed lighting, cling a pair of chandeliers from the ceilings for an surprising twist.

Natural Choice

The quintessential white kitchen by no means goes out of fashion. This one is made particularly inviting with pure touches like flagstone flooring, oak island and ceiling beams, and a farmhouse-style desk. The additional seating alongside the island make it a cushty spot for informal breakfasts or mid-afternoon espresso.

Conventional Timing

Simply as you’d enhance a lounge across the mantel or a bed room across the mattress, plan your kitchen across the cooking zone. The blue vary cooker is and must be this kitchen’s point of interest. For a house that depends on loads of storage, cling additional floating cabinets to carry cookbooks and containers.

The post Kitchen Decorating Ideas appeared first on Decorate and Fun!.


February 28, 2019

Ember Crooks

Connecting to an Informix Database from Jupyter Notebook

There is almost nothing in this blog post about Db2. This is unusual for me. But I had a bear of a time figuring this out, so I need to share. I have a lot of Db2 performance data that is stored in an Informix databse. This means that if I want to apply things I'm learning with Jupyter Notebook and data science to this data, I had to learn the basics of how to connect to an Informix database.

February 25, 2019

Robert Catterall

Db2 for z/OS: Isolating REST Client Activity in Db2 Monitor Accounting Reports

In an entry posted to this blog some years ago, I described the form of a Db2 monitor-generated accounting report that I most like to use to get an overall view of application activity in a Db2 for z/OS environment: an accounting long report with data ordered by connection type (here, I am using terminology associated with the Db2 monitor with which I'm most familiar: IBM's Tivoli OMEGAMON XE for Db2 Performance Expert on z/OS). I like to see data in an accounting report aggregated at the...

(Read more)

Henrik Loeser

Digital ethics, trusted AI and IBM

Last week I gave a talk followed by a discussion at a university. The presentation was about the current state of Artificial Intelligence (AI) and AI research topics. A good chunk of the discussion...

(Read more)

February 22, 2019

DB2Night Replays

The DB2Night Show #212: Db2 LUW SQL Tuning; Find, Fix, and Prevent Problems

@klaas_brant Special Guest: Klaas Brant Owner, KBCE IBM Gold Consultant Db2 LUW SQL Tuning: Find, Fix, and Prevent Problems! 100% of our audience learned something!Klaas gave us another amazing presentation! From monitoring commands to utility recommendations, Klaas covered it all! Watch our replay to learn MON_GET queries, OS commands, configuration settings, and best practices for making your Db2 SQL run crazy fast! Watch and...

(Read more)

February 21, 2019

Ember Crooks

Update on Ember’s Data Science Journey – February 18, 2019

I’ve been moving along well this year on my data science journey. I’ve been thoroughly enjoying an edX class: Python for Data Science from UC San Diego. I started using Jupyter Notebooks (Python Kernel) over a year and a half ago, so I am enjoying the course on three levels:

  1. It seems easy because I have a background in Python, basic programming, and Linux systems
  2. I’m learning more about the Python libraries I use for Db2 health checks, and more about DataFrames that builds on my self-taught knowledge.
Read the rest

February 20, 2019

Dave Beulke

THINK Conference – Db2 for z/OS Highlights

The IBM THINK conference was an interesting event with over 33,000 people in attendance that braved the cold San Francisco weather and rain while going to the many different conference session locations. One of the best sessions during the week was given by Db2 for z/OS Director Mo Townsend and...

(Read more)

February 19, 2019

Triton Consulting

Six Reasons to Review your Database Availability – Part 6 Marketing and PR Costs

From working with many customers to help keep their critical databases up and running we have come up with the top 6 reasons for putting Database Availability at the top of your priority list. In this blog we look at … Continue reading → The post Six Reasons to Review your Database...

(Read more)

Ember Crooks

Db2 SQL Basics: The Column List

Learning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing. The complete detachment from the physical layer can confound others.… Read the rest


February 18, 2019

Craig Mullins

My Thoughts on Think

Last week I had the great pleasure of attending the IBM Think 2019 conference in San Francisco. There were many great sessions and content covering my interest areas, including AI, machine learning, analytics, data governance, Db2, digital transformation, and more. Part of the difficulty of attending such an event is deciding what to attend from a list of competing, interesting topics. And...

(Read more)

DB2Night Replays

Db2Night Show #z94: Data Masking for Db2 on z/OS

Presented by: Kai Stroh UBS Hainer "The DB2Night Show #Z94: Data Masking for Db2 on z/OS" Replays available in WMV and M4V formats! 100% of our studio audience learned something!Kai described the requirements and issues when creating Db2 test data. Watch the replay...

(Read more)

February 12, 2019

Kim May

Baltimore/Washington Db2 Users Group March Education Session

The Baltimore/Washington Db2 Users Group will be holding our annual education session on Wednesday, March 20, 2019, at the BWI Hilton.  Please note the date is the third Wednesday in March, not the...

(Read more)

Ember Crooks

Db2 SQL Basics: The Most Basic Select Statement

Learning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing. The complete detachment from the physical layer can confound others.… Read the rest

Triton Consulting

Countdown Begins for DB2 v10.5 Support

End of Support Announced Did you know the End of Support (EOS) date for DB2 v10.5 on Linux, UNIX and Windows platforms has been announced as 30th April 2020?  After this date IBM will only provide the full defect and … Continue reading → The post Countdown Begins for DB2 v10.5 Support...

(Read more)
Jack Vamvas


Question: During a change on a server , I had to do a TSA failover as part of testing . For various reasons - outside of TSA - the failover failed. Using  lssam - one of the resources - ended up in MemberInProblemState and Failed offline

Both the network and virtual ip resources are in a state of equivalency

How can I fix and reset ?



When a resource is marked as failed offline:clear the state and return that resource to normal operation

#resetrsrc -s 'Name =="resource1"' IBM.Application

#resetrsrc -s "Name like 'db2_db2inst1_0-rs' AND NodeNameList in {'MY_HOST_NAME'}" IBM.Application



For more reading on TSA

TSAMP Cheat Sheet for DBA managing DB2 clustering


February 08, 2019

Henrik Loeser

Startup lessons from a Fuckup Night

Last Wednesday, I attended the Fuckup Night Friedrichshafen Vol. II. If you don't know, Fuckup Nights is a global movement and event series dedicated to professional failures. That is, usually...

(Read more)

February 07, 2019

Frank Fillmore

IBM Replication 2019 New Features Webinar #IBMAnalytics #IBMz

Thanks to my colleagues, Kim May and Ed Lynch, for a terrific IBM InfoSphere Data Replication (IIDR) new features webinar delivered today.  The recording of the webinar is found here.    These are...

(Read more)

Data and Technology

Inside the Data Reading Room – 1Q2019

It has been awhile since I have published a blog post in the Inside the Data Reading Room series, but that isn’t because I am not reading any more!  It is just that I have not been as active...

(Read more)

February 05, 2019

Ember Crooks

Using Windows AD groups in DB2

DB2 has an “interesting” relationship with Windows OS, and one of the areas where that relationship comes to the surface is user authentication and authorization, particularly when one is trying to use Active Domain groups for authorization purposes.

Here are a few pointers:

  1. Don’t use CLIENT authentication – this authentication method is explicitly excluded from the ability to use AD groups for authorization purposes.
Read the rest