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: 30
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: 1609
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: 30
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: 1712
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 syncsort: copy lines after the keyword shreya19 SYNCSORT 1 Fri Dec 02, 2016 9:47 am
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts Single COPY CICS TS datasets and when... Kyle Carroll CICS 2 Tue Oct 11, 2016 9:47 pm


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