Archives of the TeradataForum
Message Posted: Fri, 27 Feb 2009 @ 12:46:38 GMT
<-- Anonymously Posted: Fri, 27 Feb 2009 10:54 -->
ref below from teradata
Short Description: software_event_log not populated on LINUX/W2K/WS03
logd and logtpad are not ported from MP-RAS to OpenPDE.
DR 116114 is open to fix this problem. Upgrade to the release or above at which the DR will be fixed.
PDE on LINUX and PDE on Windows.
Following DRs were open to fix this problem.
DR 85889 RFC: Add logging to SW_EVENT_LOG on W2K AND LINUX (all OPNPDE) DR 102835: Sw_event_log not populated on Linux/W2K/WS03
DR 85889 is closed as a duplicate of DR 102835.
DR 102835 is fixed in OpenPDE 12.0. But, this does not enable logtpad. If the system is already running on OpenPDE 12.0 and if logtpad is not running on the PDN node, as a workaround, add the following line in the /etc/opt/teradata/tdconfig/startup.txt on LINUX on all the nodes -
start -v0 -p0 READY logtpad
Then restart the database.
If you don't have a startup.txt file in tdconfig directory then create startup.txt file in tdconfig directory. So that the settings in tdconfig startup.txt file remains even after the PDE version changes.
Do ps -ef | grep logtpad to check if logtpad is running.
To check if sw_event_log is populating, login to the database using bteq. You can view the contents of the log by submitting the query:
SELECT * FROM DBC.Software_Event_Log ;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|