This is very similar to an RFE that i submitted for MQTs...ID : 39165'Auth to Refresh Table for MQT'Under Consideration We have the same situation for CLONE Tables. The developers wish to run the EXCHANGE using Dynamic SQL, but the RACF ID that ru...
about 10 years ago
in Db2 for z/OS
0
Not under consideration
[RFE][Diagnostic and Debug-ability] - Audit - Log OS User name in EGO Service Controller audit log
EGO Service Controller Audit logs the EGO user and not the OS account issuing egosh command. Additionally, the EGO user is incorrectly logged when the same OS user logs in on different terminals.
Matrix - Cloudera lastest version integration (CDH5.0)
SDMCC has ordered 70 PowerLinux box plus Symphony, GPFS to run big data analytics application, the application was developped at CDH5.0 (MRv2). Symphony MR to integrate with CDH can bring better performance, reliablity to SDMCC.
Currently a CTE is always being resolved by going back to disk. For example, if the same CTE is reused with in the same query, for each time it is used, it is reading from the disk and processing the entire query. So if it is used 5 times with in ...
[Security and Access Control] Security - Kerberos - Support Kerberos Library outside of default install location
Kerberos libraries are installed in a non starndard location (outside of /lib and /lib64). Setting the LD_LIBRARY_PATH helps except with VEMKD and PEM, which fail to start.
Provide Accelerator systems administrator ability to see & set Incremental Update RSG controls
With Incremental Update now being in it's own resource sharing group (V4), the resource management controls (visible to the systems admin) is ambiguous and not flexible. 1) It does not include the relative percentage impact of the new IU resource ...
When a load utility (other than shrlevel change) performed on an accelerated table, an informational message should be generated to SYSLOG so we can automate related actions regarding the IDAA.If incremental update is not turned on for an accelera...
Query performs poorly due to missing column group statistics
SQL chose hash join instead of index join, and performs poorly. The defect number is "idsdb00496878". It's identified to be an issue of "missing column group statistics". Please help to fix it. Thanks!
We have partitioned by Growth table of size 1.5TB. It is defined in the bufferpool BP2. We noticed that the average row length of the rows is around 2000 and hence by altering the tablespace to BP16K0, each page will contain more rows there by giv...
over 10 years ago
in Db2 for z/OS
1
Not under consideration