Matt Huras - Chief Architect, DB2 for Linux, Unix and Windows has shared this great article discussing some of the high-value, core advances in security, availability and performance with the recently announced DB2 11.1 for Linux, UNIX and Windows.
This article is Part 1 of a 2-part Blog series. The article discusses the following
Added by Sajan K on April 28, 2016 at 4:00am — No Comments
In order to analize system performance I tried to discover how time is spent within my database system.
According to the documentation, TOTAL_RQST_TIME=TOTAL_WAIT_TIME + TOTAL_*_PROC_TIME.
By querying the service class table function (MON_GET_SERVICE_CLASS) I'm disappointed by the fact that there is a big difference between total_rqst_time and the sum of all other values.
It seems that with "normal" DML statements these two values are quite…Continue
Added by Alessandro Oppici on April 24, 2016 at 2:58am — No Comments
Operational monitoring refers to collecting key system performance metrics at periodic intervals over time. This information gives you critical data to refine that initial configuration to be more tailored to your requirements, and also prepares you to address new problems that might appear on their own or following software upgrades, increases in data or user volumes, or new application deployments.... …Continue
Added by Vinay Kumar Bommana on March 9, 2016 at 11:30pm — No Comments
Have you come across a scenario where you need to migrate your databases db2 LUW from AIX P6 Box to P8 box and you couldn't perform a redirected restore as this could be time consuming activity.
Below is link where you can learn quickly how to migrate db2 luw in 7 minutes
DB2 LUW Migration from AIX P6 Box to AIX P8 Box.
Added by Rohit Kumawat on March 9, 2016 at 5:49am — No Comments
I have a table A with 30,000 Records.
Module B selects the data from the table A.
This module B is called via online(CICS) and Batch mode.
This Module is called 30 million times in day. 20% of traffic is via Online mode and 80% of traffic is via Batch Mode.
In a second this Table is referred 30 times and in a minute 4500 times.
Each time Module B is triggered it selects data from Table A.
Whenever I do a select to table A. IO is caused and by…Continue
Added by Satya on January 18, 2016 at 11:16am — No Comments
Mis Comentarios Técnicos
Empezaremos esta entrega hablando de unos de las implementaciones tal vez menos conocidas, es la referida al particionamiento en un servidor. En especial nuestro interés es más bien estratégico y queremos enseñarles como sabe usted que esta ante una instalación de este tipo. Para ello hemos estructurados dos partes, en la primera aprenderemos a darnos cuenta que estamos antes este tipo de instalación y entender su arquitectura estratégica y la segunda, donde…
Added by SENDEROPRESS on December 13, 2015 at 5:37pm — No Comments
Lots of new content is available on www.ibmbluhub.com, a site that is focused on BLU Acceleration in-memory computing for fast reporting and analytics from the transaction environment or a warehouse environment. Here is a summary of some content you may want to check out:
Added by Cindy Russell on September 26, 2014 at 9:41am — No Comments
Oracle TopLink supports access to any data store accessible through standard JDBC using standard SQL.
Additionally TopLink offers database platforms that allow for specific functionality to be exposed such as
native SQL, sequencing, out-join syntax, custom date/timestamp operators and formats, and schema import
and generation with the mapping editors.
To setup Oracle Toplink please follow the below steps :-
1.We need to identify the…
Added by Ramya on September 18, 2014 at 5:41am — No Comments
Added by Mark Willium on July 8, 2014 at 11:00pm — No Comments
This post is useful for DB2 developers, administrators, database architects to learn how to access Oracle database
stored procedures from DB2 database sources.
A federated system is a special type of distributed database management system (DBMS).
A federated system consists of a DB2® database system that operates as a federated server, a database that acts
as the federated database, one or more data sources, and clients (users and applications) that access the…
Added by Ramya on June 24, 2014 at 4:01am — No Comments
My top five picks of new content on the DB2 with BLU Acceleration microsite at www.ibmbluhub.com:
Added by Cindy Russell on June 18, 2014 at 11:41am — No Comments
The heart of today's data warehouse, big data and analytics initiatives is based around databases. Analysts show that transactional data and log data are top two types of data used in big data initiatives despite the immediate association of social data and unstructured content. DB2 for z/OS by example is robust, scalable, secure and provides some of the best transactional integrity. With all of this Mike Ferguson analyst and consultant concludes in his white paper : "All of this makes…Continue
Added by Mark Simmonds on May 20, 2014 at 11:58am — No Comments
Hold tight - this will probably freak the accounting world out. I was listening to an analyst call about big data earlier today. I asked the question whether data would soon have a value on the asset sheet. There was a resounding agreement that it would - if a suitable metric could be devised.
To me it all depends on whether an organization can put controls around the following (non-exhaustive) criteria :
Accurate data - bad data is like a virus to the business and could…
Added by Mark Simmonds on May 20, 2014 at 11:56am — No Comments
I have updated my db2-hash-routines package to include bcrypt and sha-256 hashes.
The following hashes are supported:
Documentation is available as…Continue
Added by Helmut K. C. Tessarek on May 11, 2014 at 6:38pm — No Comments
One of the techniques to improve database performance and achieve greater scalability is using table partitioning. According to live industry observations when you see the following symptoms you should consider table partitioning
Slow queries that return small amounts or no data
Slow queries that return large amounts of data
Blocking between readers and writers (inserts or updates)
As tables grow in size, it may be easier to manage your…Continue
Added by Ramya on May 1, 2014 at 6:00am — No Comments
It's a complimentary webcast led by guest speaker Mike Ferguson, an independent consultant and analyst. He will review the business and technical requirements for clients embarking on big data and business analytics solutions. Mike will also discuss some of the key IBM solutions for System z and their potential to help clients meet those requirements.
Register and receive Mike's new white paper on this topic
Added by Mark Simmonds on April 22, 2014 at 10:35am — No Comments
has I hope you're well a good I could use for you today just like any not that day but going to be a slight difference I'm going to use my newt stop so excited about mismanages it's a masticating juicer okay his brilliant for getting dead extraction the best extraction out that Green’s celery cucumber those kind of things okay a just got land use the from UK juices that place I get all my juices from great deal family run company great that the service when you know customer services…Continue
Added by ragini taxi on April 1, 2014 at 7:52am — No Comments
With expression-based indexes, you can create an index that includes expressions. The performance of queries that involves expressions is improved if the database manager chooses an index that is created on the same expressions. Expression-based indexes are best suited when you want an efficient evaluation of queries that involve a column expression. Simple index keys consist of a concatenation of one or more specified…Continue
Added by Ramya on March 6, 2014 at 12:56pm — No Comments
DB2 with BLU Acceleration speeds analytics and reporting using dynamic in-memory columnar technologies. In-memory columnar technologies provide an extremely efficient way to scan and find relevant data. Coupled with innovations such as parallel vector processing and actionable compression, it makes your analytic queries far faster and less complex. So you can connect with the information you need at breakthrough speed and…
Added by Ramya on March 6, 2014 at 12:54pm — No Comments
This analyst finds that DB2 with BLU Acceleration for in-memory computing delivers consistently higher performance at a lesser cost. Read for yourself.
Added by Cindy Russell on January 27, 2014 at 1:54pm — No Comments