Capture and Replay procedures

Capture and Replay procedures dinther Thu, 07/23/2020 - 16:56

Workload Capture procedures

Procedure Description Example
wlc.beat(duration int) set beat call wlc.beat(123)
wlc.flush() flush capture data call wlc.flush()
wlc.master(path string) set master with path call wlc.master('dbfarm/dbfree')
wlc.master() set master call wlc.master()
wlc.stop() stop capture call wlc.stop()

Note: You must include the wlc. prefix for these procedures and functions (see examples) in order to work properly.

Workload Capture functions

Function Return type Description Example Result
wlc.clock() clob get clock as string select wlc.clock()  
wlc.tick() bigint get tick select wlc.tick()  

 

 

Workload Replay procedures

Procedure Description Example
wlr.accept() accept the error reported an skip the record call wlr.accept()
wlr.beat(duration integer) control the interval for replication call wlr.beat(123)
wlr.master(dbname string) set database name of master call wlr.master('dbfree')
wlr.replicate(id integer) run replicator until condition is met call wlr.replicate(12)
wlr.replicate(id smallint) run replicator until condition is met call wlr.replicate(12)
wlr.replicate(id tinyint) run replicator until condition is met call wlr.replicate(12)
wlr.replicate(pointintime timestamp) run replicator until condition is met call wlr.replicate(timestamp '2020-07-25 09:00:00')
wlr.replicate(id bigint) run replicator until condition is met call wlr.replicate(12)
wlr.replicate() run it forever call wlr.replicate()
wlr.stop() stop replicator call wlr.stop()

Note: You must include the wlr. prefix for these procedures and functions (see examples) in order to work properly.

Workload Replay functions

Function Return type Description Example Result
wlr.clock() clob get clock as string select wlr.clock()  
wlr.tick() bigint get tick select wlr.tick()