title: How to upload pandas dataframe to IBM Db2 database
body: <p>I am trying to upload pandas dataframe to IBM db2 dataframe. However, I could not manage to find the method to load the complete dataset at once. </p>
  
  <pre><code>import ibm_db
  dsn_driver = "IBM DB2 ODBC DRIVER"
  dsn_database = "BLUDB"
  dsn_hostname= "dashdb-txn-xxxxx.eu-gb.bluemix.net"
  dsn_port="5xx00"
  dsn_protocol="TCPIP"
  dsn_uid="xxxxx"
  dsn_pwd="xxxx"
  
  dsn = (
      "DRIVER={{IBM DB2 ODBC DRIVER}};"
      "DATABASE={0};"
      "HOSTNAME={1};"
      "PORT={2};"
      "PROTOCOL=TCPIP;"
      "UID={3};"
      "PWD={4};").format(dsn_database, dsn_hostname, dsn_port, dsn_uid, dsn_pwd)
  
  try:
      conn = ibm_db.connect(dsn, "", "")
      print('Connected')
  except:
      print('Unable to connect to database', dsn)
  
  d = {'col1': [1, 2,3,4,5,6,7,8,9,10], 'col2': [3, 4,3,4,5,6,7,8,2,34], 'col3': [1, 2,3,14,5,36,72,8,9,10],}
  import pandas as pd
  df = pd.DataFrame(data=d)
  df
  </code></pre>
  
  <p>So far, I manage to conect successfully to the ibmdb2 database, the rest steps of uploading the pandas dataframe is not clear to me, I tried several options from google, none seem to be working. </p>
  
  <p>To make problem easy, I created a sample pandas dataframe (df, above). Any help page or documentation is appreciated.</p>
  
  <p>thank you
  pooja</p>