I haven't used DB2 load and unload utility before. I have a JCL for table unload. But I am not that familiar with the parameters used. I plan to use the following JCL

//Step01 EXEC PGM=INZUTILB
Then a Steplib,followed by SYSPUNCH DD DSN = xxxxx.xxxxx.xxxxx, disp=(new, catlg)

Then SYSIN DD *
UNLOAD TABLESPACE table space name
DB2 YES
SELECT * from tablename
WITH UR
FORMAT DSNTIAUL
LOADDDN SYSPUNCH LOADOPT(RESUME NO REPLACE)
OUTDDN (SYSREC00)

/*
//SYSREC00 DD DSN = outputfile name to be created
//**************************
I would be thankful if some one explain in brief the format statement, the meaning of ""UR" in the select satement. I also see the QUIESCE YES QUIESCECAT NO LOCK No etc. What other FORMATS are associated with Load utility. A good link that explains load/unload tables in DB2 will also be beneficial.

The WITH UR is standard SQL that specifies the isolation level (Uncommitted Read). This is explained in the SQL Reference manual.

The load and unload parms are explained in the DB2 z/OS Utilities Reference manual, which you can download from the IBM website (sorry, don't have a link handy, but you can google it).

Thank you Markus.



TDNJ