If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 Load Problems

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Feb 2004
Location: Sydney, Australia
Posts: 2
Question DB2 Load Problems

Hi,

I have a DB2 Table on OS390 which is heavily used.

When I try to load this table, sometimes there are threads using this table and my Load job fails. Is there a way in which I can cancel threads (if any) attached to this tablespace before I start my Load process??

Thanks in Advance.
Best Regards,
Suresh Karthik.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jul 2003
Location: Austin, TX, USA
Posts: 278
Quesice

Hi,

I haven't worked on OS/390 but what I can suggest is that you can quesice the tablespace and then do the load.

Please read on the quesice command for more details.

cheers

Nitin
__________________
HTH

Nitin

Ask the experienced rather than the learned
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Apr 2003
Posts: 191
Re: DB2 Load Problems

Hi Suresh,

in DB2 UDB version 8, there is a new load option. It is called LOCK WITH FORCE and does just that. Sorry I can't tell if DB2/390 offers something similar.

Are you positive that forcing off the other threads is a good idea? After all their transactions will roll back then.

Another option would be to program retry and restart capabilities into your load job - or doing imports instead, albeit this would be significantly slower.

Johann

Quote:
Originally posted by sureshkarthik
Hi,

I have a DB2 Table on OS390 which is heavily used.

When I try to load this table, sometimes there are threads using this table and my Load job fails. Is there a way in which I can cancel threads (if any) attached to this tablespace before I start my Load process??

Thanks in Advance.
Best Regards,
Suresh Karthik.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,713
Quiesce the tablespace using the QUIESCE utility. Then stop the tablespace (using the STOP DATABASE command with the SPACENAM option). You can use the FORCE option if necessary.

Then start the tablespace in utility (UT) mode (using the START DATABASE command with the SPACENAM option). Be sure to start the tablespace in RW mode after the load.

At this level of operation, DB2 for OS/390 does not have much in common with other DB2 platforms.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Nov 2003
Location: Germany
Posts: 62
Hi

And if you are at DB2 V7 you can choose the SHRLEVEL CHANGE option. Then there is no need to cancel any threads. The following restrictions hold for this option: LOG YES and RESUME YES.
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Dec 2003
Posts: 9
Before doing anything, you have to check what are those threads and which application is accessing the data.
There is a tool called OMEGAMON using which you can monitor the threads and if the application is just holding the threads for a long time without any action, you can kill the threads.

If you are using BMC, you can view the threads by just doing a
DIS LOCKS or DIS CLAIMERS on the tablespace..
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On