Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Can connect remote to docker db2 (getting SQL1639N error)

    Posted Fri December 18, 2020 06:11 PM

    Hello,

    I followed the steps at ibmcom/db2 - Docker Hub

    and got a db2 container running. I am able to connect and run db2 within the container, but I can't connect with a user/password either from within the container or outside.

    [db2inst1@8f797e9d9fdc ~]$ db2 connect to testdb user db2inst1
    Enter current password for db2inst1:
    SQL1639N The database server was unable to perform authentication because
    security-related database manager files on the server do not have the required
    operating system permissions. SQLSTATE=08001

    I tried the fix recommended at Database connection fails with authentication error SQL1639N (ibm.com)

    But, I am unable to change owner of the files from db2inst1 to root (tried with chown)

    Please help. Thank you.



    ------------------------------
    Richard Hsu
    ------------------------------

    #Db2


  • 2.  RE: Can connect remote to docker db2 (getting SQL1639N error)

    Posted Mon December 21, 2020 02:49 AM
    Hi Richard,
     
    Its permission issue, you have to change the ownership and access of 2 files (db2chpw & db2ckpw).
    Try below steps, hopefully it will resolve the issue
     
     cd /home/db2inst1/sqllib/security  chown root:root db2chpw  chown root:root db2ckpw  chmod u+s db2chpw  chmod u+s db2ckpw
     
    Masheed Ullah
    Database Administrator
    Phone: +92-304-6664916
     




    Original Message


  • 3.  RE: Can connect remote to docker db2 (getting SQL1639N error)

    Posted Mon December 21, 2020 05:16 AM

    Hi Richard,

     

    could you please post the command how you run your container ?

     

    Mit freundlichen Grüßen / Best regards

    Ferdinand Prahst

    Lead Consultant

    Operational Services

    ___________________________________________

    ITGAIN Consulting Gesellschaft für IT-Beratung mbH
    Essener Str. 1
    D-30173 Hannover
    Mobil:   +49 172 6270831

    Tel.:       +49 511 51513700
    Fax.:      +49 511 51513800

    Internet: www.itgain.de

     

    Geschäftsführer: Per Stricker, Norbert Wilkening, Sven Mares
    Handelsregister: Amtsgericht Hannover HRB 59246, Ust-IDNr. DE214508933

     

    ITGAIN – Kompetenz gewinnbringend einsetzen

     

     

     




    Original Message


Related Content