IBM iSee Video Blog
-
Register
- Member - Free!
- Non-member - Free!
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
Advanced Search This List
-
Contains 1 Component(s)
What ? MFA integrated ? Yes!! With the new IBM i 7.6 release, the operating system now includes support for even higher securability. Every user profile can now leverage MFA. The best part, there is no external servers needed, meaning that it even works when in restricted state! Or from the SST signon screen. Crazy!! In this session we will explore how this support works, and how to configure.
What ? MFA integrated ? Yes!! With the new IBM i 7.6 release, the operating system now includes support for even higher securability. Every user profile can now leverage MFA. The best part, there is no external servers needed, meaning that it even works when in restricted state! Or from the SST signon screen. Crazy!! In this session we will explore how this support works, and how to configure.
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)
We all need to use the IFS, both system management and app dev folks to accomplish a variety of tasks. This iSee shows the many SQL options for dealing with IFS. This includes both Read and Write! This is a revolutionary option, simplify the ability to write to files in the IFS or Read from IFS files using simple SQL statements. This mean you can do all this using embedded SQL within your native RPG and COBOL.
We all need to use the IFS, both system management and app dev folks to accomplish a variety of tasks. This iSee shows the many SQL options for dealing with IFS. This includes both Read and Write! This is a revolutionary option, simplify the ability to write to files in the IFS or Read from IFS files using simple SQL statements. This mean you can do all this using embedded SQL within your native RPG and COBOL.
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)
In this iSee we will show you how to leverage the power of the SQL language to compare the list of libraries on say 2 different systems. Easy see what libraries on only on system 1 or system 2 or what are all the libraries that are different.
In this iSee we will show you how to leverage the power of the SQL language to compare the list of libraries on say 2 different systems. Easy see what libraries on only on system 1 or system 2 or what are all the libraries that are different.
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)
Security… its poking us at every turn. What are the security attributes on your created libraries ? Want to know ? This iSee shows some super fast ways to list all the libraries on the system and review the important security attributes that you really need to take better care of.
Security… its poking us at every turn. What are the security attributes on your created libraries ? Want to know ? This iSee shows some super fast ways to list all the libraries on the system and review the important security attributes that you really need to take better care of.
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)
A customer asked if the temporary storage on their system was climbing to a large number and why it appeared that the database was driving that?
This session dives into the incredible database catalogs to help you see the landscape on your IBM i! We will help you identify how you can tune the database better to maybe avoid some potential pitfalls.
A customer asked if the temporary storage on their system was climbing to a large number and why it appeared that the database was driving that?
This session dives into the incredible database catalogs to help you see the landscape on your IBM i! We will help you identify how you can tune the database better to maybe avoid some potential pitfalls.
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)
Adoption! Well, not the getting a new one.. but rather the scarry security risk of running a job not with your authority… but by adopting additional authority. That may sound like great fun to you, but as an administrator, not sure I want Sally or Joe user out there running and accessing things that they really should not be using. This session will help you take a look at the programs on your system that are using adopted authority. This brilliant SQL-based insight should help you better understand your security posture.
Adoption! Well, not the getting a new one.. but rather the scarry security risk of running a job not with your authority… but by adopting additional authority. That may sound like great fun to you, but as an administrator, not sure I want Sally or Joe user out there running and accessing things that they really should not be using. This session will help you take a look at the programs on your system that are using adopted authority. This brilliant SQL-based insight should help you better understand your security posture.
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)
The IBM i has lots of Devices, hardware, IASPs that need to be understood, reviewed and managed. Sure you can use the Green screen to look at this, but when you need to automate activities, its sure nice to have simple SQL options for checking devices , hardware resources and IASPs. This iSee uncovers these hidden gems to help bring these to life.
The IBM i has lots of Devices, hardware, IASPs that need to be understood, reviewed and managed. Sure you can use the Green screen to look at this, but when you need to automate activities, its sure nice to have simple SQL options for checking devices , hardware resources and IASPs. This iSee uncovers these hidden gems to help bring these to life.
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)
The professor of SQL dives into some pretty powerful building block to help you bring the full power of the SQL language to help solve problems. This example walks though SQL service delivered within SYSTOOL - Spool_File_Data. This SQL is an amazing tool for looking at the contents of spool files, but instead of using this SQL, we will review how its build and how you can leverage this for other SQL tools.
The professor of SQL dives into some pretty powerful building block to help you bring the full power of the SQL language to help solve problems. This example walks though SQL service delivered within SYSTOOL - Spool_File_Data. This SQL is an amazing tool for looking at the contents of spool files, but instead of using this SQL, we will review how its build and how you can leverage this for other SQL tools.
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.
-
Contains 1 Component(s)
With the recent change to how the IBM i operating system is licensed, the chance to subscription license. Its is now more important that ever to make sure you know when your license will expire. With subscription license, your system may stop working someday in the future! Guessing it might be useful to know what. This iSee will explore a few ways that is possible. Some magical SQL as well as updates to the Navigator interface to help make it very clear.
With the recent change to how the IBM i operating system is licensed, the chance to subscription license. Its is now more important that ever to make sure you know when your license will expire. With subscription license, your system may stop working someday in the future! Guessing it might be useful to know what. This iSee will explore a few ways that is possible. Some magical SQL as well as updates to the Navigator interface to help make it very clear.
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)
User Profiles, we all have them, sometimes we have too many! Do you ever have a need to do a mass update of user profiles? The use case for this video was someone that needed to do some sensitive testing and did not want ANYONE to sign in during the test. Easy way to make that happen ? Disable ALL user profiles on the system for a period, and then revert all those changed back. The SQL provided will show you how to build your list of profiles, run the action and then make sure you clean up after. Sure we are showing Disable and Enable, but think of other user cases, you want to force all profiles to reset their password based on new security password rules, this SQL can easily be adopted for that as well.
User Profiles, we all have them, sometimes we have too many! Do you ever have a need to do a mass update of user profiles? The use case for this video was someone that needed to do some sensitive testing and did not want ANYONE to sign in during the test. Easy way to make that happen ? Disable ALL user profiles on the system for a period, and then revert all those changed back. The SQL provided will show you how to build your list of profiles, run the action and then make sure you clean up after. Sure we are showing Disable and Enable, but think of other user cases, you want to force all profiles to reset their password based on new security password rules, this SQL can easily be adopted for that as well.
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)
What ? MFA integrated ? Yes!! With the new IBM i 7.6 release, the operating system now includes support for even higher securability. Every user profile can now leverage MFA. The best part, there is no external servers needed, meaning that it even works when in restricted state! Or from the SST signon screen. Crazy!! In this session we will explore how this support works, and how to configure.
What ? MFA integrated ? Yes!! With the new IBM i 7.6 release, the operating system now includes support for even higher securability. Every user profile can now leverage MFA. The best part, there is no external servers needed, meaning that it even works when in restricted state! Or from the SST signon screen. Crazy!! In this session we will explore how this support works, and how to configure.
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)
We all need to use the IFS, both system management and app dev folks to accomplish a variety of tasks. This iSee shows the many SQL options for dealing with IFS. This includes both Read and Write! This is a revolutionary option, simplify the ability to write to files in the IFS or Read from IFS files using simple SQL statements. This mean you can do all this using embedded SQL within your native RPG and COBOL.
We all need to use the IFS, both system management and app dev folks to accomplish a variety of tasks. This iSee shows the many SQL options for dealing with IFS. This includes both Read and Write! This is a revolutionary option, simplify the ability to write to files in the IFS or Read from IFS files using simple SQL statements. This mean you can do all this using embedded SQL within your native RPG and COBOL.
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)
In this iSee we will show you how to leverage the power of the SQL language to compare the list of libraries on say 2 different systems. Easy see what libraries on only on system 1 or system 2 or what are all the libraries that are different.
In this iSee we will show you how to leverage the power of the SQL language to compare the list of libraries on say 2 different systems. Easy see what libraries on only on system 1 or system 2 or what are all the libraries that are different.
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)
Security… its poking us at every turn. What are the security attributes on your created libraries ? Want to know ? This iSee shows some super fast ways to list all the libraries on the system and review the important security attributes that you really need to take better care of.
Security… its poking us at every turn. What are the security attributes on your created libraries ? Want to know ? This iSee shows some super fast ways to list all the libraries on the system and review the important security attributes that you really need to take better care of.
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)
A customer asked if the temporary storage on their system was climbing to a large number and why it appeared that the database was driving that? This session dives into the incredible database catalogs to help you see the landscape on your IBM i! We will help you identify how you can tune the database better to maybe avoid some potential pitfalls.
A customer asked if the temporary storage on their system was climbing to a large number and why it appeared that the database was driving that?
This session dives into the incredible database catalogs to help you see the landscape on your IBM i! We will help you identify how you can tune the database better to maybe avoid some potential pitfalls.
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)
Adoption! Well, not the getting a new one.. but rather the scarry security risk of running a job not with your authority… but by adopting additional authority. That may sound like great fun to you, but as an administrator, not sure I want Sally or Joe user out there running and accessing things that they really should not be using. This session will help you take a look at the programs on your system that are using adopted authority. This brilliant SQL-based insight should help you better understand your security posture.
Adoption! Well, not the getting a new one.. but rather the scarry security risk of running a job not with your authority… but by adopting additional authority. That may sound like great fun to you, but as an administrator, not sure I want Sally or Joe user out there running and accessing things that they really should not be using. This session will help you take a look at the programs on your system that are using adopted authority. This brilliant SQL-based insight should help you better understand your security posture.
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)
The IBM i has lots of Devices, hardware, IASPs that need to be understood, reviewed and managed. Sure you can use the Green screen to look at this, but when you need to automate activities, its sure nice to have simple SQL options for checking devices , hardware resources and IASPs. This iSee uncovers these hidden gems to help bring these to life.
The IBM i has lots of Devices, hardware, IASPs that need to be understood, reviewed and managed. Sure you can use the Green screen to look at this, but when you need to automate activities, its sure nice to have simple SQL options for checking devices , hardware resources and IASPs. This iSee uncovers these hidden gems to help bring these to life.
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)
The professor of SQL dives into some pretty powerful building block to help you bring the full power of the SQL language to help solve problems. This example walks though SQL service delivered within SYSTOOL - Spool_File_Data. This SQL is an amazing tool for looking at the contents of spool files, but instead of using this SQL, we will review how its build and how you can leverage this for other SQL tools.
The professor of SQL dives into some pretty powerful building block to help you bring the full power of the SQL language to help solve problems. This example walks though SQL service delivered within SYSTOOL - Spool_File_Data. This SQL is an amazing tool for looking at the contents of spool files, but instead of using this SQL, we will review how its build and how you can leverage this for other SQL tools.
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.
-
Contains 1 Component(s)
With the recent change to how the IBM i operating system is licensed, the chance to subscription license. Its is now more important that ever to make sure you know when your license will expire. With subscription license, your system may stop working someday in the future! Guessing it might be useful to know what. This iSee will explore a few ways that is possible. Some magical SQL as well as updates to the Navigator interface to help make it very clear.
With the recent change to how the IBM i operating system is licensed, the chance to subscription license. Its is now more important that ever to make sure you know when your license will expire. With subscription license, your system may stop working someday in the future! Guessing it might be useful to know what. This iSee will explore a few ways that is possible. Some magical SQL as well as updates to the Navigator interface to help make it very clear.
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)
User Profiles, we all have them, sometimes we have too many! Do you ever have a need to do a mass update of user profiles? The use case for this video was someone that needed to do some sensitive testing and did not want ANYONE to sign in during the test. Easy way to make that happen ? Disable ALL user profiles on the system for a period, and then revert all those changed back. The SQL provided will show you how to build your list of profiles, run the action and then make sure you clean up after. Sure we are showing Disable and Enable, but think of other user cases, you want to force all profiles to reset their password based on new security password rules, this SQL can easily be adopted for that as well.
User Profiles, we all have them, sometimes we have too many! Do you ever have a need to do a mass update of user profiles? The use case for this video was someone that needed to do some sensitive testing and did not want ANYONE to sign in during the test. Easy way to make that happen ? Disable ALL user profiles on the system for a period, and then revert all those changed back. The SQL provided will show you how to build your list of profiles, run the action and then make sure you clean up after. Sure we are showing Disable and Enable, but think of other user cases, you want to force all profiles to reset their password based on new security password rules, this SQL can easily be adopted for that as well.
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.
COMMON
332 S. Michigan Ave.
Unit LL – C12
Chicago, IL 60604
© 2025 COMMON. All rights reserved.