DSNU406I !!!

[login to unmask email]

DSNU406I !!!
While taking a fullimagecopy on a TS in a non-datasharing enviroment and
invoking a normal :

COPY TABLESPACE DBxxxxxx.TSxxxxxx COPYDDN SYSCOPYx

I received a warning (04) DSNU406 !!! wich means :

DSNU406I FULL IMAGE COPY SHOULD BE TAKEN FOR BOTH LOCAL SITE AND RECOVERY
SITE.

Explanation: The requested full image is for one site only but history
shows that there were image copies taken for both local site and recovery
site and the table space is in copy pending status, or point in time
recover has been done on the table space, or the table space is in copy
pending status and the requested full image copy is for a site other than
the current site. Be aware of the following situations:

bla,bla,bla .....

I ,never in the past , made a recovery site copy ?!?!?!

Thanks in advance ,


Pino.

[login to unmask email]

Re: DSNU406I !!!
(in response to Giuseppe_Di_Donna@CARTASI.IT)
Hi Pino,

History never lies...At some point in time someone took an image
copy with RECOVERYDDN specified in the image copy control card.
This is just a warning and can be ignored if you do not intend to
perform disaster recovery by bringing up DB2 as 'recovery site'.
Many installations create two image copies of a tablespace, one
for local recovery (COPYDDN) and one for disaster recovery purposes
(RECOVERYDDN). At the disaster recovery site, DSNZPARM is changed
to recovery site and DB2 calls for image copies created with the
RECOVERYDDN DD.

Regards,

Michael Levine
Premier Data Services, Inc.


>While taking a fullimagecopy on a TS in a non-datasharing enviroment and
>invoking a normal :
>
>COPY TABLESPACE DBxxxxxx.TSxxxxxx COPYDDN SYSCOPYx
>
>I received a warning (04) DSNU406 !!! wich means :
>
>DSNU406I FULL IMAGE COPY SHOULD BE TAKEN FOR BOTH LOCAL SITE AND RECOVERY
> SITE.
>
>Explanation: The requested full image is for one site only but history
>shows that there were image copies taken for both local site and recovery
>site and the table space is in copy pending status, or point in time
>recover has been done on the table space, or the table space is in copy
>pending status and the requested full image copy is for a site other than
>the current site. Be aware of the following situations:
>
>bla,bla,bla .....
>
>I ,never in the past , made a recovery site copy ?!?!?!
>
>Thanks in advance ,
>
>
>Pino.
>
>

James Campbell

Re: DSNU406I !!!
(in response to Mike_Levine@TEKHELP.NET)
Giuseppe

What does the following SQL reveal:

SELECT * FROM SYSIBM.SYSCOPY
WHERE DBNAME = 'DBxxxx' AND TSNAME = 'TSxxxxxx'
AND ICTYPE = 'F' AND ICBACKUP='RP'
?

If it does produce some rows, you might want to run a MODIFY RECOVERY to
delete the rows. You won't, then, get this message.

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Tooronga
+61 3 9261 1802
[login to unmask email]
-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Friday, October 08, 1999 10:25 PM
To: [login to unmask email]
Subject: DSNU406I !!!


While taking a fullimagecopy on a TS in a non-datasharing enviroment and
invoking a normal :

COPY TABLESPACE DBxxxxxx.TSxxxxxx COPYDDN SYSCOPYx

I received a warning (04) DSNU406 !!! wich means :

DSNU406I FULL IMAGE COPY SHOULD BE TAKEN FOR BOTH LOCAL SITE AND
RECOVERY
SITE.

Explanation: The requested full image is for one site only but history
shows that there were image copies taken for both local site and
recovery
site and the table space is in copy pending status, or point in time
recover has been done on the table space, or the table space is in copy
pending status and the requested full image copy is for a site other
than
the current site. Be aware of the following situations:

bla,bla,bla .....

I ,never in the past , made a recovery site copy ?!?!?!

Thanks in advance ,


Pino.