As DB2 z/OS catalog/directory has LOB columns since V10, we may have LOB/data corruption issues on cat/dir. And cat/dir is system tablespaces, we can’t use standard recovery technique to fix the LOB/data corruption. This topic will show how to deal with it on real life examples.
Many companies have started using Agile development methods which also requires an Agile infrastructure. The DevOps practice advocates automation and continuous testing. The demand for automation requires DBAs to help create services that can be used by developers. Unfortunately, the preferred interface is not ISPF, but RESTful… Learn how to use the no-charge z/OS Management … Czytaj dalej
Join DBI Software for this unique, educational, informative, and enlightening presentation on DB2 LUW Performance Monitoring and Tuning. Discover how to make SAP, PeopleSoft, Siebel, e-Commerce, Sterling Commerce, JD Edwards, and many other applications run 4X faster in less than 24 hours while slashing or avoiding hardware and license costs and saving incalculable, invaluable time. … Czytaj dalej
Whenever a DBA has an index they want to create to solve a performance issue, there is often someone raising an objection “But will this new index cause the database/application any harm?” For those that desire to successfully create indexes with confidence, this session will present a new method for predictively measuring the impacts of … Czytaj dalej
Building on Sage Advice Part 1, once you know what the worst problems are within a Db2 LUW database, you need to find the best solutions to remedy those problems. This presentation teaches how to evaluate effectiveness of various potential solutions so that optimal solutions can be implemented with minimal cost and maximum effectiveness.
For years, people have talked about measuring performance by costs, ratios, and other key performance indicators. This presentation explores looking at Db2 LUW Performance in new and important ways so that true problems are discovered and can be focused upon. The first in the Sage Advice series, the presentation teaches how to focus on what … Czytaj dalej
A tall skinny pimple faced teenager sells the most pizzas three years in a row for his Boy Scout Troop, becomes an Eagle Scout, a Fraternity Brother, Radio Shack’s top salesman, a COBOL/VSAM/DB2 developer, a DBA, an MVS Systems Programmer, a father, a Director for the #1 App Vendor to Higher Education, an IDUG … Czytaj dalej
zServiceAdvisor – easier PTF maintenance
Part 1 (15 minutes): 30000ft view on Db2 monitoring interfaces 1.1Build in SQL interfaces: – monreport module – event monitors – administrative routines and views (MON_GET_*) 1.2 Product embeded standalone facilities: – snapshots – db2getsnaps – db2pd – db2top – auditing 1.3 Allude on External products: – IBM InfoSphere Optim Performance Manager (and others) – … Czytaj dalej
By continuing to use the site, you agree to the use of cookies. więcej informacji
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.