delete time series data using tscontainerpurge
Nasiha Zailan got errors UTSBW (location argument bad) and UTSGR (control file cannot be opened) running TSContainerPurge on a time series control file. Paul Watson advised passing the full file path, a location such as 'client', and the other parameters explicitly. That worked, and Paul recommended not relying on defaults in TS functions.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, i tried to delete time series data through a specified timestamp using tscontainerpurge with this script: - unload to "regular_purgetest.unl" SELECT GetContainerName(para_values),InstanceId(para_values),GetIndex(para_values,'2018-01-01 23:00:00.00000'::datetime year to fraction(5))::varchar(25) FROM meter_ts_tbl WHERE GetContainerName(para_values)='dlog1_meter'; afterall the control file is generated and located in informix directory however when i try to execute time series deletion function with this statement: - EXECUTE FUNCTION TSContainerpurge('regular_purgetest.unl',1); and it return error: (UTSBW) - location argument to routine TSContainerPurge was bad. so, i tried other statement: -EXECUTE FUNCTION TSContainerpurge("regular_purgetest.unl"); Then, it return another error (UTSGR) - control file error: The file regular_purgetest.unl cannot be opened. Anyone know how to resolve this? ------------------------------ nasiha zailan ------------------------------ #Informix
Try adding full path and 'server' Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC
Hi, you mean this?
EXECUTE FUNCTION TSContainerpurge("regular_purgetest1.unl","C:\\Program Files\\IBM Informix Software Bundle\\regular_purgetest1.unl""tlms_db_server",1);I've executed then but still it returns the same error:
(UTSBW) - location argument to routine TSContainerPurge was bad.
------------------------------
nasiha zailan
------------------------------
Sometime like 'full path to file', 'client', 1 as the parameters. Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC
Ok it works, thanks for your help. ------------------------------ nasiha zailan ------------------------------
In my experience it's not a good idea for rely on the defaults when using TS functions, better to populate . And, IMHO, makes the function calls more readable. Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark of Oninit LLC