Restarting after commit

[John Sayre <john_sayre@GAP.COM>]

I have to produce a report and do table inserts which is causing a DB2
  -905 error.
  I want to do a commit, but am having problems getting the query to
pick
  up where it left off.

  The problem is that the query has an order by clause which orders on 6
  things:
  Division number
  zone
  region
  district
  store
  employee id

  I actually can get this to restart exactly where it was at the commit
 by
  putting variables
  in the query where clause. (and zone# >= saved zone#)

  The problem is always:

  When the higher level sort resets to a lower # the lower sort has to
as
  well

  I can't consistently get this to restart at the place it was, but at
 the
  next emplid
  then if the higher levels, to reset the lower levels at exactly the
  right time. I get too few
  rows.

  Any ideas?