Migration von PureData System for Analytics

Bereitstellungsoptionen: Netezza Performance Server für Cloud Pak for Data System

Erfahren Sie, wie Sie mithilfe des Befehls nzevent von PureData System for Analytics zu Netezza Performance Server migrieren.

Vorgehensweise

Exportieren Sie die Ereignisse in eine Datei von PureData System for Analytics, aus der Sie die Ereignisse migrieren möchten:

nzevent show -syntax > events_with_syntax

Die Datei events_with_syntax enthält die Befehlszeilensyntax zum Erstellen/Bearbeiten von Ereignissen.

Die Ausgabe könnte zum Beispiel so aussehen:

-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

Um dieses Ereignis auf dem NPS hinzuzufügen/einzustellen, fügen Sie nzevent add an die Syntax aus Schritt 1 an.

Beispiel:

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

Fügen Sie nzevent add zu allen Ereignissen hinzu, die im neuen System hinzugefügt werden müssen.

Sie können die Mail-IDs unter -dst und -ccDst bei Bedarf bearbeiten/ändern. Um mehr als eine E-Mail-ID hinzuzufügen, trennen Sie die IDs durch ein Komma ( , ).

Führen Sie alle nzevent add Anweisungen auf dem neuen System aus, um Ereignisse zu erstellen.

Wenn keine Ereignisse für die Migration vorhanden sind (wie im Beispiel in Schritt 2), können Sie E-Mail-IDs in die Felder -dst und -ccDst eingeben und die Anweisungen ausführen, um Ereignisse zu erstellen.

Beispiel:

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