Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 40
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: 1529
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: 40
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: 1278
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: 40
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: 1529
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: 645
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: 40
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 syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts How to find the first monday of the w... abdulrafi COBOL Programming 10 Fri Nov 25, 2016 3:24 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us