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

IBMHPU - Tablespace and Imagecopy


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Fri Apr 15, 2016 5:56 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts force tablespace using LISTDEF input DB2 1
No new posts Map VSAM Dataset to a Table/Tablespace DB2 5
No new posts DB2 tablespace space limitation DB2 3
No new posts Issue While Recovering a Tablespace DB2 4
No new posts Need inputs on DB2 tablespace/table r... DB2 3
Search our Forums:

Back to Top