estimate_old_version script

You can use the estimate_old_versions.sh shell script to get a size estimate for the number of old object versions in various Product Master database tables.

Syntax

./estimate_old_version.sh 
--code=Company_code
--end_date=YYYY-MM-DD.HH24:MI:SS 
[--ctg=Catalog_ID] 
[--start_date=YYYY-MM-DD.HH24:MI:SS] 
[--confirm_db=no]

Parameters

Mandatory Parameters

code: Company code that is used to log in to Product Master
end_date: Old objects that are created before this date are estimated.

Optional Parameters

ctg: Catalog ID that should be checked for old object versions. This ID can be retrieved by using the following SQL query: select * from ctg
start_date: Old objects that are created after this date and until the end_date are estimated.
confirm_db: Confirmation flag to proceed with script execution with or without confirmation prompt. If no is specified, the script does not prompt for database user confirmation.

Table 1. Actions performed by various combinations of parameters
Options	Action
`--code=<Company_code> --end_date=<YYYY-MM-DD.HH24:MI:SS>`	Provides an estimate of old version objects that exist in the company code and created before the `end_date`.
`--code=<Company_code> --end_date=<YYYY-MM-DD.HH24:MI:SS> --start_date=<YYYY-MM-DD.HH24:MI:SS>`	Provides an estimate of old version objects that exist in the company code and created between `start_date` and `end_date`.
`--code=<Company_code> --end_date=<YYYY-MM-DD.HH24:MI:SS> --ctg=<Catalog_ID>`	Provides an estimate of old version objects that exist in the company code, catalog, and created before the `end_date`.
`--code=<Company_code> --end_date=<YYYY-MM-DD.HH24:MI:SS> --ctg=<Catalog_ID> --start_date=<YYYY-MM-DD.HH24:MI:SS>`	Provides an estimate of old version objects that exist in the company code, catalog, and created between `start_date` and `end_date`.

Example

./estimate_old_version.sh --code=ibm --end_date=2009-01-31.18:30:30 --ctg=2063