Displaying file system space usage information

Use the Storage Checkpoint Capacity Planning utility to display space-usage information for VxFS file systems and the associated Storage Checkpoints. You can monitor this space-usage information as your Storage Checkpoint-creation schedules progress.

Before starting Storage Checkpoint Planning utility, the following conditions must be met:

Usage notes

  • If a Storage Checkpoint is created using other tools and products (for example, through the command line interface using the dbed_ckptcreate command or VERITAS NetBackup), then the following will occur when a Storage Checkpoint Capacity Planning schedule is in progress:

    The Storage Checkpoint Capacity Planning utility will fail the next time cron attempts to create a Storage Checkpoint at the time designated in the schedule you created.

    The Storage Checkpoint Capacity Planning utility will display the following error when displaying the Storage Checkpoint space information using the Display Space Usage Information operation:

    DBED1007: Non-Capacity Planning Storage Checkpoints detected.

To display VxFS file system and Storage Checkpoint space usage using the Capacity Planning utility

  1. From the Storage Checkpoint Capacity Planning menu, type 3 to select Display Space Usage Information:

    
    
    VERITAS Storage Foundation for Oracle (ORACLE_SID 'PROD')
    Menu: Storage Checkpoint Capacity Planning
    
    1			Create Capacity Planning Schedules
    2			Display Capacity Planning Schedules
    3			Display Space Usage Information
    4			Remove Capacity Planning Schedules
    
    ?			Display Help About the Current Menu
    q			Exit From Current Menu
    x			Exit From Capacity Planning Utility
    
    Select Operation to Perform: 3
  2. Select the kind of space-usage information you want to display:

    VERITAS Storage Foundation for Oracle (ORACLE_SID 'PROD')
    Menu: Display Space Usage Information
    
    1			Display Space Usage for the Current Instance
    2			Display Space Usage for a List of File Systems
    3			Display Space Usage for All File Systems
    4			Display Space Usage by Schedule
    
    ?			Display Help About the Current Menu
    q			Exit From Current Menu
    x			Exit From Capacity Planning Utility
    
    Select Operation to Perform: 1

    Select from the following operations:

    Display Space Usage for the Current Instance

    Displays space-usage information for the VxFS file systems contained in the current database instance.

    Display Space Usage for a List of File Systems

    Displays space-usage information for the VxFS file systems listed in a user-supplied list file. You are prompted for the list file name when you select this operation.

    Display Space Usage for All File Systems

    Displays space-usage information for all VxFS file systems on the host.

    Display Space Usage by Schedule

    Displays space-usage information for the VxFS file systems by Storage Checkpoint Capacity Planning schedule. You are prompted for the schedule number for which you want to display the space usage.

    For example, to display VxFS file system and Storage Checkpoint space-usage information for the current database instance, type 1 on the Display Space Usage Information menu:

    File System (1K block)				 FS Size				Used			Avail			%Full
    
    ----------------------				---------		------	-------	-------
    
    /db01					                	10.0GB			  5.3GB		4.5GB			53.4%
    
    Storage Checkpoint							 Creation Time 					 	     	Space Needed
    
    -------------------					  ---------------						     --------------
    
    Planning_00001_956765641		Wed Oct 27 09:14:01 2001						 82.0KB
    
    Planning_00001_956762040		Wed Oct 27 08:14:00 2001								4.0KB
    
    Planning_00001_956758441			Wed Oct 27 07:14:01 2001							4.0KB
    
    	Total space required by 3 Storage Checkpoint(s) is 90.0KB
    
    	Press <Return> to continue... 
    

    In addition to providing space-usage information for the current database instance's underlying file systems, Display Space Usage Information for the Current Instance shows the following information about each Storage Checkpoint it detects:

    Storage Checkpoint

    All Storage Checkpoints created by the Storage Checkpoints Capacity Planning utility are named using the following conventions:

    • Prefixed with Planning_

    • Followed by the five digit schedule number, for example 00001_

    • Followed by a timestamp sequence number, for example 956758441

    Creation Time

    Creation Time is the time that cron creates the Capacity Planning Storage Checkpoint.

    Space Needed

    Space Needed is storage space consumed by the Storage Checkpoint based on the changed blocks recorded in the Storage Checkpoint.