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
 

 

IBMHPU - Tablespace and Imagecopy

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

New User


Joined: 15 Apr 2016
Posts: 1
Location: India

PostPosted: Fri Apr 15, 2016 5:46 pm    Post subject: IBMHPU - Tablespace and Imagecopy
Reply with quote

Hi ,

Need to know what will happen in the below scenario.

UNLOAD TABLESPACE
DB2 YES
SELECT *
FROM TableA
WHERE NST_ID = 'XYZ'
AND XY_ID IN ('ADB', 'PVR')
AND XYZID IN (SELECT XYZID FROM TableA
WHERE XY_ID = 'ADB'
AND ACCESS != '4');
OUTDDN (SYSREC)



UNLOAD SHRLEVEL CHANGE CONSISTENT NO INFILE IMAGECOPY FULL 0
SELECT *
FROM TableA
WHERE NST_ID = 'XYZ'
AND XY_ID IN ('ADB', 'PVR')
AND XYZID IN (SELECT XYZID FROM TableA
WHERE XY_ID = 'ADB'
AND ACCESS != '4');
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Fri Apr 15, 2016 5:56 pm    Post subject: Reply to: IBMHPU - Tablespace and Imagecopy
Reply with quote

When You have questions start a new thread/topic
it will save us moderator from fixing things
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 Image Copy of a tablespace that conta... Robin Sulsona DB2 4 Thu Jun 02, 2016 1:47 am
No new posts Query on Image Copy Tablespace and QU... vickey_dw DB2 3 Fri Oct 23, 2015 10:55 am
No new posts UNLOAD from Image Copy Tablespace wit... alluri12 DB2 5 Wed Sep 23, 2015 7:00 pm
No new posts BMC UNLOAD for a LOB tablespace JyothsnaNayak DB2 2 Wed Jul 29, 2015 2:02 am
No new posts Tablespace in UT state gylbharat DB2 11 Mon Feb 10, 2014 2:07 pm


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