Archives of the TeradataForum
Message Posted: Fri, 29 Sep 2006 @ 20:59:02 GMT
| Subj: | | Re: Blocked sessions history file |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Friday, September 29, 2006 16:57 -->
Sazia,
| | The Teradata session information is stored somewhere that is been fetched by Teradata manager to displayed as session. | |
| | How can we find that file from where the Teradata manager is fetching this information (active, blocked, idle etc. sessions)? | |
| | Is there any way to find out old blocked sessions with its SQL report (few days old) knowing that we are not logging anything particular
regarding this? | |
Response:
The Teradata session information displayed are fetched using PMON (PMONAPI document will give you more details on the subject) interactively.
You have the option of capture the data into a file in your TERADATA MANAGER server using one of many function in TERADATA Manager software.
Please read the TERADATA MANAGER user's guide for the use of each function.
If you have DBQL turn on to log query and have begin query logging statement submitted for selective group or all, you can find the stats
information in DBC.DBQLOGTBL and the SQL in DBC.DBQLSQLTBL.
You might want to review the PERFORMANCE MANAGEMENT document for reference especially under the troubleshooting section to help prepare
yourself on administrator your system. I think DATABASE ADMINISTRATION document is very helpful in getting mechanism of how to set those up.
Have fun with your system.
| 
