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

what platform? The easy answer would be can you access the table?
Dave

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?

We need to identify what option was used with the load command. This is in preparation for setting up HADR.

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.

looking at the logs, db2diag.log?

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.