Restriction: This topic applies to Windows environments only. 
                  		  
               
 
               		
              
            	 
             
               		
               - From the HCOSS Extract Schema tool, click the 
                  		  Schema Extract tab. 
                  		
               
- Select an existing schema extract file from the 
                  		  Schema Extract Name drop-down list. 
                  		
               
- Using the fields and controls on the 
                  		  Schema Extract tab change the settings as required. 
                  		  
                  Note: If you change the properties from 
                     			  Local to 
                     			  Shared, or vice versa, you have the following options: 
                     			 
                       
                        				
                        - Move the existing extract file to the new location 
                           				
                        
- Copy the existing extract file to the new location 
                           				
                        
- Neither move nor copy the existing extract file 
                           				
                        
 
 
- Click 
                  		  Extract. 
                  		
               
- On the 
                  		  Results tab, verify that the schema extract file has been generated properly. 
                  		  
                  Note: If you get a -551 SQL error extracting a table, no schema is extracted. To correct this, have your DB2 DBA grant you READ
                     access to the table that generated the error; then rerun the Extract Schema tool. 
                     		  
                   
- On the 
                  		  Schema Extract tab, click 
                  		  Save to save the new settings.