IBM Systems Magazine, Mainframe - May/June 2018 - 32

TECH CORNER

collection identifier; the default
collection ID SYSIBMSERVICE is
the only one allowed.
Although HTTP verbs GET,
POST, PUT and DELETE are
allowed, native REST only
allows for POST, and, for some
system tasks, GET. When using
z/OS Connect Enterprise Edition,
POST verbs can be assigned to a
different type. Native REST POST
can be reassigned to DELETE, for
example, in z/OS Connect Enterprise Edition.
An example of creating
a service:

Figure 1: Example of Creating a Service

Figure 2: Invoking the Service

1. In Figure 1, right, a Firefox
REST client was used with
the POST method. The URL
contains the LPAR's address,
DB2M's subsystem TCP/IP
port (the examples in this article use Db2 subsystem DB2M
which uses TCP/IP port 1446),
followed by the application
name. With native REST,
headers are required specifying JSON format. The body
contains JSON name pair format: requestType is createService, sqlStmt is the actual SQL
statement, etc. The collection
ID in this case is the default
(i.e., SYSIBMSERVICE), but
can be a different ID when not
created using Data Studio.
2. After clicking the SEND button, the response comes back
as an HTTP status code. Status
codes in the 2xx range mean
successful execution. In this
case, 201 would be returned if
the create service was successful. HTTP status codes 4xx
(client error) and 5xx (server
error) relate errors. For example, 401 means unauthorized,
while 403 means forbidden.
3. Upon successful execution, a
row will be inserted into table-
SYSIBM.DSNSERVICE (created
in job DSNTIJRS), as well as
SYSIBM.SYSPACKAGE and
32 // MAY/JUNE 2018 ibmsystemsmag.com

SYSIBM.SYSPACKCOPY. Db2
command DISPLAY THREAD
will identify REST threads.
4. Once successfully created,
you can invoke the service
by using the POST method.
In Figure 2, above, the URL
contains the LPAR's address,
DB2M's subsystem TCP/IP
port, services, SYSIBMSERVICE as the collection ID and
the service name. Note that
the result set is in JSON name
paired format. All available
services can be displayed by
issuing a GET method.

using z/OS Connect Enterprise
Edition exist:

More Capabilities

*

z/OS Connect Enterprise Edition
can be used to further REST
capabilities. Many advantages of

*

*

*

It's an intuitive, workstationbased tool that enables a
developer to create REST APIs
from Db2 data using z/OS
Explorer
It can be used as a warehouse
for knowing which services
belong to which Db2 subsystems or members
All HTTP methods and verbs
are recognized, and the
native REST verb POST can be
reassigned to a different verb,
such as DELETE
No back-end application
changes are required and
because it's tools-driven, no
coding changes are required


http://www.ibmsystemsmag.com

Table of Contents for the Digital Edition of IBM Systems Magazine, Mainframe - May/June 2018

Table of Contents
Editor's Desk: Good things in small packages
Trends: IBM LinuxONE and Linux on Z offer a differentiated infrastructure and open standards for running a premium microservices cloud
Currents: RACF offers different options to ensure a secure IBM Z system
Partner POV: Linux on IBM Z postitions clients to move forward with modern technologies and workloads
Cover Story: Flexibility Counts: Why clients rely on Linux on IBM Z and LinuxONE to deliver business value
Feature: Fresh, Flexible and New: IBM z14 Model ZR1 boasts more capacity in a smaller foorprint
Tech Showcase: How DevOps helps organizations keep up with the quickening pace of competition
Tech Corner: Engage IBM Db2 V12 for mobile with z/OS Distributed Data Facility or z/OS Connect
Administrator: Single-frame IBM z14 Model ZR1 brings the benefits of IBM Z to organizations of all sizes
Solutions: CleverView for TCP/IP on Linux V2.9, VitalSigns for FTP V3.1
Stop Run: Growing up around computers and the IBM culture led Matthew Cousens to work with the mianframe
Reference Point - Global Events, Education, Resources for Power Systems
2018 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - May/June 2018 - Intro
IBM Systems Magazine, Mainframe - May/June 2018 - Cover1
IBM Systems Magazine, Mainframe - May/June 2018 - Cover2
IBM Systems Magazine, Mainframe - May/June 2018 - 1
IBM Systems Magazine, Mainframe - May/June 2018 - Table of Contents
IBM Systems Magazine, Mainframe - May/June 2018 - 3
IBM Systems Magazine, Mainframe - May/June 2018 - Editor's Desk: Good things in small packages
IBM Systems Magazine, Mainframe - May/June 2018 - 5
IBM Systems Magazine, Mainframe - May/June 2018 - Trends: IBM LinuxONE and Linux on Z offer a differentiated infrastructure and open standards for running a premium microservices cloud
IBM Systems Magazine, Mainframe - May/June 2018 - 7
IBM Systems Magazine, Mainframe - May/June 2018 - 8
IBM Systems Magazine, Mainframe - May/June 2018 - 9
IBM Systems Magazine, Mainframe - May/June 2018 - Currents: RACF offers different options to ensure a secure IBM Z system
IBM Systems Magazine, Mainframe - May/June 2018 - 11
IBM Systems Magazine, Mainframe - May/June 2018 - 12
IBM Systems Magazine, Mainframe - May/June 2018 - 13
IBM Systems Magazine, Mainframe - May/June 2018 - Partner POV: Linux on IBM Z postitions clients to move forward with modern technologies and workloads
IBM Systems Magazine, Mainframe - May/June 2018 - 15
IBM Systems Magazine, Mainframe - May/June 2018 - Cover Story: Flexibility Counts: Why clients rely on Linux on IBM Z and LinuxONE to deliver business value
IBM Systems Magazine, Mainframe - May/June 2018 - 17
IBM Systems Magazine, Mainframe - May/June 2018 - 18
IBM Systems Magazine, Mainframe - May/June 2018 - 19
IBM Systems Magazine, Mainframe - May/June 2018 - Feature: Fresh, Flexible and New: IBM z14 Model ZR1 boasts more capacity in a smaller foorprint
IBM Systems Magazine, Mainframe - May/June 2018 - 21
IBM Systems Magazine, Mainframe - May/June 2018 - 22
IBM Systems Magazine, Mainframe - May/June 2018 - 23
IBM Systems Magazine, Mainframe - May/June 2018 - 24
IBM Systems Magazine, Mainframe - May/June 2018 - Tech Showcase: How DevOps helps organizations keep up with the quickening pace of competition
IBM Systems Magazine, Mainframe - May/June 2018 - 26
IBM Systems Magazine, Mainframe - May/June 2018 - 27
IBM Systems Magazine, Mainframe - May/June 2018 - 28
IBM Systems Magazine, Mainframe - May/June 2018 - 29
IBM Systems Magazine, Mainframe - May/June 2018 - Tech Corner: Engage IBM Db2 V12 for mobile with z/OS Distributed Data Facility or z/OS Connect
IBM Systems Magazine, Mainframe - May/June 2018 - 31
IBM Systems Magazine, Mainframe - May/June 2018 - 32
IBM Systems Magazine, Mainframe - May/June 2018 - 33
IBM Systems Magazine, Mainframe - May/June 2018 - 34
IBM Systems Magazine, Mainframe - May/June 2018 - Administrator: Single-frame IBM z14 Model ZR1 brings the benefits of IBM Z to organizations of all sizes
IBM Systems Magazine, Mainframe - May/June 2018 - 36
IBM Systems Magazine, Mainframe - May/June 2018 - 37
IBM Systems Magazine, Mainframe - May/June 2018 - 38
IBM Systems Magazine, Mainframe - May/June 2018 - Solutions: CleverView for TCP/IP on Linux V2.9, VitalSigns for FTP V3.1
IBM Systems Magazine, Mainframe - May/June 2018 - Stop Run: Growing up around computers and the IBM culture led Matthew Cousens to work with the mianframe
IBM Systems Magazine, Mainframe - May/June 2018 - Cover3
IBM Systems Magazine, Mainframe - May/June 2018 - Cover4
IBM Systems Magazine, Mainframe - May/June 2018 - Reference Point - Global Events, Education, Resources for Power Systems
IBM Systems Magazine, Mainframe - May/June 2018 - 2018 Mainframe Solutions Edition Product Index
IBM Systems Magazine, Mainframe - May/June 2018 - SE2
IBM Systems Magazine, Mainframe - May/June 2018 - SE3
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