scrip to restore Netezza database to another database

pre -request.

we have to drop the target database before restore ,NPS restore process automatically will create new database.once the restore is completed we will rename the database

nzrestore -db test1 -u admin -dir /netback/backup/test/ -backupset 20130605233051

script to rename Netezza database?

alter database rename <dbname> to < new name>

How to stop/start the netezza Database?

we have to issue the below command using nz user

nzstop/nzstart

How to take the DDl of database ,table of Netezza DB?

nz_ddl_database <dbname>
nz_ddl_table <dbname> <table_name>

How to rebalance the SPU in netezza after DAc replacement

check whether able to ping the SPU
ping sassw01a
then do
nzhw rebalance

how to check active sessions on SQL server

sp_who
sp_who2 stored procedure used to list the connection and blkby column will indicate that blocked columns

dba_job is not running in oracle database?

issue:
dba jobs is not running on oracle database and its hanging

solution:
Please check the job queue process parameter value ,it should be equal or more than the no of job running on the database.

Opatch throws error in oracle database

issue:

The java class could not be loaded. java.lang.UnsupportedClassVersionError: (oracle/opatch/OPatch) bad major version at offset=6

OPatch failed with error code 1

solution:
Please use recent Opatch utility to resolve this issue/use recent version of JDK/JRE

blower issue in netezza appliance

how to find out blower issue in Netezza ?

nzhw -issue

need to replace the blower ,its a kind of cooling system for chasis

script to do full restore on Netezza database

2013-08-02 12:55:09.428218 PDT Info: NZ-00022: --- program 'restoresvr' (4080) starting on host 'nsdwt03' ... ---
2013-08-02 12:55:09.454282 PDT Info: Restore command: nzrestore -u admin -db XYZ -sourcedb ABC -dir /netback_old/backup/july -backupset 20130721195736 -npshost VIP
2013-08-02 12:55:09.454302 PDT Info: Setting the command line options
2013-08-02 12:55:09.776227 PDT Info: Restoring from base directory '/netback_old/backup/july'
2013-08-02 12:55:09.776362 PDT Info: Starting the restore process
2013-08-02 12:57:24.888546 PDT Info: Reading locations file
2013-08-02 12:57:25.459500 PDT Info: Warning: Invalid backupset, found /Netezza/VIP.petc.com/ABC/20130721195736/1/FULL in locations.txt, expected /Netezza/VIP/ABC/20130721195736/1/FULL.
2013-08-02 12:57:26.871784 PDT Info: Reading schema from /netback_old/backup/july/Netezza/<VIP>/ABC/20130721195736/1/FULL/md
2013-08-02 12:57:26.872418 PDT Info: Opening pipe for schema read ...
2013-08-02 12:57:27.252432 PDT Info: Restoring a 4.0 backup from NPS Release 6.0.2 (P-1) [Build 17433] created on xs system 'nsdwp01'
2013-08-02 12:57:27.252454 PDT Info: Restore of 92 dataslice backupset to 46 dataslice system
2013-08-02 12:57:27.657741 PDT Info: Operation txid and history table record 2773474
2013-08-02 12:57:27.669672 PDT Info: Restoring schema
2013-08-02 12:58:24.897130 PDT Info: Start restoring the data, compressed format.