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 Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
No new posts copy SEQ to PDS and create stats steve-myers JCL & VSAM 7 Thu Apr 27, 2017 1:15 am
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am


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