Regarding the influence due to ResUsage setting change

General
General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything
Highlighted
Teradata Employee

Regarding the influence due to ResUsage setting change

Hello, this is David.

Now i have one question 「 Regarding the influence due to ResUsage setting change」want to confirm

Problem Description:
We received an inquiry from DCS to inquire about channel utilization rate. (Among the current 1.6 GB channels, how much are you using ?)

If it is a ResUsageShst table, the communication volume of the channel is understood, due to the setting of Shst is not ON at present, so could not get the information.
Please check the following contents.

· Is there any way to check the channel traffic volume except the ResUsageShst table?
⇒ Since Shst currently set OFF state, please teach if there is a way to acquire similar information in others.

· Please tell us the effect of turning ON Shst setting.
⇒ it is production environment currently in operation, is it necessary to restart in order to reflect the setting?
How much CPU load will increase, and how much capacity will increase. Would you please give me some advice.
Thanks in advance
Best regards

David


Accepted Solutions
Teradata Employee

Re: Regarding the influence due to ResUsage setting change

Added overhead should be very small with normal ResUsage intervals (accumulate every 1 minute, write log row for each host interface every 10 minutes) and space occupied by the log records should be small.

 

If the nodes containing your channel interfaces are not used for TCP/IP ("network") connections, then you could use node-level ResUsageSpma data. If those nodes support both channel and TCP/IP traffic (so "host" traffic at the node level is both channel and network combined), then you could at least get an upper bound.

1 ACCEPTED SOLUTION
2 REPLIES
Teradata Employee

Re: Regarding the influence due to ResUsage setting change

Added overhead should be very small with normal ResUsage intervals (accumulate every 1 minute, write log row for each host interface every 10 minutes) and space occupied by the log records should be small.

 

If the nodes containing your channel interfaces are not used for TCP/IP ("network") connections, then you could use node-level ResUsageSpma data. If those nodes support both channel and TCP/IP traffic (so "host" traffic at the node level is both channel and network combined), then you could at least get an upper bound.

Teradata Employee

Re: Regarding the influence due to ResUsage setting change

Hi dear Fred, thanks for your advice.

Will use your advice to be solution.

best regards

David