温馨提示：本站仅提供公开网络链接索引服务，不存储、不篡改任何第三方内容，所有内容版权归原作者所有
AI智能索引来源：http://www.ibm.com/support/pages/node/1116627
点击访问原文链接

Db2 for i Database Engineer (DBE) Enhancements

进入原网站 导航首页
IBM SupportIBM i Technology UpdatesDb2 for i - Technology UpdatesIndex advice adds ordering information to key column listSYSIXADV pruning with SYSIBMADM.QIBM_SYSIXADV_BY_DAYSSQL Error Logging Facility (SELF) pruning with SYSIBMADM.QIBM_SELF_BY_DAYSSQL Error Logging Facility (SELF) - stop logging for all jobsSQLSTATE_INFO tableSQL table function cursor name improvementQSYS2.MTI_INFO returns member/partition nameQSYS2.SYSMEMBERSTATQSYS2.ACTIVE_QUERY_INFO - filter for the job's userQSYS2.PARSE_STATEMENT() table function - DDL informationSQL Error Logging Facility (SELF) - improved controls and insightSYSTOOLS.SQLCODE_INFO()Tracking Important System Limits - Improved AlertingQSYS2.SYSCOLUMNS2 additional columns QSYS2.CANCEL_SQL procedure enhancementSQE performance and compression enhancementsSQL Error Logging Facility (SELF)COMMENT on table function return columnsOnline reorganize physical file member (RGZPFM) enhancementQSYS2.MTI_INFO lists QRO hashes and plan identifiers that have used the MTIQSYS2.SYSCOLUMNSTAT enhanced for variable length columnsNew QAQQINI control PARALLEL_MIN_TIMENew QAQQINI control PARALLEL_MAX_SYSTEM_CPUQSYS2.MTI_INFOMaximum Binary Radix Index size increased to 16TBQSYS2.GENERATE_SQL for long view namesQSYS2.GENERATE_SQL_OBJECTS for long view namesQSQGNDDL API for long view namesQSYS2.GENERATE_SQL option to generate comment for system object textQSYS2.GENERATE_SQL_OBJECTS option to generate comment for system object textQSQGNDDL API option to generate comment for system object textRagged flashQuery Supervisor CL exit programsQSYS2.ACTIVE_QUERY_INFOQSYS2.SYSFILESIBM i System Limits pruning global variablesQuery SupervisorQSYS2.SYSCOLUMNS2QSYS2.SYSPACKAGESTATQSYS2.END_IDLE_SQE_THREADSQSYS2.GENERATE_SQL procedure output to IFSQSYS2.GENERATE_SQL_OBJECTS procedure output to IFSQSQGNDDL API output to IFSRELATED_OBJECTS table functionSYSCOLUMNS2_SESSION viewQSYS2.SYSPARTITIONSTAT and QSYS2.SYSTABLESTAT viewsOVERRIDE_QAQQINI procedureAllow RI children to be added without an exclusive lockExtend ALLOW_DDL_WHILE_OPEN for grant and revoke authoritiesAdd SUPPRESS_INQUIRY_MESSAGESNew columns added to QSYS2.SYSINDEXSTATHealth attributes added to the SQL Plan Cache PropertiesAlerts for IBM i System LimitsTracking Important System LimitsQSYS2.GENERATE_SQL_OBJECTS procedureQSYS2.SYSPARTITIONSTAT enhancementQSYS2.PARSE_STATEMENT() table function enhancementQSYS2.PARSE_STATEMENT() table functionFair lock option - PREVENT_ADDITIONAL_CONFLICTING_LOCKSNo lock option - ALLOW_DDL_CHANGES_WHILE_OPENAdd columns to QSYS2.SYSPROGRAMSTMTSTAT for SQL dependency level and IBM i Service dependency levelDetail about the lock holder on SQL0913 failuresHonor priority change for parallel index buildALTER TABLE ADD PARTITION preserves spanning DDS keyed logical filesQSYS2.Generate_SQL procedureSome SQL messages changed to return SQL column namesDebugger support for EVAL within SQL Routines and SQL TriggersDRDA connections imprinted with client special register valuesAbility to create range partitions out of orderQSYS2.RESTART_IDENTITY ProcedureDeferred Journal RestoreNew Generate SQL option for ModernizationDebug step supported for SQL Procedures, Functions and TriggersGenerating field reference detail on CREATE TABLE ASDatabase Reorganization - User specified starting pointSTRQMQRY command - instrumented for Client Special RegistersSYSPROC.BASE_TABLE - alias interrogationNumber of partition keys - added to statistical viewsCHECK_SYSCST procedure added to SYSTOOLSCHECK_SYSROUTINE procedure added to SYSTOOLSImproved catalog management for procedures and functionsSTRDBMON pre-filtering of QUERY/400 command useAdd result set information to QUSRJOBI & System i NavigatorSTRDBMON - QQI1 fast delete reason codeSTRDBMON - QQI2 result rows for more statementsSTRDBMON - FETCH statements show failures and warningsAdd QSYS2.REMOVE_PERFORMANCE_MONITOR procedureAdd FTRSQLCODE parameter to STRDBMONExtend FTRINTNETA pre-filter on STRDBMON command to work with non-Database clientsExtend STRDBMON to support FTRUSER against group profilesAdd client/server IP address and port number to QSYS2/TCPIP_INFOAutomatic cancel of QSQSRVR jobs when an application is endedQSYS2.DUMP_SQL_CURSORS procedureQSYS2.QIBM_SQL_NO_RLA_CANCEL environment variableQSYS2.FIND_AND_CANCEL_QSQSRVR_SQL and QSYS2.CANCEL_SQL proceduresQSYS2.FIND_QSQSRVR_JOBS procedureSQL Server Mixed Mode for Batch ProcessingDirectory of worldwide contacts

智能索引记录