1. Command Line Interface
  2. Verb Reference
  3. EM CLI Verbs
  4. create_dbprofile

create_dbprofile

Creates a new database profile.

Format

emcli create_dbprofile
			       -input_file=data:"file:path"
	       [-schedule=
	               	[frequency:interval|weekly|monthly|yearly];
	               	start_time:yy-MM-dd HH:mm;
	               	end_time:yy-MM-dd HH:mm;
		               [repeat:#m];
	               	[months:#,#,#,...];
	               	[days:#,#,#,...];
	               	[tz:{timezone ID}];
	               	[grace_period:xxx];
      	]
	[-purge_policy=DAYS|SNAPSHOTS: number]

[ ]  indicates that the parameter is optional.

Options

  • input_file

    A property file which completely describes the type of profile that will be created and the options used.

  • schedule

    frequency: Frequency type with which the Database Profile will be created. It can be interval (in minutes), weekly, monthly or yearly

    start_time: Denotes the starting time of Database Profile Component creation in the format yy-MM-dd HH:mm

    end_time: Denotes the end time of Database Profile Component Creation Repetition in the format yy-Mm-dd HH:mm

    repeat: Repetition rate at which Database Profile will be created. If the frequency is interval, then repeat will be in minutes

    months: Number of months after which repetition of Database Profile Component Creation will occur

    days: Number of days after which repetition of Database Profile Component Creation will occur

    tz: Time Zone ID for example tz:America/New_York

    grace_period: A period of time in minutes that defines the maximum permissible delay when attempting to create a Databasse Profile. If the job system cannot start the execution within a time period equal to the scheduled time + grace period, it will set the create Database Profile to be skipped.By default, grace period is indefinite

  • purge_policy

    You can purge the collected data based on number of days or count of snapshots. If you do not specify purge_policy, it is defaulted to NONE. Allowed values: DAYS, SNAPSHOT

    DAYS specify the number of days after which the data component should be purged.

    SNAPSHOT specify the count or number of data components, after which older data will be purged

Exit Codes

0 if successful. A non-zero value indicates that verb processing was unsuccessful.

Example

The following example creates a new database profile based on the property file "profile.txt" with the specified schedule and purge policy.

emcli create_dbprofile -input_file="data:/tmp/profile.txt" -schedule="frequency:interval;start_time:14-10-05 05:30;end_time:14-10-12 05:23;repeat:30;grace_period:60;tz:America/New_York" -purge_policy=DAYS:2