title: DB2 LUW Parallel Jobs Execution
body: <p>I have been working in DB2 LUW database, i want to submit procedures as a parallel job. Meaning I have a procesure which will do some DDL, DML statements to one table. This table is having huge data, the same procedure need to run for few more tables run in parallel.</p>
  
  <p>I submit the job using DBMS_JOB.SUBMIT statement and executed the job using DBMS_JOB.RUN statement. I have job handler procedure which helps to do this in parallel.</p>
  
  <p>But each job is executing in sequentially (meaning the first job got completed then the second jobs started, after 2nd job completed 3rd job getting started.</p>
  
  <p>**My First Question ** 
  <em>how to run DBMS_JOB in parallel ?</em></p>
  
  <p>And second issue I'm facing is the cutrent session is still waiting to get complete all the jobs. I can't use that particular session, once all the job got completed than i can have access to use that same session.</p>
  
  <p>**My Second Question **
  *how to make the session accessible, instead of waiting for all jobs completed *</p>
  
  <p>Please help me sir/madam. </p>