• IBM Consulting

    DBA Consulting can help you with IBM BI and Web related work. Also IBM Linux is our portfolio.

  • Oracle Consulting

    For Oracle related consulting and Database work and support and Migration call DBA Consulting.

  • Novell/RedHat Consulting

    For all Novell Suse Linux and SAP on Suse Linux questions releated to OS and BI solutions. And offcourse also for the great RedHat products like RedHat Enterprise Server and JBoss middelware and BI on RedHat.

  • Microsoft Consulting

    For Microsoft Server 2012 onwards, Microsoft Client Windows 7 and higher, Microsoft Cloud Services (Azure,Office 365, etc.) related consulting services.

  • Citrix Consulting

    Citrix VDI in a box, Desktop Vertualizations and Citrix Netscaler security.

  • Web Development

    Web Development (Static Websites, CMS Websites (Drupal 7/8, WordPress, Joomla, Responsive Websites and Adaptive Websites).

22 October 2012

SUSE Linux "We Adapt, You Succeed"

SUSE Linux SUSECON 2012:

SUSECon 2012 Intro video:

SUSE is ater a take over by Novell and a partnership with Microsoft en after
that last year a takeover by Attachemate now just finished with is last SUSECon
2012.They have a lot of improvements to show since they are way ahead with their
positive profit margins and have more revenue then expected and have a new
slogan: "We Adapt, You succeed". As told in earlier posts in this blog they are
responsible for 70% of all SAP installs on Linux and even 80% of all mainframes
are running SUSE Linux. If you did have money to visit the event, unlike me,
then you were lucky enough to see some of these keynotes.

Here is the keynote from Nils Braukman the President and General Manager of SUSE:

By the way they are now 20 years in business:

SUSE today announced its plans to celebrate the company's 20th anniversary with
a year-long campaign highlighting the company's history and future. The
long-time provider of enterprise Linux solutions will showcase major historical
milestones and discuss plans for the future through a series of worldwide events
that will include SUSECon 2012, the premier event for SUSE customers, partners
and enthusiasts.
"We have a lot to celebrate in 2012," said Nils Brauckmann, president and
general manager, SUSE. "SUSE today is the recognized market leader in several
important segments, and is well positioned to take advantage of an ever
expanding market for commercial Linux and open source technologies. We plan to
recognize the people, the events and the technological developments that have
helped bring us to where we are today."
SUSE plans to roll out information and activities highlighting how the company
has evolved from its early beginnings in the open source industry, to forging
partnerships with the world's leading technology vendors in order to deliver
innovation, investment protection and affordable enterprise-quality software
infrastructure to a generation of customers.
SUSE's roots date back to September 1992, when three German university math
students and a recently graduated software engineer formed a company to develop
software and function as an advisory UNIX group. Seeing the potential of Linux,
the team decided to distribute Linux operating systems and offer support
services. It chose the name "S.u.S.E," using an acronym for a German term that
meant software and systems development. The name was eventually shortened to

Corporate Milestones
In its 20-year history, SUSE has undergone two notable ownership changes. SuSE
Linux AG was acquired by Novell Inc. in early 2004. Seven years later, Novell
was acquired by The Attachmate Group, which reestablished SUSE as an autonomous
business unit focused on engineering excellence, smart innovation, and enduring
customer and partner relationships.
For two decades, SUSE has brought the power of Linux to a wide variety of
customers, including the London Stock Exchange, BMW, Walgreen's, SONY, Sesame
Workshop, and Office Depot. Many customers trust SUSE Linux Enterprise to
deliver a diverse range of core, mission-critical IT services, from high volume
market data and trading, to manufacturing and production, to e-commerce and air
traffic control, just to name a few.
"We have a rich history as a Linux pioneer. We're proud to be part of the open
source community and long-serving contributors to Linux," said Hubert Mantel, an
original founder of SUSE. "Celebrating our 20th anniversary provides an
opportunity to reflect upon our history and share our visions for the future.
The possibilities for SUSE today are more exciting than ever. Perhaps even more
exciting than when we started 20 years ago.

Thy are also very strong in BI in general, Netazza and TerraData are strong BI
solutions and SAP. Here is a small TerraData video from SUSECon 2012.

TerraData and SUSE Linux:

SUSE® and Teradata, the leading analytic data solutions company, today
reaffirmed their partnership at SUSECon, SUSE's first annual user conference.
Teradata relies on SUSE Linux Enterprise to help its customers flexibly and
securely run their data warehousing and business analytics workloads off a
mature and scalable operating system. Over a million users access a Teradata
data warehouse daily for precise and reliable intelligence to support business

In 2005, Teradata selected SUSE Linux Enterprise as its exclusive open source
operating system for its enterprise-class data warehouse offerings. Teradata
deliver its entire portfolio of solutions exclusively on SUSE Linux Enterprise,
demonstrating both the success of the partnership and proof that Linux is the
operating system of choice for big data.

"We needed an open source partner that could work closely with us to deliver
value to our customers. Our tight engineering relationship with SUSE enables us
to develop unique extensions or make modifications that drive performance and
deliver value to our customers," said Scott Gnau, president of Teradata Labs.
"Not only do we deliver SUSE Linux Enterprise across our entire platform family,
we use SUSE Linux inside of Teradata to run our business. We're excited to
continue to deliver best-in-class performance and value to our customers through
our partnership."

"Today at SUSECon we demonstrated to attendees how Teradata running SUSE Linux
Enterprise can deliver the most robust, reliable and well-supported enterprise
data warehousing and business analytics solutions available today," said Michael
Miller, vice president of Global Alliances and Marketing, SUSE. "Our partnership
with Teradata is an example of SUSE's ability to adapt to our partners needs in
order to help them succeed, which we will continue to do as Teradata continues
deliver data integration and business insight that helps customers make the best
decisions possible for competitive advantage."

Teradata is the world's leading analytic data solutions company focused on
integrated data warehousing, big data analytics, and business applications that
provide actionable business intelligence. It's our passion and it's all we do.
We deliver award-winning, integrated, purpose built platforms based on the most
powerful, scalable, and reliable technology platform in the industry. Our assets

Over 9,000 associates in 42 countries
Strong diversified client base of over 1,200 customers worldwide and companies
of all sizes
2,600+ implementations worldwide
Every day we push analytical intelligence deeper into operational execution,
enhancing efficiency and transforming corporate culture.

And to continue with BI and Datawarehousing, here is a video from SUSECon 2012
from IBM General Manager, IBM System z, Douglas Balog:

SUSE Manager demo at SUSECon 2012 in Orlando:

With SUSE Manager 1.7, you get the most efficient solution for managing a Linux
environment with improvements for patch and update management, compliance and
provisioning with support for PostgreSQL database.

SUSE Manager 1.7 provides improvements for:
•Patch and update management
•Flexible deployment options
•Additional provisioning features

The enhancements are supported through the following new technical features:
•PostgreSQL as a supported database option
•Provisioning of SUSE Studio™ images directly from SUSE Manager
•Migrating systems to new Service Packs from the SUSE Manager user interface
•Basic support for OpenSCAP compliance checking
•IPv6 support for management and provisioning

Patch and update management enhancements

SUSE Manager provides the option of updating an existing system to new Service
Packs without completely reinstalling it. No manual installation is needed.
Through the SUSE Manager interface, you get information about the current
version of the existing systems. Afterwards, SUSE Manager offers you the various
service pack migration options. As soon as you have chosen an option, SUSE
Manager automatically migrates to the Service Pack. As part of the migration,
additional extensions like SUSE Linux Enterprise High Availability Extension can
be added.

Compliance improvements

IT compliance addresses how well the organization conforms with external
regulations, industry standards, and internal policies. Failure to meet IT
compliance requirements can be a costly mistake. SUSE Manager makes it easier
and faster for IT organizations to align with various compliance initiatives.

SUSE Manager 1.7 offers a standard approach (OpenSCAP) to maintaining the
security of enterprise systems. This includes the ability to audit software
patch status, automatically confirm that servers have the latest security
updates, check system security configuration settings, and examine systems for
signs of compromise.

SUSE Manager 1.7 also offers improved search and reporting capabilities which
allow you to easily find and capture valuable information about the Red Hat and
SUSE Linux Enterprise Server systems that are being managed by SUSE Manager.
These reports can be important for audits and compliance-related activities,
providing detailed lists containing:
•System Inventory — All systems registered to SUSE Manager, including hardware
and software information
•Entitlements — All organizations registered to SUSE Manager, sorted by system
and channel entitlements and usage
•Errata — All errata relevant to the registered systems including full list of
errata and affected systems
•Users — All users registered with SUSE Manager and systems the user can
•Channel — All packages within a channel including packages in each channel
•History — History of events

SUSE Studio demo at SUSECon 2012 in Orlando:

SUSE Studio lets you rapidly scale up or down as needed. Assemble, build and
maintain complete portable application stacks in minutes and deploy wherever you

Driven by the need to demonstrate value to the business, IT organizations like
yours are coming under increasing pressure to reduce infrastructure costs,
manage capital expenditures, and consolidate operations. At the same time you
need to provide more sophisticated support to the business. As result, leading
IT organizations increasingly look at areas like standardization, virtualization
and cloud computing for the benefits they can offer.

SUSE Studio is designed to help you build, configure and maintain portable and
cloud-enabled application images or appliances, to reduce the complexity,
maintenance and support costs of software deployments. Within a couple of
clicks, you decide if you would like to deploy a new or existing application to
a physical, virtual and/or cloud environment. SUSE Studio even lets you choose
if you want to deploy your application within an x86 or mainframe environment.
The ability to leverage one new or existing application for various environments
dramatically improves the efficiency of deploying and maintaining applications.

SUSE Studio is a tremendous aid when it comes to reducing complexity. SUSE
Studio leverages the appliance form-factor and allows you to effectively
decouple the software installation from the underlying layer. This eliminates
many of the versioning and patch management issues that you have to deal with
normally. This can also help you standardize your applications to further reduce
time, costs and maintenance for software applications deployed into your

SUSE Snapper demo at SUSECon 2012 in Orlando:

For years we had the request to provide rollbacks for YaST and zypper but things
never got far due to various technical problems. With the rise of btrfs
snapshots we finally saw the possibility for a usable solution. The basic idea
is to create a snapshot before and after running YaST or zypper, compare the two
snapshots and finally provide a tool to revert the differences between the two
snapshots. That was the birth of snapper. Soon the idea was extended to create
hourly snapshots as a backup system against general user mistakes.

SuperMUC Supercomputer Runs SUSE Linux Enterprise Server:

For more information on Linux support and consultancy please contact me:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
email:           albertspijkers@dbaconsulting.nl

17 October 2012

IBM extended their PureSystems Hardware family with PureData racks

    IBM Pure Systems now also available as PureData

The volume and velocity of business data is growing at an accelerated rate, and more of it is being identified as mission critical. At the same time, data availability and response time expectations continue to rise. Deploying and running reliable and highly scalable transactional database systems can be expensive and time consuming. A new approach to delivering fast, reliable and scalable data services is needed.
PureData™ System for Transactions is an integrated, optimized, ready-to-run database platform designed and tuned exclusively for transactional data workloads.

Here is a small video that explains why Big Data might be important for you:

Big Data:

A simplified system for today's data demands

With the challenge of growing volume, velocity and variety of data used today in all aspects of the business - using a multi-purpose system for all data workloads is often not the most cost effective or low risk approach, and definitely not the fastest to deploy. The new PureData System is optimized exclusively for delivering data services to today's demanding applications. Like each of the IBM PureSystems, it offers built-in expertise, integration by design, and a simplified experience throughout its life cycle.

Built-in expertise 
Codified data management best practices are provided for each workload. PureData System delivers automated pattern-based deployment and management of highly reliable and scalable database services.

Integration by design
Hardware, storage and software capabilities are designed and optimized for specific high performance data workloads such as patented data filtering using programmable hardware (FPGAs) for ultrafast execution of analytic queries without the need for indices.

Simplified experience
The PureData System provides single part procurement with no assembly required (ready to load data in hours), open integration with 3rd party software, integrated management console for the entire system, single line of support, integrated system upgrades and maintenance.
The new PureData System comes in different models that have been designed, integrated and optimized to deliver data services to today's demanding applications with simplicity, speed & lower cost

Possible sources of Big Data:

Figure explains the three domains of information

IBM PureSystems Product Family - IBM PureData™ System Overview:

PureData for Transactions:

PureData System for Transactions is an integrated, ready-to-run database platform designed and tuned exclusively for transactional data workloads.

PureData for Analytics:

PureData System for Analytics is optimized to deliver data services for analytics and deal with vast amounts of data and complex analytic processing.

Why bother about big Data at all:

The simplest approach, driven pragmatically by what early adopters in the market have done, is to look at the business uses of big data and see how they apply to you. Of course, this approach cannot be complete, because more novel uses will likely be found. However, big data is likely to be important if your business is following one or more of the following directions:

1. Marketing uses social media content and relationship information as well as internally captured content from customer interactions such as call center logs to more deeply understand customer motivation. In industries such as retail, consumer packaged goods and telecommunications where there is direct or indirect interaction with large numbers of consumers, this enables a move from sampling to full dataset analysis, from demographic segments to markets-of-one and from longer-term trending
of historical data to near real-time reaction to emerging events. The ultimate goal is prediction of customer behaviors and outcomes of proposed actions such as next best offer.
2. Detecting fraud and other irregularities in financial transaction data has expanded to include larger volumes of often smaller-value transactions on ever-shorter timescales. Big data analysis techniques on streaming data—before or without storing it on disk—have become the norm.
3. Real-time forecasting becomes possible as utilities, such as water and electricity supply and telecommunications, move from measuring consumption on a macro- to a micro-scale using pervasive sensor technology and big data processes to handle it. Value arises as consumption peaks and troughs can be predicted and, in some cases, smoothed by influencing consumer behavior.
4. Tracking of physical items by manufacturers, producers and distributors—everything from food items to household appliances and from parcel post to container shipping—through distribution, use and even disposal allows business process optimization or improved customer experiences. People, as physical entities, are also subject to tracking for business reasons or for surveillance.
5. Reinventing business processes through innovative use of sensor-generated data offers the possibility of reconstructing entire industries. Automobile insurance, for example, can set premiums based on actual behavior rather than statistically averaged risk. The availability of individual genomic data and electronic medical records presents the medical and health insurance industries with significant opportunities, not to mention ethical dilemmas.

PureData is powered by Netazza software from IBM and a proven BI technology which inspired Oracle to invent the currently very fast ExaData and Big Data racks, see also previous blog about ExaData V3. Big Data can help you grow your business and increase your profits and lower your costs. Please contact DBA Consulting for more information. 

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
email:           albertspijkers@dbaconsulting.nl

10 October 2012

DB2 PureScale

          IBM DB2 PureScale High Availability!

In October 2009, IBM announced a new technology, primarily aimed at online transaction processing (OLTP) scale-out clusters, called IBM DB2 pureScale. DB2 pureScale is a new feature that provides scale out active-active services for IBM DB2 running on AIX on Power Systems servers. It's designed to deliver the highest levels of distributed availability and scalability wrapped in a well-thought-out, up-and-running path that's much easier to operate than other clustered database systems.

The DB2 pureScale Feature meets the needs of many customers by providing the following key benefits:

Virtually unlimited capacity
The DB2 pureScale Feature provides practically unlimited capacity by enabling the addition and removal of members on demand. The DB2 pureScale Feature can scale to 128 members. It has a highly efficient, centralized management facility that allows for very efficient scale out capabilities. The DB2 pureScale Feature also leverages a technology called Remote Direct Memory Access (RDMA) that provides a highly efficient inter-node communication mechanism to augment its scaling capabilities

Application transparency
An application that runs in a DB2 pureScale environment does not need to have any knowledge of the different members in the cluster or of partitioning data. The DB2 pureScale Feature automatically routes applications to the members deemed most appropriate. The DB2 pureScale Feature also provides native support for syntax that other database vendors use, which enables those applications to run in a DB2 pureScale environment with minimal or no changes.

Continuous availability
The DB2 pureScale Feature provides a fully active-active configuration such that if one member goes down, processing continues at the remaining active members. During a failure, only data being modified on the failing member is temporarily unavailable until database recovery completes for that set of data, which is very quick. This is an advantage over some competing solutions in which an entire system freeze occurs as part of the database recovery process.

Reduced total cost of ownership
The DB2 pureScale interfaces easily handle the deployment and maintenance of components integrated within the DB2 pureScale Feature. This helps reduce what might amount to steep learning curves associated with deploying and maintaining with some competing technologies.

To understand these benefits, it helps to understand the basic architecture. Clients connect to a single database view comprised of four cluster members with shared storage. The clients connect anywhere. The DB2 member runs on several host computers with integrated cluster services. The members are connected over low-latency, high-speed connections to the PowerHA pureScale server. The logs and data-sharing architecture are centralized for all the clients. The figure below depicts the components that make up the DB2 pureScale configuration. Even though there are several advanced components, a significant portion of this architecture is transparent to the end user, because the DB2 pureScale Feature internally deploys and manages these components.

DB2 pureScale Feature topology overview

In the Figure for Architecture Overview, clients can connect to any member. The DB2 pureScale Feature can automatically load balance the clients across the different members based on the utilization of each computer. If any host in the configuration fails, the DB2 pureScale Feature redirects clients among the active members on the remaining hosts.

Each DB2 member represents a DB2 processing engine. Up to 128 members can be deployed in a single DB2 pureScale configuration. The members cooperate with each other and with the PowerHA pureScale server to provide coherent access to the database from any member. Members can be added and removed as processing demands change. Modifications to the number of active members can be done without any impact to the clients.

Integrated with the DB2 pureScale Feature is a cluster services layer that provides failure detection, recovery automation, and a clustered file system. These technologies are integrated within the DB2 pureScale Feature, and they leverage IBM technologies optimized for DB2 software. The technologies include IBM Tivoli® Systems Automation for Multi-platforms (Tivoli SA MP), Reliable Scalable Cluster Technology (RSCT), and General Parallel File System (GPFS™). The DB2 pureScale Feature automatically deploys and configures these technologies according to a best-practice, pre-defined configuration. A customer does not need to determine how to configure the clustering technology that comes with the DB2 pureScale Feature, because the end user doesn't see it.
In the DB2 pureScale configuration, there is a need for communication between the members and the PowerHA pureScale servers. To make this communication as efficient as possible, the DB2 pureScale Feature leverages the RDMA technology. RDMA allows one computer to read or write to the memory of another computer without requiring any processor cycles on the target machine. This mechanism, in conjunction with extremely high-speed networks such as InfiniBand, allows for an extremely efficient transport layer, which enables the DB2 pureScale Feature to scale efficiently.

The PowerHA pureScale servers (also referred to as CF) provide a scalable and centralized locking mechanism to ensure data coherency. The servers also act as a fast cache for DB2 pages, leveraging RDMA technology to provide increased performance in situations where a physical disk operation might otherwise have been required. The PowerHA pureScale server and the efficient transport layer are two of the features that enable the DB2 pureScale Feature to scale so well, because each member does not have to negotiate with all other members when performing a task.

The DB2 pureScale Feature leverages a shared-disk technology. Any member can read or write to any portion of the database. If any member fails, the full set of data is still accessible from the other active members.

DB2 pureScale

DB2 pureScale: Availability Demo

Using Data Replication for Continuous Availability

Download DB2 10.1:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
email:           albertspijkers@dbaconsulting.nl

07 October 2012

Oracle OpenWorld 2012 annouced Exadata X3

Exadata X3 | Database In-Memory Machine

Oracle Open World was held last week and the biggest news was the announcement of the Oracle Exadata X3 Database In-Memory Machine - the latest generation of its Oracle Exadata Database Machines.
  • The Oracle Exadata X3 Database In-Memory Machine is a key component of the Oracle Cloud.
  • Oracle Exadata X3-2 Database In-Memory Machine and Oracle Exadata X3-8 Database In-Memory Machine can store up to hundreds of Terabytes of compressed user data in Flash and RAM memory, virtually eliminating the performance overhead of reads and writes to slow disk drives, making Exadata X3 systems the ideal database platforms for the varied and unpredictable workloads of cloud computing.
  • In order to realize the highest performance at the lowest cost, the Oracle Exadata X3 Database In-Memory Machine implements a mass memory hierarchy that automatically moves all active data into Flash and RAM memory, while keeping less active data on low-cost disks.
  • With a new Eighth-Rack configuration, the Oracle Exadata X3-2 Database In-Memory Machine delivers a cost-effective entry point for smaller workloads, testing, development and disaster recovery systems, and is a fully redundant system that can be used with mission critical applications.

Next-Generation Technologies Deliver Dramatic Performance Improvements
  • Oracle Exadata X3 Database In-Memory Machines use a combination of scale-out servers and storage, InfiniBand networking, smart storage, PCI Flash, smart memory caching, and Hybrid Columnar Compression to deliver extreme performance and availability for all Oracle Database Workloads.
  • Oracle Exadata X3 Database In-Memory Machine systems leverage next-generation technologies to deliver significant performance enhancements, including:
    • Four times the Flash memory capacity of the previous generation; with up to 40 percent faster response times and 100 GB/second data scan rates. Combined with Exadata’s unique Hybrid Columnar Compression capabilities, hundreds of Terabytes of user data can now be managed entirely within Flash; An Exadata Database Machine X3-8 includes 56 PCI flash cards providing 22.4 TB of Flash Memory.

    • 20 times more capacity for database writes through updated Exadata Smart Flash Cache software. The new Exadata Smart Flash Cache software also runs on previous generation Exadata systems, increasing their capacity for writes tenfold;
    • 33 percent more database CPU cores in the Oracle Exadata X3-2 Database In-Memory Machine, using the latest 8-core Intel® Xeon E5-2600 series of processors;
    • Expanded 10Gb Ethernet connectivity to the data center in the Oracle Exadata X3-2 provides 40 10Gb network ports per rack for connecting users and moving data;
    • Up to 30 percent reduction in power and cooling.

Configured for Your Business, Available Today
  • Oracle Exadata X3-2 Database In-Memory Machine systems are available in a Full-Rack, Half-Rack, Quarter-Rack, and the new low-cost Eighth-Rack configuration to satisfy the widest range of applications. Oracle Exadata X3-8 Database In-Memory Machine systems are available in a Full-Rack configuration, and both X3 systems enable multi-rack configurations for virtually unlimited scalability.
  • Oracle Exadata X3-2 and X3-8 Database In-Memory Machines are fully compatible with prior Exadata generations and existing systems can also be upgraded with Oracle Exadata X3-2 servers.
  • Oracle Exadata X3 Database In-Memory Machine systems can be used immediately with any application certified with Oracle Database 11g R2 and Oracle Real Application Clusters, including SAP, Oracle Fusion Applications, Oracle’s PeopleSoft, Oracle’s Siebel CRM, the Oracle E-Business Suite, and thousands of other applications.

Exadata Video overview 13 minutes

A small overview of the new features can be found in the table below:

Also the new Oracle Database12c was touched shortly with new features for: Real Application Testing, pluggable database, RAC transaction failover, etc.

Drs. Albert Spijkers
DBA Consulting
web:            www.dbaconsulting.nl
blog:            http://drsalbertspijkers.blogspot.com/
profile:         http://nl.linkedin.com/pub/drs-albert-spijkers/13/b4a/7a8
Facebook :  http://www.facebook.com/pages/DBA-Consulting/101640233252655
email:           albertspijkers@dbaconsulting.nl