Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to find Status Copy Pending in system catalog?

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Auryn

New User


Joined: 11 Jan 2006
Posts: 45
Location: Lower Saxony (DE)

PostPosted: Mon Jun 10, 2013 8:01 pm    Post subject: How to find Status Copy Pending in system catalog?
Reply with quote

Hello all,

today I deleted some image copy entries from SysIBM.SysCopy using the MODIFY RECOVERY command. - Which was my first time doing this...
The result was that some of the table spaces felt in status Copy Pending.
The good thing was I was able to verify the SysPrint, start new full image copies of the affected ts and reset their status.
But: Is it possible to query the system catalog if there is any table space in status Copy Pending? - Or the other table space, index etc. status?
Thank you for your hints
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1542
Location: Andromeda Galaxy

PostPosted: Mon Jun 10, 2013 8:29 pm    Post subject:
Reply with quote

You can identify copy pending status by running the DB2 command

Code:
-DIS DB(<DATABASE NAME>) SPACE(<TABLE SPACE NAME>)
Back to top
View user's profile Send private message
Bang_1

New User


Joined: 08 May 2009
Posts: 39
Location: Bangalore

PostPosted: Mon Jun 10, 2013 9:03 pm    Post subject:
Reply with quote

Hi Auryn,
If you need Table Spaces or Indexes that are in restrictive / pending status alone under a particular database, use the below DB2 command

-DIS DATABASE(dbname) SPACENAM(*) RESTRICT
Back to top
View user's profile Send private message
Auryn

New User


Joined: 11 Jan 2006
Posts: 45
Location: Lower Saxony (DE)

PostPosted: Thu Jan 16, 2014 7:03 pm    Post subject:
Reply with quote

This thread hat been fallen into oblivion to me for a while.
But today it's getting relevant again.

The both Commands were helpful to me last summer and today again.

But my opening question was:
Is it possible to retrieve the Copy-Pending status by analyzing any Sysibm.Sys... Tables? I.e. in column SysTableSpaces.Status you can see if the tablespace is active, in status CHECK pending and some others.
But - according to my documentations - there is no value for status COPY pending.
Where else is this stored?
How can I retrieve this with a (more or less) simple SQL Select query?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Jan 21, 2014 8:54 pm    Post subject:
Reply with quote

http://ibmmainframes.com/viewtopic.php?t=54613
Back to top
View user's profile Send private message
Auryn

New User


Joined: 11 Jan 2006
Posts: 45
Location: Lower Saxony (DE)

PostPosted: Wed Jan 22, 2014 2:47 pm    Post subject:
Reply with quote

GuyC wrote:
http://ibmmainframes.com/viewtopic.php?t=54613


Thank you for pointing out the DB2 Command and repeating older answers.

But this is not what I was asking for...

Again:
I'm asking for a select statement similar to
Code:
SELECT *
FROM sysibm.sys???
WHERE SysCol = '???'
WITH UR

that achieves the same result than he mentioned DB2 command...
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1542
Location: Andromeda Galaxy

PostPosted: Wed Jan 22, 2014 3:23 pm    Post subject:
Reply with quote

Auryn - Did you care to read the reply ?

GuyC wrote:
I don't think it is reflected in the catalog.
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 683
Location: Pennsylvania

PostPosted: Wed Jan 22, 2014 6:10 pm    Post subject:
Reply with quote

Again:

There is no SQL/Select statement for what you are asking for.

The DB2 Command is the old, new and only answer.

Please reply your understanding, so the moderator can lock this topic.
Back to top
View user's profile Send private message
Auryn

New User


Joined: 11 Jan 2006
Posts: 45
Location: Lower Saxony (DE)

PostPosted: Wed Jan 22, 2014 6:32 pm    Post subject:
Reply with quote

GuyC wrote:
I don't think it is reflected in the catalog. (...)


1000 Sorries for my last post, I had overlooked that sentence :-(
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts XMITIP sends it out. Can it copy on l... Rommel Dayon Rustia IBM Tools 0 Tue Sep 05, 2017 10:16 am
No new posts Command to find TMEMBER name for a TPIPE Siva NKK Kothamasu IMS DB/DC 0 Wed Aug 16, 2017 6:08 pm
No new posts Unable to copy data from spool in a d... srikant314 JCL & VSAM 8 Fri Jul 28, 2017 9:10 pm
No new posts How system know which REXX to excute? jackzhang75 CLIST & REXX 14 Thu Jul 06, 2017 1:09 am
No new posts Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us