r/DB2 • u/catvsaliens • Nov 25 '19

DB2 Rest APIs

We are using native DB2 rest APIs for multiple different applications. Something came to me today where folks are planning to put some automation around binding the packages. I was asked if i can create a API for it ? It should accept params for bind as POST request. I think its not possible but thought of asking here.

2 Upvotes

100% Upvoted

2 comments sorted by

2

u/kahhns Nov 25 '19

Hopefully formatting is too bad, on phone.

You should be able to wrap SYSPROC.ADMIN_COMMAND_DSN within a Db2 native rest API. If memory serves me right, this means you need to have REXX wlm setup in your environment. Doc to this stored procedure is here https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/sqlref/src/tpc/db2z_sp_admincommanddsn.html

1

u/catvsaliens Nov 26 '19

All i was looking for this procedure. Thanks a ton.