One Point of Contact for IBM Data Solutions

DB2

Buy DB2 For Less
Get a free quote and review of
your DB2 licensing

With a 25-year track record and large install base, IBM DB2 UDB data servers offer industry leading performance, scale, and reliability on your choice of platform. In fact, DB2 UDB is used at 25 of the top 25 worldwide banks, 23 of the top 25 U.S. retailers, and 9 of the top 10 global life and health insurance providers.

DB2 License Renewal

Let One Point Solutions show you how to transform your data center with DB2 UDB. With options from the full capability of DB2 UDB Enterprise 9 to the flexible DB2 UDB Express for small to midsized business, One Point can recommend and source the optimal DB2 UDB edition for your needs and budget.

ALL DB2 UDB Users Can Extend Capabilities with Data Warehousing and Business Intelligence

We can help you make the most of the new data warehousing capabilities with direct import of data from both mainframes and System i (formely iSeries orAS/400) servers into Infosphere Balanced Warehouse (formerly DB2 DWE). Your current mainframe and System i data can be imported into turnkey data warehouse solutions without drawing on the resources of your current systems. In additon, DB2 UDB’s advanced support for business intelligence applications ensures your business is getting accurate and timely information analysis across the organization.

Check out our DB2 UDB tools that improve performance, manage data and security, recovery and more…

From application management to backup & recovery and more, Information Management Tools for DB2 on Linux, UNIX and Windows simplify the management of complex and routine database tasks, to help maximize DBA efficiency and reduce total cost of ownership.

DB2 Features include:

  • Advanced Access Control - Label Based Access Control to define write and read access to rows and columns.
  • Autonomics - automated memory allocation, storage management and business policy maintenance.
  • Compress data up to 85% to maximize storage requirements. Also: Value compression, XML Compression, Index compression, temporary table compression, backup compression. Estimate your savings with this IBM ROI tool:
  • Geodetic Data management - Store, access, manage, analyze location information.
  • High Availability Disaster Recovery (HADR) - 24 x 7 availability with online reorganization and reconstruction, failover, and Tivoli automation allowing transition to a standby DB2 server automatically.
  • DB2 Workload Manager - fine control over execution, including CPU and prefetch priority, plus the ability to execute workloads by business priority, bufferpool IO prioritization and integration with Linux workload management.
  • Optim Performance Manager - Extended Edition for DB2 Linux, UNIX and Windows – Identify, diagnose, solve and prevent performance bottlenecks in DB2 and Java applications, DB2 Call Level Interface (CLI), pre-configured for SAP, Websphere, Cognos, InfoSphere DataStage and InfoSphere Warehouse SQL Warehousing Tool applications.
  • DB2 Query Patroller - query flow control.
  • pureScale - cluster-based, shared-disk architecture for easy scalability and high availability (also now on System X).
  • pureXML - store, process and manage XML data in hierarchical form.
  • Security - user ID and password authentication, group member lookup, Kerberos, LDAP and customer authentication;
  • Auditing - monitor and analyze data access to data. Retain access history.
  • Encryption - encrypts User ID, password and data while data is being tranmitted through the network. Support external encryption using Secure Socket Layer (SSL) for a tunnel or envelop while between client and server.
  • SQL Skin - allows DB2 to perform many functions required by Sybase ASE.

 

DB2 for z/OS

DB2 for z/OS helps you reduce cost and complexity in your IT infrastructure, simplify compliance, and leverage your core asset - your data. DB2 for z/OS is optimized for SOA, CRM and data warehousing to drive your mission critical business requirements.

  • Continuous availability with unique improvements such as online schema evolution, including the ability to add partitions and change data definitions with ALTER statements, online unload and replace, and improved backup and recovery utilities
  • Data serving with IBM's mainframe and DB2 for z/OS helps you reduce cost and complexity in your IT infrastructure, simplify compliance, and leverage your core asset - your data

 

DB2 PureScale

For organization with distributed systems running online transaction processing (OLTP). DB2 pureScale is based on DB2 of z/OS and available as an option on DB2 9.7 Enterprise Server Edition. PureScale provides unlimited capacity, continuous availability and application transparency while reducing risk and cost through more efficient resource usage.

Scaling is a matter of connecting a new node and issuing two commands. Application software typically run on the modified system with little or no changes. DB2 provides native support for common syntax and PL/SQL languages, easing the transition from Oracle to DB2.