Migrating from PureData System for Analytics

Deployment options: Netezza Performance Server for Cloud Pak for Data System

Learn how to migrate from PureData System for Analytics to Netezza Performance Server by using the nzevent command.

Procedure

Export the events to a file from PureData System for Analytics from which you want to migrate events:

nzevent show -syntax > events_with_syntax

The events_with_syntax file will have the command line syntax for creating/editing events.

For example, the output might be similar to:

-name NPSNoLongerOnline -on yes -eventType sysStateChanged -eventArgsExpr '$previousState == online && $currentState != online' -notifyType email -dst '<your email here>' -ccDst '' -msg 'NPS system $HOST went from $previousState to $currentState at $eventTimestamp $eventSource.' -bodyText '$notifyMsg\n\nEvent:\n$eventDetail\n' -callHome yes -eventAggrCount 0

To add/set this event on NPS, append nzevent add to the syntax from Step 1.

Example:

nzevent add -name NPSNoLongerOnline -on yes -eventType sysStateChanged -eventArgsExpr '$previousState == online && $currentState != online' -notifyType email -dst '<your email here>' -ccDst '' -msg 'NPS system $HOST went from $previousState to $currentState at $eventTimestamp $eventSource.' -bodyText '$notifyMsg\n\nEvent:\n$eventDetail\n' -callHome yes -eventAggrCount 0

Append nzevent add to all the events that need to be added on the new system.

You can edit/change the mail IDs in -dst and -ccDst if needed. To add more than one email ID, separate the IDs with a comma(,).

Run all the nzevent add statements on the new system to create events.

If no events are present for migration (as in the example in Step 2), you can add email IDs in the -dst and -ccDst fields and run the statements to create events.

Example:

nzevent add  -name 'Disk80PercentFull'          -on yes -eventType hwDiskFull           -eventArgsExpr '$threshold == 80 || $threshold == 85' -notifyType email -dst 'youremail@company.com' -ccDst '' -msg 'NPS system $HOST - $hwType $hwId partition id $partition is $value % full at $eventTimestamp.' -bodyText '$notifyMsg\n\nSPA ID: $spaId\nSPA Slot: $spaSlot\nLun Id: $lunId\nThreshold: $threshold\nValue: $value\n' -callHome yes -eventAggrCount 50

nzevent add  -name 'Disk90PercentFull'          -on yes -eventType hwDiskFull           -eventArgsExpr '$threshold == 90 || $threshold == 95' -notifyType email -dst 'youremail@company.com' -ccDst '' -msg 'NPS system $HOST - $hwType $hwId partition Id $partition is $value % full at $eventTimestamp.' -bodyText '$notifyMsg\n\nSPA ID: $spaId\nSPA Slot: $spaSlot\nLun Id: $lunId\nThreshold: $threshold\nValue: $value\n' -callHome yes -eventAggrCount 50

nzevent add  -name 'NPSNoLongerOnline'          -on yes -eventType sysStateChanged      -eventArgsExpr '$previousState == online && $currentState != online' -notifyType email -dst 'youremail@company.com' -ccDst '' -msg 'NPS system $HOST went from $previousState to $currentState at $eventTimestamp $eventSource.' -bodyText '$notifyMsg\n\nEvent:\n$eventDetail\n' -callHome yes -eventAggrCount 0

nzevent add  -name 'RunAwayQuery'               -on yes -eventType runawayQuery                 -eventArgsExpr '' -notifyType email -dst 'youremail@company.com' -ccDst '' -msg 'NPS system $HOST - long-running query detected at $eventTimestamp.' -bodyText '$notifyMsg\n\nsessionId: $sessionId\nplanId: $planId\nduration: $duration seconds' -callHome yes -eventAggrCount 0

nzevent add  -name 'SpuCore'                    -on yes -eventType spuCore              -eventArgsExpr '' -notifyType email -dst 'youremail@company.com' -ccDst '' -msg 'NPS system $HOST - Process Cored on SPU $hwId at $eventTimestamp' -bodyText '$notifyMsg\n\nhwId:$hwId\nspaId:$spaId\nslot:$slot\nerror string:$errString\nevent source:$eventSource\n' -callHome no -eventAggrCount 0

nzevent add  -name 'SystemOnline'               -on yes -eventType sysStateChanged      -eventArgsExpr '$previousState != online && $currentState == online' -notifyType email -dst 'youremail@company.com' -ccDst '' -msg 'NPS system $HOST went online at $eventTimestamp $eventSource.' -bodyText '$notifyMsg\n\nEvent:\n$eventDetail\n' -callHome yes -eventAggrCount 0

nzevent add  -name 'SystemStuckInState'         -on yes -eventType systemStuckInState   -eventArgsExpr '' -notifyType email -dst 'youremail@company.com' -ccDst '' -msg 'NPS system $HOST - System Stuck in state $currentState for $duration seconds' -bodyText 'The system is stuck in state change. Contact Netezza support team\nduration: $duration seconds\nCurrent State: $currentState\nExpected State: $expectedState' -callHome yes -eventAggrCount 0

nzevent add  -name 'TransactionLimitEvent'      -on yes -eventType transactionLimitEvent -eventArgsExpr '' -notifyType email -dst 'youremail@company.com' -ccDst '' -msg 'Transaction Limit Event from $HOST' -bodyText 'NPS system $HOST - current number ($CurNumTX) of transactions exceeded $TxLimitEventPercent % of total limit $MaxTransactions at $eventTimestamp.\n\nOldest Active Transaction:\n\ntxid: $OldestActiveTxId\nSession id: $SessionId\nPID: $PID\nDatabase: $Database\nUser: $User\nClient IP: $ClientIP\nClient PID: $ClientPID\nTransaction start date: $TransactionStartDateTime\n\nTo reduce the outstanding transaction count you may want to consider completing/aborting the above transaction.' -callHome yes -eventAggrCount 0

nzevent add -name 'histLoad' -on yes -eventType histLoadEvent -eventArgsExpr '' -notifyType email -dst 'youremail@company.com' -ccDst 'youremail@company.com' -msg 'NzEv-WARNING History_Load_Fault on load=$configName for $HOST at $eventTimestamp' -bodyText ' \n Hostname  $HOST \n NzEvents  \n 1\n Event  Query_History_Load \n Event Time  $eventTimestamp\n errString $errString \n configName $configName \n dirName $dirName \n nps $nps \n database $database \n histType $histType \n storageLimit $storageLimit \n loadMinThreshold $loadMinThreshold \n loadMaxThreshold $loadMaxThreshold \n diskFullThreshold $diskFullThreshold \n loadInterval $loadInterval \n batchSize $batchSize \n stagedSize $stagedSize \n errCode $errCode \n' -callHome no -eventAggrCount 10

nzevent add -name 'histCapture' -on yes -eventType histCaptureEvent -eventArgsExpr '' -notifyType email -dst 'youremail@company.com' -ccDst '' -msg 'NzEv-WARNING History_Capture_Fault on capture=$configName for $HOST at $eventTimestamp' -bodyText ' \n Hostname  $HOST \n NzEvents  \n 1\n Event  Query_History_Capture \n Event Time  $eventTimestamp\n errString $errString \n configName $configName \n dirName $dirName \n nps $nps \n database $database \n histType $histType \n storageLimit $storageLimit \n loadMinThreshold $loadMinThreshold \n loadMaxThreshold $loadMaxThreshold \n diskFullThreshold $diskFullThreshold \n loadInterval $loadInterval \n capturedSize $capturedSize \n stagedSize $stagedSize \n storageSize $storageSize \n errCode $errCode \n' -callHome no -eventAggrCount 10

nzevent add -name 'Disk_FPGA' -on yes -eventType diskError -eventArgsExpr '' -notifyType email -dst 'youremail@company.com' -ccDst 'youremail@company.com' -msg 'NzEv-Info $hwType Disk_Fault $hwId @ $spaId.$spaSlot FPGA=$fpgaEngineId for $HOST at $eventTimestamp tableId $tableId dataSliceId $dataSliceId partition $partition lba $lba errType $errType errCode $errCode retries $retries block $block' -bodyText ' \n Hostname  $HOST \n NzEvents  \n 1  \n Event  diskError \n Event Time  $eventTimestamp \n hwType  SPU \n hwId  $hwId \n partition  $partition \n lba  $lba \n dataSliceId  $dataSliceId \n tableId  $tableId \n block  $block \n devSerial  $devSerial \n diskSerial  $diskSerial \n diskModel  $diskModel \n errType  $errType \n errCode  $errCode \n oper  $oper \n retries  $retries \n' -callHome no -eventAggrCount 0

nzevent add -name 'hwService_Requested' -on yes -eventType hwServiceRequested -eventArgsExpr '' -notifyType email -dst 'youremail@company.com' -ccDst 'youremail@company.com' -msg 'NzEv-$hwType Service_Requested $hwId @ $location for $HOST at $eventTimestamp ($errString $eventSource)' -bodyText ' \n Hostname  $HOST \n NzEvents  \n 1\n Event  Service_Requested \n Event Time  $eventTimestamp\n hwType  $hwType \n hwId  $hwId\n hwSerial $devSerial \n errString $errString \n eventSource $eventSource \n' -callHome no -eventAggrCount 0