Good day everyone.
I have a serious problem that has not been solved for a very long time.
If i drop a tablespace, any backup info for that tablespace will disappear from SYSIBM.SYSCOPY
What happen? and how do I rectify this?
Thanks in advance
Joined: 23 Nov 2006 Posts: 9211 Location: 221 B Baker St
Hello,
I believe you want a feature to work differently than intended.
SYSIBM.SYSCOPY contains recovery information. When you drop a table, there can be no recovery - the table no longer exists.
Keep in mind that dropping a table is not some trivial thing to regularly do. When you do drop a table, it requires a new CREATE before it can be used. When you recreate the table and use it, syscopy is re-established. Also keep in mind that db2 does not know the table will recreated when it is dropped. As far as the database knows, the table is no longer needed.
Joined: 05 Feb 2007 Posts: 160 Location: Sri Lanka
darkranger wrote:
I have a serious problem that has not been solved for a very long time.
If i drop a tablespace, any backup info for that tablespace will disappear from SYSIBM.SYSCOPY
What happen? and how do I rectify this?
Thanks in advance
If you have dropped the tablespace and want the data back from the IC backup, you may create the tablespace, tables etc again and try using DSN1COPY with OBIDXLAT parms. This requires that you have a DDL backup of the things you dropped.
Anyway seems strange that it is a serious problem for you especially since as you mentioned that it hasn't been resolved for very long time.
