How to check the NPS heartbeat status?

NPS hearbeat status?
/sbin/service heartbeat status

steps to Netezza DB switchover

How to switch over NPS from Ha1 to HA2?
Please follow the below steps to perform switchover.

/nzlocal/scripts/heartbeat_admin.sh
--migrate
Testing DRBD communication channel...Done.
Checking DRBD state...Done.

Migrating the NPS resource group from NZHOST1 to NZHOST2................................................Complete.
20100112_084039 INFO : Run crm_mon to check NPS' initialization status.

Netezza restore logs

where to check Netezza database restore logs?
/nz/kit/log/restoresvr

netezza backup logs

where to check Netezza backup logs under NPS ?
/nz/kit/log/backupsvr

Netezza running sql statements

How to check  running sql statements in Netezza?
nzstats -type query

How to check the active sessions on Netezza server?

active sessions on netezza DB
Nzsession |grep -i active

How to access netezza database from other tools?

 access Netezza database

we can access Netezza database using the below methods
1.nzsql
2.nzadmin
3.aginity

nzsql we have to connact to server from that we can easily login to Db using nzsql under nz user
nzadmin we have to install on our local machine  and it will act as client for  that we need OLEDB needs to be installed prior to that.

Oracle ORA-03137: TTC protocol internal error

issue:
ORA-03137: TTC protocol internal error : [12333] [19] [3] [94] [] [] [] [] i

solution:

try to  setting the undocumented parameter "_optim_peek_user_binds"=false 

oracle DB 11203 @AIX bug

issue:

ORA-04030: out of process memory when trying to allocate 168824 bytes (kkoutlCreatePh,logdef* : kkoabr)

this is the bug in 11203 enterprise edition

and we can avoid this error  by adding _paramater

A Query Fails With ORA-4030 On "kkoutlCreatePh,logdef* : kkoabr" (Doc ID 1474457.1)

ALTER SYSTEM SET "_b_tree_bitmap_plans"=false scope=spfile;

How to find hardware issues on netezza database?

Netezza hw issues

nzhw -issues
nzds -issues

How to calculate Netezza DB size?

How to calculate Netezza DB size?

Netezza DB size
nz_db_size <db_name> it will display the DB size in TB ,this will be executed with nz user.

how to kill session in Netezza DB ?

steps to  kill a session on Netezza database?

the below command will clear the session on Netezza,but it wont kill the admin session.

Nzabort -id <id>

Dg broker switch over in oracle database

DGbroker commands

$dgmgrl connect sys/password
$switchover to "stdby_dbname";

steps to execute script in Netezza database

How to execute script in Netezza database?
1.nzsql
2.\c <db name>
3.\i scriptname.sql