Search

Ramchandra's Weblog

Just ……everything about DB2 LUW

Month

January 2009

10 Tips for Success at Review Time for DBA

DBTA January 2009 – Trends and Applications: DBAs: Get a Raise! 10 Tips for Success at Review Time

DBAs: Get a Raise!
10 Tips for Success at Review Tim

On Becoming a DBA

Data Management Today by Craig Mullins : On Becoming a DBA

What Does a DBA Do ??

Data Management Today by Craig Mullins : What Does a DBA Do?

DB2 Storage Trivia

DB2 Storage Trivia

The Federation – Database Interoperability (Part 1)

The Federation – Database Interoperability (Part 1)

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

Blog at WordPress.com.

Up ↑