Single query to remove duplicate records in db2

Are you using DB2 database . You may be searching solution to select or delete duplicate records available in any table using a single query. The solution is here . This tutorial covers how to display and delete duplicate records usning single query with examples . Let me explain with the following example. Table : Sales_Master In the above picture , Sales_Master table has duplicate records , but it should not have. The following table shows...

Read More

Stored Procedure in db2 and benefits. Create Procedure command with example

A stored procedure is a subroutine that can be called by an application with an SQL CALL statement . A stored procedure is stored in the database itself. Stored Procedures are invoked by executing the CALL statement with a reference to a procedure. The storedprocedure can be called locally or remotely.  Benefits using Stored Procedures :  Avoidance of network traffic : In client server architecture, applications access the remote...

Read More

how to get / change log file size in db2.

This tutorial explains about one of the db2 database configuration parameter LOGFILSIZ and How to decide and change the log file size ? . LOGFILSIZ defines the size of transaction log file that means the size of each primary and secondary log file. The default size is 1000 pages where each page having 4 K size that means log file can hold upto 4 MB of transactional data . The size of these log files limits the number of log records that can be written to them . When they become full , a new log file is required. If the database has...

Read More