Search

Ramchandra's Weblog

Just ……everything about DB2 LUW

Month

November 2008

Recommended reading list: J2EE and WebSphere Application Server

Recommended reading list: J2EE and WebSphere Application Server

WebSphere – Application Server & Database Performance Tuning

WebSphere – Application Server & Database Performance Tuning

DROPING REFERENCIAL INTEGRITY CONSTRAINT IN DB2

steps for droping and recreating RI:-

1. genrate RI by using db2look:
db2look -d dbname -e -a -td @ -l -o dbname.sql

2.check the RI
select tbname, relname, refkeyname from sysibm.sysrels

create script for droping RI
select ‘ALTER TABLE ‘||tbname||’  DROP CONSTRAINT ‘||relname   from sysibm.sysrels

3.do your operation data migration/ db2move ..etc

4. recreate RI (keep only RI part in dbname.sql delete the rest)
db2 -td@ -vf dbname.sql

WAS 6.0 Tuning Linux systems

WAS Tuning Linux systems

DB2 Performace Expert

Simplify performance management and tuning with DB2 Performance Expert: DB2 Performance Expert overview

Simplify performance management and tuning with DB2 Performance Expert: Usage scenarios to analyze and improve database performance

Simplify performance management with DB2 Performance Expert: Use Performance Warehouse data to troubleshoot and tune your DB2 UDB servers

DBA: Storage, I/O, and DB2

Distributed DBA: Storage, I/O, and DB2

DBA: Storage, I/O, and DB2

DB2 RAID CONIDERATION

DB2 Database for Linux, UNIX, and Windows

You might consider using a RAID level 1 hardware disk array or
a software disk array for your logs, because this provides recoverability
to the point of failure, and offers good write performance, which is important
for logs. To do this, use the mirrorlogpath configuration parameter
to specify a mirror log path on a RAID level 1 file system. In cases where
reliability is critical (because time cannot be lost recovering data following
a disk failure), and write performance is not so critical, consider using
a RAID level 5 hardware disk array. Alternatively, if write performance is
critical, and the cost of additional disk space is not significant, consider
a RAID level 1 hardware disk array for your data, as well as for your logs.

alter the identity column to update value in Db2

ALTER TABLE RECEIPT ALTER COLUMN RECEIPT_NUMBER DROP IDENTITY
GO
update GDT.RECEIPT set RECEIPT_NUMBER=1 where RECEIPT_NUMBER=2
GO
SELECT     MAX(RECEIPT_NUMBER)  FROM     GDT.RECEIPT
go
ALTER TABLE  RECEIPT ALTER COLUMN RECEIPT_NUMBER SET GENERATED BY DEFAULT as identity( START WITH 32331 INCREMENT BY 1 CACHE 20)
GO

Configuring and troubleshooting ITDS 6.1 on AIX

Configuring and troubleshooting ITDS 6.1 on AIX

Create a free website or blog at WordPress.com.

Up ↑