Loading...
Insights, updates, and deep dives into cybersecurity, cloud technology, and AI innovation.
I found this info in the PostgreSQL archives. Here are 2 methods: Best method from Dan Lyke: Apache::DBI will pool across Perl programs, and you don’t have to change anything in your scripts. Next best method from Gilles DAROLD: in your perl script use the following code use vars qw(); ||= DBI::connect(, , ); […]
Often programmers that haven’t worked with patches before find it intimidating. Patches are actually very simple to deal with. Here is how. Creating Patches diff -u oldfile newfile > filename.patch or diff -urN /olddir /newdir > filename.patch or diff -urN -X excludes /olddir /newdir > filename.patch diff options: -u Output (default 2) lines of unified […]
When trying to LOAD table data where one of the rows are generated, DB2 9.1 and 9.5 on Linux and AIX will crash if the generated field uses a user defined function (fenced or unfenced). IBM is aware of the issue, and the following APARs exist to track the problem: V9.1 APAR is IZ48197 V9.5 […]
We have large amounts of data, and in development we have to often to bulk insert and updates by the millions. DB2 allows us to dramatically speed up these operations by allowing to not log them. The trick is to use: ALTER TABLE <table_name> NOT LOGGED INITIALLY However, one needs to be careful using this […]
To retrieve to list of tables in DB2, you need to use the system tables, and then a little bit of sed. Here is how it goes: db2 “SELECT tabschema || ‘.’ || tabname FROM syscat.tables” | sed -e ‘/ //g’ You can redirect this into a file, and you may need to cut off […]
When you manage your main account in Postini, you indirectly manage all the aliases as well. You don’t have to login separately to manage the aliases, as the list of messages you see include those that came to the aliases.
Domino Server causes intermittent email bouncing On a Domino Server to 8.5FP1 After upgrading a Domino Server to 8.5FP1 we noticed intermittent email bouncing even though the emails were correctly delivered to the email server. The server response was: 451 Unable to complete command, DNS not available or timed out This message is misleading. What […]
Downgrading firmware on a NetApp SAN If you have just reclaimed a shelf from a NetApp SAN that you would like to use with an older head, you will notice that the drives are not recognized. This is due the the fact that DataOntap upgrades the drives automatically when you plug them in to an […]
Enterprise Class Email Protection If you need to go beyond classic SPAM and Virus filtering for your IBM Domino environment, we recommend you take a look at Lotus Protector for Mail Security. Starting at only .50 one time license fee per user, it is easy to see how the ROI over 1 year beats most […]