Interview Questions   Tutorials   Discussions   Programs   

DB2 - What does DSNDB07 database do?




500
views
asked mar August 3, 2014 06:31 AM  

What does DSNDB07 database do?


           

1 Answers



 
answered By Mswami   0  
DSNDB07 is where DB2 does its sorting. It includes DB2’s sort work area and external storage.

Basically, DSNDB07 is a work file database which consists of set of table spaces. These table spaces will be normally used by DB2 during SQL JOIN and SORT operations to store the intermediate result set of rows.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert