Women's voices become LOWER due to hormonal changes Two things we collect when measuring AMPLITUDE? 1. Men's voices become HIGHER due to thinning of VFs How do men and women's voices change over time? Infants: 350- 500 Hz Flexibility of VFs When measuring SFF, should be familiar with the average Fo across a lifespan: Sample duration: there can be significant differences in SFF samples that are 1 second, 30 seconds and 60 seconds What is SFF influenced by? (3) 1. Because it has been found that SFF during sustained phonation was higher than during reading a passage or conversational speechĢ. Why does the elicitation task matters during SFF?Ģ. Please note the new size cannot be less than the high water mark.1. Specify the size after being reduced, i.e. ALTER TABLESPACE statement with a RESIZE option.Please note the new size cannot be less than the high water mark. Specify the size to be reduced (ie New size = Current size - Reduced size). Please refer to Lowering High water mark section below in this tech note. IMPORTANT before running an ALTER TABLESPACE statement, the High water mark should be lowered manually. Reduces the Pending free pages and any free pages greater than the High water mark.ĭ) non-reclaimable DMS table space (non-auto storage) IMPORTANT Before running an ALTER TABLESPACE statement, the High water mark should be lowered manually. Please note the new size cannot be less than the high water mark.ĪLTER TABLESPACE TS1 REDUCE (FILE 'TS1' )Ĭ) non-reclaimable DMS table space using auto storage (available in V9.5 or later) Reduce the container size by using an ALTER TABLESPACE statement with a REDUCE option.Please refer to Lowering High water mark section for the output example. Next check the current Usable pages and the High water mark value by using a LIST TABLESPACE SHOW DETAIL command.First lower the high water mark with an ALTER TABLESPACE statement with a LOWER HIGH WATER MARK option.ĪLTER TABLESPACE TS1 LOWER HIGH WATER MARK.You should run the following command and statements. Please refer to the following page in document for the detailed behavior of extent movements.ī) Reclaimable DMS table space (non-auto storage) $ db2 "select * from table(SYSPROC.MON_GET_EXTENT_MOVEMENT_STATUS('', -1))" You can monitor the progress by using a MON_GET_EXTENT_MOVEMENT_STATUS table function. When you specify a size or MAX in a REDUCE option in an ALTER TABLESPACE statement, extent movement may be performed and it may take long time if the table space is very big. Extent movement may be performed as necessary. Reduces as many free extents as possible. ALTER TABLESPACE statement with REDUCE MAX option.Extent movement may be performed if necessary. Reduces pending free extents and other free extents by a specified size. ALTER TABLESPACE statement with a REDUCE option (with size specified).ALTER TABLESPACE statement with a REDUCE option.You can use any of the following options: Which one can be chosen depends on whether the table space is reclaimable or not and whether it uses auto storage or not.Ī) Reclaimable DMS table space using auto storage Please choose a method from the lists below. TBSP_NAME TBSP_ID TBSP_TYPE TBSP_USING_AUTO_STORAGE db2 "select char(TBSP_NAME,12)TBSP_NAME, TBSP_ID, TBSP_TYPE, TBSP_USING_AUTO_STORAGE from SYSIBMADM.SNAPTBSP" In V9.5 or before, you can use a SNAPTBSP administration view to confirm whether the table space uses auto storage or not. TBSP_NAME TBSP_ID TBSP_TYPE TBSP_USING_AUTO_STORAGE RECLAIMABLE_SPACE_ENABLED Object: 4 Tablespace: 2ĭAT Object Summary: Total Pages 5212 - Used Pages 5210 - Free Space 70 %ĭb2 "select char(TBSP_NAME,12)TBSP_NAME, TBSP_ID, TBSP_TYPE, TBSP_USING_AUTO_STORAGE, RECLAIMABLE_SPACE_ENABLED from table(MON_GET_TABLESPACE(null, null)) as t" Table phase start (ID Signed: 4, Unsigned: 4 Tablespace ID: 2) :ĭata phase start. Generally, when you reorganize a table which has large Total Pages and Free Space, large number of extents will be released.Įxample: Checking the usage of all the objects in the table space TS1.ĭb2 inspect check tablespace name TS1 results keep inspect_TS1.outĭb2inspf /inspect_TS1.out inspect_TS1.fmt It's useful to identify which table should be reorganized to reduce the size effectively. You can use an INSPECT command to check how much data actually using the space exist in the extents assigned to the objects like tables or indexes. Note 2: In a column-organized table (new functionality from V10.5), you need to add a RECLAIM EXTENTS option in the REORG command to release the extents from the object. Note it's possible that inserting new LOB data may become much slower after reorganizing the LOB data. If you would like to reduce the container size of LOB data by freeing unused space, you need to run a REORG command with a LONGLOBDATA option. Note 1: By default, LONG data and LOB data will not be reorganized.
0 Comments
Leave a Reply. |