Skip to content

How to install IBM Fluid Query?

In this article we will be installing IBM FLuid query version 1.7

Please note: Before you try to install Fluid Query make sure IBM Netezza Analytics is installed on this system.

To check if IBM Netezza Analytics is installed and the current version, just run below query.

nzsql inza -c “select * from product”
NAME | SHORTNAME | VERSION | INSTALLED
———————–+———–+————-+————
IBM Netezza Analytics | INZA | 3.2.2.47943 | 2016-01-21

Now, follow below steps to install FLuid Query:

1) Login to Netezza appliance as nz user.

2) Make sure that you have Fluid query installer filed downloaded from fix central.

/nzscratch/Fluid_Query->ls
nz-fluidquery-v1.7.tar.gz

3) Extract the installer package using gunzip command.

gunzip nz-fluidquery-v1.7.tar.gz

4) You have below files after gunzip

/nzscratch/Fluid_Query->ls
nz-fluidquery-v1.7.tar

5) Now extract the tar file.

/nzscratch/Fluid_Query->tar xvf nz-fluidquery-v1.7.tar

6) You will see below files/folders after extracting the tar file.

/nzscratch/Fluid_Query->ls
fluid-query-import-export-v1.7.0.0.tar
fluidquery_install.sh*
fluid-query-sql-v1.7.0.0.tar
license/
nz-fluidquery-v1.7.tar

7) Now run installer using the comand ./fluidquery_install.sh . Install will complete in seconds.

——————————————————————————-
IBM Fluid Query Installer
(C) Copyright IBM Corp. 2015, 2016. All rights reserved.
Version 1.7.0.0 [Build 160420-201]
——————————————————————————-
Installing connector…
Checking if IBM Netezza Analytics is installed…
IBM Netezza Analytics is already installed. Ok.
Checking if IBM Netezza Analytics cartridge is installed…
IBM Netezza Analytics cartridge is already installed. Ok.
Checking for previous installation of IBM Fluid Query…
Previous installation of IBM Fluid Query does not exists in /nz/export/ae/products/fluidquery…
Extracting package to /nz/export/ae/products/fluidquery…
Copying license to /opt/nz/licenses/ifq…
Copying uninstaller to /nz/export/ae/products/fluidquery…
WARNING: Unable to register IFQAdmin. Try to execute “/nz/export/ae/products/fluidquery/fqRegister.sh –admin”
Installation successful! Package installed in /nz/export/ae/products/fluidquery
For details see the log file at /nz/var/log/fluidquery_install/fluidquery_install.2016-05-26.09:46:11.log

ERROR: Concurrent update or delete of same row

ERROR: Concurrent update or delete of same row [tbl 212201676 dsid 36 tx 0x572822a U prev 0x572801c]

POSSIBLE ISSUE: You will possibly see this error in Netezaa if you try to update a row which is already deleted.

RESOLUTION: Do not try to update delete record.

Below is the example to support this answer:

TESTDB.ADMIN(ADMIN)=> select * from Test_Recovery;
NUM | DESCRIPTION
—–+————-
1 | ABC
2 | XYZ
(2 rows)

TESTDB.ADMIN(ADMIN)=> delete from Test_Recovery where NUM=1;
DELETE 1

TESTDB.ADMIN(ADMIN)=> select createxid, deletexid, rowid, * from Test_Recovery;
CREATEXID | DELETEXID | ROWID | NUM | DESCRIPTION
———–+———–+——————+—–+————-
91389590 | 0 | 1051578600800001 | 2 | XYZ
(1 row)

TESTDB.ADMIN(ADMIN)=> show show_deleted_records;
NOTICE: SHOW_DELETED_RECORDS is OFF
SHOW VARIABLE

TESTDB.ADMIN(ADMIN)=> set show_deleted_records=true;
SET VARIABLE

TESTDB.ADMIN(ADMIN)=> show show_deleted_records;
NOTICE: SHOW_DELETED_RECORDS is ON
SHOW VARIABLE

TESTDB.ADMIN(ADMIN)=> select createxid, deletexid, rowid, * from Test_Recovery;
CREATEXID | DELETEXID | ROWID | NUM | DESCRIPTION
———–+———–+——————+—–+————-
91389588 | 91389980 | 1051578600800000 | 1 | ABC
91389590 | 0 | 1051578600800001 | 2 | XYZ
(2 rows)

TESTDB.ADMIN(ADMIN)=> update Test_Recovery set DESCRIPTION=’AAA’ where NUM=1;
ERROR: Concurrent update or delete of same row [tbl 212201676 dsid 36 tx 0x57281f0 U prev 0x572801c]