View previous topic :: View next topic
|
Author |
Message |
Auryn
New User
Joined: 11 Jan 2006 Posts: 83 Location: Lower Saxony (DE)
|
|
|
|
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 |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
You can identify copy pending status by running the DB2 command
Code: |
-DIS DB(<DATABASE NAME>) SPACE(<TABLE SPACE NAME>) |
|
|
Back to top |
|
|
Bang_1
New User
Joined: 08 May 2009 Posts: 39 Location: Bangalore
|
|
|
|
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 |
|
|
Auryn
New User
Joined: 11 Jan 2006 Posts: 83 Location: Lower Saxony (DE)
|
|
|
|
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 |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
Back to top |
|
|
Auryn
New User
Joined: 11 Jan 2006 Posts: 83 Location: Lower Saxony (DE)
|
|
|
|
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 |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Auryn - Did you care to read the reply ?
GuyC wrote: |
I don't think it is reflected in the catalog.
|
|
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
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 |
|
|
Auryn
New User
Joined: 11 Jan 2006 Posts: 83 Location: Lower Saxony (DE)
|
|
|
|
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 |
|
|
|