Loading...
Insights, updates, and deep dives into cybersecurity, cloud technology, and AI innovation.
When an attribute on a table is dropped, or the data type changes, DB2 sets the table into REORG PENDING state. That prevents a number of operations on the table, which can be problematic for a production database. If there is no way around such a structural change, then a REORG command needs to be […]
If your site is hosted on an Ensim appliance, with your email bundled in the same control panel, you can check webmail by adding ‘SquirrelMail’ to your website URL. For example, if your website is www.mywebsite.com, you would check email by going to <http://www.mywebsite.com/squirrelmail>.
When inserting into regular database systems, like Oracle, DB2, and even PostgreSQL, the omitted attributes from an INSERT are automatically set to default. Not so with MyISAM tables on MySQL. The syntax required by MySQL for an implicit default when multiple attributes are inserted is DEFAULT. For example: INSERT INTO my_table VALUES (?,?,DEFAULT,?,DEFAULT) will set […]
One of the challenges in query optimization is to make sure that the query optimizer works with accurate estimates on cost of the different possible decision branches in the optimization process. The accuracy of the estimates depends on the efficiency of the stats collection. DB2 assumes the data distribution is constant distribution. And that’s why […]
This is our spam / virus filter update for customers on the mx1 / mx2.tnpw.net filtering cluster. The information is brought to you by our vendor, SpamExperts. What’s new this week: View the message in quarantine by clicking on the subject of the message in the Log Search results A few updates ago, we added […]
To mount a CD or DVD in an LPAR, first you need to use the media library to assign one of the CDs in the library to the LPAR. For example, using the ivm inteface: Click on the lpar name in the “View/Modify Partitions” section Select the optical devices tab Create a virtual optical device […]
This is our spam / virus filter update for customers on the mx1 / mx2.tnpw.net filtering cluster. The information is brought to you by our vendor, SpamExperts. What’s new this week: System Administration: We have now implemented the ability for our clients to select one or more contacts which should receive our automated server problem […]
In order to get the optimal security and guaranteed mail delivery, the following partition table is recommended: / /data /home /tmp /usr /var /var/qmail /var/qmail/queue
This is our spam / virus filter update for customers on the mx1 / mx2.tnpw.net filtering cluster. The information is brought to you by our vendor, Spam Experts. OS Update SpamExperts is preparing to upgrade all Local Cloud servers from Debian 6 (LTS) to Debian 7.0 over the next weeks. This is generally done as part […]