Find All Checked Out Objects Using SQL
Use the SQL statement below to find all the objects that are checked out: select * from ol900/f9861 where sistce=3
Users Are Unable To Map A Drive To The IFS On An IBM iSeries
Every once in a while, we encounter users that are unable to map a drive to the IFS. We do the normal troubleshooting: Does the...
Set WebSphere Application Servers To Auto Start
The following is an excerpt from Jeff Stevenson's Technology Blog: To have the application servers automatically restart, set the Node restart state to RUNNING in...
Add Environments To User Or Group Using SQL
The following SQL statement can be used to add an environment to a user or group: insert into sy900/f0093 values('48APINQ','JDV900','3.00','') Have fun!
How To Copy OCM Records From One Environment To Another Using SQL
This method can be used to copy any records in a database but the issue that I was trying to resolve was to copy 8...