ASN0011E: Reorg without keepdictionary

Maria Victoria Lainez Gutierrez

ASN0011E: Reorg without keepdictionary
Hello Pete (Woodman),

After the problem we had with Data Propagator (Reorg wihout keepdictionary) in November, that we solved losing data, we decided to test the procedure you sent us.


I believe that this might work ...

1. Image Copy the Tablespace.

2. Put the in Tablespaces UT.

3. Recover the Tablespace (or Partition) to before the Reorg ran without


4.Start the Tablespace in RO.

5. Start Capture and allow it to catch up to where the Reorg ran.

6. Shut Capture down.

7. Start the Tablespace in UT.

8. Recover the Tablespace back to 1.

9.Start the Tablespace in RO

10. Start Capture and wait for it to get up to date.

11.Start Tablespace in RW

I've not tried this personally, but we do have these instructions documented

just in case.

We have reproduced the same situation in a test environment and your procedure works fine. It's perfect.

Thanks a lot,

Vicky Láinez

Este mensaje se dirige exclusivamente a su destinatario. Los datos incluidos en el
presente correo son confidenciales y sometidos a secreto profesional, especialmente en lo que
respecta a los datos personales, se prohibe divulgarlos, en virtud de las
leyes vigentes. Si usted no lo es y lo ha recibido por error o tiene conocimiento
del mismo por cualquier motivo, le rogamos que nos lo comunique por este medio y proceda
a destruirlo o borrarlo, y que en todo caso se abstenga de utilizar, reproducir, alterar,
archivar o comunicar a terceros el presente mensaje y ficheros anexos, todo ello bajo
pena de incurrir en responsabilidades legales. Cualquier idea contenida en este correo
es exclusiva de su autor y no representa necesariamente el criterio de Iberdrola. El
emisor no garantiza la integridad, rapidez o seguridad del presente correo, ni se
responsabiliza de posibles perjuicios derivados de la captura, incorporaciones de virus o
cualesquiera otras manipulaciones efectuadas por terceros.

This message is intended for the exclusive attention of the address(es) indicated. Any
information contained herein is strictly confidential and privileged, especially as
regards personal data, which must not be disclosed, in accordance with legislation
currently in force. If you are not the intended recipient and have received it by mistake
or learn about it in any other way, please notify us by return e-mail and delete this
message from your computer system. Any unauthorised use, reproduction, alteration, filing
or sending of this message and/or any attached files to third parties may lead to legal
proceedings being taken. Any opinion expressed herein is solely that of the author(s) and
does not necessarily represent the opinion of Iberdrola. The sender does not guarantee
the integrity, speed or safety of this message, not accept responsibility for any
possible damage arising from the interception, incorporation of virus or any other
manipulation carried out by third parties.


* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
** Your only source for independent, unbiased, and trusted DB2 information.

** The most DB2 technical sessions of any conference
** Access IBM experts and developers

If you need to change settings, is the home of IDUG's DB2-L