Results 1 to 6 of 6
  1. #1
    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.

  2. #2
    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

  3. #3
    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

    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.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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

  5. #5
    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.

  6. #6
    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..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •