Question on RECP

Jose de Bedos

Question on RECP

Hi,

is there a way to know since when a TS is in RECP?
Any clues will be welcome.

Thanks,

Jose


_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE
______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Steen Rasmussen

Re: Question on RECP
(in response to Jose de Bedos)
Execute this command;



-DIS DB(*) SPACE(*) RESTRICT



It should give you pagesets in RECP, LPL, AREO* etc.



Steen Rasmussen
CA

Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals

IBM Certified Database Administrator - DB2 9 DBA for z/OS



From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jose de Bedos
Sent: Thursday, December 18, 2008 4:46 PM
To: [login to unmask email]
Subject: [DB2-L] Question on RECP



Hi,

is there a way to know since when a TS is in RECP?
Any clues will be welcome.

Thanks,

Jose



________________________________

Explore the seven wonders of the world Learn more!
<http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBR
E>



________________________________

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Steen Rasmussen

Re: Question on RECP
(in response to Steen Rasmussen)
Sorry - I didn't see the word WHEN.

I honestly have never seen a TIMESTAMP for this DBET status.



Steen Rasmussen
CA

Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals

IBM Certified Database Administrator - DB2 9 DBA for z/OS





From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jose de Bedos
Sent: Thursday, December 18, 2008 4:46 PM
To: [login to unmask email]
Subject: [DB2-L] Question on RECP



Hi,

is there a way to know since when a TS is in RECP?
Any clues will be welcome.

Thanks,

Jose



________________________________

Explore the seven wonders of the world Learn more!
<http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBR
E>



________________________________

IDUG 2009 - North America * May 11-15, 2009 * Denver, CO, USA
< http://idug.org/lsNA >

The IDUG DB2-L Listserv is only part of your membership in IDUG. The
DB2-L list archives, FAQ, and delivery preferences are at IDUG.ORG
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more. If you have not yet signed
up for Basic Membership in IDUG, available at no cost, click on Member
Services < http://www.idug.org/lsms >


______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Peter Vanroose

Re: Question on RECP
(in response to Steen Rasmussen)
You could look in SYSIBM.SYSCOPY for potential reasons for a RECP (e.g., as
a consequence of an incomplete utility like LOAD or RECOVER); there you'll
have your timestamps.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Jose de Bedos

Re: Question on RECP
(in response to Peter Vanroose)

Hi Peter,

thanks for your answer. The last thing I have in SYSCOPY is a LOAD (don't remember if it's REPLACE or not), but I thought that if the LOAD finished badly, there shouldn't be any record in SYSCOPY.
Is that wrong?
Kind regards,

Jose
> Date: Thu, 18 Dec 2008 23:43:50 +0000> From: [login to unmask email]> Subject: Re: Question on RECP> To: [login to unmask email]> > You could look in SYSIBM.SYSCOPY for potential reasons for a RECP (e.g., as> a consequence of an incomplete utility like LOAD or RECOVER); there you'll> have your timestamps.> > ______________________________________________________________________> > * IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *> ______________________________________________________________________> > > > The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms
_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

James Campbell

Re: Question on RECP
(in response to Jose de Bedos)
The only way I could think of is to scan the log looking for when the RECP
status was applied to DSNDB01.DBD01.

However, I have no clue what you should look for that shows the RECP
status going on. The best I can think of is to note when the RECP comes
off and see what change happened. Look for the reverse action.

James Campbell

>
>
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Jose de
> Bedos
> Sent: Thursday, December 18, 2008 4:46 PM
> To: [login to unmask email]
> Subject: [DB2-L] Question on RECP
>
>
>
> Hi,
>
> is there a way to know since when a TS is in RECP?
> Any clues will be welcome.
>
> Thanks,
>
> Jose
>
>

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Fred Johnson

Re: Question on RECP
(in response to James Campbell)
A query against SYSIBM.SYSCOPY should give you the utilities that ran against
the tablespace. My experience is that failed LOADS are recorded in the
SYSCOPY(At the beginning of the load phase?). The RBA from SYSCOPY could
be used as a recovery point assuming you want a PIT recovery. A query
against syscopy can also give you an idea of the jobnames and authids that
are running utilities against the tablespace allowing you to investigate archived
sysout.

A -DIS UTILITY(*) would give you the utility id of the offending job assuming
the utility was not terminated.

-- Example SYSCOPY Query for a single DBNAME.TSNAME
-- Replace $DBNAME and $TSNAME with the name of your objects
SELECT
DBNAME, TSNAME,
CASE ICTYPE
WHEN 'F' THEN 'FULL COPY'
WHEN 'I' THEN 'INCR COPY'
WHEN 'Q' THEN 'QUIESCE'
WHEN 'W' THEN 'REORG LOG NO'
WHEN 'X' THEN 'REORG LOG YES'
WHEN 'S' THEN 'LOAD REPL LOG NO'
WHEN 'R' THEN 'LOAD REPL LOG YES'
WHEN 'Y' THEN 'LOAD RESU LOG NO'
WHEN 'Z' THEN 'LOAD RESU LOG YES'
WHEN 'T' THEN 'TERM COPY'
WHEN 'P' THEN 'PIT RECOVER'
WHEN 'A' THEN 'ALTER'
WHEN 'B' THEN 'REBUILD IX'
WHEN 'D' THEN 'CHECK DATA LOG NO' ELSE ' ? '||ICTYPE
END AS TYPE
,jobname, authid, DATE(TIMESTAMP) as Date, TIME(TIMESTAMP) as time
-- ,'**All Columns**',SYSCOP.*
FROM SYSIBM.SYSCOPY SYSCOP
WHERE DBNAME = '$DBNAME'
AND TSNAME = '$TSNAME'
ORDER BY TIMESTAMP DESC
FOR READ ONLY WITH UR;

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/Events *
______________________________________________________________________




IDUG.org was recently updated requiring members to use a new password. You should have gotten an e-mail with the temporary password assigned to your account. Please log in and update your member profile. If you are not already an IDUG.org member, please register at http://www.idug.org/component/juser/register.html