using RESTFUL API

william giannelli

using RESTFUL API

What do I need to setup in order to use a RESTFUL API?

thanks

Bill

Michael Arlebrandt

using RESTFUL API
(in response to william giannelli)
Short answer:

Just create a table, SYSIBM.DSNSERVICES, and then a Racf/acf2 SAF rule for db2x.REST

A sample job exists to create the table

mvh
Michael
Den 6 okt. 2017, kI 12:17, william giannelli <[login to unmask email]<mailto:[login to unmask email]>> skrev:

What do I need to setup in order to use a RESTFUL API?

thanks

Bill

-----End Original Message-----


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

william giannelli

RE: using RESTFUL API
(in response to Michael Arlebrandt)

I am not finding the sample job to create the table. Where would I find it?

thanks

Bill

william giannelli

RE: using RESTFUL API
(in response to william giannelli)

I found the job now, DSNTIJRS.

thanks!

Bill

william giannelli

RE: using RESTFUL API
(in response to Michael Arlebrandt)

for the RACF rule, can you give any more specifics I need to tell our RACF guys?

thanks

Bill 

Michael Arlebrandt

using RESTFUL API
(in response to william giannelli)
Don't know, I did it in ACF2, just copied on of those SAF rules such as db2.SASS, .DIST .BATCH.
And I'm still in Lisbon Airport so I can't ask our RACF guy

mvh
Michael
Den 6 okt. 2017, kI 13:31, william giannelli <[login to unmask email]<mailto:[login to unmask email]>> skrev:

for the RACF rule, can you give any more specifics I need to tell our RACF guys?

thanks

Bill

-----End Original Message-----


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

william giannelli

RE: using RESTFUL API
(in response to Michael Arlebrandt)

Hi so I have the initial setup done.

How can I run a simple test from my laptop to z/os DB2?

thanks

Bill

Philip Sevetson

using RESTFUL API
(in response to william giannelli)
**please note my email address change**
Bill,

I don’t use REST. However: some resources (Google Search: “restful api on db2 for z/os redbook” – the “redbook” part came up empty)

(IBM Knowledge Center) “DB2 REST services” - https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/restserv/src/tpc/db2z_restservices.html

(developerWorks Recipes) “Getting Started with RESTful Web Services Support in the Distributed Data Facility of DB2 for z/OS” - https://developer.ibm.com/recipes/tutorials/getting-started-with-restful-web-services-support-in-the-distributed-data-facility-of-db2-for-zos/

(developerWorks) “What is the best way to do REST with the mainframe?” - https://developer.ibm.com/mainframe/docs/what-makes-a-good-api/whats-best-practice-for-http-verbs-with-apis/what-is-the-best-way-to-do-rest-with-the-mainframe/

(idug.org, Dan Luksetich, 2016-10-28) "DB2 11 and 12 for z/OS Native REST Compatibility!" - http://www.idug.org/p/bl/et/blogid=477&blogaid=544



Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: william giannelli [mailto:[login to unmask email]
Sent: Friday, October 06, 2017 12:09 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: using RESTFUL API


Hi so I have the initial setup done.

How can I run a simple test from my laptop to z/os DB2?

thanks

Bill

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

David Baldon

using RESTFUL API
(in response to william giannelli)
If you’re a member of IDUG, check out the following sessions from the just concluded IDUG EMEA 2017;

* F7 – REST Easy With DB2 For z/OS – Services Made Simple
* E11 – Db2 for z/OS Mobile Application Using Db2 REST Service
* G12 – Db2 for z/OS Modern application: Watson, ML, REST, Spark and more
* F16 – DB2 RESTful Service Support and z/OS Connect – SQL/Stored Procedures Play a Role in Mobile and API Economy

...David

From: william giannelli [mailto:[login to unmask email]
Sent: Friday, October 6, 2017 6:05 AM
To: [login to unmask email]
Subject: [DB2-L] - using RESTFUL API


What do I need to setup in order to use a RESTFUL API?

thanks

Bill

-----End Original Message-----

Steen Rasmussen

using RESTFUL API
(in response to David Baldon)
You can only download the presentations if you attended IDUG – at least for a year if memory serves me well.

Steen Rasmussen

From: Baldon, David [mailto:[login to unmask email]
Sent: Monday, October 09, 2017 8:15 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: using RESTFUL API

If you’re a member of IDUG, check out the following sessions from the just concluded IDUG EMEA 2017;

* F7 – REST Easy With DB2 For z/OS – Services Made Simple
* E11 – Db2 for z/OS Mobile Application Using Db2 REST Service
* G12 – Db2 for z/OS Modern application: Watson, ML, REST, Spark and more
* F16 – DB2 RESTful Service Support and z/OS Connect – SQL/Stored Procedures Play a Role in Mobile and API Economy

...David

From: william giannelli [mailto:[login to unmask email]
Sent: Friday, October 6, 2017 6:05 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - using RESTFUL API


What do I need to setup in order to use a RESTFUL API?

thanks

Bill

-----End Original Message-----

-----End Original Message-----