Results 1 to 3 of 3

Thread: DB2 Load/Unload

  1. #1
    Join Date
    Oct 2010
    Posts
    8

    Unanswered: DB2 Load/Unload

    I never used DB2 load and unload utility before. When you unload data to a disk, to see the data readable as we see in a table, what options/parameters should be used? Similarly, to get the data loaded back to the same table from the disk and see the data in the original form before unloading, what options/parameters should be used? Please provide me a sample JCL for load and unload, if possible. It would be greatly appreciated.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I think unload creates a sequential dataset that can be viewed using some ISPF option. For unload/load JCL, why don't you copy it from another DBA and modify it.

  3. #3
    Join Date
    Oct 2010
    Posts
    8
    Thank you Bella. I used DB2 for File Aid and I am Ok.

Posting Permissions

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