15.10 - Changes to This Book - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K
 

Release

Description

Teradata Database 15.10

December 2015

  • Modified the description of MaxIOResp in MONITOR VIRTUAL RESOURCE.
  • Teradata Database 15.10

    July 2015

  • Added advanced settings for TDStats.DefaultsTbl to control the behavior of time limits and progress indicators for all Stats Manager Analyze Jobs. See Chapter 8.
  • Teradata Database 15.10

    June 2015

  • Added advanced settings for TDStats.DefaultsTbl table settings that are not controlled by DBA Control APIs, but can be set with SQL statements.
  • Added advanced settings to TDStats.DefaultsTbl to detect and filter parse-time errors from the stats recommendations made by Analyze Jobs. See Validate_Missing_Stats_Recommendations and related settings.
  • Additional lock objects are logged in Blk_x_OType for MONITOR SESSION, MonitorMySessions, and MonitorSession.
  • Teradata Secure Zones: New ZoneId field in the MonitorSession, MonitorMySessions, and MonitorSQLCurrentStep Open APIs.
  • New fields in MonitorMySessions and MonitorSession Open APIs:
  • ProxyUserId, ZoneId, ReqHotAmpCPU, ReqHotAmpCPUId, ReqHotAmpIO, ReqHotAmpIOId, ReqFirstRespTime, ReqInvolvedAMPCnt, ReqLocalQueryStatus, ReqRemoteHostId, ReqRemoteSessionId, ReqRemoteRequestId, ReqRemoteQueryId
  • New fields SPName and SPDBName in MONITOR SQL (returned in response statement 2) and in MonitorSQLCurrentStep
  • Teradata Database 15.10

    June 2015 continued

  • New record types in TDWM STATISTICS and TDWMLoadUtilStatistics: DSA, DSA Backup, DSA Restore, and MLOADX
  • Added new monitor software version 12 and group VII data fields in MONITOR SESSION returned in response statement 2:
  • ProxyUserId, ZoneId, ReqHotAmpCPU, ReqHotAmpCPUId, ReqHotAmpIO, ReqHotAmpIOId, ReqFirstRespDate, ReqFirstRespTime, ReqInvolvedAMPCnt, ReqLocalQueryStatus, ReqRemoteHostId, ReqRemoteSessionId, ReqRemoteRequestId, ReqRemoteQueryId
  • Added profile query band in MONITOR QUERYBAND PM/API, GetQueryBand, GetQueryBandPairs, GetQueryBandSP, GetQueryBandValue, GetQueryBandValueSF, GetQueryBandValueSP, and MonitorQueryBand Open APIs.
  • The sample rate for SET SESSION RATE and SetSessionRate must be nonzero.
  • PM/API requests can be aborted in their own session by executing an asynchronous abort from CLIv2 or JDBC.
  • Added Automated Statistics Management APIs, PreserveAfterRecreate and DoNotPreserveAfterRecreate, which are used to preserve (or not) TDStats stored metadata after a table is briefly dropped and recreated with an identical structure.
  • Updated existing and added new Rule Type values to TDWM STATISTICS Statement 2 and Statement 4, TDWMGetDelayedQueries Result Rows, and TDWMGetDelayedUtilities Result Rows.
  • Utility throttle information is now returned in TDWM STATISTICS Record Type (Server and AWT Resource Limit) and in TDWMThrottleStatistics Result Rows (AWT Resource Limit).
  • Removed references to 30-character limits for object names. Teradata Database supports object names up to 128 characters long in most cases. For more information on object naming see SQL Fundamentals.