Amazon RDS - End session

 

Declaration

<AMAWSRDS ACTIVITY="end_session" SESSION="text" />

Related Topics   

Description

Ends an RDS session.

IMPORTANT: Automate's RDS activities are performed using Amazon's Relational Database Service engine, therefore, administering Amazon RDS through Automate requires a valid Access Key ID and Secret Access Key.

Practical Usage

Used to end a session previously created and started by a Create Session step.

Parameters

Credentials Properties

Property

Type

Required

Default

Markup

Description

Session Name

Text

Yes

(Empty)

SESSION="RDSSession32"

Specifies the name of the session to end.

 

Description

Error Causes

On Error

Example

NOTE:
  • The sample AML code below can be copied and pasted directly into the Steps Panel of the Task Builder.
  • Parameters containing user credentials, files, file paths, and/or other information specific to the task must be customized before the sample code can run successfully.

Description

  • Step 1 - Create RDS session "MySession" Amazon web service access key is "AKIAJU2LHLMG6BA6BZTA". Use https.
  • Step 2 - Create RDS database instance "myRDSDatabase". Instance type is "db.m1.small". Launch database in "us-east-1a" zone. Master user is "myName". Port is "3306". Session is "MySession".
  • Step 3 - Modify database instance "myRDSDatabase". Instance type is "db.m1.large". Database size is "10". Apply immediately, Session is "MySession".
  • Step 4 - Create snapshot "rdsSnap" from Rational database service database instance "myRDSDatabase". Store Rational database service database information into dataset "theSnap". Session is "MySession".
  • Step 5 - Reboot instance "myRDSDatabase". Session is "MySession".
  • Step 6 - End RDS session "MySession".

<AMAWSRDS ACTIVITY="create_session" ACCESSKEY="AKIAJU2LHLMG6BA6BZTA" SECRETKEY="AM3m5RnKS1eh50=aME" USERAGENT="Automate" SESSION="MySession" />

<AMAWSRDS INSTANCEID="myRDSDatabase" INSTANCETYPE="db.m1.small" ZONE="us-east-1a" MASTERUSER="myName" MASTERPWD="AM16wP88TJPA0FX78Oon4bvjg==aME" PORT="3306" STORAGE="5" PROVIDER="session_based" SESSION="MySession" />

<AMAWSRDS ACTIVITY="modify_instance" INSTANCEID="myRDSDatabase" INSTANCETYPE="db.m1.large" STORAGE="10" APPLYFAST="yes" PROVIDER="session_based" SESSION="MySession" />

<AMAWSRDS ACTIVITY="create_snapshot" SNAPSHOTID="rdsSnap" INSTANCEID="myRDSDatabase" RESULTDATASET="theSnap" PROVIDER="session_based" SESSION="MySession" />

<AMAWSRDS ACTIVITY="reboot_instance" INSTANCEID="myRDSDatabase" PROVIDER="session_based" SESSION="MySession" />

<AMAWSRDS ACTIVITY="end_session" SESSION="MySession" />