V12 Migration Planning and Very Early Customer Experiences

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.  

Everything You Wanted to Know About (DB2) IO But Were Afraid to Ask

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

OMEGAMON Db2 – Hands on Lab workshop

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

Zaawansowane możliwości analizy danych w języku SQL dla DB2

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.

Java Stored Procedures in DB2 for z/OS

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

Solving DB2 Performance Problems

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

How to save REAL dollars with SQL Tuning

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

What should you be aware of before your manager asks you to recover lost data?

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.

Fun with SQL

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.

Zamknij