Archives of the TeradataForum

Message Posted: Mon, 28 Apr 2014 @ 15:18:20 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

TD 14 on SLES 11. BAR server is Windows.

I am trying to figure out how to set up alert through BTEQ with ViewPoint. Below is what I got from VP Alert manual.

Step 1 says, "1 Copy the BTEQ script cpuUsageReport.txt to the Windows server at:

InstallFolder\Teradata\Client\14.10\Teradata Notification Service \sql."

I am trying to find a server where Teradata Notification Service is installed.

1. It just says 'Windows server". It doesn't tell which Windows server. Does it mean a database server or BAR server or any other server?

2. What could be that 'InstallFolder'?

Thanks,

Example: BTEQ Script

In this example, we run a BTEQ script as an alert action for the Teradata Database system TEST1, weeknights only, and track alerts in the Alert Viewer portlet. The BTEQ script, cpuUsageReport.txt contains the following macro that returns a problem analysis of daily workloads: EXECUTE ResPmaTotal;.

1 Copy the BTEQ script cpuUsageReport.txt to the Windows server at:

          InstallFolder\Teradata\Client\14.10\Teradata Notification Service \sql.

2 Verify that the Teradata Notification Service is running on the Windows server.

a At the Windows command prompt, type services.msc.

b Check that the status for the Teradata Notification Service is started in the list of services.

James Park
Database Specialist

	<Prev	Next>		<<First	<Prev	Next>	Last>>