Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007

    Unanswered: Locks problems while exporting ???

    I'm running an old DB2 v7.1 AIX 4.3.
    I wrote a script to export some data from couple tables (production environment). Everytime I ran this script, users complain to have dead locks or lock-wait problems. If I check through get snapshot for locks for example I see couple users in soon as I cancel the shell (export) script execution all locks are cleared. How come a simple export can cause locks if I'm just doing a select statement? What can I do in order to fix this situation?
    Is there any other way to unload (batch) those files without locking everybody out?


  2. #2
    Join Date
    May 2003
    I can't remember if V7 supports WITH UR clause on a select. Try it and see.

    db2 export to employee.ixf of ixf select * from employee with ur
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    May 2007
    Thanks for the tip, but unfortunately DB2 v7.1 doesn't support such SELECT clasue. Do you know anything else that I could try?

Posting Permissions

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