More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
How do we unload the DB2 tables using JCL?
BMC has more efficient tool "BMCLOAD" and "BMCUNLOAD"
than IBM utilities. Use BMCUNLOAD to unload DB2 tables. You need to write a JCL wherein you need to supply empty files to unload the data from DB2 tables.
If DBP1 is the subsystem name, then the below unload step can be used
//STEP001 EXEC DBP1UNLD,USER='USERNAME',ULDTAB='FILE1',DATE='UNLOAD(+1)'
//UNLOAD.SYSREC00 DD SPACE=(CYL,(65,10),RLSE)
//SYSIN DD *
CORP.TBMC01
CORP.TBMC01 is the tablename
A new GDG version of name USERNAME.FILE1.UNLOAD1 will be created.
(Continued on next question...)