How to overide the isolation level

karthikuma · New User Joined: 29 Mar 2005 Posts: 62

Hi,

plz help me i'm strugled in two interview.i've faced the same question in 2 interview.

1. how to overide the isolation level.(i said that by using parm).the interviewr told it's not correct.any expert plz give me an good solution.how to overide the isolation level.

2. in db2 table we are having 1000 of records.for eg:employeeno ,code,salary,like that.whether it is possible for us to overide the primary key.whether we can able to insert null-value on primary.give me an god sugestions.

3. where the bind,plan,package stored.i told that sysibm,sysplan.interview told that on on eparticular table all these contents will be stored.which table?plz give an solutions.

Regards,
kumar.

thanooz · New User Joined: 28 Jun 2005 Posts: 99

2)

primery key means unique key in this you can write null values.but data in primary key can not change means you can not overide.

thanooz

udaybarath · New User Joined: 10 May 2005 Posts: 7

The only way to override a primary key is

Insert a new value(promary key)
and delete the old value.

vinayn · New User Joined: 13 Jun 2005 Posts: 10

Hi Uday Bharath,

Pls state it clear that how to delete the old value., if at all we have deleted it, how abt the references of child table.

thanks ,
Vinay

udaybarath · New User Joined: 10 May 2005 Posts: 7

Hi vinay
the child reference table also u need to delete befor deleting the parent table.......

thanks
uday

maggiebms · New User Joined: 23 May 2005 Posts: 16

Hello,

1. I think so the Isolation level can be overrided thru BIND option ( Isolation = (CS/RR))

2. Primary Key means that it should not contain any null and unique values. It is possible to override if it does contain any reference in another child table

If anything wrong , plz correct me....

maggiebms · New User Joined: 23 May 2005 Posts: 16

Sorry for mistake, the answer for the second one is

2. the primary key does not contain any reference