glinuz/db2_exporter

Prometheus IBM DB2 exporter

db2_exporter's Issues

Docker Implementation

I'm getting a error when run this through docker, take a look here to see the implementation.

I really think you will find the issue quickly. Thanks!

Compatible with ppc64le linux

Is this exporter is compatible with ppc64le linux. What are prerequisite for running on ppc64le linux.

AIX Support for DB2 Exporter

Is it possible to add prometheus db2 exporter support for the AIX?

Password encrypted used in db2_exporter

How we can put the password in encrypted format in db2_exporter is there any method helpful for db2_exporter?

Monitoring DB2 on Windows

Estimated,
We are trying to implement this monitoring on a Windows server where DB2 is installed, after preparing the environment this message appears when compiling the main.go

C:\Users\db2admin\Desktop\workspace\src\db2_exporter-master>go build main.go
main.go:14:2: no required module provides package github.com/BurntSushi/toml: working directory is not part of a module
main.go:15:2: no required module provides package github.com/ibmdb/go_ibm_db: working directory is not part of a module
main.go:16:2: no required module provides package github.com/prometheus/client_golang/prometheus: working directory is not part of a module
main.go:17:2: no required module provides package github.com/prometheus/common/log: working directory is not part of a module

That could be, in linux it works perfect for us.

Greetings.

Monitoring DB2 with 2 or more Databases

Hi man, my name is Axel Huachacona.
First of all, thank you very much for your work.

Now, if you will allow me, I need some help.

Right now I need to check the status of my DB2 server but inside I have at least 6 different schemas that I use. With just one schema it works perfect but, apparently, the exporter only allows monitoring a single schema (like the SAMPLE schema in your example) but I need to know if it is possible to monitor more than one at the same time without having to raise more than one instance of the exporter.

Is there any possible way to do this?

Thank you again for your work!

I'll leave my environment specifications:

• SO: Windows 10
• DB2: 10.5.3 for Windows x64
• GOlang: 1.10.8
• db2_exporter: master branch

Error building project

Hi,
i get this error doing project build

[root@azwetdb01 db2_exporter-2]# go build main.go
go: inconsistent vendoring in /opt/db2_exporter-2:
	github.com/beorn7/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
	github.com/golang/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
	github.com/matttproud/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
	github.com/prometheus/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
	github.com/prometheus/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
	github.com/prometheus/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
	github.com/prometheus/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
	golang.org/x/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
	github.com/BurntSushi/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt
	github.com/ibmdb/[email protected]: is explicitly required in go.mod, but not marked as explicit in vendor/modules.txt

	To ignore the vendor directory, use -mod=readonly or -mod=mod.
	To sync the vendor directory, run:
		go mod vendor
[root@azwetdb01 db2_exporter-2]#

DB2 installed on Windows

Hello,

This monitoring works for a DB2 installed but on Windows?

Regards.

Fatal error on ppc64le

Vendor/GitHub.com/ibmdb/go_ibm_db/api_unix.go:13:22: fatal error: sqlcli1.h: no such file or directory.

I am using go version go1.16.15 linux/ppc64le.

//#include <sqlcli1.h>

Compilation terminated

Could you help me resolve this issue.

这是什么情况呢

panic: SQLGetDiagRec failed: ret=-2

goroutine 1 [running]:
github.com/ibmdb/go_ibm_db.NewError(0x7efcaa, 0xe, 0x75be60, 0xce1100, 0xc000051eb8, 0x4dc686)
/home/db2inst1/go/src/github.com/ibmdb/go_ibm_db/error.go:58 +0x50a
github.com/ibmdb/go_ibm_db.initDriver(0x0, 0x0)
/home/db2inst1/go/src/github.com/ibmdb/go_ibm_db/driver.go:29 +0x22e
github.com/ibmdb/go_ibm_db.init.0()
/home/db2inst1/go/src/github.com/ibmdb/go_ibm_db/driver.go:53 +0x22

Darwin Version

Hi @glinuz! Can you generate a Darwin version? Thanks!

Error: panic: SQLGetDiagRec failed: ret=-2

Hello,

I am trying to run this monitoring as per the suggested steps, but when I run this command:
./main -log.level debug -dsn "DATABASE=Users;HOSTNAME=localhost;PORT=50000;PROTOCOL=TCPIP;UID=db2inst1;PWD=Test012123; "
I get this error:
panic: SQLGetDiagRec failed: ret = -2

goroutine 1 [running]:
github.com/ibmdb/go_ibm_db.NewError(0x7efc3c, 0xe, 0x75be00, 0xce1100, 0xc000048eb8, 0x4dc5e6)
/usr/local/go/src/github.com/ibmdb/go_ibm_db/error.go:58 + 0x50a
github.com/ibmdb/go_ibm_db.initDriver(0x0, 0x0)
/usr/local/go/src/github.com/ibmdb/go_ibm_db/driver.go:29 + 0x22e
github.com/ibmdb/go_ibm_db.init.0 ()
/usr/local/go/src/github.com/ibmdb/go_ibm_db/driver.go:53 + 0x22

Please could you help me.

I am running a Java client to test the connection and it works perfect with these parameters:
String DB2Driver = "com.ibm.db2.jcc.DB2Driver";
String DB2ConnectionURL_users = "jdbc:db2://localhost:50000/Usuarios";
String DB2UserName = "db2inst1";
String DB2Password = "Test012123";

Thank you.