Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  bind authority

    Posted 02/18/21 12:33 PM
    I adopted the ibm db2 cloud lite plan to learn how to use
    a db2 resource was generated-credentials defined-I can create tables (in my schema) and insert/select data
    I have a windows db2 11.5 client and try to connect to this db
    catalog tcpip node : ok
    catalog db : ok
    connect to db user ..   using ..; ok
    select * from table
    msg:
    C:\Program Files\IBM\SQLLIB\BIN>db2 select * from genea
    SQL0805N Package "NULLID.SQLC2O29 0X4141414141454A69" was not found.
    tried todo the bind of db2cli.lst : ok
    but for db2ubind.lst
    SQL0551N The statement failed because the authorization ID
    does not have the required authorization or privilege to
    perform the operation. Authorization ID: "ZDK14848".
    Operation: "BIND". Object: "NULLID.SQLUFO17". SQLSTATE=42501

    is there a way to bind this file or how to connect from command line ?

    ------------------------------
    Thank for all update/help
    Best Regards, Guy Przytula
    ------------------------------

    #Db2


  • 2.  RE: bind authority

    Posted 02/18/21 12:39 PM
    ok found a doc explaining this
    https://www.ibm.com/support/pages/sql0551-returned-when-attempting-bind-client-files-db2-cloud
    and yes, my hostname has sbox : so this is a limitation of this offering

    ------------------------------
    Thank for all update/help
    Best Regards, Guy Przytula
    ------------------------------