DB2 and other Technical Tips

While supporting a high-volume transaction period in our shop, I noticed that db2top Start Date and Start Time (option d for database) show...

To add a text at the start or end of each line, use regular expressions. Click Ctrl+H, and in the "Find What" space, enter ^b i...

To find the database connection strings such as url, port number etc : Database URL can be found using the command ifconfig -a . e...

While trying to run this export command db2 " export to /filepath/schema.tablename.ixf of ixf messages v.msgs select * from wcsproln...

Application developer says that he is not able to connect to the database, he's getting a message similar to this: " Error opening...

How do you find all the tables that are connected through referential integrity? For example, let's assume that I've a table call...

Often times, when you are diagnosing a problem on mainframe, if you contact the tech support of the product, you will be asked to set up a S...

This morning I was trying to SMP/E RECEIVE a bunch of PTFs as part of a DB2 tool maintenance. After receiving 20 PTFs, the job went down wit...

One of the developers at our shop fed his query to an optimizer tool and the optimized query looked kind of weird. This is the original qu...

Ever wonder when was a stored procedure last used/invoked in DB2 LUW? Knowing this may be helpful in determining whether a stored procedure ...