View previous topic :: View next topic
|
Author |
Message |
darkranger
New User
Joined: 08 Mar 2007 Posts: 2 Location: KL
|
|
|
|
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 |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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. |
|
Back to top |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 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. |
|
Back to top |
|
|
|