Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Posts
    8

    Unanswered: DB2 Load and Unload

    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.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Oct 2010
    Posts
    8

    DB2 Load and Unload

    Thank you Markus.



    TDNJ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •