Zabbix 1.8.4 supported on AIX 6.1 and DB2 9.7 64bit?

[dkhans2]

Does anyone know if Zabbix 1.8.4 support AIX 6.1 64 bit, and IBM DB2 9.7 64 bit?

I have been trying to compile and configure Zabbix 1.8.4 source code the past weeks.

Here is the configure command with the options I issued:

./configure --enable-server --enable-agent -enable-static --with-ibm-db2=/home/zabdbint/sqllib --with-ibm2-include=/home/zabdbint/sqllib/samples/c --with-ibm-db2-lib=/home/zabdbint/sqllib/samples/c


Despite of specifying the header and libraries directory specifically, I still got the following error, "IBM DB2 library not found":

checking for -rdynamic linking option... no
checking for IBM DB2 CLI libraries... no
configure: error: IBM DB2 library not found

[richlv]

i'd suggest checking config.log for specific error message

[kpfitzgerald]

i seem to be getting the same issue.

i also specified the headers and looked at the config.log

my guess is there db2 backend wasnt tested fully and is having some issues.

I am on SLES 11sp1, db2WSE 9.7 fp3a.... thoughts? comments?

[richlv]

would be god to test with 1.8 branch svn head. if the issue is still there, reporting it on the bugtracker would be appreciated.

[kpfitzgerald]

FIXED - on SUSE 11SP1 DB2WSE 9.7SP3a

so i reinstalled, reread the info, checked a few other forums and found the problem...

if you read STEP 4 on the server install there is a portion under notes that says use the headers for the client API, well, most DBA's wont install the API's unless requested by a dev or informed by a install doc. That portion should really be under the pre-req's as that is where INSTALLATION configuration shoudl be... not a side note under the install of the zabbix app. IMHO.

now getting a libcurl library not found, and i know installed it, but alas may not be the "version" or library they are looking for. Ill hunt around.

[richlv]

That portion should really be under the pre-req's as that is where INSTALLATION configuration shoudl be... not a side note under the install of the zabbix app. IMHO.

is the information at http://www.zabbix.com/documentation/...e_requirements not sufficient/incorrect ? how could it be improved ?

[kpfitzgerald]

possible edit for install prereq

it says:

One of the following database engines:

IBM DB2 Headers and Libraries

should really include IBM DB2 Server, and Application Development Tools

It may also need client support, i did not test the process i just added all 3 and the install worked. I originally tried just the client support and that did not fix the issue, but the installation of the application dev tools did.

your documentation on the installation of the db2 db and running the scripts was spot on, i would have added a few more user freindly features and just a tad more info for a "less informed" or "less knowledgeable" DBA or acting DBA.

I know your not in the business of informing or configuring the DB2 installations, so this is a dual edged sword and i am far from a technical, legal or English compositional writer.

I may post a tutorial, walk through or cookbook on a DB2 express-c install since it is free (as in free beer) and the limitations on the use are less restrictive than MSSQL express (10GB limit on DB, 1 CPU and 1 GB RAM) or Oracle Express (4GB limit on DB, 1 CPU and 1GB RAM), since DB2 only limits the CPU to 2 cores, and 2GB of RAM. There is no size limitation or connection limits, and the admin tools are free, along with backup compression and some limited compress such as nulls and white spaces.

I would also like to see minimum versions of the db2 db engine, unless all versions and OS'es it can run on are supported or have been tested. its ok to say it should work but is untested, I would be ok with that.

[kpfitzgerald]

just another FYI

I had to connect to the OpenSuSe dev repository to get the libcurl and net-snmp dev packages...

this may raise some red flags with some admins, but, I am ok with doing it on a test system.

Ill try to find and post the src locations for the missing packages so you wont have to use a OSS repo. And can see the or inspect the source before compilation into your server.

Another thought is to include more concise documentation on the packages that need to be installed such as the DEV KIT or something along those lines... makes it easy for us general NIX users.

[richlv]

It may also need client support, i did not test the process i just added all 3 and the install worked.

hmm. it would be preferred to have more confidence on which packages specifically are needed

I may post a tutorial, walk through or cookbook on a DB2 express-c install since it is free (as in free beer)

that would be very nice - it might fit nicely on http://zabbix.org

I had to connect to the OpenSuSe dev repository to get the libcurl and net-snmp dev packages...

i'm quite sure sles has a repo with dev packages - but that's distribution specific and not related to db2

[kpfitzgerald]

rebuiliding again...

i hosed my install trying to get this to work. it appears db2 on php isnt a auto-magic installation. so... ill need to recompile and config with db2 support... since i used the SLES repos and IBM installs, these are unrelated, and could care less about each other!

I have some unanswered questions about this... such as the PECL extension for db2 is it needed? Is there a way to automagic the SLES PHP5 RPM wiht db2 support? Same goes for the sockets support needed by zabbix, can this be done somehow during the RPM install or you you ahve to config then make install and finally make?