Migración desde PureData System for Analytics

Opciones de despliegue: Netezza Performance Server para Cloud Pak for Data System

Aprenda a migrar de PureData System for Analytics a Netezza Performance Server utilizando el comando nzevent.

Procedimiento

Exporte los eventos a un archivo de PureData System for Analytics desde el que desee migrar los eventos:

nzevent show -syntax > events_with_syntax

El archivo events_with_syntax tendrá la sintaxis de línea de comandos para crear/editar eventos.

Por ejemplo, la salida podría ser similar a:

-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

Para añadir/configurar este evento en NPS, añada nzevent add a la sintaxis del paso 1.

Ejemplo:

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

Añada nzevent add a todos los eventos que deban añadirse en el nuevo sistema.

Puede editar/cambiar los ID de correo en -dst y -ccDst si es necesario. Para añadir más de un ID de correo electrónico, separe los ID con una coma( , ).

Ejecute todas las sentencias nzevent add en el nuevo sistema para crear eventos.

Si no hay eventos para migrar (como en el ejemplo del paso 2), puede añadir ID de correo electrónico en los campos -dst y -ccDst y ejecutar las sentencias para crear eventos.

Ejemplo:

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