Results 1 to 7 of 7

Thread: db2 load option

  1. #1
    Join Date
    Apr 2010
    Posts
    3

    Unanswered: db2 load option

    I need to know if tables were loaded using COPY YES, COPY NO or NONRECOVERABLE. Is there any way to get this information?

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    what platform? The easy answer would be can you access the table?
    Dave

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Once it is loaded I do not see how can you tell how it was loaded unless you have a load script. What difference does it make to you?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  4. #4
    Join Date
    Apr 2010
    Posts
    3
    We need to identify what option was used with the load command. This is in preparation for setting up HADR.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    The history file (db2 list history command) will give some info. You will see a C (load copy) operation after L (load) for a load with copy yes. I don't believe there is a way to tell if load was done with copy no or nonrecoverable without looking at the logs.

  6. #6
    Join Date
    Apr 2010
    Posts
    3
    looking at the logs, db2diag.log?

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    This information (copy yes/no, nonrecoverable) is captured in the transaction logs. You can probably use db2readlog api to access this info or some tool.

Posting Permissions

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