IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Query on Image Copy Tablespace and QUIESCE


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Fri Oct 23, 2015 10:55 am
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

Global Moderator


Joined: 21 Sep 2010
Posts: 2727
Location: NYC,USA

PostPosted: Fri Oct 23, 2015 12:30 pm
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.
ibmmainframes.com/about64064.html
Back to top
View user's profile Send private message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Wed Oct 28, 2015 2:01 pm
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: 2455
Location: Hampshire, UK

PostPosted: Wed Oct 28, 2015 6:48 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DB2: Need helping below DB2 query DB2 13
No new posts Map VSAM Dataset to a Table/Tablespace DB2 2
No new posts DB2 SQL query to read and update data... DB2 12
This topic is locked: you cannot edit posts or make replies. copy file 2 data into file1 for match... DFSORT/ICETOOL 4
No new posts Cobol-db2 : SQL query is running for ... DB2 4
Search our Forums:

Back to Top