How To
Summary
This article provides the step to reset Transaction id on Netezza Performance Server
Objective
To reset Transaction id on Netezza Performance Server
Environment
Netezza Performance Server on Cloud Pak for Data System
Steps
Take hostbackup.This will pause the system and makes online automatically once hostbackup finishes.
-----------------------------------------------------------------------------------------
nzhostbackup /nzscratch/$(uname -n).backup.$(date "+%m%d%Y").pos.tgz
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------
nzhostbackup /nzscratch/$(uname -n).backup.$(date "+%m%d%Y").pos.tgz
-----------------------------------------------------------------------------------------
Inside the container using "nz" user record the transaction count using command below :-
-----------------------------------------------------------------------------------------
nzsql -c "select pgxid from _v_pg_transaction where sessionid = current_sid;"
-----------------------------------------------------------------------------------------
nzstop
Disable the logrotate.hourly cron jobs and all other cron jobs that can trigger a postgres session.
Inside the container, as the root user,stop the cron job using command below :-
----------------------------------------------------------------------------------------
systemctl stop crond
----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
systemctl stop crond
----------------------------------------------------------------------------------------
As root user start the catalog upgrade
--------------------------------------------------------------------------------------------------------
/nz/kit/sbin/nzupgrade -r -T catupgrade upgrade DOCATUPGRADE=TRUE FORCESTATE=1
--------------------------------------------------------------------------------------------------------
When catalog upgrade is done, start cron service, start Netezza database and validate TXID value:
Inside the container, as the root user,start the cron job using command below :-
----------------------------------------------------------------------------------------
systemctl start crond
----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
systemctl start crond
----------------------------------------------------------------------------------------
Start Netezza System.
su - nz
nzstart
----------------------------------------------------------------------------------------
Inside the container using "nz" user record the transaction count using command below :-
nzstart
----------------------------------------------------------------------------------------
Inside the container using "nz" user record the transaction count using command below :-
nzsql -c "select pgxid from _v_pg_transaction where sessionid = current_sid;"
----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSHOFQ","label":"IBM Netezza Performance Server for IBM Cloud Pak for Data"},"ARM Category":[{"code":"a8m3p000000GnvwAAC","label":"Cloud Pak for Data System-\u003EIPS"}],"ARM Case Number":"TS008696329","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
08 May 2026
UID
ibm17105092