decor
 

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.

 

September 04, 2015


Data and Technology

Optimizing Database Performance, part 6: Automation

Parts 1, 2 , 3, 4, and 5 of this series are also available. Today’s post, the final one in this series, will briefly discuss automation… and autonomics. Setting the Stage Implementing,...

(Read more)

Brian Fairchild

4 Prerequisites for Enterprise AngularJS Applications

Here are 4 prerequisites for Enterprise AngularJS Applications, everyone should pay attention to. This will help in achieving successful and timely delivery of quality enterprise AngularJS...

...

Craig Mullins

Influencing the DB2 Optimizer: Part 7 - Miscellaneous Additional Considerations

In this 7th, and final installment of this series on influencing the DB2 optimizer's access path choices, we will take a look at a couple of additional things to consider as you work toward improving your SQL performance. Favor Optimization Hints Over Updating the DB2 Catalog   Optimization hints to influence access paths are less intrusive and easier to implement than changing data in the DB2...

(Read more)

Brian Fairchild

Migrating Liferay SDK to Maven – Dependencies

The liferay-plugin-package.properties file is used to list dependencies from the portal’s jars.  At deployment time, Liferay will copy the listed jars from the portal’s WEB-INF/lib...

...
 

September 02, 2015


DB2Night Show News

A DB2's GOT TALENT Success Story

I received a lovely note tonight from one of our DB2's GOT TALENT 2015 contestants. It warms my heart to see how we're helping people with DB2 and their careers. Read more...

...

Brian Fairchild

Rapid UI Development using AngularJS

AngularJS has been around for some time and has proven itself to be a framework that is here to stay. While there is a lot of promise (pun intended!) and... READ MORE The post Rapid UI Development...

...

Dave Beulke

More DB2 Family Security Best Practices Part 5

The next part of this DB2 Family Security Best Practices blog series talks about developing a unique corporate security. This security is unique within your organization and unique within your applications. Given that encryption can have performance overhead, can complicate management procedures,...

(Read more)
 

September 01, 2015


Ember Crooks

Using DB2’s New Native Encryption Feature

With fixpack 5 of DB2 10.5, IBM introduced Native Encryption for data at rest in DB2. This is a fairly significant new feature for introduction in a fixpack. It does require separate licensing...

...
 

August 31, 2015


DB2Night Show News

Heard about any data breaches lately? Learn DB2 LUW Security and Auditing

The DB2Night Show™ begins Season #7 with guest Melanie Stopfer, IBM DB2 Brain Surgeon, on 4 September 2015 at 10am CDT talking about DB2 LUW Security and Auditing! Her presentation titled...

...

Data and Technology

Optimizing Database Performance, part 5: Database Reorganization

Portions of this tip were excerpted from my book Database administration: The complete guide to DBA practices and procedures (2nd edition). The first , second , third, and fourth parts of this series...

(Read more)

Robert Catterall

DB2 for z/OS: Which Buffer Pools Should You Page-Fix?

A few days ago, I delivered a presentation on DB2 for z/OS performance monitoring and tuning for the DBA team at a large financial institution. At one point during the session, an attendee asked this question: "Which of our buffer pools should we page-fix?" Because that's a good question, and because it's a question to which the answer has changed over the years, I decided to make it the subject of this blog entry. The ability to fix a buffer pool in memory, accomplished through the PGFIX(YES)...

(Read more)

Brian Fairchild

Liferay, SAML and multiple virtual hosts

Once upon a time… Sometimes a new project becomes a challenge. That’s the interesting part of software development; otherwise, this job would not be as special as it is! And... READ MORE The...

...
 

August 28, 2015


Brian Fairchild

Okta – Liferay integration using SAML 2.0

For those of you that do not know what Okta is, an okta is a unit of measurement used to describe the amount of cloud cover at any given location such as... READ MORE The post Okta – Liferay...

...
 

August 26, 2015


Brian Fairchild

Liferay 6.2 Theme Development Tips: Speeding Up the Work

The basic process of Liferay 6.2 Theme development involves creating a new theme, make changes to it, and deploy. It’s really a simple process; however. the only drawback to this... READ MORE The...

...

Dave Beulke

More DB2 Family Security Best Practices Part 4

The next part (Part 4) of this DB2 Family Security Best Practices blog talks about the many aspects and issues around DB2 LUW and DB2 z/OS encryption. Encryption needs to be discussed extensively with your security department and various applications because it has long term impacts on operations,...

(Read more)
 

August 25, 2015


Brian Fairchild

InforCRM / SalesLogix Client-side Validation

In most case I try to do the validation for InforCRM form input on the server side. This is generally easier to implement (sometimes a lot easier), more reliable, and... READ MORE The post InforCRM...

...

Craig Mullins

Influencing the DB2 Optimizer: Part 6 - Using Optimization Hints

So far we have discussed several standard methods of influencing DB2’s access path selection -- in the first 4 parts of this series (1, 2, 3, 4) -- as well as updating DB2 Catalog statistics in part 5. But there is another tool in your DBA arsenal that you can use to force/influence access path selection - optimization hints, which will be the focus of today's post. Using Optimization Hints to...

(Read more)

Ember Crooks

Installing a Local Copy of the IBM DB2 10.5 Documentation

I have written about this before for version 9.7. The IBM DB2 Knowledge Center can be a bit unreliable – sometimes the search doesn’t return the obvious results. Sometimes it’s down...

...
 

August 24, 2015


Brian Fairchild

Customizing the activity form on Infor CRM / SalesLogix

In InforCRM 8 the activity editor has been completely reworked to be entirely Javascript based. Although this brought a little bit of pain as none of the previous customizations carried... READ...

...

Henrik Loeser

Keeping track of "my" DB2

Some years back when talking about DB2, there was only the "I am on the host" or "We are mostly OLTP" distinction. My standard phrase has been "I am a distributed guy". Well, today, when only talking...

(Read more)
 

August 23, 2015


Brian Fairchild

AngularJS i18n example

Sometimes we need a mobile app  to be internationalized when we use AngularJS. AngularJS supports i18n/l10n for date, number and currency filters. If we want to change something as simple as... READ...

...
 

August 22, 2015


Brian Fairchild

New Group options available in Infor CRM/SalesLogix v8.1 CU03

Version 8.1 CU03b of Infor CRM / SalesLogix introduced some really handy group options. Columns setting Hide extended group list on record selection Stay In Detail View on Lookup Display... READ...

...
 

August 21, 2015


Kim May

Frank to Present on HTAP at Philadelphia System z Meeting

Frank will be presenting, “Hybrid Transaction Processing” at the new Philadelphia System z group meeting at Maggiano’s Little Italy, located at 205 Mall Boulevard, King of Prussia,...

(Read more)
 

August 18, 2015


Ember Crooks

db2haicu TSAMP Advanced Topics: Objects Created

I have written quite a few articles on TSA, but thus far, they’ve been strongly focused on the basic how-to. I think this is because so many of us start with the how of a technical topic. As my...

...
 

August 17, 2015


Willie Favero

The DB2 Diagnostics Guide and Reference for 11 & 10 are now available for real

(Posted Thursday, August 17, 2015) A few weeks ago I published a blog post about the latest version of the diagnostics guide being available through an APAR that had just closed. Even though I was told the APAR had closed, upon further checking I discovered that the APAR was still open.

(Read more)

Data and Technology

Optimizing Database Performance, part 4: File Placement and Page Sizing

Portions of this tip were excerpted from my book Database administration: The complete guide to DBA practices and procedures (2nd edition). The first , second , and third parts of this series are...

(Read more)

Willie Favero

IBM z brings home TWO 2015 Stevie Awards

(Posted Thursday, August 13, 2015) Congratulations are in order for IBM and IBM z Systems on being awarded TWO gold Stevie Awards in The 2015 International Business Awards competition.

(Read more)
 

August 15, 2015


ChannelDB2 Videos

DB2 Tips n Tricks Part 69 - How To Find Index Rebuild is Slowing Query Execution


Thumbnail

How To Find Index Rebuild is Slowing Query Execution Solution: Use MON_GET_AGENT Routine along with SYSIBMADM.MON_CURRENT_SQL Happy Learning & Sharing Coinci...
 

August 14, 2015


Henrik Loeser

Wired or weird Tweets? Doesn't matter to Bluemix, DB2, and Node-RED...

Robot with a personality? Someone to talk to, someone to take the meeting minutes. Well, I can offer that - at least partially. I took the Node-RED service on Bluemix for a test drive and created a...

(Read more)
 

August 13, 2015

 

August 12, 2015


Craig Mullins

Influencing the DB2 Optimizer: Part 5 - Changing DB2 Catalog Statistics

When the standard methods of influencing DB2’s access path selection -- as discussed in the first 4 parts of this series  (1, 2, 3, 4) -- do not produce satisfactory results, you can take matters into your own hands and resort to updating the statistics in the DB2 Catalog. But this should really be a last resort type of option because there are so many...

(Read more)

Subscribe by email

 

About

planetDB2 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.
 

Bloggers

decor