This double session will: share lessons learned, surprises, pitfalls; provide hints and tips; address some myths; provide additional planning information; provide usage guidelines and positioning on new enhancements; Help customers migrate to Db2 z/OS 12 as fast as possible, but safely.
This session will introduce and discuss the features and functions of Db2 11 and 12 for z/OS for system running which involve a trade off of using larger size real memory allocation in order to reduce CPU resource consumption.
In the modern days, we expect the database to do majority of the operations in-memory. In reality though, very often the performance and effectiveness of input-output operations is crucial for the throughput of the system. DB2 database does IO operations in multiple ways: doing direct reads/writes, asynchronously via prefetches and page cleaners, skipping or not … Czytaj dalej
What you will be learning in the Hands On Lab (HOL) ———————————— This HOL introduces and discusss the features and functions of OMEGAMON XE for DB2 Performance Expert on z/OS (OMPE). The idea of this HOL is to cover almost all parts of OMPE. Because it is almost impossible to execute all exercises in the … Czytaj dalej
Analityczny SQL, czyli: jak uzyskać sumy narastające i średnie kroczące. jak wyznaczyć prędkość i dynamikę zmian sprzedaży jak uzyskać efekt tabeli przestawnej ..wyłącznie przy użyciu SQL, bez konieczności używania arkusza kalkulacyjnego.
Abstract Java is not a new technology, Java Stored Procedures were introduced to DB2 for z/OS in version 7. With the recent z13 and its Java improvements, the use of this technology might be extended. Let’s review the basic concept of Java Stored Procedures in DB2 for z/OS in this presentation, discuss how to write … Czytaj dalej
This session looks at how you FIND performance problems, or more specifically, how you can eliminate DB2 problems from everyone elses. There is no need to spend exhaustive time looking for a DB2 problem only to find the solution lies somewhere else. So how can you QUICKLY (and easily) deflect attention when it is not … Czytaj dalej
We always assume thet tuning, and thius saving cpu, will result in actual monetary savings Well, with IBMs Measured Workload Pricing this is not the case – we need to target our tuning at specific times of the month to see real value This presentation starts by explaining how IBMs MLC works in practice and … Czytaj dalej
Prezentacja mowiaca o czym nalezy pamietac na etapie przygotowania aby proces recover przebiegl plynnie. Nie zabraknie rozwazan na temat recover dla Catalog & Directory, BSDS oraz FlashCopy Backup oraz Backup System. Prezentacja bedzie doskonala okazja do dyskusji na temat temat dobrych praktyk w obszarze backup & recover.
A SQL Dojo is a meeting where a bunch of developers, DBA and SYSPROGS get together to work on a number of SQL challenges. They are there to have fun and to engage in a group effort in order to improve their skills in a noncompetitive, collaborative, fun environment. The goal is to have practical … 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.