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: 48372 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: 5708 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: 41681 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: 4495 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: 15181 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: 3531 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: 13675 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: 4171 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: 9861 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: 4032 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: 1284 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: 4240 Themis Education
Using REXX with DB2
 
01:03:41
David Simpson discusses using REXX with DB2 for z/OS to build custom scripts.
Views: 2368 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: 2004 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: 6966 Themis Education
New Features of Java 8
 
01:00:38
Themis instructor Gregg Lippa discusses what's new in Java 8.
Views: 1768 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: 1808 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: 1855 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: 1787 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: 1270 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: 1169 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: 2714 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: 918 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: 1217 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: 794 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: 3396 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: 2960 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: 1981 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: 1005 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: 725 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: 1538 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: 627 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: 2031 Themis Education
DB2 10 Discussion by Themis Education
 
08:51
Themis Instructors Linda Claussen and David Simpson discuss new features in DB2 10 for z/OS as well as migration considerations. http://www.themisinc.com
Views: 1093 Themis Education
Using Db2 for z OS Profile Tables
 
50:14
Themis instructor and DBA Linda Claussen steps us through the use of Db2's Profile Tables to monitor and control our Db2 for z/OS environment. Slides available at www.themisinc.com/webinars
Views: 193 Themis Education
IBM MQ Performance Topics
 
49:34
Themis CTO Tom Dunlap discusses some performance considerations for IBM MQ.
Views: 1084 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: 323 Themis Education
Powerful Oracle 12c SQL Features FREE Webinar
 
53:24
Themis instructor John Mullins presents Oracle 12c Features related to SQL development. Find John's presentation and more at http://www.themisinc.com/webinars
Views: 1184 Themis Education
Oracle PL/SQL Best Practices Part 2
 
46:29
Themis instructor John Mullins provides more great tips on Oracle PL/SQL!
Views: 1264 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: 239 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: 455 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: 294 Themis Education
Database Programming with Java
 
50:26
Themis instructor Gregg Lippa presents Java programming with JDBC.
Views: 471 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: 531 Themis Education
Digging Deep Into Oracle PL/SQL Compiler Warnings
 
40:07
Gain an understanding of the Oracle PL/SQL compiler warnings and how to enable them with Themis instructor John Mullins.
Views: 377 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: 491 Themis Education
Java and Database Interaction
 
08:40
Themis instructors Gregg Lippa (Java) and David Simpson (Databases) discuss the interaction between Java and back end databases. Concepts of object relational mapping and SQL tuning in Java are discussed. http://www.themisinc.com
Views: 196 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: 209 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: 582 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: 42 Themis Education

Kevin bridges story continues online dating
Here!
Jazz fm vilnius online dating
Here!
Marcus online dating tv show