# Loading IBM DB2 data using Logstash into Elasticsearch

**URL:** <https://discuss.elastic.co/t/loading-ibm-db2-data-using-logstash-into-elasticsearch/142003>\
**Category:** Logstash\
**Created:** [July 27, 2018, 10:35pm UTC](https://discuss.elastic.co/t/loading-ibm-db2-data-using-logstash-into-elasticsearch/142003 "2018-07-27T22:35:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![anon98066099](https://avatars.discourse-cdn.com/v4/letter/a/57b2e6/32.png) [@anon98066099](https://discuss.elastic.co/u/anon98066099)\
**Post date:** [July 27, 2018, 10:35pm UTC](https://discuss.elastic.co/t/loading-ibm-db2-data-using-logstash-into-elasticsearch/142003/1 "2018-07-27T22:35:54Z")

</div>

Hi,

I have 56 views to be loaded into elasticsearch. So i created a config file which has 56 jdbc blocks to load 56 views. Everytime it gets loaded but in Kibana i see only one table randomly.  
Below is my config file. Request you to help me out.

#file: db2.conf

input{  
jdbc{

# IBM DB2 jdbc connection string to database BIIPODST

jdbc\_connection\_string =\> "jdbc:db2://jade002:3936/BIIPODST"

# user

jdbc\_user =\> "IYE8288"

# Password

jdbc\_password =\> "#####"

# path to downloaded jdbc driver

jdbc\_driver\_library =\> "C:\Users\IYE8288\Downloads\logstash-6.3.1\logstash-6.3.1\Drivers\sqljdbc4.jar"

#name of driver class for DB2  
jdbc\_driver\_class =\> "com.ibm.db2.jcc.DB2Driver"

# Query

statement =\> "SELECT \* from BIIPODS.BIIPMETA\_CLT\_ADDRESS\_TYPE\_VW fetch first 50 rows only"  
}

#jdbc2  
jdbc{  
jdbc\_connection\_string =\> "jdbc:db2://jade002:3936/BIIPODST"  
jdbc\_user =\> "IYE8288"  
jdbc\_password =\> "#####"  
jdbc\_driver\_library =\> "C:\Users\IYE8288\Downloads\logstash-6.3.1\logstash-6.3.1\Drivers\sqljdbc4.jar"  
jdbc\_driver\_class =\> "com.ibm.db2.jcc.DB2Driver"  
statement =\> "SELECT \* from BIIPODS.BIIPMETA\_CLT\_ADDRESS\_VW fetch first 50 rows only"  
}

#jdbc3  
jdbc{  
jdbc\_connection\_string =\> "jdbc:db2://jade002:3936/BIIPODST"  
jdbc\_user =\> "IYE8288"  
jdbc\_password =\> "#####"  
jdbc\_driver\_library =\> "C:\Users\IYE8288\Downloads\logstash-6.3.1\logstash-6.3.1\Drivers\sqljdbc4.jar"  
jdbc\_driver\_class =\> "com.ibm.db2.jcc.DB2Driver"  
statement =\> "SELECT \* from BIIPODS.BIIPMETA\_CLT\_ASSOCIATED\_LE\_VW fetch first 50 rows only"  
}  
...........#up to 56 blocks#  
}

output {  
elasticsearch {

# protocol =\> http

index =\> "biipodst"  
document\_type =\> "BIIPMETA\_CLT\_PERSON\_VW"  
document\_id =\> "%{KEY\_COLUMN\_ID\_NUM}"  
hosts =\> "localhost"  
}

}

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [July 28, 2018, 3:00am UTC](https://discuss.elastic.co/t/loading-ibm-db2-data-using-logstash-into-elasticsearch/142003/2 "2018-07-28T03:00:03Z")

</div>

As you have another topic on this I am closing this one.  
[https://discuss.elastic.co/t/loading-ibm-db2-data-into-elasticsearch-from-logstash/141652](https://discuss.elastic.co/t/loading-ibm-db2-data-into-elasticsearch-from-logstash/141652)

As suggested in the previous topic, it helps greatly if you properly format things.

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [July 28, 2018, 3:00am UTC](https://discuss.elastic.co/t/loading-ibm-db2-data-using-logstash-into-elasticsearch/142003/3 "2018-07-28T03:00:06Z")

</div>