O’Reilly Media Mon, 26 Oct 2009 08:51 AM PDT
Yesterday, the new media team at the White House announced via the Associated Press that whitehouse.gov is now running on Drupal, the open source content management system. That Drupal implementation is in turn running on a Red Hat Linux system with Apache, MySQL and the rest of the LAMP stack. Apache Solr is the new White House search engine. This move is obviously a big win for open source …
After Air France Flight 447 crashed in the Atlantic Ocean in June, seven hours elapsed before air-traffic controllers realized it was missing, delaying search and rescue efforts and bewildering air travelers over how a jumbo jet could be lost in an age when even simple cellphones can pinpoint positions. Read the rest of this entry »
LINUX VENDOR Red Hat hit a milestone yesterday when its share prise rose above Microsoft’s.
Microsoft has a lot more shares out there in the marketplace and its own share price has not been that healthy over the past year, but this is being seen by analysts as a great day for the free software outfit.
Oracle’s (NASDAQ: ORCL) $7.4 billion purchase of the software and server company was given a thumbs-up from the U.S. Department of Justice but the EC is holding off on its verdict until sometime early next year.
In the filing, Sun (NASDAQ: JAVA) officials said the layoffs will represent about 10 percent of the company’s 29,000 employees and will be done in phases over the next year.
Once the layoffs are completed, the company expects to absorb between $75 million and $125 million in restructuring charges. The cuts will come from all its major regions including North America, Europe, Asia and other emerging market, company officials said in the filing.
Google Voice is coming onto the scene fast, and with it, a large amount of speculation and controversy. One of the largest issues at the moment is the company’s decision to block numbers from remote areas.
According to Gizmodo, “Google Voice blocks calls to some rural carriers, conference call services and naughty talk lines because they have pricey access fees.”
Read the rest of this entry »
Every column that is selected has to be individually handed back to the calling program, unless there is a precise match to the entire DCLGEN definition.
This may lean you towards requesting all columns, however, the real harm occurs when a sort is required. Every SELECTed column, with the sorting columns repeated, makes up the width of the sort work file wider. Read the rest of this entry »
The less rows retrieved, the faster the query will run. Each qualifying row has to make it through the long journey from storage, through the buffer pool, Stage 1, Stage 2, possible sort and translations, and then deliver the result set to the calling program. Read the rest of this entry »
When writing a SQL statement with multiple predicates, determine the predicate that will filter
out the most data from the result set and place that predicate at the start of the list. By
sequencing your predicates in this manner, the subsequent predicates will have less data to
filter. Read the rest of this entry »
General Dynamics Corporation (GD) Tuesday bagged twin contracts worth approximately $750 million from the U.S. Army and Navy.
General Dynamics’ subsidiary General Dynamics Land Systems bagged a five-year contract worth $430 million for work at the Army tank research center. The company will provide engineering, electronics and manufacturing services. Separately, General Dynamics bagged a $320.6 million contract from the U.S. Navy. The company will design, plan and provide engineering and technical support for active nuclear submarines till October 2010. Read the rest of this entry »
Stage 1 processing has been very strict in prior releases about processing predicate compares
where the datatype lengths vary.
Prior to DB2 v7, this mismatch led to the predicate being demoted to stage 2 processing. However, a new feature in DB2 v7 allows numeric datatypes to be manually cast to avoid this stage 2 demotion.
ON DECIMAL(A.INTCOL, 7, 0) = B.DECICOL
ON A.INTCOL = INTEGER(B.DECICOL)
If both columns are indexed, cast the column belonging to the larger result set. If only one
column is indexed, cast the partner. A rebind is necessary to receive the promotion to Stage 1.
The first step to successful email marketing is actually getting your emails delivered so they can be read.
There are several things you want to keep in mind when sending out emails to make sure you stay on an email provider’s good side. If you make too many mistakes, your emails will be sent to the spam folder by the email providers (like Yahoo and Gmail) before your readers even have a chance to see them.
Either the Stage 1 Data Manager or the Stage 2 Relational Data Server will process every query. There are tremendous performance benefits to be gained when your query can be processed as Stage 1 rather than Stage 2. The predicates used to qualify your query will determine whether your query can be processed in Stage 1. In addition, each predicate is evaluated to determine whether that predicate is eligible for index access. There are some predicates that can never be processed as Stage 1 or never eligible for an index. It’s important to understand if your query is indexable and can be processed as Stage 1. The following are the documented Stage 1 or Sargable predicates: Read the rest of this entry »
The most important resource to the DB2 optimizer, other than the SELECT statement itself, is the statistics found within the DB2 catalog. The optimizer uses these statistics to base many of its decisions. The main reason the DB2 optimizer may choose a non-optimal access path for a query is due to either invalid or missing the statistics. The DB2 optimizer uses the following catalog statistics: Read the rest of this entry »