1. db2 "select * from org"

DEPTNUMB DEPTNAME       MANAGER DIVISION   LOCATION    
-------- -------------- ------- ---------- -------------
      10 Head Office        160 Corporate  New York    
      15 New England         50 Eastern    Boston      
      20 Mid Atlantic        10 Eastern    Washington  
      38 South Atlantic      30 Eastern    Atlanta     
      42 Great Lakes        100 Midwest    Chicago     
      51 Plains             140 Midwest    Dallas      
      66 Pacific            270 Western    San Francisco
      84 Mountain           290 Western    Denver      

  8 record(s) selected.

2. db2 "export to org.ixf of ixf select * from org"

3. db2 "import from org.ixf of ixf replace_create into org_mirror"

4. db2 "delete from org_mirror where DEPTNUMB=10"

5. db2 "select * from org a where not exists(select * from org_mirror b where a.DEPTNUMB=b.DEPTNUMB)"

DEPTNUMB DEPTNAME       MANAGER DIVISION   LOCATION    
-------- -------------- ------- ---------- -------------
      10 Head Office        160 Corporate  New York    

  1 record(s) selected.

=> Estimated Cost = 26.194668
     Estimated Cardinality = 0.016667

    db2 "select * from org a where not exists(select 1 from org_mirror b where a.DEPTNUMB=b.DEPTNUMB)"

DEPTNUMB DEPTNAME       MANAGER DIVISION   LOCATION    
-------- -------------- ------- ---------- -------------
      10 Head Office        160 Corporate  New York    

  1 record(s) selected.

=> Estimated Cost = 26.194668
     Estimated Cardinality = 0.016667

두 sql이 하는일은 동일합니다.