Hello, everyone!
I'm happy to share some of mine DB2 groundwork.
It's based on odbc, so you will need an IBM driver.
Here's a link to it. Get a "IBM Data Server Runtime Client". For my RedHat6 testing server i used "Linux AMD64 and Intel EM64T" version. And yes, its heavy.
DB2 has quite unordinary setup compare to Sybase or Oracle - This guide helped me a lot.
I made a python script to tablespace discovery.
To make it work you need to be sure that db2cli.ini contains "username" and "password" fields.
To allow 'zabbix' user to use db2instance try:
- find SYSADM_GROUP, its must have something like db2inst group in it. Put 'zabbix' in this group, or just update cfg using:
If you get a SQLAllocHandle error - you need to set up an DB2INSTANCE variable:
To add remote servers to catalog use this:
and
Hope someone find this helpful.
GL w DB2.
I'm happy to share some of mine DB2 groundwork.
It's based on odbc, so you will need an IBM driver.
Here's a link to it. Get a "IBM Data Server Runtime Client". For my RedHat6 testing server i used "Linux AMD64 and Intel EM64T" version. And yes, its heavy.
DB2 has quite unordinary setup compare to Sybase or Oracle - This guide helped me a lot.
I made a python script to tablespace discovery.
To make it work you need to be sure that db2cli.ini contains "username" and "password" fields.
To allow 'zabbix' user to use db2instance try:
Code:
db2 get dbm cfg
Code:
db2 update dbm cfg using SYSADM_GROUP <group>
Code:
export DB2INSTANCE=db2inst
Code:
catalog tcpip node HOSTALIAS remote 10.10.10.10 server 50000
Code:
catalog database HOSTALIAS as HOSTALIAS at node HOSTALIAS
GL w DB2.