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


the DB2 family of Linux*, UNIX*
and Windows*. DB2 now fully
supports and allows a table
to be used as input, multiple
MATCHED clauses, additional
predicates with [NOT]MATCHED,
the DELETE operation, and
IGNORE and SIGNAL.
SQL pagination dealing
with complex OR statements
was first introduced in DB2
V10. SQL pagination now
allows for numeric-based and
data-dependent pagination. An
example of the numeric-based
pagination is:

absolute page number, used in prior releases of
DB2 for PBR data sets. RPN data sets remove the
dependency between the number of partitions
and partition size. Part number is stored in the
partition header page, while page number is stored
in the data page, relative to start of the partition.

With RPN, DSSIZE maximum of
256 GB per data set (partition)
increases to 1 TB. Maximum
table size increases from 128 TB
for a 32K object to 4 PB. Maximum number of rows for 4K

SELECT * FROM tab OFFSET
10 ROWS FETCH FIRST 10 ROWS
ONLY

An example of data-dependent
pagination is:

(E)JES Web: Raising the Bar
and Your Bottom Line

WHERE (LASTNAME = 'SMITH'
AND FIRSTNAME >= 'JOHN') OR
(LASTNAME > 'SMITH')

Wednesday, April 5 | 10 PT / Noon CT / 1 ET

With the new equivalent
syntax:
WHERE (LASTNAME,
FIRSTNAME) > (SMITH, JOHN)

DELETE statements, such as
DELETE FROM T1 WHERE C1 > 7,
could delete millions of rows,
affecting locking and logging.
Piecewise data modification
allows for deletion of fewer rows
as shown where a maximum of
5,000 rows are deleted:
DELETE FROM T1 WHERE C1
> 7 FETCH FIRST 5000 ROWS
ONLY;
COMMIT;

At times, DB2 clients are
frustrated by the partition by
range (PBR) data set maximum
size and other limitations. PBR
relative page number (RPN) is
a new type of table space that
lifts the limitations. The new
RPN is mutually exclusive with

Easy Enough for New Users;
Fast Enough for Experts

FEATURING:

In this complimentary webinar, you will:
0Á'(Á##Á$*'&*1'+Á$(ÁÂÃ Á"'$ÄÁ#Á$&$+''&Á1#('&(#%'Á1#($ÁÂÃ ÄÁ#Á'-'('"Á"###)'"'#(Á ($$!Á ($&Á "$#1($&1#)ÄÁ "###)1#)Á ##&Á
%$#(&$!!1#)Á-$)&Á.Ç Á !',Æ
0Á'#&#Á0$+ÁÂÃ Á"'$Á)'''Á(&1'&Å##&Å(&)'Á
+'$Á&'*'!$%"'#(Á%&#%(1%''Á($Á%&$*1&'Á##Á
1#()1(1*'ÄÁ)#%$"%!1%#('&Á1#('&(#%'Æ

Ed Jaffe
Chief Technology Officer
Phoenix Software
International

0Á ''Á#Á&'"$Á$(ÁÂÃ Á"'$Á('#()&''Á')%0Á
#'Á  Å!1 'Á ÉÄÁ #&*##%'&Á /!('&1#)ÄÁ ##&Á
(',(Á$&ÁÉÁ&$+#!$#&'Æ

')1'('&Á!$&#-ÈÁ+'$%#'('Æ%$"Ç1$"'-'('"'"#)
sponsored advertising content

ibmsystemsmag.com MARCH/APRIL 2017 // 51

pg 50-53.indd 3

2/7/17 2:12 PM


https://event.webcasts.com/starthere.jsp?ei=1136785 http://webcasts.com/ibmsystemsmag 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