Join us for subject matter expert webinars
Accessing Non-Relational Data Using SQL
In this webinar, Dan will discuss the use of the system catalog views SYSPARTITIONINDEXSTAT, SYSPARTITIONSTAT and SYSPROGRAMSTAT as shortcuts to the good stuff. In addition, Dan will cover the process of combining the Open List APIs and the SQL User Defined Table Function (UDTF) support to create your own set of system views over nonrelational data (ie objects, spool files, messages, etc).
Presented by IBM's Dan Cruikshank
Watch the Webinar Recording
Download the Presentation
Download
a zip file containing both RPG and COBOL examples of creating the UDTF based on the Open List APIs
Integrated File Systems: Advanced Topics
Are you familiar with the fundamentals of the IFS and want to learn more? Then this advanced topics web session is for you.
Margaret will cover topics designed to help you use the integrated file system more effectively and efficiently.
In this webinar we'll cover:
** user-defined file systems; object usage tracking; retrieving
** object attribute information; national language support; virus
** scanning; file system performance and maintenance; powerful IFS APIs
** commands; features added for 6.1; and more.
Presented by IBM's Margaret Fenlon
Watch the Webinar Recording
Download the Presentation
DB2 for i Autonomic Index Advice - Garbage or Gospel?
DB2 for i is the premier DBMS in terms of integration, ease of use and low total cost of ownership. In support of these attributes, DB2 for i has for years provided index advice for queries both simple and complex. This elegant feature has been a mystery as well as a source of joy and confusion for many users.
In this webinar we will review and explain the index advice mechanism and behavior, and sort out whether the information provided by DB2 for i is gospel or garbage.
Presented by IBM's Mike Cain
Watch the Webinar Recording
Download the Presentation
iSeries Capacity Planning Gotchas
Capacity planning for the System i is not for the faint hearted. There are many gotchas that you have to be aware of. David will introduce you to the methodology he has developed over many years of experience and give you some tips and techniques to help you address these gotchas yourself.
Presented by David Pickett
Watch the Webinar Recording
Download the Presentation
Partition Resource Utilization and IBM i Performance
Performance Analysis and Capacity Planning are integral parts of System Management enabling IT to meet its service level commitments to its users.
Presented by Lloyd Perera
Watch the Webinar Recording
Download the Presentation
System Storage and the IBM i
As the IBM i weans itself from the traditional integrated storage to SAN storage, many IBM i specialists are perplexed and concerned about migrating. Their issues are a result of their limited knowledge of the solutions that are available to them.
Presented by IBM's Chuck Stupca
Watch the Webinar Recording
Download the Presentation
