Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: DSNDB07 sort space extents

    We are Z/0s DB2 7.1 shop.
    For a special purpose i need to extract an output which calls for a join of more than 6 to 7 tables in a batch job. Because for different cluster indexes in the join and some order by clauses, the query going a big sort. We are getting -904 continuously on SORT 4k spaces. Till we get our system people to increase the space is there a way to augment the 4k spaces by providing SORKWK01..n DD cards in the job. Any other suggestions are welcome.

    ofcource .. beaking the query into parts is my final resort.
    Any help in this is appreciated.

    Thanks for the post marcus. Well, the select set is not more than 300 bytes.
    ORDER BY clause is required for the purpose of reporting.
    Last edited by chas_dba; 12-04-05 at 22:09.

  2. #2
    Join Date
    May 2003
    You can add sortwork in the JCL for utilities like reorg, etc, but in jobs that execute regular SQL statements that need to create system temporary tables.

    Also, if you are joining a lot of tables and the resulting row (or an intermediate row) is greater than 4000 bytes, DB2 may need to create temporary tables with a page size 8K or larger, and you system would need to be configured to support that.
    Last edited by Marcus_A; 12-03-05 at 23:31.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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