IBM Systems Magazine, Mainframe - March/April 2017 - 13


settle a claim or prove compliance, its integrity is important.
Procedures designed to prevent this scenario from happening exist, but traditional LOB
data management practices are
difficult, disruptive, expensive
and seldom used. As a result,
employees and customers may
find problems accessing the data
before the IT staff is aware. LOB
issues don't occur frequently,
but when they're discovered, it's
often too late to recover the data.
Because LOBs aren't regularly accessed and traditional
management best practices are
difficult to implement, some
organizations are left wondering
if it's necessary to spend time
performing regular maintenance
on them. Yes, it absolutely is.

Maintenance Matters
To understand why a new
strategy is required, we must
look at the structure of LOBs.
LOBs are stored and maintained
differently from traditional
relational data.
This means that the traditional DB2 database maintenance practices running daily in
your environment aren't ensuring the integrity of your LOB
data like they do for your normal
row and column tabular data.
Some database professionals
incorrectly assume that a standard DB2 reorganization of their
LOBs will detect these integrity
issues, but this isn't the case.
LOBs require more attention,
including extra steps to check
structure and data integrity by
running three utilities:
1. Check index
2. Check data
3. Check LOB
These must be run frequently
enough to capture any problems
while a valid image copy is

available. Once they are done,
run regular reorganizations.
These processes have their own
challenges of resource consumption and application availability.

organization cope? LOBs
require frequent integrity
checks. However, the standard integrity checking tools
require extensive resources
and time, which can impact
the availability of the data
to the applications. Organizations must turn to modern
tools or determine what
additional people and compute resources are needed
to manage the ever-growing
data volumes.

Understanding and
Mitigating the Risk

|
Only

26%
of survey
respondents
knew how many
LOBs they had,
and over

80%
weren't regularly
checking the
integrity of them

Organizations need better
visibility into LOBs. Based on
a survey, only 26 percent of
respondents said they know
how many LOBs they have
and over 80 percent said they
weren't regularly checking the
integrity of them.1
For unstructured data use to
be successful, organizations
need an effective strategy to
manage LOBs-whether this
involves using existing tools or a
modern solution that can manage structured and unstructured
data automatically and intelligently. Developing a strategy is
important for three key reasons:
1. Corrupted LOB data can be
lost forever if not properly
maintained. Organizations
must be able to validate data
integrity at all times. In a
recent survey1, more than
50 percent of DBAs interviewed said they couldn't
confidently prove their data
was intact.
2. Traditional data management methods don't apply to
LOBs. LOB integrity must be
regularly managed to avoid
loss that can be disruptive
or even catastrophic to a
business. It doesn't matter
how infrequently LOB data is
accessed, it must be maintained regularly.
3. The manual maintenance
procedures for LOBs will
introduce a significant
increase in workload and
complexity. How will your

Strategy
Considerations
Companies must make the
regular management and validation of LOB data a priority.
Modern tools can ensure that
indexes, data and LOBs are constantly and frequently validated
as part of a daily automated
maintenance process with no
additional work required.
But first, creating a strategy is
imperative. Begin by performing
a data management assessment
that includes your current state
and long-term objectives.
Typical questions to explore
include:
ĀÃ
ĀÃ
ĀÃ
ĀÃ

'RÃ\RXÃKDYHÃ/2%V"Ã
+RZÃPDQ\"Ã
:KDWÃLVÃVWRUHGÃWKHUH"Ã
+RZÃFULWLFDOÃLVÃWKLVÃGDWDÃWRÃ
your business?
ĀÃ +RZÃRIWHQÃDUHÃ\RXUÃ/2%VÃ
validated and reorganized?
ĀÃ +RZÃPXFKÃWLPHÃGRHVÃLWÃWDNHÃ
to complete all of the manual LOB housekeeping?
Unstructured data will only grow,
and you must be prepared. Now
is the time to develop your LOB
strategy and ensure you have the
tools and processes to manage
them. Don't let unmanaged LOBs
disrupt your business.

1. IDUG EMEA LOBs Survey Report, BMC

ibmsystemsmag.com MARCH/APRIL 2017 // 13

pg 12-13.indd 3

2/7/17 1:07 PM


http://www.ibmsystemsmag.com

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe - March/April 2017

Table of Contents
Editor's Desk: Ahead of the Times
Techbits: Cognitive Customer Engagement
Partner PoV: Keep Data Out of Danger: Use the right tools to implement your large-object strategy
Currents: A Layered Approach: Using microservices on z Systems with CICS improves flexibility and reliability
IT Today: Choosing the Right Cloud: What to consider when using a managed service provider
R&D: Move Along: IBM Research and partners help traffic run smoothly in Madrid
Trends: How to Improve Your Sales Skills: Tips for techies on showing the value of their services
Feature: Strength in Collaboration: Linux on z Systems accelerates new and traditional workloads
Feature: Community Computing: The Open Mainframe Project expands educational opportunities for Linux on z Systems users
TECH Showcase: Shift-Left Testing Improves Success: Automated testing in the DevOps cycle improves quality and reduces risk
Tech Corner: Database Development: IBM DB2 V12 enhances and integrates data for cloud, mobile and analytics
Solutions: SMART TS XL V8.0, IN-COM Data Systems; Tubes, Macro 4; CleverView for TCP/IP on Linux V2.5, AES
Stop Run: A Global View: Computer science and astrophysics prove a natural fit
Reference Point - Global Events, Education, Resources for Mainframe
2017 Mainframe Solutions Edition
IBM Systems Magazine, Mainframe - March/April 2017 - Intro
IBM Systems Magazine, Mainframe - March/April 2017 - Cover1
IBM Systems Magazine, Mainframe - March/April 2017 - Cover2
IBM Systems Magazine, Mainframe - March/April 2017 - 1
IBM Systems Magazine, Mainframe - March/April 2017 - Table of Contents
IBM Systems Magazine, Mainframe - March/April 2017 - 3
IBM Systems Magazine, Mainframe - March/April 2017 - 4
IBM Systems Magazine, Mainframe - March/April 2017 - 5
IBM Systems Magazine, Mainframe - March/April 2017 - Editor's Desk: Ahead of the Times
IBM Systems Magazine, Mainframe - March/April 2017 - 7
IBM Systems Magazine, Mainframe - March/April 2017 - Techbits: Cognitive Customer Engagement
IBM Systems Magazine, Mainframe - March/April 2017 - 9
IBM Systems Magazine, Mainframe - March/April 2017 - 10
IBM Systems Magazine, Mainframe - March/April 2017 - 11
IBM Systems Magazine, Mainframe - March/April 2017 - Partner PoV: Keep Data Out of Danger: Use the right tools to implement your large-object strategy
IBM Systems Magazine, Mainframe - March/April 2017 - 13
IBM Systems Magazine, Mainframe - March/April 2017 - Currents: A Layered Approach: Using microservices on z Systems with CICS improves flexibility and reliability
IBM Systems Magazine, Mainframe - March/April 2017 - 15
IBM Systems Magazine, Mainframe - March/April 2017 - 16
IBM Systems Magazine, Mainframe - March/April 2017 - 17
IBM Systems Magazine, Mainframe - March/April 2017 - IT Today: Choosing the Right Cloud: What to consider when using a managed service provider
IBM Systems Magazine, Mainframe - March/April 2017 - 19
IBM Systems Magazine, Mainframe - March/April 2017 - 20
IBM Systems Magazine, Mainframe - March/April 2017 - 21
IBM Systems Magazine, Mainframe - March/April 2017 - R&D: Move Along: IBM Research and partners help traffic run smoothly in Madrid
IBM Systems Magazine, Mainframe - March/April 2017 - 23
IBM Systems Magazine, Mainframe - March/April 2017 - Trends: How to Improve Your Sales Skills: Tips for techies on showing the value of their services
IBM Systems Magazine, Mainframe - March/April 2017 - 25
IBM Systems Magazine, Mainframe - March/April 2017 - 26
IBM Systems Magazine, Mainframe - March/April 2017 - 27
IBM Systems Magazine, Mainframe - March/April 2017 - Feature: Strength in Collaboration: Linux on z Systems accelerates new and traditional workloads
IBM Systems Magazine, Mainframe - March/April 2017 - 29
IBM Systems Magazine, Mainframe - March/April 2017 - 30
IBM Systems Magazine, Mainframe - March/April 2017 - 31
IBM Systems Magazine, Mainframe - March/April 2017 - 32
IBM Systems Magazine, Mainframe - March/April 2017 - 33
IBM Systems Magazine, Mainframe - March/April 2017 - Feature: Community Computing: The Open Mainframe Project expands educational opportunities for Linux on z Systems users
IBM Systems Magazine, Mainframe - March/April 2017 - 35
IBM Systems Magazine, Mainframe - March/April 2017 - 36
IBM Systems Magazine, Mainframe - March/April 2017 - 37
IBM Systems Magazine, Mainframe - March/April 2017 - 38
IBM Systems Magazine, Mainframe - March/April 2017 - 39
IBM Systems Magazine, Mainframe - March/April 2017 - 40
IBM Systems Magazine, Mainframe - March/April 2017 - 41
IBM Systems Magazine, Mainframe - March/April 2017 - 42
IBM Systems Magazine, Mainframe - March/April 2017 - 43
IBM Systems Magazine, Mainframe - March/April 2017 - 44
IBM Systems Magazine, Mainframe - March/April 2017 - TECH Showcase: Shift-Left Testing Improves Success: Automated testing in the DevOps cycle improves quality and reduces risk
IBM Systems Magazine, Mainframe - March/April 2017 - 46
IBM Systems Magazine, Mainframe - March/April 2017 - 47
IBM Systems Magazine, Mainframe - March/April 2017 - 48
IBM Systems Magazine, Mainframe - March/April 2017 - 49
IBM Systems Magazine, Mainframe - March/April 2017 - Tech Corner: Database Development: IBM DB2 V12 enhances and integrates data for cloud, mobile and analytics
IBM Systems Magazine, Mainframe - March/April 2017 - 51
IBM Systems Magazine, Mainframe - March/April 2017 - 52
IBM Systems Magazine, Mainframe - March/April 2017 - 53
IBM Systems Magazine, Mainframe - March/April 2017 - 54
IBM Systems Magazine, Mainframe - March/April 2017 - Solutions: SMART TS XL V8.0, IN-COM Data Systems; Tubes, Macro 4; CleverView for TCP/IP on Linux V2.5, AES
IBM Systems Magazine, Mainframe - March/April 2017 - Stop Run: A Global View: Computer science and astrophysics prove a natural fit
IBM Systems Magazine, Mainframe - March/April 2017 - Cover3
IBM Systems Magazine, Mainframe - March/April 2017 - Cover4
IBM Systems Magazine, Mainframe - March/April 2017 - Reference Point - Global Events, Education, Resources for Mainframe
IBM Systems Magazine, Mainframe - March/April 2017 - 2017 Mainframe Solutions Edition
IBM Systems Magazine, Mainframe - March/April 2017 - SE2
IBM Systems Magazine, Mainframe - March/April 2017 - SE3
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20191112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/relevantz_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2019mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20190102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20181112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20180102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/2018mfse
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20171112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_sesupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20170102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_linuxsupp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20161112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/MainframeSecurity
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20160102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20151112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910_se
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150910
http://www.ibmsystemsmagmainframedigital.com/MFSkills
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506_supp
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20150102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20141112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_gt_201405
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/BigData
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20140102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20131112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910_v2
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20130102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20121112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/buyersguide2013
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20120102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/ibmsystems_mainframe_2012bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20111112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20110102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20101112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100910_bg
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100506
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100304
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20100102
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20091112
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090910
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090708
http://www.ibmsystemsmagmainframedigital.com/nxtbooks/ibmsystemsmag/mainframe_20090506
http://www.nxtbook.com/nxtbooks/ibmsystemsmag/mainframe_20090304
http://www.nxtbook.com/nxtbooks/mspcomm/ibmsystems_mainframe_200901
http://www.nxtbookMEDIA.com