2 new product(s) added recently

IBM iSee Video Blog

image


image
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 1 Component(s)

    Is your library list a trusted friend or a sneaky saboteur? Somewhere in your compiled programs, SQL is quietly running CL commands through QCMDEXC. If those commands aren't library-qualified, IBM i goes hunting for them through the library list. Anyone who slips a look-alike command in ahead of the real one wins. In this episode of iSee, Scott and Tim turn Db2 for i into a security detective. With just a few lines of SQL against QSYS2.SYSPROGRAMSTMTSTAT, they sniff out the risky spots hiding in your *PGM, *SRVPGM, and *MODULE objects, with no source code required. No extra tools. No installs. Just SQL, a little regex magic, and a list of things you'll probably wish you'd checked sooner. Watch it before the bad guys do.

    Is your library list a trusted friend or a sneaky saboteur? 


    Somewhere in your compiled programs, SQL is quietly running CL commands through QCMDEXC. If those commands aren't library-qualified, IBM i goes hunting for them through the library list. Anyone who slips a look-alike command in ahead of the real one wins.
    In this episode of iSee, Scott  and Tim  turn Db2 for i into a security detective. With just a few lines of SQL against QSYS2.SYSPROGRAMSTMTSTAT, they sniff out the risky spots hiding in your *PGM, *SRVPGM, and *MODULE objects, with no source code required.
    No extra tools. No installs. Just SQL, a little regex magic, and a list of things you'll probably wish you'd checked sooner.


    Watch it before the bad guys do.

    Tim Rowe

    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

    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 [email protected]. Scott is an avid runner and enjoys cooking.

  • Contains 1 Component(s)

    It's Monday morning. A new CVE just dropped. Your boss leans in and asks, "Are we exposed?" CVEs don't take days off, and neither should your patch checking. Before you go digging through bulletins, web pages, and PTF lists, watch this episode of iSee. Scott and Tim unveil the new CVE SQL service. Which vulnerabilities hit your release? Which fixes are you missing? Ask SQL, and get the answer in seconds (ok.. maybe a few mins...) No spreadsheets. No scavenger hunts. Just a few lines of SQL and a very honest report card. Be the person who already knows the answer.

    It's Monday morning. A new CVE just dropped. Your boss leans in and asks, "Are we exposed?"

    CVEs don't take days off, and neither should your patch checking. Before you go digging through bulletins, web pages, and PTF lists, watch this episode of iSee. Scott  and Tim  unveil the new CVE SQL service. Which vulnerabilities hit your release? Which fixes are you missing? Ask SQL, and get the answer in seconds (ok.. maybe a few mins...)

    No spreadsheets. No scavenger hunts. Just a few lines of SQL and a very honest report card.

    Be the person who already knows the answer.

    Tim Rowe

    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

    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 [email protected]. Scott is an avid runner and enjoys cooking.

  • Contains 1 Component(s)

    Have you ever wanted to see the entry-specific portion of a data journal presented in a user-friendly manner? Great news! Scott spent the cold Minnesota winter building a new SQL Service that allows you to establish data journal "readers" for your favorite database files. In this video, Scott and Tim demonstrate how to use the service, walk through the SQL, and show how you can quickly gain insight into your journaled data.

    Have you ever wanted to see the entry-specific portion of a data journal presented in a user-friendly manner? Great news! Scott spent the cold Minnesota winter building a new SQL Service that allows you to establish data journal "readers" for your favorite database files. In this video, Scott and Tim demonstrate how to use the service, walk through the SQL, and show how you can quickly gain insight into your journaled data.

    Tim Rowe

    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

    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 [email protected]. Scott is an avid runner and enjoys cooking.

  • Contains 1 Component(s)

    CVEs continue to gain momentum, and keeping your systems secure is more important than ever. But how do you determine which CVEs affect your IBM i environment? Great news! Scott has been at it again, and a new SQL Service has been delivered that allows you to use SQL on your IBM i to discover relevant CVEs. In this video, Scott and Tim show how the service works and how it can help you quickly identify CVEs that matter to your systems.

    CVEs continue to gain momentum, and keeping your systems secure is more important than ever. But how do you determine which CVEs affect your IBM i environment? Great news! Scott has been at it again, and a new SQL Service has been delivered that allows you to use SQL on your IBM i to discover relevant CVEs. In this video, Scott and Tim show how the service works and how it can help you quickly identify CVEs that matter to your systems.

    Scott Forstie

    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 [email protected]. Scott is an avid runner and enjoys cooking.

    Tim Rowe

    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.

  • Contains 1 Component(s)

    In this episode, we turn toward the database. We dive into commitment control, what a great topic! We learn a little about what this is all about but then learn how to treat database transactions from a systems management perspective. Watch this episode to understand the core knowledge around transactions and leave with some handy SQL to better monitor and manage this important topic.

    In this episode, we turn toward the database. We dive into commitment control, what a great topic! We learn a little about what this is all about but then learn how to treat database transactions from a systems management perspective. Watch this episode to understand the core knowledge around transactions and leave with some handy SQL to better monitor and manage this important topic.

    Tim Rowe

    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

    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 [email protected]. Scott is an avid runner and enjoys cooking.

  • Contains 1 Component(s)

    Welcome to IBM Bob. To celebrate the general availability of IBM Bob, Scott and Tim put Bob through its paces, taking some SQL, creating design documents, asking for coding improvements, and even getting Bob to write some new SQL. Bob is ready to be your IBM i development partner.

    Welcome to IBM Bob. To celebrate the general availability of IBM Bob, Scott and Tim put Bob through its paces, taking some SQL, creating design documents, asking for coding improvements, and even getting Bob to write some new SQL. Bob is ready to be your IBM i development partner. 

    Tim Rowe

    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

    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 [email protected]. Scott is an avid runner and enjoys cooking.

  • Contains 1 Component(s)

    Speaking of hidden gems, this one is a gem within the gem. Imagine being able to find and review all the SQL that is coded within your programs (*PGM) and service programs (*SRVPGM). You not only discover the SQL statements and how they are being presented to the database, you can leverage this capability for real-time impact analysis, and so much more! This episode leverages the power of some database statistical catalogs, along with an SQL interface into the SQL Parser, that provides an amazing view of the SQL used within your applications.

    Speaking of hidden gems, this one is a gem within the gem. Imagine being able to find and review all the SQL that is coded within your programs (*PGM) and service programs (*SRVPGM). You not only discover the SQL statements and how they are being presented to the database, you can leverage this capability for real-time impact analysis, and so much more!  This episode leverages the power of some database statistical catalogs, along with an SQL interface into the SQL Parser, that provides an amazing view of the SQL used within your applications. 

    Tim Rowe

    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

    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 [email protected]. Scott is an avid runner and enjoys cooking.

  • Contains 1 Component(s)

    Spreadsheets, seems everyone loves them. So, instead of fighting it, let’s automate it! In this iSee we will explore how to gather your favorite data and get it loaded into a spreadsheet that can be happily emailed right to your inbox. This support is all available on your IBM I…so it’s ready for you to put it to work.

    Spreadsheets, seems everyone loves them. So, instead of fighting it, let’s automate it!  In this iSee we will explore how to gather your favorite data and get it loaded into a spreadsheet that can be happily emailed right to your inbox. This support is all available on your IBM I…so it’s ready for you to put it to work. 

    Tim Rowe

    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

    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 [email protected]. Scott is an avid runner and enjoys cooking.

  • Contains 1 Component(s)

    Managing work on the IBM i can sometimes be a challenge. Like making sure that a particular job or user does not impact the rest of the production system. There are many ways this can be accomplished, but one of the best and easiest must be Server Subsystem Routing. What if when a job enters the system the operating system could inspect the user, group profile, or even the IP Address the request is coming from and put that job into its own special subsystem and memory pool. That would be pretty slick, best part, that support already exists! In this iSee we show you how to set it up and make it work. Ever wondered every thing needed to create a new subsystem ? Check the Script! All the commands are there for you!!

    Managing work on the IBM i can sometimes be a challenge. Like making sure that a particular job or user does not impact the rest of the production system. There are many ways this can be accomplished, but one of the best and easiest must be Server Subsystem Routing. What if when a job enters the system the operating system could inspect the user, group profile, or even the IP Address the request is coming from and put that job into its own special subsystem and memory pool.  That would be pretty slick, best part, that support already exists!  In this iSee we show you how to set it up and make it work.  Ever wondered every thing needed to create a new subsystem ? Check the Script! All the commands are there for you!! 

    Tim Rowe

    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

    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 [email protected]. Scott is an avid runner and enjoys cooking.

  • Contains 1 Component(s)

    We had a request come in, is there an ‘easy’ way to hold only the Job Scheduled entries that are in Scheduled state, and later release only those entries that were held in the first step? With SQL, all things are possible. In this episode, Scott and Tim take you step by step through a solution. Even better, the solution is a template that could be used to solve similar problems.

    We had a request come in, is there an ‘easy’ way to hold only the Job Scheduled entries that are in Scheduled state, and later release only those entries that were held in the first step?

    With SQL, all things are possible.

    In this episode, Scott and Tim take you step by step through a solution.

    Even better, the solution is a template that could be used to solve similar problems.

    Tim Rowe

    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

    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 [email protected]. Scott is an avid runner and enjoys cooking.