The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > OS Specific Forums > Linux
Google UNIX.COM



View Single Post in UNIX Forums - Click on the Thread or Permalink to View Entire Thread -->
  #3 (permalink)  
Old 05-07-2008
frank_rizzo frank_rizzo is offline
Registered User
 

Join Date: Dec 2007
Posts: 208
try this

Code:
db2 -x "select CONTAINER_NAME ,usable_pages from table( SNAPSHOT_CONTAINER('TST103',-1)) as SNAPSHOT_CONTAINER, syscat.tablespaces where 
tablespace_name = tbspace and tbspacetype = 'D' and tbspace='TSOPS06'" | read container upages

echo "'${container}' ${upages}"
Reply With Quote