Netezza Backup & Restore via Networker

EMC Networker supports Netezza backup configuration.Also we use this backup methology.

Previous week we deleted some row unfortunately.So we had to restore this table before the deletion was completed.

But we are newbie this issue,netezza restore.

Finally we hit restore command and restored it.But default restore without any date parameter,networker restores last backup.But I need to restore 3 previous backup.

So we hit the 3 previous backup set id from the backup log.

Then we restored it.

Backup command:
-----------------------
nzbackup -db XX_DWH -connector networker -connectorArgs NSR_SERVER=networkerist.doganay.com.tr:NSR_DATA_VOLUME_POOL=DDBoostNetezza


Restore Command:
------------------------
nzrestore -db XX_DWH_RST -sourcedb XX_DWH -backupset 20151017201912 -connector networker -connectorArgs NSR_SERVER=networkerist.doganay.com.tr:NSR_DATA_VOLUME_POOL=DDBoostNetezza -tables  XX_HIST -sourceschema XX_ADMIN


XX_DWH_RST -------->Empty database which created by us.

XX_DWH --------------->Source database which backed up.

20151017201912------->Backup set id(You can't find this id from backup admin,you have to mine netezza backup log)

networkerist.doganay.com.tr-------->networker hostname

XX_HIST --------------->table name which you want to restore it.

XX_ADMIN------------>table's schema



Restore output:
-------------------
Restore of increment 1 from backupset 20151017201912 to database 'XX_DWH_RST' committed.
Restore of increment 2 from backupset 20151017201912 to database 'XX_DWH_RST' committed.
Restore of increment 3 from backupset 20151017201912 to database 'XX_DWH_RST' committed.
Restore of increment 4 from backupset 20151017201912 to database 'XX_DWH_RST' committed.
Restore of increment 5 from backupset 20151017201912 to database 'XX_DWH_RST' committed.
Restore of increment 6 from backupset 20151017201912 to database 'XX_DWH_RST' committed.


Pray & Tray:)