z/OS Connect Enterprise Edition

z/OS Connect

z/OS Connect

Truly RESTful APIs to and from your IBM Z mainframe

 View Only

  • 1.  DB2 Service Creating - IKJ56712I INVALID KEYWORD

    Posted Tue December 15, 2020 11:28 AM
    My DBA is trying to create a new DB2 service using the example from the Connect guide.  During the create we are getting an error that Service is an invalid keyword.  The command being passed is:

    BIND SERVICE(zCEEService) -
                NAME ("SelPTOPO") -
                SQLDDNAME (SQL) -
                SQLENCODING (1047) -
                OWNER (SYSADM)


    He is not sure why it would not recognize the SERVICE  subcommand.

    IKJ56712I INVALID KEYWORD, SERVICE(zCEEService)
    IKJ56712I INVALID KEYWORD, NAME ("SelPTOPO")
    IKJ56712I INVALID KEYWORD, ("SelPTOPO")
    IKJ56712I INVALID KEYWORD, SQLDDNAME 
    IKJ56712I INVALID KEYWORD, (SQL)
    IKJ56712I INVALID KEYWORD, SQLENCODING
    IKJ56712I INVALID KEYWORD, (1047)
    IKJ56712I INVALID KEYWORD, OWNER
    IKJ56712I INVALID KEYWORD, (SYSADM)

    He feels this is a problem with Connect/EE, but I would not know what it is.  Have you seen this before

    Any Help is greatly apprecaited.
    Garrett

    ------------------------------
    Garrett Shaw
    Sr System Programmer
    Ingram
    La Vergne TN
    404-964-2032
    ------------------------------


  • 2.  RE: DB2 Service Creating - IKJ56712I INVALID KEYWORD

    Posted Tue December 15, 2020 02:24 PM

    Garrett,
    At the stage of the bind, you are using features native to Db2 and has nothing to do with z/OS Connect EE. 
    I see that the quotes (") are missing around the service name.  I think you want BIND SERVICE("zCEEService") -
    Check out the Db2 Knowledge Center on details on Db2 Rest Services: https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/restserv/src/tpc/db2z_restservices.html



    ------------------------------
    Eric Higgins
    Field Technical Specialist - CICS Tools
    IBM
    Jamesville NY
    315-431-2620
    ------------------------------

    Original Message


  • 3.  RE: DB2 Service Creating - IKJ56712I INVALID KEYWORD

    Posted Tue December 15, 2020 02:59 PM
    Thanks Eric.  I think there were a few configuration jobs that he hasn't run that will build the SYSIBM.DSNSERVICE tables.

    ------------------------------
    Garrett Shaw
    Sr System Programmer
    Ingram
    La Vergne TN
    404-964-2032
    ------------------------------

    Original Message


Related Content