steps to collect plan file for SQL in Netezza database.

Here is the steps to generate the plan file for a SQL in netezza database


nzsql -d databasename -f <create file with SQL statement that has issue> -plndir /nz/data/

you need to pass the database name
full sql statement that has the issue  and location for the plan file

once you execute the above command ,it will generate the below files and under these directory you see the plan files.

nz@servername:/nz/data> ls -ltr
total 1540
nz@servername:/nz/data> ls -ltr
total 1540
-rw-r--r-- 1 nz 500    6727 Jan 15 12:33 full_sql.sql
drwx------ 2 nz 500    4096 Jan 15 12:36 45176
drwx------ 2 nz 500    4096 Jan 15 12:36 45177
drwx------ 2 nz 500    4096 Jan 15 12:36 45178
drwx------ 2 nz 500    4096 Jan 15 12:37 45179