Skip to content

Archive for wrong ELF class: ELFCLASS64

Netezza client is not working and is throwing below error.
$ nzsql
nzsql: error while loading shared libraries: wrong ELF class: ELFCLASS64

$ pwd

$ ldd ./bin/nzsql => (0x003e0000) => /lib/ (0x00256000) => /lib/ (0x00600000) => /nzhome/nzclient/lib/ (0x00d8f000) => /nzhome/nzclient/lib/
(0x008c2000) => /lib/ (0x00f01000) => /lib/ (0x001e4000) => /lib/ (0x002ef000) => not found => /lib/ (0x00bf0000) => /lib/ (0x003e1000) => /lib/ (0x0015b000) => /lib/ (0x00e87000) => /lib/ (0x002fe000) => /lib/ (0x00e1c000) => /lib/ (0x001aa000)
/lib/ (0x0013b000) => /lib/ (0x00110000) => /lib/ (0x0011b000) => /lib/ (0x0011f000) => /lib/ (0x001ff000)

Here you will find that is shown as not found. But when you check, you will see the symbolic link is alread created.
$ pwd

$ ls -lrt -> /lib64/

You will see that it is pointing to 64 bit library file. Which is wrong. It should point to /lib/

In order to fix th issue, you have to delete the current soft link and create a new one which will point to 32bit library file.
$ pwd

$ rm

$ ln -s /lib/ /nzhome/nzclient/v707/lib/

$ ls -lrt -> /lib/


How to find SQL extention toolkit version?

To find the SQL extention toolkit version / functions installed on your Netezza server, we can run below select queries in system database or database where SQL Extention toolkit is enabled.

1) To find the version of xml functions installed on the server:

SYSTEM(ADMIN)=> SELECT regexp_version();

IISI XML / Regular Expression Library Version 1.4 Build ()
(1 row)
2) To find the version of all the functions except xml functions run:


IISI Crypto Library Version 1.4 Build ()
(1 row)

Normally both wil have same version but it posisble that someone may have installed one component and missed the other because when we install SQL Extention toolkit and enable for a databsae we have two steps each, one to install xml functions and other for non-xml.