Thanks David for all the help!
Mery B. Moreno
Database Administrator - DBA
Lakeland Regional Medical Center
Phone: 863-687-1100 Ext 2830
>>> "David" <db2udbdba-ezmlmshield-x22834889.[Email address protected] 07/28/04 11:09PM >>>
**************************************************************************
Note: This e-mail is subject to the disclaimer contained at the bottom
of this message.
**************************************************************************
:
Mery,
Use the following command (run under DSNUTILB):
REPAIR SET TABLESPACE PHABL0PA.PIXDTL NORCVRPEND
David Chapman,
IBM Certified DBA for DB2 UDB on OS/390, Linux, Unix and Windows.
|---------+------------------------------------------------------->
| | Mery Moreno |
| | <db2udbdba-ezmlmshield-x416004.[Email Address Removed] | azyDBA.com> |
| | |
| | 29/07/2004 05:35 |
| | |
|---------+------------------------------------------------------->
>----------------------------------------------------------------------------------------------|
| |
| To: LazyDBA Discussion <[Email address protected] |
| cc: |
| Subject: how to release recovery flag |
>----------------------------------------------------------------------------------------------|
** High Priority **
DSNU050I DSNUGUTC - RECOVER TABLESPACE PHABL0PA.PIXDTL DSNUM ALL
DSNU514I - DSNUCASA - RECOVERY DATA DOES NOT PERMIT DSNUM(ALL) RECOVERY
OF TABLESPACE PHABL0PA.PIXDTL
Gurus,
I need your advise, I tried to recover this tablespace, but I am not
able. I have a RECOVER flag on this table due to this job failed last
night. I don't have a backup job for it either. Please help me how I can
release the RECP flag on this table
Plataform OS/390 version 6
I really appreciate for all the help!
DSNU562I - DSNUGSRX - TABLESPACE PHABL0PA.PIXDTL IS IN RECOVER PENDING
DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
Mery B. Moreno
Database Administrator - DBA
Lakeland Regional Medical Center
Phone: 863-687-1100 Ext 2830
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Moreno, Mery
ORG:;I.S.
EMAIL;WORK;PREF:Mery.[Email address protected]
N:Moreno;Mery
TITLE:DBA
END:VCARD
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]
:
********************************************************************************
The information transmitted in this message and attachments (if any)
is intended only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material.
Any review, retransmission, dissemination or other use of, or taking
of any action in reliance upon this information, by persons or entities
other than the intended recipient is prohibited.
If you have received this in error, please contact the sender and delete this
e-mail and associated material from any computer.
The intended recipient of this e-mail may only use, reproduce, disclose or
distribute the information contained in this e-mail and any attached files,
with the permission of the sender.
This message has been scanned for viruses and cleared by MailMarshal.
********************************************************************
:
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Moreno, Mery
ORG:;I.S.
EMAIL;WORK;PREF:Mery.[Email address protected]
N:Moreno;Mery
TITLE:DBA
END:VCARD
DB2 & UDB email list listserv db2-l LazyDBA home page