Bind process is mainly for two processes:1. To syntax check the Query (To see the Columns and tables referred are actually present etc. )2. To find the efficient access path.Result of Bind is an Executable form of the DBRM.
The temporary datasets are created by using the option ===>//DD1 DD DSN=&&TEMP,DISP=(NEW,PASS,DELETE).The PASS is used instead of CATLG, because we need the dataset only for the temporary purpose. Th...
Just to elaborate on what others have said - Small temporary datasets can be directed to VIOs (Virtual I/O using memory) to elminate most of the delays associated with DASDs.