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 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
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
This topic is locked: you cannot edit posts or make replies. session stuck in TPX with status ACL amitc23 CA Products 1 Tue Dec 13, 2016 12:53 pm


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