Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to overide the isolation level

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
karthikuma

New User


Joined: 29 Mar 2005
Posts: 62

PostPosted: Thu Jul 28, 2005 9:38 am    Post subject: How to overide the isolation level
Reply with quote

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.
Back to top
View user's profile Send private message

thanooz

New User


Joined: 28 Jun 2005
Posts: 99

PostPosted: Thu Jul 28, 2005 3:31 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
udaybarath

New User


Joined: 10 May 2005
Posts: 7

PostPosted: Thu Jul 28, 2005 3:40 pm    Post subject:
Reply with quote

The only way to override a primary key is

Insert a new value(promary key)
and delete the old value.
Back to top
View user's profile Send private message
vinayn

New User


Joined: 13 Jun 2005
Posts: 10

PostPosted: Fri Jul 29, 2005 9:32 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
udaybarath

New User


Joined: 10 May 2005
Posts: 7

PostPosted: Fri Jul 29, 2005 9:45 am    Post subject: Re: db2-isolation(very important)
Reply with quote

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

thanks
uday
Back to top
View user's profile Send private message
maggiebms

New User


Joined: 23 May 2005
Posts: 16

PostPosted: Fri Jul 29, 2005 12:50 pm    Post subject: Re: db2-isolation(very important)
Reply with quote

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....
Back to top
View user's profile Send private message
maggiebms

New User


Joined: 23 May 2005
Posts: 16

PostPosted: Fri Jul 29, 2005 12:52 pm    Post subject:
Reply with quote

Sorry for mistake, the answer for the second one is

2. the primary key does not contain any reference
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Syncsort TPF Level Majid Hussain SYNCSORT 2 Wed Apr 13, 2016 2:22 am
No new posts Need a logic to validate the data in ... sandeep kumar302 COBOL Programming 17 Mon Feb 01, 2016 3:30 pm
No new posts DB2 10.1 Share level locking and Sele... Mary Lewis DB2 1 Wed Apr 15, 2015 9:51 pm
No new posts CICS SE Level Openings in Accenture enikhilk Mainframe Jobs 0 Mon Sep 01, 2014 6:39 pm
No new posts 88 level variable logic not working sandeep kumar302 COBOL Programming 19 Thu Jul 31, 2014 10:59 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us