Notify Exit Routine

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Notify Exit Routine

Rate Topic

Display Mode

Topic Options

Author

Message

Rakesh nc

Posted 2/19/2008 1:45:38 AM

Junior Member

Group: Forum Members
Last Login: 10/10/2008 7:40:45 AM
Posts: 11, Visits: 40

Hi,
I am trying to use notify exit with TPUMP. I have compiled my TPUMP notify “C” with cc under Linux. My question is

1. When this Notify exit is called?

In the TPUMP reference doc, the event ‘Interim Run statistics’ is called when Tpump is about to update the Monitor interface table or Tpump successfully completed a checkpoint or an Import has just completed successfully. But when I set checkpoint=0, every minute (I,e time difference between checkpoint end and checkpoint begin) the stat information is written into a file. The time difference is approximately 1 minute even when you set checkpoint =1 or checkpoint =2 or checkpoint =3 or checkpoint =4 or checkpoint =5 …. As per TPUMP reference doc, It should call the Notify exit every 5 minutes when checkpoint=5. Please clarify my doubt.

Thanks in advance.

Rakesh nc

Post #10627

dnoeth

Posted 2/22/2008 11:59:24 AM

Supreme Being

Group: Forum Members
Last Login: Today @ 7:20:23 AM
Posts: 533, Visits: 282

The SysAdmin.TPumpStatusTbl is updated once a minute, so this is the first case:
"TPump is about to update the Monitor Interface table".

If you add the NOMONITOR option the "Interim Run Statistics" will be called for each checkpoint.

Dieter

Post #10674

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 3:32pm