Core files in Netezza
Core file is generated when for some reason Netezza is not able to process some requests and hit some issue which result in Netezza server to dump all the contents of memory to a file for diagnostics purpose.
Basic idea to identify what component generated a core file.
– If core file is generated at /nz/data or /nz/data.1.0 then this core file is probably generated by postmaster process.
– If core file is generated at /nz/kit/log/spucores then the core file is generated by SPU cores.
– If core file ise generated by any of the NPS server processes then the core file will be found under /nz/kit.5.0.6.P1/log/ and the respective process directory like /nz/kit.5.0.6.P1/log/dbos.