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.

 

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)
 

August 11, 2015


Willie Favero

August 2015 (RSU1507) service package has been tested and is now available

(Posted Tuesday, August 11, 2015) Testing for RSU service package RSU1507 is now complete. This August 4, 2015 2nd Quarter "2nd quarter Quarterly Report, 1st Addendum" (64 KB PDF file) is based on RSU1503 recommendations and contains ALL service through the end of March 2015 not already marked...

(Read more)

Ember Crooks

PowerShell for DB2 DBAs – Part 1

Any DBAs faced with having to administer and maintain a large number of instances and databases will quickly find themselves swamped with work unless they learn to script most of their workload.  Of...

...
 

August 10, 2015


Willie Favero

Open Source development and DB2 Connect

(Posted Monday, August 10, 2015) The DB2 Connect development organization would like to better understand the need to support a broader spectrum of current development languages.

(Read more)

Data and Technology

Optimizing Database Performance, part 3: Free Space and Compression

This tip is excerpted from my book Database administration: The complete guide to DBA practices and procedures. The first and second parts of this series are also available. Today we start by...

(Read more)
 

August 09, 2015


ChannelDB2 Videos

DB2 Tips n Tricks Part 68 - How To Disable Health Monitor or db2acd process completely


Thumbnail

How To Disable Health Monitor or db2acd process completely Solution: Use db2set DB2_FMP_COMM_HEAPSZ=0 Happy Learning & Sharing
 

August 08, 2015


Willie Favero

z/OS Version 2 Release 2 has recently been announced

(Posted Saturday, August 8, 2015) I know, I?m a little late to the party on this one. I was hoping to publish this post last Tuesday morning (7/28). However, as things sometimes go, I got sidetracked and didn?t make it. Sorry about that. I hope to make up for that slight slipup. Here is the...

(Read more)
 

August 06, 2015


Brian Fairchild

Introduction to Using the PowerShell Command Line for DB2 on Windows

A lot of DB2 LUW DBAs spend significantly more time working with DB2 on Linux and UNIX than they do working with DB2 on Microsoft Windows. This can lead to... READ MORE The post Introduction to...

...
 

August 05, 2015


Data and Technology

New API Security Survey Highlights Mobile Security Concerns

A new survey on API security titled Global State of API Security Survey 2015, conducted by API management vendor Akana, was released today. This is the first survey conducted by Akana on API...

(Read more)

Brian Fairchild

VirtualBox Networks: DHCP vs Static IP

On my third day at XTIVIA, it was recommended I tinker with Oracle’s free VirtualBox. The following week, I was hooked! A Unix guy at heart, I can launch whichever flavor... READ MORE The...

...
 

August 04, 2015


Ember Crooks

Multiple Instances in DB2 for Linux/UNIX and in DB2 for Windows

I have been working with multiple instances on Windows servers lately, and have learned a few things about them, so I thought an article about multiple instances in general would be a good thing. The...

...

Triton Consulting

Reduce MIPS to Manage Budget Pressures

Worldwide economic uncertainty in recent years has put significant pressure on CIOs to at least keep IT costs level and more likely push for cost reduction across the board.  Gone are the days when performance issues were relatively easily handled … Continue reading →

(Read more)
 

August 03, 2015


Data and Technology

Optimizing Database Performance, part 2: Denormalization and Clustering

In Part 1 of our series introducing database performance topics and considerations we tackled the issues of partitioning data and creating indexes. In Part 2, today, we will introduce the topic of...

(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