title: Pandas connect to DB2 server with SSL
body: <p>So before my server started to use/enforce SSL I was able to connect by doing</p>
  
  <pre><code>from sqlalchemy import create_engine
  import ibm_db_sa
  import pandas as pd
  import numpy as np
  
  eng = 'ibm_db_sa://{user}:{psw}@{host}:{port}/{db}'.format(
      user = user,
      psw=psw,
      host=host,
      port=port,
      db=db
  )
  engine = create_engine(eng)
  sql = '''select * from table fetch first 10 rows only'''
  df = pd.read_sql(sql, con=engine)
  </code></pre>
  
  <p>So I can connect to the DB with SSL just fine using data studio and a .jks file, but can't connect anymore using Python. I tried editing the connection string to either</p>
  
  <pre><code>ibm_db_sa://{user}:{password}@{host}:{port}/{db};SECURITY=SSL;SSLServerCertificate={arm};
  </code></pre>
  
  <p>or</p>
  
  <pre><code>ibm_db_sa://{user}:{password}@{host}:{port}/{db};SECURITY=SSL;SSLCLIENTKEYSTOREDB={kdb};SSLCLIENTKEYSTASH={sth}; 
  </code></pre>
  
  <p>where arm, kdb and sth are paths on my local system where I have the corresponding files. ex "C:/Users/wizuriel/Documents/Trusted Sources/[file].kdb" (have tried surrounding the path in single quotes and with no quotes and no issue)</p>
  
  <p>the error I get is</p>
  
  <blockquote>
    <p>(ibm_db_dbi.ProgrammingError) ibm_db_dbi::ProgrammingError: [IBM][CLI
    Driver] SQL1109N  The specified DLL "GSKit Error: 202" could not be
    loaded.  SQLSTATE=42724\r SQLCODE=-1109</p>
  </blockquote>
  
  <p>looking up that GSKit error 202 people say it might be an issue with the path variables. I've tried editing my environment variables to point to \Anaconda3\Lib\site-packages\clidriver\bin\icc64 where I see the GSK8 dlls and had no luck. So hoping someone might know what else I can try</p>
  
  <p><a href="https://i.stack.imgur.com/nLZDW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nLZDW.png" alt="enter image description here"></a></p>