Copyright International Business Machines Corporation 2016.
All rights reserved.
Component: IBM® Tivoli® Composite Application Manager for Microsoft® Applications: Version 6.3.1.8
Fix Pack: 0008
Component ID: 5724-U17
Date: Jan 22, 2016
1.0 General description
This fix contains the APARs and defects that are specified in the "Problems fixed" section. This fix also includes the enhancements that are made in the V6.3.1.8 release of ITCAM for Microsoft Applications product.
2.0 Problems fixed
The following problems are addressed by this fix.
2.1 APARs
For the SQL Server agent:
APAR: IV79444
Abstract: Server name is blank when the event for inactive server status is generated.
Additional Information: Server name was not filled when a SQL Server Instance was Inactive. This event when generated gives a blank server name. This issue is with reference to PMR 22431, 004,000: MS SQL agent EIF missing server.
For the Active Directory agent:
APAR: IV72817
Abstract: Agent Shows wrong value for “DCA PDC Master ","DCA RID Controller Availability “attribute group
Additional Information: Agent shows wrong value for "DCA PDC Master","DCA RID Master" and "DCA Infrastructure Master" attributes of "Domain Controller Availability" attribute group, when DNS name and NetBIOS name of Domain Controller machine are different.
APAR: IV52452
Abstract: Domain Name of the host machine is not fetched by AD Agent.
Additional Information: Agent is not able to fetch the domain name of the host machine because getaddrinfo API gives incorrect canonical name of host machine.
APAR: IV52672
Abstract: Agent shows incorrect data for DNS ADIntegrated attribute group.
Additional Information: Some SRV records (for Read only Domain Controller) which are specific to sites get added under sites not in the default location in DNS Manager. Hence agent fails to verify the SRV records of sites and incorrect data displays for some of the attribute of DNS ADIntegrated attribute group on TEP.
APAR: IV53500
Abstract: Agent Shows wrong count of Global Catalog Servers in a Domain.
Additional Information: Agent Shows wrong count of Global Catalog Servers in a Domain for Domain controller availability attribute group. Agent does not consider the RODC with GC configured as Global Catalog Server.
APAR: IV60416
Abstract: Agent shows wrong data of "DRA INTERSITE PARTNER COUNT" attribute
Additional Information: Microsoft Active Directory Agent shows wrong data of "DRA InterSite Partner Count" attribute. The Microsoft Active Directory Agent displays correct data initially, but sometimes it shows the incorrect value.
APAR: IV74419
Abstract: Active Directory 64-bit Agent does not connect to Tivoli Enterprise Monitoring Server (TEMS) using IPSPIPE.
Additional Information: Due to incorrect value of PATH environment Variable, Active Directory 64-bit Agent does not connect to Tivoli Enterprise Monitoring Server (TEMS) using IPSPIPE.
For the Exchange Server agent:
APAR: IV73298
Abstract: Microsoft Exchange Server Agent fails to fetch the data for
Email Statistics attribute group.
Additional Information: Microsoft Exchange Server Agent fails to fetch the data for Email Statistics attribute group when monitored server name has maximum allowed NETBIOS name.
APAR: IV73296
Abstract: Microsoft Exchange server agent shows wrong data for "MS Exchange Reachability" attribute group.
Additional Information: "MS Exchange Reachability" attribute group shows wrong data when user name having white spaces provided in the agent configuration panel.
APAR: IV75572
Abstract: Microsoft Exchange Server Agent Guide shows incorrect configuration parameters' name in ‘Remote installation and configuration’ section.
Additional Information: Microsoft Exchange Server Agent Guide shows incorrect name of below configuration parameters in ‘Remote installation and configuration’ section.
1. Existing Name: EXCHSETTINGS.exch_event_interval
Correct Name: EXCHSETTINGS.exchange_event_interval
2. Existing Name: EXCHSETTINGS.exch_event_count
Correct Name: EXCHSETTINGS.exchange_event_count
For the IIS agent:
APAR: IV76536
Abstract: IBM Tivoli Monitoring IIS Agent uses high CPU.
Additional Information: With this patch we have restricted IIS agent from consuming high CPU. This APAR was delivered for ITCAMMA IIS agent V6.3.1.2. Now we have integrated this APAR in current release ITCAMMA IIS agent V6.3.1.8.
For the Lync Server agent:
Customer Requirement: 86423
Abstract: Nordea: MS Lync Agent (v8).
Additional Information: Provided additional metrics and synthetic monitoring for the Lync infrastructure.
2.2 Defects
For the SQL Server agent:
Defect: 132699
Abstract: MSSQLDEV: Newly added attributes in 6312 release are visible on Table information and Additional Database Details workspaces with older versions of agent.
Additional Information: When agent of version lower than 6312 was pointed to the ITM with support 6312 or higher, the Table information and Additional Database Details workspaces were showing newly added attributes in 6312 release on portal.
Defect: 133141
Abstract: MSSQLDEV: Resource Pool Statistics Attribute group showing wrong values on portal
Additional Information: Because of wrong calculation and wrong perfmon counter names, some of the attributes in Resource Pool Statistics attribute group were showing incorrect data on portal.
Defect: 133142
Abstract: MSSQLDEV: Workload Group Statistics Attribute Group is showing wrong value on portal.
Additional Information: Because of wrong calculation and wrong perfmon counter names, some of the attributes in Workload Group Statistics attribute group were showing incorrect data on portal.
Defect: 132611
Abstract: MSSQLDEV: KOQTBLD Query failure while removing deleted tables from global map causing high memory.
Additional Information: After failure of one of the query which gets the list of deleted tables, collector didn’t remove the deleted tables from global mapand at the same time new tables entries were added to this map in every new interval. This was leading to high memory usage. To fix this made following changes:
o When query used for finding deleted tables fails, delete all entries present in global map and collect complete data for KOQTBLD once again in global map.
o In old algorithm, query execution was marked as failed when query returns more than 10,000 rows. Now this behavior is changed for all the queries used inKOQTBLD. If any of the queries used in KOQTBLD returns more than 10,000 rows then query will not fail. All the rows returned by query are considered for processing.
o In old algorithm, first 10,000 rows collected for KOQTBLD were sent to portal without any sorting. This behavior is changed now. Now the row returned for KOQTBLD will be sorted based on environmental variable "COLL_TBLD_SORTBY". Possible value for this variable are as below:
"frag" - Sort according "fragmentation percent" value in descending order
"space" - Sort according "Space used" value in descending order
"optsage" - Sort according "Optimizer Statistics Age" in descending order
"rows" - Sort according "Number of Rows" in descending order
If user does not specify any of these values or gives any wrong value for "COLL_TBLD_SORTBY", then by default sorting will be based on "fragmentation percent"
Defect: 134274
Abstract: The agent and collector processes are not terminated and the data remains visible on the portal when an instance is removed from MTEMS configuration panel
Additional Information: After un-configuring agent from MTEMS window, agent and collector services were not getting stopped and removed.
Defect: 135345
Abstract: SVTMSOQ: Table details attribute group data is not updated successfully in case of database detach, attach scenario.
Additional Information: Reattached tables were not getting listed on portal.
For the .NET Data Collector:
1. Defect: 134740
Abstract:
.NET DC makes WCF extensions entries in “machine.config” files even if WCF is unregistered using ServiceModelReg.exe utility.
Additional Information:
WCF component of a .NET Framework can be removed by using servicemodelreg.exe. This change cannot be detected by .NET Data Collector during configuration and it makes WCF related entries in machine.config file, making them anomalies for .NET Framework.
2. Defect: 134739
Abstract: DEVNETDC7323: Component name contains space for Microsoft.NET.
Additional Information:
When an event has component name Microsoft.NET, it contains a space between the two words.
2.3 Enhancements
For the SQL Server agent:
- Added support for Unicode characters so that SQL server with different collations can be monitored.
- RFE 61001: MSSQL Agent - delivering wrong database status. Changed the source of server status so that sql agent can report accurate SQL server status and Database status in all the conditions. Changes have been made to fetch status of SQL server using WMI queries.
3. Jar files are signed with refreshed certificate.
- Done some improvements in configuration panel window as mentioned below :
· Made "Windows Authentication" and "Support Long Live Connection"options true by default.
· Disabled "Login" and "Password" text boxes when "Windows Authentication" is selected.
· Made "Login" and "Password" fields mandatory when "Windows Authentication" is not selected.
· Made "Home Directory" , "Error Log File" , "Database Version" text boxes read-only when agent has found these settings successfully.
· Made ”Server Name” text box read only while configuring/reconfiguring the instance.
· Made functional behavior of all the buttons and list boxes present on configuration panel window identical.
- Newly added attributes :
a. The newly included attributes in SAAS release are included in ITM release:
o In MS SQL Database Summary attribute group:
· Total Databases Critical: The total number of databases that are in critical state. The database is in critical state, if (lPctLogUsed is greater than 90) or (lPctDBUsed is greater than 90) or (dbStatus is equal to 1) or (dbState is equal to offline) or (dbState is equal to emergency) or (dbErrStatus is equal to yes) or (oldOpenTran is greater than 15)
· Total Databases Warning: The total number of databases that are in warning state. The database is in warning state, if (lPctLogUsed is greater than 70 and less than equal to 90) or (lPctDBUsed is greater than 70 and less than equal to 90) or (dbState is not equal to offline, online, and emergency) or (oldOpenTran is 6 – 15)
o In MS SQL Job Summary attribute group :
· Jobs Executed Current Interval: The number of processed jobs in the current sampling interval.
· Warning Jobs Current Interval: The number jobs that are cancelled or in unknown state in the current sampling interval.
o In MS SQL Server Properties attribute group :
· Instance Path: The installation path of the SQL server instance.
· Instance Port: The TCP/IP port number of the SQL server instance.
b. Added one attribute in MS SQL Database Details attribute group so that mirroring role of each database can be monitored.
· Mirroring Role: The mirroring role of the database (mirror or principal). If database is not mirrored then value for this attribute will be Not Applicable. And for not accessible database this attribute will show value as Not Collected.
For the Exchange Server agent:
- APMUI77IF02 support: With MS Exchange Agent v6312IF01 agent, APMUI77IF02 (and onwards) will display only mandatory and configured services in Exchange APMUI dashboard.
- Added following new attribute groups :
i. MS Exchange Top Ten Senders: This data set provides information about top ten email senders.
ii.MS Exchange Top Ten Receivers: This data set provides information about top ten email receivers.
iii.MS Exchange Top Ten Largest Emails: This data set provides information about top ten largest emails.
For the SharePoint Server Agent
1. Added detail information about web application through below attribute groups and workspace Web Application Details.
· Web Service
· Health Bucket
· Service Application Details
The workspace “Web Application Details” is viewed by using a cross-link (web application name) from the workspace “SharePoint configuration”.
For the .NET Data Collector
1. Added Support for URL based filtering of KD4SOAPHeaderV2. The web services present at such URLs will not be injected with .NET Data Collector’s SOAP header.
2. Added support for Silent and remote installation of .NET Data Collector.
For the Active Directory Server Agent
1. Added support for DBCS character encoding.
2. RFE: 61487
Abstract: Timestamp comparison for "RPL Partner Last Success Time" and "RPL Partner Last Attempt Time" attribute in situation formula.
Additional Information: Timestamp datatype is added for "RPL Partner Last Success Time" and "RPL Partner Last Attempt Time" attribute. Now timestamp comparison can be done in the situation formula for these attributes.
For the Lync Server agent:
- Added support for Lync Topology and Synthetic Transactions
- Added support for the Edge Server, Mediation Server, Video Integration Server, and SQL Server
- Added configuration panel
- Added an enterprise level workspace for Synthetic Transactions
- Added new attribute groups for the following roles of the Lync Server:
· Front- end Server
· Outlook web access (OWA)
· Web Conferencing Server
· Audio Video Conferencing Server
2.4 Superseded fixes
6.3.1-TIV-ITM_MSAPP-FP0002
2.5 APARs and defects included from superseded fixes
2.5.1 APARs
For the SQL Server agent:
APAR: IV54729
Abstract: Wrong Job Execution Duration.
Additional Information: The SQL Server agent calculates incorrect value for the job execution duration as original value+3600 (1 hour of daylight saving in seconds). This problem occurs because of daylight saving.
APAR: IV71563
Abstract: Collector crashing in Workload Group Statistics (KOQWGLS) and Resource Pool Statistics (KOQRPOOL) attribute groups.
Additional Information: Fixed size container was used to store values of performance counter and instance names, the size of container was insufficient if maximum number of instances were created for 'SQL Server: Workload Group Stats' or 'SQL Server: Resource Pool Stats' perfmon counter object.
APAR: IV71520
Abstract: Collector is crashing in Table Detail attribute group as query is failing for negative table id.
Additional Information: Negative table ids were generated for tempdb database. This negative table id resulted in failure of query, this query failure was not handled properly which resulted in crash.
APAR: IV70417
Abstract: Select query from 'Log Shipping Job Detail' attribute group is causing severe delay on SQL Agent jobs
Additional Information: The problematic query was used to find job name from msdb.Sysjobhistory table by searching for the agent ID in the message column of Sysjobhistory. It was taking more time because msdb..sysjobhistory table was having millions of rows.
APAR: IV69383
Abstract: Unable to trigger situation on attribute ‘Long Running Transactions Time (sec)’ of Database detail attribute group.
Additional Information: Data type of this attribute in dockoq file was float. And every time the actual value of this attribute was getting divided by 100 while sending to portal that is why situation was not getting triggered.