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
 

 

Query on Image Copy Tablespace and QUIESCE

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

New User


Joined: 10 Jun 2015
Posts: 34
Location: India

PostPosted: Fri Oct 23, 2015 10:55 am    Post subject: Query on Image Copy Tablespace and QUIESCE
Reply with quote

While anlaying jobs in my application and came across below questions.

1. I have seen that some of the jobs are copying tablespace and other jobs
are taking the unload of the tables present in those tablespace.I dont
understand the need to take image copy of tables-space when we are
taking unload of all the tables present in the tablespace.
2. Some jobs are performing QUIESCE on TableSpace.To best of my
knowledge QUIESCE is used to gain Exclusive control.But these jobs are
not doing anything apart from QUIESCE,so i am not able to understand
then need.Also there is no UNQUIESCE in this jobs.


Thanks in Advance !!!
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1638
Location: NY,USA

PostPosted: Fri Oct 23, 2015 12:30 pm    Post subject:
Reply with quote

1. Unload and image copies are two different things. Unloading the database or a table has many reason like to unload production data every and use that files in QA or dev region for testing purpose, share the file to any vendor or to a external application, or to just reinstate the table to its earlier yesterday's volume by simply loading the table with this unload file and many more.however for disaster recovery you have a image copy or a snap of entire table space .
2. You could have searched before but here I found for you.
http://ibmmainframes.com/about64064.html
Back to top
View user's profile Send private message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 34
Location: India

PostPosted: Wed Oct 28, 2015 2:01 pm    Post subject:
Reply with quote

Thanks Rohit !!!

Just adding one more question to my post on same topic.

If tables are no longer used(application using these tables were sunset), is there any significance of image copying the tablespaces where these
tables resides ?
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1727
Location: UK

PostPosted: Wed Oct 28, 2015 6:48 pm    Post subject:
Reply with quote

'yes - if the appliation no longer exists/the tables are redundant then you are wasting resources - DASD and processor
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 Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts GETMAIN/FREEMAIN query Suja.Sai CICS 9 Tue Jan 31, 2017 12:01 pm
No new posts Mail via SMTP with an image? Mike 1304 JCL & VSAM 3 Thu Jan 26, 2017 2:01 pm
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm


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