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
 

 

Copy pending status of a table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rajesh_m

New User


Joined: 15 Apr 2008
Posts: 39
Location: India

PostPosted: Thu Apr 17, 2008 5:17 pm    Post subject: Copy pending status of a table
Reply with quote

How to check the copy pending status of a table. Is there any status field kind of thing to check the status.
Back to top
View user's profile Send private message

sri_mf

Active User


Joined: 31 Aug 2006
Posts: 216
Location: India

PostPosted: Fri Apr 18, 2008 3:14 pm    Post subject: Re: Copy pending status of a table
Reply with quote

rajesh_m wrote:
How to check the copy pending status of a table. Is there any status field kind of thing to check the status.


-DISPLAY DATABASE(dddd) SPACENAM(tttt)

If u display it will show the status of the space whether in R/RW mode.
Back to top
View user's profile Send private message
rajesh_m

New User


Joined: 15 Apr 2008
Posts: 39
Location: India

PostPosted: Sat Apr 19, 2008 8:17 pm    Post subject: Reply to: Copy pending status of a table
Reply with quote

I want to know it from a sql query is it possible?
Back to top
View user's profile Send private message
sri_mf

Active User


Joined: 31 Aug 2006
Posts: 216
Location: India

PostPosted: Mon Apr 21, 2008 11:57 am    Post subject: Re: Reply to: Copy pending status of a table
Reply with quote

rajesh_m wrote:
I want to know it from a sql query is it possible?


may be but i am not sure of that some one has to throw lite on this.
Back to top
View user's profile Send private message
Ajesh

New User


Joined: 03 Apr 2008
Posts: 6
Location: Chennai

PostPosted: Tue Apr 22, 2008 11:55 am    Post subject: Reply to: Copy pending status of a table
Reply with quote

Rajesh,

When u try to access a table which is in copy pending status,the SQL query will return you an SQL code -904.This way you can identify it.

Hope this solves your problem.
Back to top
View user's profile Send private message
sri_mf

Active User


Joined: 31 Aug 2006
Posts: 216
Location: India

PostPosted: Tue Apr 22, 2008 12:26 pm    Post subject: Re: Reply to: Copy pending status of a table
Reply with quote

Ajesh wrote:
Rajesh,

When u try to access a table which is in copy pending status,the SQL query will return you an SQL code -904.This way you can identify it.

Hope this solves your problem.


The copy pending status will appear when image copies job fails while copying the data to Tape or DASD. So the Tablespace status will be copy pending status and the table will be an read only table with no updates.
Back to top
View user's profile Send private message
Bharath Bhat

Active User


Joined: 20 Mar 2008
Posts: 283
Location: chennai

PostPosted: Tue Apr 22, 2008 3:36 pm    Post subject: Re: Reply to: Copy pending status of a table
Reply with quote

rajesh_m wrote:
I want to know it from a sql query is it possible?

You need to have a DB2 command processor for that! icon_cool.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    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 Data replication from multiple Db2 ta... kishpra DB2 1 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am


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