IBM iSee Video Blog

image



Short demonstrations of tools, techniques and examples (including working SQL examples!!) to help you solve real problems that are part of your everyday work.  Presented by Scott Forstie and Tim Rowe, IBM

 

Search by Category
Search by Format
Sort By
  • Contains 2 Component(s)

    ​ In this session Scott and Tim have some fun with Rest APIs

     In this session Scott and Tim have some fun with Rest APIs. The IBM i operating system has a built in Rest API engine combined with SQL you have a simple powerful way to call a Rest API out in the InterWeb.  Yea… this means that you can do this with RPG and COBOL by simply imbedding the SQL in your ILE programs. We show you a fun API that returns a ‘Dad joke’.  Think of how that can be used!!!  Add a fun bit of humor to your application!  Then we dive in looking at Geo position data.  Using a street address, find your geo-location.  Last we really spice it up but showing you a simple service that can be leveraged to send text messages to your phone from the IBM i!!!   Bet you cant do that with your AS/400….

    Tim Rowe

    Business Architect Application Development & Systems Management for IBM i

    Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

    Scott Forstie

    Db2 for i Business Architect

    Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

    Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

  • Contains 2 Component(s)

    This iSee looks at the active jobs and IFS and shows some pretty interesting details.​

    Recently, we had an IBM i administrator ping us with a request from an Auditor. They needed to find out all the jobs on the system that were using the IFS, and then of course more specially, what in the IFS! So Scott dove into his toolbox of SQL services to answer this question and more!  This iSee looks at the active jobs and IFS and shows some pretty interesting details.

    Tim Rowe

    Business Architect Application Development & Systems Management for IBM i

    Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

    Scott Forstie

    Db2 for i Business Architect

    Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

    Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

  • Contains 2 Component(s)

    In this iSee video Scott and Tim are going to tackle the topic of understanding what is in your libraries and IASP

    In this iSee video Scott and Tim are going to tackle the topic of understanding what is in your libraries and IASP. We get asked on a regular basis, Can I tell how large a library is? What is the biggest object in the library ?  Should I be concerned about what’s filling up my IASP ?  We are going to explore some interesting options for diving in and seeing if you have cute little space cruisers, or huge ugly galactic monsters hiding in your libraries. As always, we are providing the SQL so you can adjust to meet your specific needs.

    Tim Rowe

    Business Architect Application Development & Systems Management for IBM i

    Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

    Scott Forstie

    Db2 for i Business Architect

    Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

    Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

  • Contains 2 Component(s)

    For this session many make use of the information provided in the DSPFD - Display File Description CL Command. Now, for sure there is useful information in that, but in this session we are going to take a closer look at what database catalogs have to offer.

    Like many of these videos we want to show you something new, not just for the sake of new.. but because its better. For this session many make use of the information provided in the DSPFD - Display File Description CL Command.  Now, for sure there is useful information in that, but in this session we are going to take a closer look at what database catalogs have to offer. I think after we are done, you will agree they are a true treasure chest of goodness. 

     

    Tim Rowe

    Business Architect Application Development & Systems Management for IBM i

    Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

    Scott Forstie

    Db2 for i Business Architect

    Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

    Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

  • Contains 1 Component(s)

    This session will help you first, find the Health Center, and more importantly help you see why its a must to keep the "heart of the system" beating in a happy rhythm.

    The Db2 for i Health Center helps you with understanding and keeping your database healthy and happy. If you have used this interface in the past, it was part of the Heritage Navigator interface, but won't be found in the New Navigator as database features are found within IBM i Access Client Solutions (ACS).


    So, where do you look within ACS to find the Db2 Health Center? This session will help you first, find the Health Center, and more importantly help you see why its a must to keep the "heart of the system" beating in a happy rhythm.

    Tim Rowe

    Business Architect Application Development & Systems Management for IBM i

    Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

    Scott Forstie

    Db2 for i Business Architect

    Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

    Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

  • Contains 2 Component(s)

    In this iSee we give/show you how to search the IFS for a specific object name.

    How do you find things in IFS ?  There is an amazing service for this.  In this iSee we give/show you how to search the IFS for a specific object name.  This was made important by the recent security issue sounding Log4J.  This iSee will show you how to find all reference to this in your IFS.  Help you identify applications that need to be resolved. 

    Tim Rowe

    Business Architect Application Development & Systems Management for IBM i

    Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

    Scott Forstie

    Db2 for i Business Architect

    Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

    Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

  • Contains 2 Component(s)

    In this iSee, we will look at an automated way to create a set of views over a number of physical files.

    When is comes to modernizing your applications, it can be a very daunting task.  This also include modernizing your data. We know that there are still many physical files out in the wild and converting them to a new DDL based table while can be very freeing, is a huge task. The good news, is using Views, you can start to unlock that data and not have to also modernize that applications that have been using these physical files.  In this iSee, we will look at an automated way to create a set of views over a number of physical files. This will not only give you this automated process, but we then also talk about leveraging these View in new ways. 

    Tim Rowe

    Business Architect Application Development & Systems Management for IBM i

    Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

    Scott Forstie

    Db2 for i Business Architect

    Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

    Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

  • Contains 2 Component(s)

    This iSee is really a template that you could use to watch and monitor growth of not just Journal, but pretty much anything you might find interesting. We are putting Temporal tables to work in a practical way.

    We all have Journal Receivers, and I am sure you all at some point have wondered how large are they. Which of course is nice to know, but what if you could watch the and monitor the growth of your Journals over time.... Now, that might not only be investing, but could prove enlightening! In this session, Scott and Tim look at how to solve this problem. This iSee is really a template that you could use to watch and monitor growth of not just Journal, but pretty much anything you might find interesting.  We are putting Temporal tables to work in a practical way.  This video shows you how simple it is to accomplish.  When you are done you have working framework, today showing Journal receiver growth, but easily leveraged for your favorite topic in the future. 

    Tim Rowe

    Business Architect Application Development & Systems Management for IBM i

    Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

    Scott Forstie

    Db2 for i Business Architect

    Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

    Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

  • Contains 2 Component(s)

    In this iSee we will unwrap how to use a CL command that only creates spool data, use some nifty SQL to pull part that spool file to build a table with the data we are after. This iSee while sure it give you the printer devices, its far more, its a learning guide to some very powerful SQL techniques

    Today there is NO SQL service for getting the list of printer devices.  If you want to automatically integrate you devices.. its just not easy.  One of our ISV asked us is there a way to do that with SQL.  At first the thought was no...there is no SQL services.  BUT, upon review we thought, we have a toolbox of services that can be used and if you combine a few...walla!   You have your list devices in an automated manner.  In this iSee we will unwrap how to use a CL command that only creates spool data, use some nifty SQL to pull part that spool file to build a table with the data we are after.  This iSee while sure it give you the printer devices, its far more, its a learning guide to some very powerful SQL techniques

    Tim Rowe

    Business Architect Application Development & Systems Management for IBM i

    Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.

    Scott Forstie

    Db2 for i Business Architect

    Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

    Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

  • Contains 2 Component(s)

    In this session Scott and Tim will play with a few of these newer SYSTOOLS showing you how they work and what they can do for you.

    When you buy a car, often its the accessaries that help make the car easier to driver, more fun, comfortable, in short it makes better.  Your IBM i is no different, there are all sort of 'Accessories' that have been added to the operating system. One of these best kept secrets is SYSTOOLS.  The database team continues to deliver some pretty interesting tools that can help you with gaining a better understanding of the system in some cases, better security practices, or just help you with general system management in faster and better ways. In this session Scott and Tim will play with a few of these newer SYSTOOLS showing you how they work and what they can do for you.

    Scott Forstie

    Db2 for i Business Architect

    Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

    Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.

    Tim Rowe

    Business Architect Application Development & Systems Management for IBM i

    Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development. He has a passion for modernization on IBM i and how we can continue to move IBM i into the world of 'Normal' . In his spare time he is a certified Soccer referee and enjoys refereeing games with his youngest son.