Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db2 connect to tsmdb1
- db2 set schema tsmdb1
- db2 -x "select imt.objid, imt.nodeid, imt.fsid, '\"'||cast( hl_name as VARCHAR( 1024 ) for sbcs data )||'\"', '\"'||cast( ll_name as VARCHAR( 1024 ) for sbcs data )||'\"' from backup_objects imt, nodes nd where ( imt.nodeid=nd.nodeid and ( nd.repl_mode=2 or nd.repl_mode=4 )) AND NOT EXISTS (select 1 from replicated_objects nrro where imt.objid=nrro.objid) for read only with ur /*<OPTGUIDELINES><IXSCAN TABLE='nrro' INDEX='NRRO_NDX' /></OPTGUIDELINES>*/" > command.out
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement