DB2 Dates format by region
To give a specific format to the date obtained throught DB2 “current date”, you can use the following method.
Read more »
Resource Limits between DB2 Express-C versus Oracle XE and SQL Server Express
The free version of DB2 (DB2 Express-C) has much less limitations than those existing in Oracle and SQL Server, Oracle Express Edition 10g/11g and SQL Server 2005/2008 Express.
This article shows this advantage you get with DB2 Express-C compared to Oracle/Microsoft SQL Server.
Read more »
Tuning DB2: Snapshots
To tuning a database is useful to create snapshots that capture information from different structures/components of the instance.
In this post we show how they can be used to perform an analysis of tuning.
First of all, the monitor switches must be on to collect data from the different structures.
Rename database DB2
Is common practice to require a replica of a database on another different environment, and also require that the new database has a new name. For example, to update a pre-production database, backing up SAP homogeneous or simply to change the name of the database for any need.
Detecting indexes not used DB2 9.7
This article shows a method to view the indexes not used in our database since the last reboot. There are another methods to obtain the same information, like the use of the LASTCOLUMN included on 9.7 version. This article will let you know what indexes are not being used, with the waste of resources involved.
Read more »
Version history DB2
This article shows the query to obtain the history of DB2 versions and patching. That is, not only shows the current version, but since when is installed / updated.
Cache Hit Ratio DB2
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).
Avg Disk Access read/write in DB2
Through DB2 we can get the average time in ms disk access is having DB2. These times are crucial for the detection of a IO problem with DB2 instance.
Read more »
DB2 top rows
In this article we will see how to get the first N rows for a Query in DB2. You can do the same with Oracle ROWNUM function and in SQL Server with TOP too.
Read more »
How know the DB2 connection port
Maybe there are other methods, in this short article, a simple way to know the port that serves DB2 server.
