ARSMAINT Syntax To Migrate Data based on Internal Date

[Jaydeep Mehta]

Hi All,

I am planning to migrate data on based on internal date but some time it is migrate data for particular internal date and some time it is migrated all data from AG which is loaded on different internal date .

Below is syntax I am using.

arsmaint -I CMOD  -u XXXX -p XXXX -g Test_New  -t 16858 -m -s


Can someone suggest me Can we migrate data based on Internal Date .
what will be the correct syntax or any other suggestion.

Thanks in advance ..:)

Regards
JD Mehta

[Alessandro Perucchi]

You need to use the option "-t yyyy-mm-dd"

and also you need to use in conjonction with that the option -u <username> -p <password>.

[Jaydeep Mehta]

Thanks for suggestion  Alessandro..

But while i am running with below syntax

arsmaint -I CMOD -u xxxx -p xxxxx  -g Test_New1  -t 2016-02-20 -m -s

Getting
The option >-t< argument > 2016-02-20< is invalid  Error.

is any other solution for run migration on basis of Date .

Thanks
JD

[Alessandro Perucchi]

Jaydeep,

simply run the command "arsmaint" without any options, you will get the full help on the commands.
Here is what I get on my system (Linux with CMOD V9.5):

Code Select Expand


$ /opt/ibm/ondemand/V9.5/bin/arsmaint
ARS1201I Usage: arsmaint [-c [-n <min>] [-x <max>]] [-d] [-D <pct>] [-e] [-f <full>] [-g <name>] [-i] [-I <od_inst>] [-l <days>] [-L] [-m] [-o] [-r] [-R] [-t <yyyy-mm-dd> [-u <userid>] [-p <passwd>]]
Version:  9.5.0.3
-c Expire Cache
-d Expire Database
-D <pct> Threshold of load being held before reloading
         (defaults to 0% - not reloaded)
-e Migrate Database Tables
-f <full> Cache Full - When to send alert message (defaults to 95%)
-g <name> Application Group Name (Defaults to all)
-h <od_inst> OnDemand Instance Name (same as -I)
-i Expire Migrated Imported Database Tables
-I <od_inst> OnDemand Instance Name (same as -h)
-l <days> Expire load information from Report Distribution Facility (RDF)
-L Update load id table with application id
-m Migrate Cache
-n <min> Min cache threshold percentage (Only for -c, Defaults to 80%)
-o Expire OnDemand Distribution Facility
-p <passwd> OnDemand Passwd Stash File (Only for -t)
-r Database Statistics
-R Reload Resources
-s Cache Filesystem statistics
-t <yyyy-mm-dd> Date To Expire/Migrate (Defaults to Today)
-u <userid> OnDemand Userid (Only for -t)
-v Verify/Validate Cache Filesystems
-x <max> Max cache threshold percentage (Only for -c, Defaults to 80%)



So maybe with your version, you need to put the internal date for ondemand (number of days since 1/1/1970, the output of the arsdate command). But you will know it by running "arsmaint" without options.

[Alessandro Perucchi]

Jaydeep,

simply run the command "arsmaint" without any options, you will get the full help on the commands.
Here is what I get on my system (Linux with CMOD V9.5):

Code Select Expand


$ /opt/ibm/ondemand/V9.5/bin/arsmaint
ARS1201I Usage: arsmaint [-c [-n <min>] [-x <max>]] [-d] [-D <pct>] [-e] [-f <full>] [-g <name>] [-i] [-I <od_inst>] [-l <days>] [-L] [-m] [-o] [-r] [-R] [-t <yyyy-mm-dd> [-u <userid>] [-p <passwd>]]
Version:  9.5.0.3
-c Expire Cache
-d Expire Database
-D <pct> Threshold of load being held before reloading
         (defaults to 0% - not reloaded)
-e Migrate Database Tables
-f <full> Cache Full - When to send alert message (defaults to 95%)
-g <name> Application Group Name (Defaults to all)
-h <od_inst> OnDemand Instance Name (same as -I)
-i Expire Migrated Imported Database Tables
-I <od_inst> OnDemand Instance Name (same as -h)
-l <days> Expire load information from Report Distribution Facility (RDF)
-L Update load id table with application id
-m Migrate Cache
-n <min> Min cache threshold percentage (Only for -c, Defaults to 80%)
-o Expire OnDemand Distribution Facility
-p <passwd> OnDemand Passwd Stash File (Only for -t)
-r Database Statistics
-R Reload Resources
-s Cache Filesystem statistics
-t <yyyy-mm-dd> Date To Expire/Migrate (Defaults to Today)
-u <userid> OnDemand Userid (Only for -t)
-v Verify/Validate Cache Filesystems
-x <max> Max cache threshold percentage (Only for -c, Defaults to 80%)



As you can see it says for CMOD V9.5:

   -t <yyyy-mm-dd> Date To Expire/Migrate (Defaults to Today)

So maybe with your version, you need to put the internal date for ondemand (number of days since 1/1/1970, the output of the arsdate command). But you will know it by running "arsmaint" without options.

[Jaydeep Mehta]

Hi Alessandro ,

Thanks i am Using CMOD 9.0 Version .

And         -t <internal_date> Internal Date To Expire/Migrate (Defaults to Today).

so  i have to Use internal date .

But my question is if suppose  i have given internal date of 16192 (05/01/14).

so it will migrate only internal date  data  or it will migrate all data before the internal date ..??

Thanks ..

[Alessandro Perucchi]

Normally all data from and before the date provided.