Home
Videos uploaded by user “Themis Education”
Interpreting Oracle Explain Plan Output - John Mullins
 
01:00:16
Themis Instructor John Mullins presents some details on interpreting Oracle Database Explain Plan output. For more information visit http://www.themisinc.com
Views: 50364 Themis Education
20 Essential Oracle SQL and PL/SQL Tuning Tips
 
01:11:53
SQL and PL/SQL are powerful languages used to access an Oracle database. Today's databases contain mountains of data which presents itself as a challenge when trying to get to the data we want to in a timely fashion. In this FREE Webinar, OCP DBA John Mullins will present 20 valuable tips to help your SQL or PL/SQL perform better. The tips cover every angle regarding SQL and PL/SQL performance, making the presentation suitable for all job roles. Demonstrations will be used to support many of the tips and Oracle 11g and 12c will be covered.
Views: 43748 Themis Education
Advanced Query Tuning with IBM Data Studio by Themis Education
 
06:18
A few minutes of the Themis course "Advanced Query Tuning with IBM Data Studio" presented by Tony Andrews. Produced by Curl Films. http://www.themisinc.com/CourseDetail.aspx?id=DB1032 http://www.curlfilms.com
Views: 3581 Themis Education
Native SQL Stored Procedures on DB2 for z/OS
 
13:51
Themis instructors Linda Claussen and David Simpson discuss the use of native SQL PL stored procedures in DB2 9 and DB2 10. http://www.themisinc.com
Views: 5814 Themis Education
Static SQL on DB2 for z/OS Packages, Collections and Plans, Oh my! - David Simpson
 
57:52
Static SQL has long been a mainstay of DB2 development on z/OS. The infrastructure that supports static SQL is robust but sometimes confusing. If you've ever been confused by what happens in a BIND or you don't know what a collection is, this webinar is for you! Themis instructor David Simpson presents this webinar.
Views: 4810 Themis Education
Five Oracle 12c SQL, PL/SQL New Features To Take Advantage Of - John Mullins
 
53:01
Themis instructor John Mullins talks PL/SQL features in Oracle 12c.
Views: 16063 Themis Education
DB2 Optimization, Performance and Tuning by Themis Education
 
08:04
A few minutes of the Themis course "DB2 for z/OS Optimization, Performance and Tuning" presented by Tony Andrews. Produced by Curl Films. http://www.themisinc.com/CourseDetail.aspx?id=DB1032 http://www.curlfilms.com
Views: 13869 Themis Education
Troubleshooting Oracle PL/SQL with DBMS_PROFILER and DBMS_UTILITY
 
45:44
Themis instructor John Mullins helps you gain an understanding of how to use the Oracle PL/SQL dbms_profiler and dbms_utilitypackages to troubleshoot and handle PL/SQL performance issues, program errors and exceptions.
Views: 4328 Themis Education
CICS-TS Web Services Overview
 
54:42
In this 1 hour webinar industry expert Tom Dunlap provides an overview of using CICS as a server for Web Services.
Views: 10151 Themis Education
Influencing Oracle SQL Execution Plans
 
51:50
Themis instructor John Mullins discusses Oracle SQL Execution plans and how you can influence them for better SQL performance.
Views: 2126 Themis Education
CICS Storage Violations; what you were afraid to ask
 
48:06
This session will cover some of the common causes plus some lesser know causes for storage violations in a CICS environment. We will begin the session with a quick review of the CICS options, features and storage management techniques which allow CICS to detect and somewhat handle storage violations. We will then look at a few application programming techniques which can result in storage violations. After which we will have a look at the system dumps resulting from a storage violation and how to potentially resolve them. All of this will be fast paced to fit in the time allotted but the handout will have notes backing each topic covered as a take-away for later use at your site. While we cannot cover all of the possibilities in a single session, we can provide a little bit of a methodology plus some diagnostic tips for you to use. You should also gain some insight into some considerations for what a storage violation could mean to your site.
Views: 1332 Themis Education
Oracle PL/SQL Best Practices Part 1
 
46:53
Themis instructor John Mullins helps you become familiar with best practices when coding Oracle PL/SQL best practices. Examples of before and after are provided.
Views: 4439 Themis Education
Developing Java Applications for z/OS Batch Execution
 
47:03
Java applications today may be run as batch applications on the mainframe. While traditional mainframe programmers are well-versed in using COBOL and JCL, there are a few twists when it comes to batch programs written in Java. In this FREE Webinar, Gregg Lippa brings his 30 years of experience in both mainframe and distributed environments to provide some perspective on how Java applications can be run as batch jobs. How do I use JCL to trigger execution? How does Java access flat files and VSAM files? What is USS (HFS) and how does it figure into batch Java? Can I use RAD or Eclipse for the development environment? What capabilities exist to support debugging the application? What is ANT and what role does it play? What other tools and frameworks are available to assist with the development of batch Java applications? This 45 minute long webinar by Themis instructor Gregg Lippa is designed to help you understand Java coding in a batch processing environment.
Views: 4441 Themis Education
Using REXX with DB2
 
01:03:41
David Simpson discusses using REXX with DB2 for z/OS to build custom scripts.
Views: 2457 Themis Education
IBM MQ Clustering - Tom Dunlap
 
55:22
As your number of queue managers grows, so does your management time needed to implement and maintain this configuration. By using the clustering feature of IBM MQ you can minimize the effort necessary to add and maintain queue managers and their configurations. To download the slides and review other webinars visit: http://www.themisinc.com/webinars
Views: 7165 Themis Education
Modernizing Mainframe Development Using Java
 
53:57
Themis instructor Gregg Lippa talks about the use of Java in a z/OS (Mainframe) environment.
Views: 1911 Themis Education
New Features of Java 8
 
01:00:38
Themis instructor Gregg Lippa discusses what's new in Java 8.
Views: 1836 Themis Education
Enhanced Production Explain Tables in DB2 11 for z OS
 
59:15
Themis instructor Linda Claussen takes you through the "extra" information you get as part of an Explain in DB2 11 for z/OS.
Views: 1858 Themis Education
What do you mean the Oracle Optimizer won't use my Index
 
47:15
Learn some details about how the Oracle optimizer works with Themis instructor John Mullins.
Views: 813 Themis Education
What to Expect from DB2 11 for z OS
 
45:13
This 45 minute session is intended for Database Administrators and System Administrators and will give you an overview of what you can expect when you migrate to DB2 11. We will cover some of the most important migration survival items as well as some of the new features that you will be able to use shortly after you migrate. David Simpson is currently a Senior Technical Advisor at Themis Inc. He teaches courses on SQL, Application Programming, Database Administration as well as optimization, performance and tuning. He also installs and maintains the database systems used for training at Themis. Since 1993 David has worked as a developer and DBA in support of very large transactional and business intelligence systems. David is a certified DB2 DBA on both z/OS and LUW. David was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006 and is a member of the IDUG Speakers Hall of Fame.
Views: 2792 Themis Education
CICS Db2 Interface
 
01:07:26
You have become a seasoned CICS application technical support person or system administrator but you have been avoiding looking at the CICS/Db2 interface and its options. If this is the case, then this webinar is just the thing for you. After a very quick overview of the interface, we will dive into the CICS resources and their options with an eye toward performance. We will also take a look at the Db2 command interface within the CICS region along with their use in problem solving or performance tuning. If that is not enough, we will walk through CICS trace data with an associated application to profile its use of Db2. All in all we hope to provide you with the knowledge and confidence to begin working with the interface. However, we cannot cover all aspects of problem solving or performance tuning but we can give you a good start in one short hour.
Views: 1268 Themis Education
CICS TS MQ Interface
 
51:37
You have become a seasoned CICS application technical support person or system administrator but you have been avoiding looking at the CICS / MQ interface and its options. Then this webinar is just the thing for you. After a very quick overview of the interface, we will dive into the CICS resources and their options with an eye toward performance. We will also take a look at the MQ command interface within the CICS region along with their use in problem solving or performance tuning. If that is not enough, we will walk through CICS trace data and MQ application trace data with an associated application to profile its use of MQ. All in all we hope to provide you with the knowledge and confidence to begin working with the interface. However, we cannot cover all aspects of problem solving or performance tuning but we can give you a good start in one short hour.
Views: 1086 Themis Education
DB2 SQL for the 21st Century - Part 2
 
38:53
In this webinar Themis instructor David Simpson talks about the use of OLAP functions, Moving Aggregates and Advanced Grouping in recent releases of DB2.
Views: 641 Themis Education
DB2 SQL for the 21st Century - Part 1
 
41:34
In this webinar Themis instructor David Simpson talks about the use of table expressions and recursion in SQL for DB2.
Views: 1911 Themis Education
Cross Platform SQL: Complex Queries by Themis Education
 
08:17
A few minutes of the Themis course "Cross Platform SQL: Dealing with Complex Queries" presented by David Simpson. Produced by Curl Films. http://www.themisinc.com/CourseDetail.aspx?id=SQ1010 http://www.curlfilms.com
Views: 1276 Themis Education
REXX Parse Keyword - Gerhard Adam
 
55:30
Themis instructor Gerhard Adam discusses the use of the PARSE command in the REXX language.
Views: 1282 Themis Education
CICS Transaction Dump Analysis
 
53:00
So it has been a while since you have looked at a CICS transaction dump or maybe never. In this one hour long webinar we will provide the most amount of information possible in the short time period about how to analyze the transaction dump. Our focus will be on a standard CICS dump and not using any tool like Fault Analyzer or Abend-Aid. While we cannot provide a complete solution to the application problem in detail, we will cover the key topics of interest for both Enterprise COBOL V4 and V5. While the information presented will be complete, it cannot be thorough like a class setting due to the limited time allowed. Rest assured that if you have the need for a complete understanding of this process, we do offer complete CICS application debugging classes
Views: 2216 Themis Education
Developer Best Practices for DB2 Performance
 
45:48
Themis instructor Tony Andrews talks through some critical SQL performance topics for DB2 Developers in this 45 minute webinar.
Views: 1990 Themis Education
DB2 SQL Tuning Tips for Developers
 
55:05
More DB2 SQL Tuning tips from industry expert and Themis instructor Tony Andrews. Some Q&A with the live audience at the end.
Views: 3172 Themis Education
Unit Testing in Java with JUnit
 
49:58
Themis instructor Gregg Lippa discusses the importance of developing test plans and the use of JUnit for testing Java applications. Find more webinars at: www.themisinc.com/webinars
Views: 1084 Themis Education
Advanced SQL and the Power of Rewriting Queries
 
48:43
Themis instructor Tony Andrews walks you through different ways to write common SQL statements that will yield the same results but may perform differently.
Views: 3473 Themis Education
Oracle PL/SQL Best Practices Part 2
 
46:29
Themis instructor John Mullins provides more great tips on Oracle PL/SQL!
Views: 1376 Themis Education
Native SQL PL Error Logging on DB2 for z/OS
 
37:49
This 45 minute session is intended for DB2 for z/OS Developers and Database Administrators and will give you a detailed approach to Native SQL Procedure error handling and error logging. We will cover the GET DIAGNOSTICS and asynchronous error logging methods. The presenter is Linda Claussen. Linda is currently a Senior Technical Advisor at Themis Inc. She teaches courses on SQL, Application Programming, Database Administration, Systems Administration as well as performance tuning. Linda's 40+ years of experience spans the various roles of application developer, project manager, Data Base Administration and Systems Programmer. Linda is a certified DB2 DBA and Systems Administrator. Linda is a past member of the IBM DB2 GOLD Consultants program, a current member of the IBM consultants advisory counsel and frequent speaker at IDUG and DB2 User Groups.
Views: 839 Themis Education
Oracle 12c New Feature Spotlight Synchronous Refresh for Materialized Views
 
54:18
Materialized views can perform a number of roles, such as improving query performance or providing replicated data. Prior to Oracle 12c, materialized views used traditional refresh methods where changes were applied to the base tables and then the materialized views were refreshed separately with one of several methods. Synchronous refresh is a new approach in Oracle 12c R1 for maintaining tables and materialized views where tables and materialized views are refreshed at the same time. This webinar will discuss the benefits of the synchronous refresh method along with how to implement it.
Views: 504 Themis Education
IBM MQ Performance Topics
 
49:34
Themis CTO Tom Dunlap discusses some performance considerations for IBM MQ.
Views: 1152 Themis Education
IBM MQ Publish and Subscribe
 
54:18
Themis instructor Tom Dunlap discusses Publish and Subscribe for IBM MQ in this free webinar.
Views: 1697 Themis Education
Minimize your trips to DB2 for z/OS and reduce your elapsed and CPU times - Linda Claussen
 
50:56
Themis instructor Linda Claussen discusses coding techniques to improve performance on DB2 for z/OS by making fewer trips to the database.
Views: 249 Themis Education
Db2 Top Reasons for Poor SQL, Program, and Application Performance
 
52:45
SQL tuning expert Tony Andrews is back with more tips on writing Db2 SQL that performs well. Save your organization time and money by writing SQL that performs!
Views: 360 Themis Education
Database Programming with Java
 
50:26
Themis instructor Gregg Lippa presents Java programming with JDBC.
Views: 511 Themis Education
Working with CICS JCICS Applications - Tom Dunlap
 
01:06:33
Themis instructor Tom Dunlap provides a look at necessary processes to develop, deploy, and test JCICS applications in CICS TS. We will show how CICS Explorer SDK is used to develop the class and build the necessary CICS resources including the BUNDLE and MANIFEST. We will also cover the necessary mainframe based resources to deploy the application into, plus the CICS TS resources to execute the application. Lastly, we will take a brief look at the tooling to test the JCICS application within the CICS region.
Views: 562 Themis Education
Db2 User Defined Functions (UDFs)
 
54:14
Find more webinars at https://www.themisinc.com/webinars Themis instructor David Simpson discusses User Defined Functions (UDFs) written in SQL PL. Sample functions are supplied. Download the slides at: https://www.themisinc.com/FileRetrieve.aspx?filenum=58
Views: 368 Themis Education
Access Path Stability on Db2 for z/OS - Best Practices
 
01:03:03
Themis instructor David Simpson reviews the features of DB2 for z/OS that will help ensure performance stability for static SQL.
Views: 194 Themis Education
DB2 12 for z OS, Continuous Delivery!
 
47:37
Themis instructor Linda Claussen discusses the new and improved migration process for DB2 and the prospect of receiving new features in the maintenance stream.
Views: 511 Themis Education
Relative Page Numbering on Db2 for z/OS
 
32:18
Check out this new feature of Db2 12 for z/OS! Relative page numbering can solve lots of problems for very large tables. Themis Instructor David Simpson presents. Visit https://www.themisinc.com/webinars for more content!
Views: 85 Themis Education
Oracle 12c R2 Improvements to the Index Usage Tracking Feature
 
41:44
Oracle 12c R2 adds some nice improvements to its index usage tracking feature. With these improvements, it is now easy to find out how many accesses the indexes have received, how many rows have been returned and the most recent time that the index was used. In this webinar OCP DBA John Mullins will explain and demonstrate the behavior changes, enhancements and usage of this feature. This webinar is a subset of the 4 day Oracle Database Performance Tuning course and the 3 day Oracle SQL Optimization for Developers course offered by Themis. This presentation is meant for Oracle development staff and database administrators. It is delivered by Themis instructor John Mullins.
Views: 221 Themis Education
Enhanced System-Period Temporal Tables on DB2 for z/OS
 
28:48
Watch as Themis instructor Linda Claussen discusses the recent enhancements to System Temporal Tables on DB2 for z/OS.
Views: 222 Themis Education
Oracle 18c New Feature Focus - Private Temporary Tables
 
31:38
Oracle 18c brings us Private Temporary Tables. A Private Temporary Table is stored in memory and is visible only to the session that created it and is dropped at the end of the session or transaction depending on the setup. In this webinar OCP DBA John Mullins will cover the creation and management of Private Temporary Tables along with their benefits and restrictions. In addition, Private Temporary Tables will be compared to Global Temporary Tables. Get the slides from this and other webinars at: https://www.themisinc.com/webinars
Views: 215 Themis Education
Altering Tables with High Availability on Db2 for z/OS
 
46:54
Themis instructor David Simpson discusses the latest ways to evolve Db2 objects while still maintaining high availability.
Views: 98 Themis Education
David Simpson on DB2Night Show™ December 2015
 
53:21
Themis instructor David Simpson discusses the extended RBA/LRSN with Martin Hubel on the DB2Night Show.
Views: 133 Themis Education
Db2 SQL PL Array Parameters and Variables
 
35:57
Db2 11 introduced arrays for SQL PL variables and parameters. Themis instructor Tony Andrews walks you through how to use them.
Views: 652 Themis Education