Objects, catalogs and database versions Oracle vs DB2
In this tables, I relate general terminology, versions, utilities and views from IBM DB2 and Oracle databases..
Uptime / Last reboot of DB2
- Read more about Uptime / Last reboot of DB2
- Log in to post comments
This mini tip show you how to know when was the last time you restart a DB2 server on a UNIX / LINUX.
> db2 get snapshot for dbm | grep Start Start Database Manager timestamp = 04/02/2011 13:45:20.516473
Simple, isn't it?
Search more accessed tables in DB2
- Read more about Search more accessed tables in DB2
- Log in to post comments
It’s relatively simple and unfamiliar tool for the novices: db2top.
Using the option “T” (tables) and sorting the list (key “z”) using column 1.
The first position will be for the most accessed table.
If there is much difference between that and the rest during an appreciable period of normal use of the database, these tables would be candidates to improve their access or optimice their access to improve the overall performance,
Tablespaces status on DB2
- Read more about Tablespaces status on DB2
- Log in to post comments
Below are a list with the more common status of IBM DB2 tablespaces
The most used method to show the status of the tablespaces is, from the console command line:
Containerization and the Cloud: A Perfect Match
Many are claiming that containerization is the future of the cloud and maybe even of application development in general. Supporting this is the fact that Google alone launches more than two billion containers each week. In fact, almost all of the Google services you know and use are built on containers..
7 Tips to Optimize Data Visualizations
- Read more about 7 Tips to Optimize Data Visualizations
- Log in to post comments
Data has become a central asset to organizations and visualizations are critical to present data in a clear way. Visualization helps organizations make data-driven decisions. Optimizing data visualizations conveys the information in an accessible way that enhances the user experience. This article provides seven practices you can follow to improve your data visualization process..
4 Cloud Migration Hacks and Tips
- Read more about 4 Cloud Migration Hacks and Tips
- Log in to post comments
Migrating to the cloud is becoming increasingly popular, and for good reason. Cloud migration can provide boosts in performance and accessibility at a fraction of the price of what most businesses can achieve on their own..
TOP 10 rows on DB2
- Read more about TOP 10 rows on DB2
- Log in to post comments
In this shosrt post we will show how to obtain the N first rows from a Query on IBM DB2.
With Oracle SQL would be with ROWNUM, and with SQL Server we'd use TOP.
This is the Top 10 query syntax:
select * from My_Table fetch first 10 rows only
Query to obtain Cache Hit Ratio on IBM DB2
- Read more about Query to obtain Cache Hit Ratio on IBM DB2
- Log in to post comments
The cache hit ratio is one of the indicators used for tuning tasks. It Measures the percentage of hits in memory, specifically in the bufferpools (each of them).
To get the cache hit ratio for each buffer pool configured to run this query:
SELECT SUBSTR(DB_NAME,1,8) AS DB_NAME, SUBSTR(BP_NAME,1,14) AS BP_NAME,
TOTAL_HIT_RATIO_PERCENT, DATA_HIT_RATIO_PERCENT,
INDEX_HIT_RATIO_PERCENT
FROM SYSIBMADM.BP_HITRATIO ORDER BY DBPARTITIONNUM